Tuesday, December 11, 2012

How to Deinstall/Disable a specific licensable database option from already installed Oracle Database 11gR2 Home



Method:

Installation of Oracle Database 11g Release 2 Software installs all the licensable database options. Though installed, not all the licensable database options are enabled by default. During installation, installer gives an option for users to enable the licensable database options that are not enabled in a default installation. 

Users can also choose to disable some licensable database options that are enabled by default. 

Once the installation is done, users can still disable or enable some licensable database options. 

This article explains how to enable or disable a specific licensable database option from an already installed Oracle home.

Oracle Database 11g Release 2 (11.2.0.x), it is not possible to deinstall/remove a specific licensable database option from an already installed database Oracle home. However, users can choose to enable or disable a specific licensable database option using the chopt tool. 

The chopt tool is a command-line utility that is located in the ORACLE_HOME/bin directory. 

The syntax for chopt is:
 
chopt [ enable | disable] db_option

Example :  To enable the Oracle Partitioning option in your Oracle binary files, stop the database, run the following command, and start the database. 

chopt enable Partitioning