Remove Oracle Database Options with chopt in 12c

In 10g and 11g Enterprise Edition, one could select which options to install or not to install during the installation process (excl. the 10g ‘custom database’ option, you would get partioning, OLAP and rat). In 12g, one is not able to choose during install anymore, you will get all the options and they must be removed afterwards. Remove / disable them after installing the database software (only), but before creating databases.

The best way to do this is using the ‘chopt’ tool, or when the option is not available, the Oracle Universal Installer must most likely be used. It’s available in Windows and Linux. When using Windows, one can also rename the .dll’s which ‘enable’ the options. It will NOT remove the objects from the database!

On Linux, this tool will invoke the ‘make -f’ options to enable the chosen option.

Remember

  • Please check Oracle Support when removing the options from the software, because MOS will also explain how to remove schema’s and objects from the database!
  • Shutdown all databases in the Oracle Home were the options are removed from, unless the Oracle Universal Installer can be used!

chopt: Windows, Linux

A simple command line utility, to enable / disable options. This will not remove those options schema and objects from the database.

12c (12.1.0.1)

usage:

chopt <enable|disable> <option>

options:
          dm = Oracle Data Mining RDBMS Files
        olap = Oracle OLAP
partitioning = Oracle Partitioning
         rat = Oracle Real Application Testing

e.g. chopt enable rat

* Data Vault and Label Security are installed, but can not be removed anymore.

11g (11.2.0.3)

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

10g

Please refer to this blog where all the install/uninstall MOS documents for 10g options are listed: http://momendba.blogspot.nl/2007/11/manually-installde-install-database.html

Alternative Windows solution

Renaming dll’s which ‘enable’ the options are a solutions found on My Oracle Support. I would prefer using ‘chopt’, but not all options are available. Again, this will not remove those options schema and objects from the database.

11g

In almost all Oracle docs, the .dll’s are renamed to ‘.dll.off’ when deinstalling options.

:: Partitioning Off
oraprtop11.dll

:: OLAP Off
oraolapop11.dll

:: Label Security Off
oralbac11.dll

:: Data Mining Off
oradmop11.dll

:: Data Vault Off
oradv11.dll

:: Real Application Testing Off
orarat11.dll

:: Data Mining Scoring Engine
The Oracle Data Mining Scoring Engine Option is not available in Oracle Database 11g. All functionality of the Data Mining Scoring Engine Option is offered in the Data Mining Option.

10g

In almost all Oracle docs, the .dll’s are renamed to ‘.dll.off’ when uninstalling database options.

:: Partitioning Off
oraprtop10.dll

:: OLAP Off
oraolapop10.dll

:: Label Security Off
Unlike 11g, there is no 'oralbac10.dll' to rename. Use the Oracle Universal Installer.

:: Data Mining Off
With Database Release 10g Release 2, the only supported way to remove the Data Mining option is to use the Oracle Universal Installer. "How To Remove the Data Mining Option from the Database [ID 297551.1]

:: Data Vault Off [ID 744390.1] / Admin Guide, 10.2, [B25166-25]
oradv10.dll

:: Real Application Testing Off
:: --> Oracle Universal Installer
orarat10.dll

:: Data Mining Scoring Engine
The Oracle Data Mining Scoring Engine Option, a separately installed database option in Oracle Database 10g. Use the Oracle Universal Installer to uninstall.

The best solution…

Options can be uninstalled, but the best way to avoid not used installations of options, is NOT installing them! I have seen a lot of databases having installed options not payed for: Installing / Using database options is expensive. Simple ‘next, next, finish’ in an Enterprise Edition installation will give you options you probably won’t use.

12c

Unfortunately 12c won’t give you the option not selecting them, therefor you must disable them by invoking ‘chopt’, after installing the database software (only), but before creating databases.

Happy removing!

Tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.