Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to enable Oracle Real Application Testing option in my existing database, but I couldn't find the way to do that using Oracle Universal Installer (OUI) or Database Configuration Assistant (DBCA). Do I have to reinstall the Oracle software in order to enable the options that I didn't choose to install during Oracle software installation?

The version of the Oracle Database installed is

share|improve this question

No, you don't have to reinstall the Oracle software. According to the section "Oracle Database 11g Release 2 ( New Features" in the Database Installation Guide 11g Release 2:

Oracle Universal Installer no longer provides the custom installation option of individual components. Use the chopt tool, a command-line utility that is located in the ORACLE_HOME/bin directory, to configure the database options.

For example, to enable Oracle Real Application Testing, you would first shut down your database, and then issue chopt as follows:

chopt enable rat

For more information on how to enable and disable other database options with chopt, consult "Enabling and Disabling Database Options" section in the Database Installation Guide 11g Release 2.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.