1. 概述
Oracle EM 12c OMR数据库异常后， 需要将em 12c平台连接转换到备份的standby OMR数据库。
a. 关闭OMS
b. 开启OMR Data Guard数据库为read/write模式
c. 更新Oracle EM OMS的连接DB的配置
d. 启动OMS
这个操作方法在Oracle EM 11g/12c中都有效。
2. 具体操作步骤
(1). 关闭OMS
找到OMS所在的bin下的emctl工具，关闭OMS服务
$ cd $OMS_HOME/bin
$./emctl stop oms
(2). 将OMR Data Guard开启为可读写模式
(3). 更新Oracle EM OMS的连接DB的配置
首先检查一下DB连接配置详情。
$cd $OMS_HOME/bin
$./emctl config oms -list_repos_details
例子:
[oracle@sz101db03 bin]$ ./emctl config oms -list_repos_details
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, Oracle Corporation. All rights reserved.
Repository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))(CONNECT_DATA=(SID=em12c)))
Repository Host :
Repository Port : 1521
Repository SID : em12c
Repository User : SYSMAN
[oracle@sz101db03 bin]$
通过emctl工具修改EM 12c的DB配置, emctl提供了两个修改方法。
语法：
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>]
Note: Steps in changing repository details are:
1) Stop all the OMSs using 'emctl stop oms'
2) Run 'emctl config oms -store_repos_details' on each of the OMSs
3) Stop all the OMSs completely using 'emctl stop oms -all'
4) Start all of the OMSs using 'emctl start oms'
例子：
emctl config oms -store_repos_details -repos_conndesc"'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))(CONNECT_DATA=(SID=em12c)))'" -repos_user sysman -repos_pwd Huawei123
或者
emctl config oms -store_repos_details -repos_host -repos_port 1521 -repos_sid em12c -repos_user SYSMAN -repos_pwd Huawei123
来自 “ ITPUB博客 ” ，链接：/35489/viewspace-1824329/，如需转载，请注明出处，否则将追究法律责任。
如果觉得《Oracle EM 12c 如何切换备用的OMR数据库 - 1》对你有帮助，请点赞、收藏，并留下你的观点哦！
