Oracle 11g 重建EM需要刪除的對象

Oracle 11g 重建EM需要刪除的對象

因為需求需要重建EM,重建時因為某些錯誤被迫停止,比如對象已存在、使用者已經存在等,最終找出了建立必備的條件；

1.環境變數(Oracle和Grid在同一個使用者下安裝):

ORACLE_HOME 要設為DB路徑;

ORACLE_UNQNAME 要設定;

2.刪除em相關的同義字:

select 'drop public synonym '||synonym_name||';' from dba_synonyms where regexp_like(synonym_name,'^MGMT_|^SMP_EMD|^EMD_') order by synonym_name;3.刪除em相關使用者:

drop user MGMT_VIEW;
drop user SYSMAN cascade;4.刪除em相關role:

drop role MGMT_USER;5.檢查em相關殘留的對象,並刪除:

select * from dba_objects where status='INVALID' AND OBJECT_TYPE='SYNONYM';6.重建em:

em -config dbcontrol  db  -repos  create

Hope is personal,hope is something that no one can give to you,you have to choose to believe in hope,you have to make it yourself..