chopt – Technology Geek

I post before how to enable oracle database vault using make command, in this post i will talk about how to enable database vault but using chopt command which easier and faster.

Common Syntax :-
chopt [enable | disable] db_option

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

Like the other way you need to shutdown database, listener and dbconsole

cd $ORACLE_HOME/bin

chopt enable lbac

and Start database, listener, and dbconsole , Enterprise should be configured to access database vault.

Cheers

osama

All New From Oracle ….
Amazing Tools , If you install Oracle Database After that you remember that you should enable/Disable some Feature Like Oracle Security ad you Forget Script That Located in RDBMS/admin the What Reinstall Again

In ORACLE 11gR2 you Can do this Easily Just Follow The Below Steps :

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 :

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

1-Shut down the database with srvctl or SQL*Plus:

SQL>Shutdown immediate (single node)
 
srvctl stop database -d ORCL

2-Run the following commands:

cd %ORACLE_HOME%/bin
chopt enable lbac

3-Start Database :

srvctl start database -d ORCL

OR

SQL>Startup  (Single Node)

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

Thank you
Osama Mustafa

Tag: chopt

Enable Database Vault Using chopt Command

Enabling and Disabling Database Options