Check the existence of public synonyms Remove the public synonyms

531968912發表於2018-03-22
REM
在安裝12c Cloud Control時遭遇Check the existence of public synonyms， Remove the public synonyms錯誤，由於之前安裝過一次，可能沒刪除乾淨
但是不知道public synonym名稱是什麼，上mos上查查，終於找到了一篇文章，解決方法如下：
1.刪除資料庫使用者：
drop user SYSMAN cascade;
drop user SYSMAN_MDS cascade;
drop user MGMT_VIEW cascade;
drop user SYSMAN_RO cascade;
drop user SYSMAN_OPSS cascade;
drop user SYSMAN_APM cascade; 
drop user SYSMAN_BIP;
drop user CLOUD_SWLIB_USER cascade;
drop user CLOUD_ENGINE_USER cascade;
drop role MGMT_USER;
2.刪除同義詞：
select 'drop '|| decode(owner,'PUBLIC',owner||' synonym '||synonym_name, ' synonym '||owner||'.'||synonym_name) ||';' from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS', 'MGMT_VIEW', 'SYSMAN_BIPLATFORM', 'SYSMAN_APM', 'SYSMAN_OPSS', 'SYSMAN_RO') ;
刪除之後用如下語句查詢一下：
SQL> select owner,synonym_name from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS','MGMT_VIEW','SYSMAN_BIP','SYSMAN_APM','SYSMAN_OPSS','SYSMAN_RO') ; 
3.刪除表空間;
select 'drop tablespace '||tablespace_name||' including contents and datafiles;' from dba_tablespaces where tablespace_name like 'MGMT%';
4.刪除物件：
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Authorization Policy Manager';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Oracle Platform Security Services';
commit;

執行以上步驟之後，安裝順利完成！


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25462274/viewspace-2152143/，如需轉載，請註明出處，否則將追究法律責任。

相關文章