Database Reference
In-Depth Information
This command should be executed after the management repository has been restored and before starting
the OMS.
The steps required to make Enterprise Manager Cloud Control operational after restoring the repository database
will vary depending on whether a full or incomplete recovery is performed as well as whether the recovery was done
on the same host or a different host. Table
13-3
summarizes the steps required for the different recovery scenarios. In
each scenario, the repository database should be recovered after stopping the OMS.
Table 13-3.
Recovery Scenarios for OMS, Repository, and Agent
Full Recovery
on Same Host
Incomplete Recovery
on Same Host
Full Recovery on
Different Host
Incomplete Recovery
on Different Host
Repository resync
No
Yes
No
Yes
OMS reconfig
No
No
Yes
Yes
Relocate Management
repository target
No
No
Yes
Yes
OMS and repository
monitoring reconfig
No
No
Yes
Yes
OMS reconfiguration is required whenever the repository database is recovered on a different host. This stores
the new database connection description in the OMS. We use the following command to reconfigure the repository
database in the OMS:
emctl config oms -store_repos_details (-repos_host <host> -repos_port <port> -repos_sid
<sid> | -repos_conndesc <connect descriptor>) -repos_user <username> [-repos_pwd <pwd>]
Follow these steps to reconfigure the OMS:
1.
Stop all the OMSs.
emctl stop oms
2.
Reconfigure the repository connection string on each of the OMSs.
emctl config oms -store_repos_details
3.
Restart Admin Server and all the OMSs by using the following:
emctl stop oms -all
emctl start oms
Recovering the repository on a different host also requires relocating the management repository database target
to a different agent running on the new host. This can be done only if an agent already exists on the host and no other
database has been discovered by it. Use the following syntax to relocate the target to a new host:
emctl config repos [-sysman_pwd <sysman password>]
[-agent <new agent>] Specify new destination agent for repository target
[-host <new host>] Specify new hostname for repository target
[-oh <new oracle home>] Specify new OracleHome for repository target
