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
