Enabling and Disabling Database feature after installation using chopt tool
When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the chopt
tool.
The chopt tool is a command-line utility that is located in the directory ORACLE_HOME/bin
. It uses the following syntax, where db_option is the option whose status you want to modify:
chopt [enable | disable] db_option
Refer :
Example : Disable Data mining options
[oracle@netbackuptest bin]$ pwd/u01/app/oracle/product/11.2.0/dbhome_1/bin[oracle@netbackuptest bin]$ chopt disable dmWriting to /u01/app/oracle/product/11.2.0/dbhome_1/install/disable_dm.log…
%s_unixOSDMakePath% -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk dm_off
%s_unixOSDMakePath% -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk ioracle[oracle@netbackuptest bin]$
One Comment
Post a comment
Brief but nice article and explanation.