Welcome 微信登录

首页 / 数据库 / MySQL / Oracle EM 11g/12c资料库 迁移操作

1.  概述
Oracle EM11g的资料库需要进行迁移，它的主要操作步骤如下：1、关闭OMS2、全库备份现在的资料库，再恢复到新服务器上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 omsOracle Enterprise Manager 11g Release 1 Grid Control Copyright （c） 1996, 2010 Oracle Corporation.  All rights reserved.Stopping WebTier...WebTier Successfully StoppedStopping Oracle Management Server...Oracle Management Server Successfully StoppedOracle Management Server is Down第二步，使用RMAN备份恢复一下，很简单，不解释。第三步，更新Oracle EM OMS的连接资料库的配置首先检查一下资料库连接配置详情。 /u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$./emctlconfig oms -list_repos_detailsOracle 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 welcome2012Oracle 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_detailsOracle 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 welcome2012Oracle 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_detailsOracle 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.8Repository Port : 6688Repository SID  : emrepRepository User : SYSMAN 第四步，启动OMS/u01/app/oracle/middlehome/oms11g/bin@lin-65-210-dba=>emgrid$./emctlstart omsOracle Enterprise Manager 11g Release 1 Grid Control Copyright （c） 1996, 2010 Oracle Corporation.  All rights reserved.Starting WebTier...WebTier Successfully StartedStarting Oracle Management Server...Oracle Management Server Successfully StartedAdminServer Could Not Be StartedOracle Management Server is Up相关阅读：通过expdp&impdp把11g的数据迁移到10g平台的要点 http://www.linuxidc.com/Linux/2013-06/86493.htmOracle Data Pump使用范例及部分注意事项（expdp/impdp） http://www.linuxidc.com/Linux/2013-06/86383.htmOracle datapump expdp/impdp 导入导出数据库时hang住 http://www.linuxidc.com/Linux/2013-05/84746.htmexpdp/impdp做Oracle 10g 到11g的数据迁移 http://www.linuxidc.com/Linux/2013-05/83923.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12监控数据备份恢复完成进度（EXPDP/IMPDP/RMAN）SHUTDOWN: Active processes prevent shutdown operation相关资讯      Oracle 11g  Oracle 12C EM  Oracle 11g EM 
  • Oracle 11g导入到10g引起的错误  （11/16/2015 10:55:27）
  • Oracle 11g 导库导不出空表问题  （08/19/2015 19:55:58）
  • Oracle 11g统计信息收集--多列统计  （07/24/2015 10:32:39）
  • Oracle 11gClone安装方法  （08/24/2015 20:25:41）
  • Oracle 11g中和SQL TUNING相关的新  （08/12/2015 11:22:52）
  • Oracle 11g数据泵详解  （07/08/2015 08:29:51）
本文评论 查看全部评论 （0）
表情： 姓名： 字数