Reconfigure Oracle Enterprise Manager

Salah satu yang bikin pusing saat pergantian hostname, adalah kita tidak bisa begitu saja menggunakan OEM (Oracle Enterprise Manager), harus di install ulang baru kemudian bisa kita pakai.
Ada bebetrapa step yg harus kita lakukan, yaitu :

Edit IP ke mechinename, di :
listerner.ora, tnsname.ora
untuk windows di :

 %ORACLE_HOME%\network\admin

Unix (AIX),

 $ORACLE_HOME/network/admin

Lalu pastikan hosname baru sudah ada di host file

Windows :

 C:\WINDOWS\System32\drivers\etc\hosts

127.0.0.1      localhost
192.168.1.212  mynewmechinename mynewmechinename.mycompany.com

AIX:
 /etc/hosts

127.0.0.1               loopback localhost      # loopback (lo0) name/address
192.168.1.212  mynewmechinename

Lalu Drop OEM yg lama :

Windows

C:\set ORACLE_SID=orcl
C:\emca -deconfig dbcontrol db -repos drop

Unix

oracle@mechinename:/oracle> ORACLE_SID=orcl
oracle@mechinename:/oracle> export ORACLE_SID
oracle@mechinename:/oracle> emca -deconfig dbcontrol db -repos drop

kemudian masukan sid, port, password dari SYS, dan SYSMAN

STARTED EMCA at May 13, 2014 10:44:06 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:

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

Jika user SYSMAN gagal di unlock, drop user tersebut, jika user SYSMAN tidak di drop akan keluar error sebagai berikut :

CONFIG: ORA-20001: SYSMAN already EXISTS..
ORA-06512: at line 17

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already EXISTS..
ORA-06512: at line 17
The Java stack trace will look like this, more or less based on version and release:

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)


connect menggunakan sys ke sqlplus lalu drop user SYSMAN dan dependent -nya juga bebarapa object :

oracle@mynewmechine:/oracle>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 13 11:05:17 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected
SQL>
jalan kan syntax di bawah ini.

DROP USER sysman CASCADE;
DROP PUBLIC SYNONYM setemviewusercontext;
DROP ROLE mgmt_user;
DROP PUBLIC SYNONYM mgmt_target_blackouts;
DROP USER mgmt_view;

Lalu buat EM environtment yg baru dengan syntax sbb:

Windows :
C:\> emca -config dbcontrol db -repos create
Unix :
oracle@mynewmechine:/oracle>emca -config dbcontrol db -repos create

kembali masukan  masukan sid, port, password

EM Configuration Assistant, Version Version 10.2.0.1.0 Production

Enter the following information:
DATABASE SID: orcl
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\10.2.0\db_1

LOCAL hostname ................  mynewmechinename
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