Enabling and Disabling Database Options
When you select the “Enterprise Edition” option during Oracle installation, all the components which are licensed under “Enterprise Edition” get installed by default. The idea is to install all these options and then disable those options that were not licensed.
If you need additional functionality such as partitioning some time after the initial installation, you can enable (or disable) the specific component functionality at the binary level:
1. Shutdown all database instance(s)/service(s) running from the Oracle Database Home
2. Run the following relink command to disable the option at the binary level:
|
1 2 3 4 |
make -f ins_rdbms.mk option_switch ioracle cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk part_off ioracle |
Here is the list of database options and switches:
| Database Option | ON | OFF |
| Data Mining | dm_on | dm_off |
| Data Mining Scoring Engine | dmse_on | dmse_off |
| Database Vault | dv_on | dv_off |
| Label Security | lbac_on | lbac_off |
| Partitioning | part_on | part_off |
| Real Application Clusters | rac_on | rac_off |
| Spatial | sdo_on | sdo_off |
| Real Application Testing | rat_on | rat_off |
| OLAP | olap_on | olap_off |
| Automatic Storage Management | asm_on | asm_off |
| Context Management Text | ctx_on | ctx_off |
3. Startup the instance and check if the option is enabled:
|
1 |
SELECT * FROM v$option WHERE parameter = 'Partitioning'; |