Enabling and Disabling Database Options

One of those small items that is easy overlooked (at least I overlooked it…) and I think, arrived with Oracle database version 11.2, at least on Windows/Linux…

The Oracle 11gR2 Database Installation Guide for Windows described a new tool, at least for me, that enables or disables database features on Windows. In the manual it is described as follows…

When you install Oracle Database, certain options are enabled and others are disabled. If you must enable or disable a particular database feature for an Oracle home, then shut down the database and use the chopt tool. See Example 5-1.

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

chopt [ enable | disable] db_option

The possible values for db_option 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_2 Oracle Database Extensions for .NET 2.0

Example 5-1 Complete Example of Running the Chopt Tool

To enable the Oracle Label Security option in your Oracle binary files:

  1. Shut down the database with srvctl or SQL*Plus:
    srvctl stop database -d myDb
  2. Stop the database service, OracleServiceSID, using the Services program in Control Panel.
  3. Run the following commands:
    cd %ORACLE_HOME%/bin
    chopt enable lbac
  4. Start the database service, OracleServiceSID, using the Services program in Control Panel.
  5. Start up the database:
srvctl start database -d myDb

In linux the “chopt” statement will show the following output

[oracle@localhost ~]$ chopt

usage:

chopt [enable|disable] {option}

options:
                  dm = Oracle Data Mining RDBMS Files
                  dv = Oracle Database Vault option
                lbac = Oracle Label Security
                olap = Oracle OLAP
        partitioning = Oracle Partitioning
                 rat = Oracle Real Application Testing

e.g. chopt enable rat

Useful information / good to know…its that easy in 11.2 to enable/disable database options.

HTH

Marco Gralike Written by:

4 Comments

  1. May 31

    BTW be aware of Bug 8967636:

    $ORACLE_HOME/BIN/CHOPT.INI NOT INSTANTIATED CORRECTLY

    CHECK http://support.oracle.com if applicable for your OS !!!

    Among others it states for some environments:

    The OUI log files show that $ORACLE_HOME/bin/chopt.ini is instantiated,
    but the file still contains references to the %s_unixOSDMakePath%
    variable. During the instantiation, these variables should have been
    replaced by the path to the make utility ( /usr/bin/make )

    Without making any changes to chopt.ini, the chopt script just echos
    some lines to the screen and to a log file in $ORACLE_HOME/install

    It does not perform any linking

    The workaround is to edit the chopt.ini file and replace all references
    to %s_unixOSDMakePath% with /usr/bin/make before running the chopt script

    There are two other issues here:

    1. The script does not check whether the ‘oracle’ binary is busy
    (which it should really do before trying to relink this binary)

    2. The new $ORACLE_HOME/bin/chopt script is not documented anywhere

  2. December 1

    thanks for this information

  3. maja
    October 4

    Thanks for dis information, its really helpful to me…

Comments are closed.