RECONFIGURE ORACLE EM CONSOLE ON WINDOWS HOST AFTER RENAMING HOST

When running Oracle 11g etc on a Windows system the EM Console will quit working if you rename the host.  To fix you have to drop the EM Console and recreate.

Verify these items:

• listener.ora points and tnsnames.ora files pont to the new host name instead of IP
• make sure there is a line for the new host name in the hosts file that resolves the current IP
• If the sysman account is locked unlock it
• If not in the system enviromental variables already set the SID on the command line
• c:\> set ORACLE_SID=theSID     (You can get the SID name from the ORACLE Service name in the services panel it will be something like ORACLESERVICEtheSID, the SID is the “theSID” part)
• Do not close the command window use it to run all subsequent step, if you close it you lose the environmental variable for the ORACLE SID
• Have the passwords for sys, DBSNMP. and sysman available

Now deconfig the EM Console

In the same command window where you entered the SID run

c:\>emca -deconfig dbcontrol db -repos drop

You will see these prompts:

Database SID: theSID
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y

When done rebuild the EM Console

c:\>emca -config dbcontrol db -repos create

You will see these prompts:

DATABASE SID: theSID
Listener port NUMBER: 1521
Password FOR SYS USER:
Password FOR DBSNMP USER:
Password FOR SYSMAN USER:
Password FOR SYSMAN USER: Email address FOR notifications (optional):
Outgoing Mail (SMTP) server FOR notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

DATABASE ORACLE_HOME ................ C:\app\Administrator\product\11.1.0\db_1

LOCAL hostname ................ mclaughlin11g
Listener port NUMBER ................ 1521
DATABASE SID ................ orcl
Email address FOR notifications ...............
Outgoing Mail (SMTP) server FOR notifications ...............

-----------------------------------------------------------------

Do you wish TO continue? [yes(Y)/no(N)]: y