Enterprise Manager Configuration for Active/Passive Clustered Database

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