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:
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 8-1 Database Options for Chopt Tool Command
Value | Description |
---|---|
|
Oracle Advanced Analytics |
|
Oracle OLAP |
|
Oracle Real Application Testing |
Example 8-1 Running the Chopt Tool
-
Shut down the database with
srvctl
or SQL*Plus:srvctl stop database -d myDb
-
Stop the database service,
OracleServiceSID
, using the Services program in Control Panel. -
Run the following commands:
cd ORACLE_HOME/bin chopt enable rat
-
Start the database service,
OracleServiceSID
, using the Services program in Control Panel. -
Start up the database:
srvctl start database -d myDb
Parent topic: Oracle Database Postinstallation Tasks