DB Console Mainenance.

Comments

——–

=== ODM Action Plan ===

To recreate dbcontrol, please follow the instructions below:

1. Make sure that the following is true or have already been done:

– you’re logged in to the OS as the user who owns the database installation

– the ORACLE_HOME and ORACLE_SID environment variables are set properly in the OS user’s session

– the database password file exists and is valid

– the listener is up and running, the database is open and its instance have successfully registered to its listener.

(Note: a. The instance status should be ‘READY’ and not ‘UNKNOWN’ in the output of “lsnrctl status ”

command.

b. If the listener port is not 1521, make sure the database instance can statically register to the listener.

(You may have to set the local_listener instance parameter)

– the DBSNMP user exists and its account status is unlock.

2. Run the following commands:

To drop the dbcontrol repository and configuration files (if any):

/bin/emca -deconfig dbcontrol db -repos drop

Then, create the dbcontrol repository and configuration files:

/bin/emca -config dbcontrol db -repos create

Note: This command puts the database in Quiesce Mode. Please consult Note 375946.1 – Running EMCA Results in Database quiesce And No New Connections or Operations Can Be Performed During the DB Control Repository Creation