Database Reference
In-Depth Information
Database - emrep2
Enterprise Manager Name: emrep_sby
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
emrep2
Database Status:
SUCCESS
DGMGRL> show database emrep;
Database - emrep
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
emrep
Database Status:
SUCCESS
Here you can see that the role of the database has been successfully changed. The next
step is to reconfigure the OMS to use the new primary database.
5.
Start the Admin Server if it is not already running.
emctl start oms -admin_only
6.
Configure the OMS with the new primary database repository.
$OMS_HOME/bin/emctl config oms -store_repos_details -repos_conndesc
"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oem3)(PORT=1522)))
(CONNECT_DATA=(SID=emrep2)))" -repos_user sysman
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
Enter Repository User's Password :
7.
Start the OMS.
emctl start oms
8.
Relocate the management repository target. The management agent on an OMS monitors the
OMS and management repository targets. After the switchover, the repository target needs to
be updated to reflect the switched-over repository database, which is the new primary.
emctl config emrep -agent <central_agent_name> -conn_desc <conn_desc_of_new_primary>
