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
chopttool. See Example 5-1.The
chopttool is a command-line utility that is located in theORACLE_HOME\bindirectory. The syntax forchoptis as follows:chopt [ enable | disable] db_optionThe possible values for
db_optiondescribed in the following table.
Value Description dmOracle Data Mining RDBMS Files dvOracle Database Vault lbacOracle Label Security olapOracle OLAP partitioningOracle Partitioning ratOracle Real Application Testing ode_net_2Oracle Database Extensions for .NET 2.0 Example 5-1 Complete Example of Running the Chopt ToolTo enable the Oracle Label Security option in your Oracle binary files:
- Shut down the database with
srvctlor SQL*Plus:srvctl stop database -d myDb- Stop the database service,
OracleServiceSID, using the Services program in Control Panel.- Run the following commands:
cd %ORACLE_HOME%/bin chopt enable lbac- Start the database service,
OracleServiceSID, using the Services program in Control Panel.- 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
3 comments
1 ping
Marco Gralike
31 May, 2010 at 13:14 (UTC 1) Link to this comment
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
ApattDada
1 December, 2010 at 10:25 (UTC 1) Link to this comment
thanks for this information
maja
4 October, 2012 at 11:57 (UTC 1) Link to this comment
Thanks for dis information, its really helpful to me…
Ein- und Ausschalten von Oracle Datenbank-Optionen « Sven’s Technik-Blog
30 May, 2010 at 19:40 (UTC 1) Link to this comment
[...] Gralike beschreibt in seinem Blogeintrag, wie man per Commandline-Tool Datenbankoptionen aus- und einschalten [...]