Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OMS repos update in Data Guard Setup

BPradhanFeb 27 2017 — edited Feb 28 2017

Hi

We have the following setup:

     Host-S (Hosts OMS)

     Host-1 (Hosts OMR)

     Host-2 (Hosts OMR-Standby)

Please note that, there is only One OMS here, but the repository database is Oracle Dataguarded.

So the setup described in https://docs.oracle.com/cd/E63000_01/EMADV/ha_disaster.htm#EMADV13331 is Not the one we are having (as in Docs it uses two OMSs, with each one having local OMRs).

ISSUE: When there is a switchover or failover, unable to update the "repos_details" using emctl.

After a switchover/failover, the Primary Database is on Host-2.

1] When we run the below command on Host-S:

  emctl config oms -store_repos_details -repos_conndesc '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Host-2.domain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emreps.domain)))' -repos_user SYSMAN

It fails with 'Unable to connect to Admin Server'.

So it is expecting the Admin Server to be up.

2] When we try to start the Admin Server on Host-S, it fails saying unable to connect to repository.

  emctl start oms -admin_only

Because the existing repository setting is for Host-1 DB, which is not open now (in mount stage because of data guard switchover)

Is there any way to update the repos_details, in this case. Idea is to update the repos details to Host-2 and start the OMS and get going.

Version : 13.1

Regards

BPradhan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2017
Added on Feb 27 2017
7 comments
433 views