If you have an active/passive clustered environment, also known as Cold Failover Cluster (CFC) environments (HP/UX Service Guard in this case), the enterprise manager database control fails to communicate with agent, listener and cannot connect to database because listener listens from cluster IP. In this case EM shows db, listener and agent down. Here is a workaround for this problem.

Change the hostname of the database server to cluster IP (192.168.1.3 in this example) in the following files. Also you should check LISTENER_PORT and LISTENER_NAME variables and change if it's not correct. If management agent is running restart it. (emctl stop dbconsole / emctl start dbconsole)

(assume that ORACLE_HOME is /oracle/product/10.2.0 ; ORACLE_SID=ORCL ; CLUSTER_IP=192.168.1.3 ; LISTENER_NAME=LISTENER_ORCL ; LISTENER_PORT = 1521)
vi /oracle/product/10.2.0/dbserver_ORCL/sysman/config/emoms.properties

#Fri Sep 05 11:51:30 EEST 2008
oracle.sysman.emSDK.svlt.ConsoleServerName=dbserver_Management_Service
oracle.sysman.eml.mntr.emdRepPwd=662e901ada770e41
emdrep.ping.pingCommand=/usr/sbin/ping
oracle.sysman.eml.mntr.emdRepPort=1521
oracle.sysman.eml.mntr.emdRepDBName=ORCL
oracle.sysman.eml.mntr.emdRepPwdSeed=1893515180231278974
oracle.sysman.emSDK.svlt.ConsoleMode=standalone
oracle.sysman.emRep.dbConn.statementCacheSize=30
oracle.sysman.db.isqlplusUrl=http\://192.168.1.3\:5560/isqlplus/dynamic
oracle.sysman.emSDK.svlt.ConsoleServerPort=1158
oracle.sysman.eml.mntr.emdRepRAC=FALSE
oracle.sysman.emSDK.emd.rt.useMonitoringCred=true
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
oracle.sysman.db.isqlplusWebDBAUrl=http\://192.168.1.3\:5560/isqlplus/dba/dynamic
oracle.sysman.emSDK.svlt.ConsoleServerHost=192.168.1.3
oracle.sysman.eml.mntr.emdRepDBID=3824679565
oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1158
oracle.sysman.eml.mntr.emdRepServer=192.168.1.3
oracle.sysman.eml.mntr.emdRepSID=ORCL
oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=192.168.1.3)(PORT\=1521)
))(CONNECT_DATA\=(SERVICE_NAME\=ORCL)))
oracle.sysman.emSDK.sec.ReuseLogonPassword=true
oracle.sysman.eml.mntr.emdRepUser=SYSMAN
oracle.sysman.db.adm.conn.statementCacheSize=2
oracle.sysman.db.perf.conn.statementCacheSize=30



vi /oracle/product/10.2.0/dbserver_ORCL/sysman/config/emd.properties

REPOSITORY_URL=http://192.168.1.3:1158/em/upload/
emdWalletSrcUrl=http://192.168.1.3:1158/em/wallets/emd
EMD_URL=http://192.168.1.3:3938/emd/main



vi /oracle/product/10.2.0/dbserver_ORCL/sysman/emd/targets.xml

Targets AGENT_SEED="-1761825416">
Target TYPE="oracle_emd" NAME="192.168.1.3:3938"/>
Target TYPE="host" NAME="10.6.111.36"/>
Target TYPE="oracle_database" NAME="ORCL">
Property NAME="MachineName" VALUE="192.168.1.3"/>
Property NAME="Port" VALUE="1521"/>
Property NAME="SID" VALUE="ORCL"/>
Property NAME="OracleHome" VALUE="/oracle/product/10.2.0"/>
Property NAME="UserName" VALUE="6f7af2088af7c514" ENCRYPTED="TRUE"/>
Property NAME="password" VALUE="ffdb6ed655af4c51" ENCRYPTED="TRUE"/>
/Target>
Target TYPE="oracle_listener" NAME="LISTENER_ORCL">
Property NAME="Machine" VALUE="192.168.1.3"/>
Property NAME="LsnrName" VALUE="LISTENER_ORCL"/>
Property NAME="Port" VALUE="1521"/>
Property NAME="OracleHome" VALUE="/oracle/product/10.2.0"/>
Property NAME="ListenerOraDir" VALUE="/oracle/product/10.2.0/network/admin"/>
/Target>
/Targets>

Important Note: These steps will not make your enterprise manager and cluster environment fully adapted, after a failover operation enterprise manager will not work. For a fully adapted environment refer to http://download.oracle.com/docs/cd/B19306_01/em.102/b40002/actpass_env.htm#CHDBBEAB

4 Responses so far.

  1. Thank you for posting this blog i honestly cherished it and submit some unique blogs about oracle........visit our internet site related to oracle fusion all modules education
    oracle cloud fusion financials

  2. harsha says:

    Really thanks for sharing such a wonderful blog.
    Oracle Fusion Financilas Online Training

  3. Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion Financials Online Training
    Oracle Fusion SCM Online Training
    Workday Online Training

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -