Skip to content

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 :

http://bit.ly/p1CPxR

Example : Disable Data mining options

[oracle@netbackuptest bin]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/bin
[oracle@netbackuptest bin]$ chopt disable dm
Writing 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
  1. Brief but nice article and explanation.

    September 21, 2011

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: