Oracle 11gR2 Enabling and Disabling Database Options After Installation

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

The chopt tool is a command-line utility that is located in the directory $ORACLE_HOME/bin. It uses the following syntax, where db_option is the option whose status you want to modify:

chopt [enable | disable] db_option

The possible values for db_option are:

Value Description
dm Oracle Data Mining Database 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

In this example, the chopt tool is used to enable Oracle Label Security in the database oradb1:

$ cd $ORACLE_HOME/bin
$ srvctl stop database -d oradb1
$ chopt enable lbac
$ srvctl start database -d oradb1

in Oracle 11g R2 Documentation

I hope it was useful!!!
Cheers

  1. Thanks for the information.

    I was in the middle of a case where OLS wasn’t installed. So, the procedure I used was as follows:

    1. shutdown all instances
    2. On main node as user oracle run $ORACLE_HOME/oui/bin/runInstaller (it could be necessary count on installation media)
    3. Selecting Advanced Options, selected OLS (after that, option changed to ‘Reinstall’). Proceed (on RAC, the process installs it on every node automatically)
    4. cd $ORACLE_HOME/bin; chopt enable lbac
    5. Startup all instances
    6. On main node run dbua connected as user oracle.

    Hope it helps.

  2. Sorry, I made a mistake at point 6 and forgot something else:

    1. shutdown all instances
    2. On main node as user oracle run $ORACLE_HOME/oui/bin/runInstaller (it could be necessary count on installation media)
    3. Selecting Advanced Options, selected OLS (after that, option changed to ‘Reinstall’). Proceed (on RAC, the process installs it on every node automatically)
    4. cd $ORACLE_HOME/bin; chopt enable lbac
    5. Startup all instances
    6. On main node run dbca connected as user oracle. Select Configure options. OLS will be available for selection. Execute it.
    7. sqlplus system/password
    alter user lbacsys identified by password account unlock;

    Hope it helps.

  3. when ever i configure database vault it. and than i want to perform any sysdba activity it gives an error

    alter user hr identified by hr;
    alter user hr identified by hr
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges

  4. Hi,

    This is a normal error. In Database Vault the sysdba is no longer the master profile. When you install/configure Database Vault you have to create a user that is the Security Administrator (by default I think it’s dvadmin). You can see every think about Database Vault Security on the documentation:

    Oracle Database Vault Security Guidelines

    I hope it was useful!!!
    Cheers

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Optimization WordPress Plugins & Solutions by W3 EDGE