Cannot Connect Oracle Enterprise Manager After Switchover

Applicable only to Oracle Database 11g.

Symptom

After a switchover or failover occurs, the Oracle Enterprise Manager on the Replica is not accessible.

Solution

Reconfigure the Database Console. Before you begin, stop the running scenario or suspend the Is-Alive check. The following procedure is an example. Provide the correct values for <oracle_db_instance_name>, Oracle Database Version (the example uses 11g R2), file paths, and SID for your environment.

1. set oracle_home=D:\app\administrator\product\11.2.0\dbhome_1
2. set oracle_sid=orcl
3. emca -deconfig dbcontrol db -repos drop
4. To verify the TEMP DB already exists, perform the following steps:
   • sqlplus /nolog
   • connect / as sysdba
   • select * from dba_temp_files where tablespace_name = 'TEMP';
5. If an error occurs, perform these steps:
• alter database temp file 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\TEMP01.DBF' drop including datafiles;
• alter tablespace temp add tempfile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\TEMP01.DBF';
5. emca -config dbcontrol db -repos create
6. net stop OracleDBConsole<oracle_db_instance_name>
7. net start OracleDBConsole<oracle_db_instance_name>