oracle oem 重建,重建OEM的步骤

  • Post author:
  • Post category:其他


1、重新配置OEM时,一定要首先配置监听,并启动监听。

2、保证监听里的host是静态IP地址或者主机名;

3、在日志文件中,出现以下错误:ORA-20001: SYSMAN already exists..

ORA-06512:在line 17,运行以下命令之后:

drop user sysman cascade;

drop role MGMT_USER;

DROP USER MGMT_VIEW CASCADE;

drop public synonym MGMT_TARGET_BLACKOUTS;

drop public synonym SETEMVIEWUSERCONTEXT;

4、运行命令。重建OEM:emca -config

dbcontrol db-repos recreate

5、如果出现以下错误,则首先检查监听中host是否是静态IP或者主机名,然后再按照下边红色的步骤操作。

保护Database Control时出错, Database

Control已在非安全模式下启动。要保护Database Control,请执行以下命令:

1)将环境变量ORACLE_SID设置为orcl

2) D:\oracle\product\10.2.0\db_1\bin\emctl.bat

stop dbconsole

3) D:\oracle\product\10.2.0\db_1\bin\emctl.bat

config emkey -repos -sysman_pwd < SYSMAN用户的口令>

4) D:\oracle\product\10.2.0\db_1\bin\emctl.bat

secure dbconsole -sysman_pwd < SYSMAN用户的口令>

5) D:\oracle\product\10.2.0\db_1\bin\emctl.bat

start dbconsole

要保护EM密钥,请运行D:\oracle\product\10.2.0\db_1\bin\emctl.bat config emkey-remove_from_repos -sysman_pwd < SYSMAN用户的口令>

C:\Windows\system32>set ORACLE_SID=orcl

C:\Windows\system32>D:\oracle\product\10.2.0\db_1\bin\emctl.bat

config emkey -repos -sysman_pwd windows host thinkpad sid orcl

Oracle

Enterprise Manager 10g Database Control Release 10.2.0.4.0

Copyright

(c) 1996, 2007 Oracle Corporation.All

rights reserved.

Invalid

Password

caught Exception java.sql.SQLException: Io异常: The Network Adapter could not establish the connection

注释:监听主机名不是静态Ip或者主机名

C:\Windows\system32>D:\oracle\product\10.2.0\db_1\bin\emctl.bat config emkey -repos

-sysman_pwd windows host thinkpad sid orcl

Oracle

Enterprise Manager 10g Database Control Release 10.2.0.4.0

Copyright

(c) 1996, 2007 Oracle Corporation.All

rights reserved.

The Em

Key has been configured successfully.

C:\Windows\system32>

D:\oracle\product\10.2.0\db_1\bin\emctl.bat secure

dbconsole -sysman_pwd windows host thinkpad sid orcl

Oracle

Enterprise Manager 10g Database Control Release 10.2.0.4.0

Copyright

(c) 1996, 2007 Oracle Corporation.All

rights reserved.

C:\Windows\system32>emctl start dbconsole

Normal

0

7.8 磅

0

2

false

false

false

EN-US

ZH-CN

X-NONE