Configuring Database Control with EMCA Oracle 11g

Configure Database Control w/EMCA

1.Set the following environment variables to identify the Oracle Home and the Oracle System Identifier (SID) for the database you want to manage:
a. ORACLE_HOME
b. ORACLE_SID

2. Change directory to the ORACLE_HOME/bin directory.

3. Start EMCA by entering the following command with any of the optional command-line arguments show in the Table below:

$PROMPT> ./emca

Depending upon the arguments you include on the EMCA command line, EMCA prompts you for the information required to configure Database Control.

For example, enter the following command to configure Database Control so it will perform automatic daily backups of your database:

$PROMPT> ./emca -config dbcontrol db -backup

EMCA commands are of the form:

emca [operation] [mode] [flags] [parameters]

Note: To configure Database Console for single instance database using ASM, no extra parameters are required to be passed along with the EMCA command. Run the following command to configure the Database Console which will automatically detect the ASM instance:

$PROMPT> ./emca -config dbcontrol db -repos create

Note: The Database Control repository is in secure mode, which means that Enterprise Manager data is encrypted. The file location of the encryption key depends upon the type of database, as follows:

For Single Instance Databases:

$ORACLE_HOME/_/emkey.ora

For Oracle RAC Databases:

$ORACLE_HOME/node_sid/emkey.ora

Oracle strongly recommends that you ensure this file is backed up because the encrypted data will become unusable if this file is lost.

emca -h | –h | -help | –help

Use this option to display the Help message for the EMCA utility.

emca -version

Prints the version information associated with EMCA.

emca -config dbcontrol db [-repos (create|recreate)][-cluster][-silent][-backup][parameters]

Configures Database Control for a database. Options include creating (or recreating) Database Control repository, configuring automatic backups and performing these operations on a cluster database.

---

Possibly related posts: (automatically generated)

• Configure Oracle 10g EM / DBconsole
• Oracle Tip: Dropping a Database
• MANUAL INSTALLATION OF DB CONTROL