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

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

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 

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

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 

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

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 

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

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 

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

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 

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

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 

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

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 

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Starting WebTier...

WebTier Successfully Started

Starting Oracle Management Server...

Oracle Management Server Successfully Started

AdminServer Could Not Be Started

Oracle Management Server is Up

通过expdp&impdp把11g的数据迁移到10g平台的要点

Oracle Data Pump使用范例及部分注意事项（expdp/impdp）

Oracle datapump expdp/impdp 导入导出数据库时hang住

expdp/impdp做Oracle 10g 到11g的数据迁移