Oracle has introduced a utility called Chopt in 11gR2 to enable/disable few database features after database installation. To perform this, you need to shut down database and run the utilty present under $ORACLE_HOME/bin. Find below list of options allowed
| 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 |
e.g To enable Database Vault, you need to issue following command
$chopt enable dv
As of now no option to enable/disable RAC option. It would still be enabled/disabled using (make -f ins_rdbms.mk rac_off ioracle)
You can find documentation link here
Amit,
There is a bug in 11.2.0.1 for linux x86_64 bits for using chopt.
We have to change the path in chopt.ini file for “make” command and give the exact path of “make” (we can find this by using $which make)
Have you faced the same??
– Saurabh Sood
Thanks Amit for such posting.
Please send me your mail ID if possible.