手動刪除EMCC13C的 Repository Database

In this Document

APPLIES TO:

GOAL

 This document provides the steps for dropping the 13c Cloud Control Repository Database Objects manually.

Note:  

-  "RepManager dropall" is the supported method for dropping the Repository objects and it is  highly recommended  to drop repository objects only using the RepManager utility as described here:

Enterprise Manager Cloud Control Administrator's Guide
Release 13.2
Chapter 20 Maintaining and Troubleshooting the Management Repository
20.3 Dropping and Recreating the Management Repository

-  This document should be used in extreme cases like:

1) The OMS home is lost or removed and there is no RepManager utility availableto drop the repository objects
2) The RepManager utility fails to completely remove all repository objects.

SOLUTION

Login to repository database as  sys  user and perform the following steps to cleanup the repository database manually:

1. Drop the repository users:

SQL> drop user sysman cascade;
SQL> drop user sysman_types cascade;
SQL> drop user sysman_stb cascade;
SQL> drop user sysman_opss cascade;
SQL> drop user sysman_biplatform cascade;
SQL> drop user sysman_bip cascade;
SQL> drop user sysmanupgr_opss cascade;
SQL> drop user sysman_apm cascade;
SQL> drop user sysman_ro cascade;
SQL> drop user sysman_mds cascade;
SQL> drop user cloud_engine_user cascade;
SQL> drop user cloud_swlib_user cascade;
SQL> drop user mgmt_view cascade;
SQL> drop user eus_engine_user cascade;
SQL> drop role mgmt_user;

2. Verify if there are any leftover synonyms:

SQL> spool synonyms.lst
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', 'SYSMAN_BIPLATFORM', 'SYSMANUPGR_OPSS', 'CLOUD_ENGINE_USER', 'CLOUD_SWLIB_USER', 'EUS_ENGINE_USER', 'SYSMAN_TYPES', 'SYSMAN_STB') ;
SQL> spool off
SQL> @synonyms.lst

3. Drop the tablespaces:

SQL> drop tablespace MGMT_ECM_DEPOT_TS including contents and datafiles;
SQL> drop tablespace MGMT_TABLESPACE including contents and datafiles;
SQL> drop tablespace MGMT_AD4J_TS including contents and datafiles;

4. Delete the entries from registry:

SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';
SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Authorization Policy Manager';
SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Oracle Platform Security Services';
SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='OracleBI and EPM'
SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Service Table';
SQL> commit;

REFERENCES

........................................................................................................................

● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除

● 本文在itpub（ http://blog.itpub.net/26736162 ）、部落格園（ http://www.cnblogs.com/lhrbest ）和個人weixin公眾號（ xiaomaimiaolhr ）上有同步更新

● 本文itpub地址： http://blog.itpub.net/26736162

● 本文部落格園地址： http://www.cnblogs.com/lhrbest

● 本文pdf版、個人簡介及小麥苗雲盤地址： http://blog.itpub.net/26736162/viewspace-1624453/

● 資料庫筆試面試題庫及解答： http://blog.itpub.net/26736162/viewspace-2134706/

● DBA寶典今日頭條號地址：

........................................................................................................................

● QQ群號： 230161599 （滿） 、618766405

● weixin群：可加我weixin，我拉大家進群，非誠勿擾

● 聯絡我請加QQ好友 （ 646634621 ） ，註明新增緣由

● 於 2018-10-01 06:00 ~ 2018-10-31 24:00 在魔都完成

● 最新修改時間：2018-10-01 06:00 ~ 2018-10-31 24:00

● 文章內容來源於小麥苗的學習筆記，部分整理自網路，若有侵權或不當之處還請諒解

● 版權所有，歡迎分享本文，轉載請保留出處

........................................................................................................................

● 小麥苗的微店 ：

● 小麥苗出版的資料庫類叢書 ： http://blog.itpub.net/26736162/viewspace-2142121/

● 小麥苗OCP、OCM、高可用網路班 ： http://blog.itpub.net/26736162/viewspace-2148098/

● 小麥苗騰訊課堂主頁 ： https://lhr.ke.qq.com/

........................................................................................................................

使用 weixin客戶端 掃描下面的二維碼來關注小麥苗的weixin公眾號（ xiaomaimiaolhr ）及QQ群（DBA寶典）、新增小麥苗weixin， 學習最實用的資料庫技術。

........................................................................................................................