Check the existence of public synonyms Remove the public synonyms
在安裝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;
執行以上步驟之後,安裝順利完成!
但是不知道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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Public Synonyms for Data Dictionary Views (263)View
- Oracle synonyms總結Oracle
- Overview of Synonyms (193)View
- ORA-01775: looping chain of synonymsOOPAI
- 【Oracle】-【同義詞】-public與非public同義詞Oracle
- public interface View介面和public interface ViewResolver介面介紹View
- Oracle中的publicOracle
- public void sendHtmlHTML
- public-image-mirror
- Elasticsearch:使用同義詞 synonyms 來提高搜尋效率Elasticsearch
- Azure Public IP DNS域名DNS
- SKYPE -- Public database projectsDatabaseProject
- win rac public ip 修改
- 修改Public/Interconnect IP
- 10g ALL_SYNONYMS同義詞查詢效能下降
- var和public的區別
- Angular Public API 介面設計AngularAPI
- Public Private VIP的區別
- RAC 11.2.0.3 修改 Public IP
- CRS : PUBLIC網路卡的STANDBY
- 【Java小疑問】類和方法 前面新增public和不新增public的區別Java
- expdp ORA-01775: looping chain of synonyms 解決辦法OOPAI
- Oracle 12.2 RAC修改public ip address或public ip(subnet (netmask) or interface)Oracle
- Python 訪問限制 private publicPython
- Swift 3.0 的 open,public,internal,fiSwift
- PostgreSQL-PostgreSQL中的public(九)SQL
- Oracle RAC修改public, VIP, SCAN IPOracle
- Synonym_View_Materialized和Public物件ViewZed物件
- revoke EXECUTE privileges on powerful packages from PUBLICPackage
- java中的 public protected friendly privateJava
- Azure PIP (Instance Level Public IP)
- Role of Public,Private,Virtual, and SCAN IPs
- public void setModerationMinThreadValue(int value)thread
- Public與Private的區別 (轉)
- rac 新增第二public ip 和 vip
- 修改 Laravel 的預設 public 路徑Laravel
- 私有屬性的Get Set 與 Public
- Oracle RAC修改public,private,vip scan IPOracle