在安裝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;
