Enabling and Disabling Database Options After Installation

When you install Oracle Database, some options are enabled and the others disabled. You can view the enabled Oracle Database options by querying the V$OPTION view using SQL*Plus.

See Also:

Oracle Database Administrator's Guide

If you need to enable or disable a particular database feature for an Oracle home, then use 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 as follows:

chopt [ enable | disable] db_option

The possible values for db_option described in the following table.

Table 7-1 Database Options for Chopt Tool Command

Value	Description
oaa	Oracle Advanced Analytics
olap	Oracle OLAP
partitioning	Oracle Partitioning
rat	Oracle Real Application Testing
ode_net	Oracle Database Extensions for .NET

Example 7-4 Running the Chopt Tool

To enable the Oracle Data Mining RDBMS Files option in your Oracle binary files:

1. Shut down the database with srvctl or SQL*Plus:

   srvctl stop database -d myDb

2. Stop the database service, OracleServiceSID, using the Services program in Control Panel.

3. Run the following commands:

   cd ORACLE_HOME/bin
   chopt enable dm

4. Start the database service, OracleServiceSID, using the Services program in Control Panel.

5. Start up the database:

   srvctl start database -d myDb