改主機名後Oracle OEM無法使用處理方法

rudy_gao發表於2014-03-16
1,修改DBSNMP密碼: 
重新配置DBCONSOLE,需要輸入DBSNMP密碼,但任何密碼都會顯示錯誤,需要預先修改。 
sql>alter user dbsnmp identified by xxx;  
2,刪除早期DBCONSOLE建立的使用者:  
sql>drop role MGMT_USER; sql>drop user MGMT_VIEW cascade; sql>drop user sysman cascade;  
3,刪除早期DBCONSOLE建立的物件: 

sql>drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS; sql>drop public synonym SETEMVIEWUSERCONTEXT;

4. 重新建立oem

[oracle@rac log]$ emca -config dbcontrol db -repos recreate 或emca -repos recreate -host rac

5. 如果建立oem時提示

Note: For Desktop Class Install always pass parameter ORACLE_HOSTNAME 
      as "localhost" to any emca command

則:

Set ORACLE_HOSTNAME=old_hostname in the environment.


For a single-instance database:
$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db


For Oracle RAC:
$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db -cluster

參考文件:http://docs.oracle.com/cd/E18283_01/server.112/e17120/dbcontrol006.htm

相關文章