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!