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'; |
ilyas
Gokhan Atil
Michal
Sandy
LAL PRASAD
Gokhan Atil
zhalin
rishi
Gokhan Atil
Ruthira
Gokhan Atil
Sean
Rob Lasonder
Gokhan Atil
Sreedhar Silveri
kalyan
Hari
Mustapha
Gokhan Atil
engine
Majid
Gokhan Atil
Pingback: Removing Options from the Oracle Database kernel in 12c | Upgrade your Database - NOW!
Tukaram
VENKATESH RANGARAJAN
umer
satish S
Rahul