Oracle EM 11g/12c资料库迁移操作

最新推荐文章于 2021-04-05 04:31:03 发布

miki西游

最新推荐文章于 2021-04-05 04:31:03 发布

阅读量2.1k

点赞数

分类专栏： Oracle 文章标签： oracle em 资料库迁移

本文链接：https://blog.csdn.net/mikixiyou/article/details/9465169

版权

Oracle 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

1. 概述

Oracle EM11g的资料库需要进行迁移，它的主要操作步骤如下：

1、关闭OMS

2、全库备份现在的资料库，再恢复到新服务器上

3、更新OracleEM OMS的连接资料库的配置

4、启动OMS

这个操作方法在Oracle EM 12c中也有效。

2. 操作步骤

第一步，关闭OMS

找到OMS所在的bin下的emctl工具，关闭OMS服务

/u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$./emctlstop oms

Oracle Enterprise Manager 11g Release 1 Grid Control

Stopping WebTier...

WebTier Successfully Stopped

Stopping Oracle Management Server...

Oracle Management Server Successfully Stopped

Oracle Management Server is Down

第二步，使用RMAN备份恢复一下，很简单，不解释。

第三步，更新Oracle EM OMS的连接资料库的配置

首先检查一下资料库连接配置详情。

/u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$./emctlconfig oms -list_repos_details

Oracle Enterprise Manager 11g Release 1 Grid Control

Repository Connect Descriptor :(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.65.14)(PORT=6688)))(CONNECT_DATA=(SID=emrep)))

Repository Host :

Repository SID :

Repository User : SYSMAN

通过emctl工具修改EM GRID CONTROL的资料库配置,emctl提供了两个修改方法。

emctl config oms -store_repos_details (-repos_host <host>-repos_port <port> -repos_sid <sid> | -repos_conndesc <connectdescriptor>) -repos_user <username> [-repos_pwd <pwd>][-no_check_db]

Connect descriptor should be enclosed in quotes. eg:'"<conn_descr>"' or "'<conn_descr>'"

具体执行的命令如下：

emctl config oms -store_repos_details -repos_conndesc"'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.65.8)(PORT=6688)))(CONNECT_DATA=(SID=emrep)))'"-repos_user sysman -repos_pwd welcome2012

emctl config oms -store_repos_details -repos_host 192.168.65.8-repos_port 6688 -repos_sid emrep -repos_user SYSMAN -repos_pwd welcome2012

最后，修改这两个命令中的一个。

/u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$emctlconfig oms -store_repos_details -repos_conndesc"'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.65.8)(PORT=6688)))(CONNECT_DATA=(SID=emrep)))'"-repos_user sysman -repos_pwd welcome2012

Oracle Enterprise Manager 11g Release 1 Grid Control

Successfully stored repository details in Credential Store.

/u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$emctlconfig oms -list_repos_details

Oracle Enterprise Manager 11g Release 1 Grid Control

Repository Connect Descriptor :(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.65.8)(PORT=6688)))(CONNECT_DATA=(SID=emrep)))

Repository Host :

Repository SID :

Repository User : sysman

/u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$emctlconfig oms -store_repos_details -repos_port 6688 -repos_sid emrep -repos_host192.168.65.8 -repos_user SYSMAN -repos_pwd welcome2012

Oracle Enterprise Manager 11g Release 1 Grid Control

Successfully stored repository details in Credential Store.

/u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$emctlconfig oms -list_repos_details

Oracle Enterprise Manager 11g Release 1 Grid Control

Repository Connect Descriptor :(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.65.8)(PORT=6688)))(CONNECT_DATA=(SID=emrep)))

Repository Host : 192.168.65.8

Repository Port : 6688

Repository SID : emrep

Repository User : SYSMAN

第四步，启动OMS

/u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$./emctlstart oms

Oracle Enterprise Manager 11g Release 1 Grid Control