OracleEM11g/12c资料库迁移操作
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了OracleEM11g/12c资料库迁移操作，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4360字，纯文字阅读大概需要7分钟。
内容图文
1. 概述Oracle EM11g的资料库需要进行迁移，它的主要操作步骤如下： 1、关闭OMS 2、全库备份现在的资料库，再恢复到新服务器上
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
Connect descriptor should be enclosed in quotes. eg:'"
具体执行的命令如下：
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的数据迁移
内容总结
以上是互联网集市为您收集整理的OracleEM11g/12c资料库迁移操作全部内容，希望文章能够帮你解决OracleEM11g/12c资料库迁移操作所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。