Oracle Database - Configure Database Options with the chopt tool
Table of Contents
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.
Articles Related
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 |
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