oracle rac手工创建em,oracle 10g rac em重建实施步骤

1.1.1

bin/emca -deconfig dbcontrol db-cluster

[oracle@p595a2:/oracle/app/oracle]$emca -deconfig dbcontrol db -cluster

STARTED EMCA at May 10, 2010 5:02:53 PM

EM Configuration Assistant, Version 10.2.0.1.0 Production

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

Enter the following information:

Database unique name: fsyyk

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

May 10, 2010 5:02:58 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /oracle/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/fsyyk/emca_2010-05-10_05-02-53-PM.log.

May 10, 2010 5:03:00 PM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) ...

Enterprise Manager configuration completed successfully

FINISHED EMCA at May 10, 2010 5:03:44 PM

注意如果是双机，则需要加-cluster选项。

1.1.2

Remove the following directories from your filesystem:

//oc4j/j2ee/OC4J_DBConsole__

一般在运行2.1.1脚本时会自动删除上面目录，如果没删除掉，请手工删除

1.1.3RepManager命令(两个节点)

In both 10g R1 and R2 run:

/sysman/admin/emdrep/bin/RepManager -action drop[oracle@p595a2:/oracle/app/oracle/product/10.2.0/db_1]$sysman/admin/emdrep/bin/RepManager p595a2 1521 fsyyk1 -action dropEnter SYS user's password :Enter repository user name : dbsnmpEnter repository user password :Getting temporary tablespace from database...Found temporary tablespace: TEMPChecking SYS Credentials ... OK.Dropping the repository..Quiescing DB ...

[oracle@p595a2:/oracle/app/oracle/product/10.2.0/db_1]$sysman/admin

/emdrep/bin/RepManager p595b2 1521 fsyyk2 -action drop

1.1.4Step 1: Drop AQ related objects in the SYSMAN schema

Logon SQLPLUS as user SYSMAN

SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'MGMT_NOTIFY_QTABLE',force =>TRUE);

Step 2: Drop the DB Control Repository Objects

Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects:

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP RESTRICT;

SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs;

SQL> EXEC sysman.setEMUserContext('',5);

SQL> REVOKE dba FROM sysman;

SQL> DECLARE

CURSOR c1 IS

SELECT owner, synonym_name name

FROM dba_synonyms

WHERE table_owner = 'SYSMAN';

BEGIN

FOR r1 IN c1 LOOP

IF r1.owner = 'PUBLIC' THEN

EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;

ELSE

EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;

END IF;

END LOOP;

END;

/

SQL> DROP USER mgmt_view CASCADE;

SQL> DROP ROLE mgmt_user;

SQL> DROP USER sysman CASCADE;

SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;注意这里数据库要停机。

/bin/emca -deconfig dbcontrol db -repos drop -cluster

[oracle@p595a2:/oracle/app/oracle/product/10.2.0/db_1]$emca -deconfig dbcontrol db -repos drop -cluster

STARTED EMCA at May 10, 2010 5:37:32 PM

EM Configuration Assistant, Version 10.2.0.1.0 Production

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

Enter the following information:

Database unique name: fsyyk

Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

Password for SYSMAN user:

Password for SYSMAN user:

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

May 10, 2010 5:37:54 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /oracle/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/fsyyk/emca_2010-05-10_05-37-32-PM.log.

May 10, 2010 5:37:55 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration

WARNING: EM is not configured for this database. No EM-specific actions can be performed.

May 10, 2010 5:37:55 PM oracle.sysman.emcp.EMReposConfig dropRepository

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

May 10, 2010 5:37:56 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Enterprise Manager configuration completed successfully

注意加cluster选项和输入sys,sysman等用户密码

图形界面重建EM

dbca,选择集群，选择配置数据库选项,选择要配置的数据库，

删除em后,这时Enterprise Manager资料档案库是可选状态的，输入dbsnmp和

sysman用户密码，点finish,即可创建Em

在创建过程中可以监控

/oracle/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/fsyyk

下的emConfig.log

如果出现以下信息，则表示创建成功

****************Current Configuration****************

INSTANCENODEDBCONTROL_UPLOAD_HOST

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

fsyyk1p595a2p595a2

fsyyk2p595b2p595a2

May 10, 2010 5:48:24 PM oracle.sysman.emcp.EMConfig restoreOuiLoc

用IE浏览器登录EM正常。

也可以用脚本来重建em，

参考metalink文档ID278100.1见附件