Oracle重建OEM

对于Oracle EBS系统，我们需要经常做clone。如果系统启用了OEM，那么在clone操作完成后，OEM将不可用，需要重建OEM。

EBS系统重建OEM没有什么区别。大体步骤如下：

前提条件：

1、clone操作成功完成

2、应用关闭

 

1、创建密码文件

1）重置sys口令为uatsyspass

alter user sys identified by uatsyspass;

2)创建密码文件

cd $ORACLE_HOME/dbs

orapwdpassword=uatsyspass entries=1 file=orapwUAT

3)确认密码修改成功：

$ sqlplussys/uatsyspass@UAT as sysdba

能连接上说明ok

 

2、重建em

$ emca -reposrecreate

 

STARTED EMCA at Aug22, 2013 10:29:45 AM

EM ConfigurationAssistant, Version 10.2.0.1.0 Production

Copyright (c) 2003,2005, Oracle.  All rights reserved.

 

Enter the followinginformation:

Database SID: UAT

Listener portnumber: 1529

Password for SYSuser:  (输入uatsyspass)

Password for SYSMANuser:  (输入sysman)

Do you wish tocontinue? [yes(Y)/no(N)]: Y

Aug 22, 201310:30:22 AM oracle.sysman.emcp.EMConfig perform

INFO: This operationis being logged at/8008/uat/db/tech_st/10.2.0/cfgtoollogs/emca/UAT/emca_2013-08-22_10-29-45-AM.log.

Aug 22, 201310:30:23 AM oracle.sysman.emcp.EMReposConfig dropRepository

INFO: Dropping theEM repository (this may take a while) ...

 

$ emca -configdbcontrol db

 

STARTED EMCA at Aug22, 2013 5:19:42 PM

EM ConfigurationAssistant, Version 10.2.0.1.0 Production

Copyright (c) 2003,2005, Oracle.  All rights reserved.

Enter the followinginformation:

Database SID: UAT

Listener portnumber: 1529

Password for SYSuser: 

Password for DBSNMPuser: 

Invalidusername/password.

Password for DBSNMPuser:  (重置DBSNMP用户的口令为dbsnmp： alter userdbsnmp identified by dbsnmp;)

Password for SYSMANuser: 

Email address fornotifications (optional):

Outgoing Mail (SMTP)server for notifications (optional):

-----------------------------------------------------------------

 

You have specifiedthe following settings

Database ORACLE_HOME................ /8008/uat/db/tech_st/10.2.0

Database hostname................ ebsdb2.sapagroup.com

Listener port number................ 1529

Database SID................ UAT

Email address fornotifications ...............

Outgoing Mail (SMTP)server for notifications ...............

-----------------------------------------------------------------

Do you wish tocontinue? [yes(Y)/no(N)]: y

Aug 22, 2013 5:21:36PM oracle.sysman.emcp.EMConfig perform

INFO: This operationis being logged at/8008/uat/db/tech_st/10.2.0/cfgtoollogs/emca/UAT/emca_2013-08-22_05-19-42-PM.log.

Aug 22, 2013 5:21:48PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: SecuringDatabase Control (this may take a while) ...

Aug 22, 2013 5:22:21PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: DatabaseControl secured successfully.

Aug 22, 2013 5:22:21PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: StartingDatabase Control (this may take a while) ...

Aug 22, 2013 5:24:18PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: DatabaseControl started successfully

Aug 22, 2013 5:24:18PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO:>>>>>>>>>>> The Database Control URL is https://ebsdb2.sapagroup.com:5500/em<<<<<<<<<<<

Enterprise Managerconfiguration completed successfully

FINISHED EMCA at Aug22, 2013 5:24:18 PM