:: Stracca Blog :: Stefano Stracuzzi TECH blog

Recreate Enterprise Manager Repository on 10g Windows with multiple ip addresses

If you have a Windows Server with multiple IP addresses and you install a Database Instance with Enterprise Manager Repository and you bind your

LISTENER to a different

ip address than the one that respond to the machine name you had to manually drop and recreate the EM.

You had to open a dos command prompt and setup your SID and you correct IP Address:

C:\> set ORACLE_SID=YOUR_SID
C:\>

  set ORACLE_HOSTNAME=10.1.0.100

Unlock DBSNMP and SYSMAN user and reset their password connecting :

sqlplus "sys/YOUR_PASSWORD@YOUR_SID as sysdba"
alter user dbsnmp account unlock identified by YOUR_PASSWORD;
alter user sysman account unlock identified by YOUR_PASSWORD;

Go to %ORACLE_HOME%\bin directory and drop EM Repository:

C:\oracle\product\10.2.0\db1\bin> emca -deconfig dbcontrol db -repos drop

Clear some DB Object that can remain:

sqlplus "sys/YOUR_PASSWORD@YOUR_SID as sysdba"
drop public synonym SETEMVIEWUSERCONTEXT;
drop ROLE MGMT_USER;
drop

  PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
drop user sysman cascade;
drop user MGMT_VIEW cascade;
exit;

Recreate the EM Repository:

C:\oracle\product\10.2.0\db1\bin> emca -config dbcontrol db -repos create

When you start emca operations follow online instructions.