Hi,
Enter prise manager connects to the database using the option EM_REPOS_CONNECTDESCRIPTOR in /oracle/gc_inst/em/EMGC_OMS1/emgc.properties
if have to set up standby database for the repository database.
and if the EM_REPOS_CONNECTDESCRIPTOR looks like
EM_REPOS_CONNECTDESCRIPTOR=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=VACDSPRD)(PORT\=1525)))(CONNECT_DATA\=(SID\=CDSPRD)))
and I need to make it some thing like , althoug it is not correct syntax but you get idea of what I need to know.
EM_REPOS_CONNECTDESCRIPTOR=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=VACDSPRD)(HOST\=VACDSPRD1)(PORT\=1525)))(CONNECT_DATA\=(service\=CDSPRD_app)))
so the question is .
if the repsository database in standby is failovered to the primary.
1.will just updating host in EM_REPOS_CONNECTDESCRIPTOR and restarting enterprise manager will do (emctl stop/start oms)
2. As asked above can a configuration like this been done where there is no intervention required to update hostname and the EM connects to repository database which connects through the service pointing to the new primary, and how the entry should look like.
Thanks
Atul