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

7 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. Baby says:

    Awesome post……. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion SCM Online Training

  3. Sravani says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion HCM Online Training

  4. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Online Training

  5. harsha says:

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

  6. Very interesting blog Really excellent information and thank you for giving your valuable information
    Oracle Fusion HCM Online Training

  7. Thank you for sharing such a nice and interesting blog and really very helpful article
    Oracle Fusion SCM Online Training

Powered by Blogger.

Page Views

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