Oracle Database - Configure Database Options with the chopt tool

> Database > Oracle Database

1 - About

When you install Oracle Database, some options are enabled and others are disabled. If you want to enable or disable a particular database feature for an Oracle home, then shut down the database and use the chopt tool.

Advertising

3 - Syntax

The chopt tool is a command-line utility that is located in the ORACLE_HOME/bin directory. The syntax for chopt is:

chopt [ enable | disable] db_option

The possible values for db_option are described in the following table:

Value Description
dm Oracle Data Mining RDBMS Files
dv Oracle Database Vault
lbac Oracle Label Security
olap Oracle OLAP
partitioning Oracle Partitioning
rat Oracle Real Application Testing
ode_net Oracle Database Extensions for .NET 1.x
ode_net_2 Oracle Database Extensions for .NET 2.0

4 - Complete Example of Running the Chopt Tool

To enable the Oracle Label Security option in your Oracle binary files, use the following command:

cd %ORACLE_HOME%
srvctl stop database -d myDb
chopt enable lbac
srvctl start database -d myDb
Advertising

5 - Documentation / Reference

db/oracle/chopt.txt · Last modified: 2017/09/06 19:27 by gerardnico