因?yàn)樾枨笮枰亟‥M,重建時(shí)因?yàn)槟承╁e(cuò)誤被迫停止,比如對(duì)象已存在、用戶已經(jīng)存在等,最終找出了創(chuàng)建必備的條件；

1.環(huán)境變量(Oracle和Grid在同一個(gè)用戶下安裝):

ORACLE_HOME 要設(shè)為DB路徑;

ORACLE_UNQNAME 要設(shè)置;

2.刪除em相關(guān)的同義詞:

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

drop user MGMT_VIEW;

drop user SYSMAN cascade;4.刪除em相關(guān)role:

drop role MGMT_USER;5.檢查em相關(guān)殘留的對(duì)象,并刪除:

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..

總結(jié)

以上是生活随笔為你收集整理的oracle em 删除 重建,Oracle 11g 重建EM需要删除的对象的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。