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 theORACLE_HOME
\bin
directory. The syntax forchopt
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 ToolTo enable the Oracle Label Security option in your Oracle binary files:
- Shut down the database with
srvctl
or SQL*Plus:
srvctl stop database -d myDb
- Stop the database service,
OracleService
SID
, using the Services program in Control Panel.- Run the following commands:
cd %ORACLE_HOME%/bin chopt enable lbac
- Start the database service,
OracleService
SID
, 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
#66cc66;">[oracle#33cc33;">@localhost ~#66cc66;">]$ chopt usage: chopt #66cc66;">[enable|disable#66cc66;">] #66cc66;">{option#66cc66;">} 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
Recent comments
1 year 45 weeks ago
2 years 5 weeks ago
2 years 10 weeks ago
2 years 10 weeks ago
2 years 15 weeks ago
2 years 36 weeks ago
3 years 4 weeks ago
3 years 34 weeks ago
4 years 18 weeks ago
4 years 19 weeks ago