deinstall oracle cloud control 12c

This document is for installation cleanup of oracle cloud control 12c without using installed oracle home.

1. drop user from repository database.
  select 'drop user ' || username || ' cascade ;' from dba_users where username in  ('SYSMAN', 'SYSMAN_MDS','MGMT_VIEW','SYSMAN_BIP','SYSMAN_APM','BIP','SYSMAN_OPSS','SYSMAN_RO')
2. drop synonym from repository database
  select 'drop public synonym ' || synonym_name ||  ';' from dba_synonyms where owner='PUBLIC' and table_owner in ('SYSMAN', 'SYSMAN_MDS','MGMT_VIEW','SYSMAN_BIP','SYSMAN_APM','BIP','SYSMAN_OPSS','SYSMAN_RO')

 select 'drop ' || owner || '.' || synonym_name || ';' from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS','MGMT_VIEW','SYSMAN_BIP','SYSMAN_APM','BIP','SYSMAN_OPSS','SYSMAN_RO')

3. delete registry from system.schema_version_registry

SQL> select comp_name from SCHEMA_VERSION_REGISTRY;

COMP_NAME
--------------------------------------------------------------------------------
Authorization Policy Manager
Metadata Services
Oracle Platform Security Service

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='Metadata Services';
SQL> commit;

4. deinstall EM12c software throgh original installation software.
  ./runInstaller -deinstall
  select software home and click remove.
  sequence:  a. plugin homes
                    b. agent12c
                    c. sbin
                    d. jdk1
                    e.oms12c
                    f. common

5. clean up any process of EM12c

6. rm -rf $OEM_HOME

7. check if repository was cleaned up
  SQL> select username,account_status from dba_users where username in ('SYSMAN', 'SYSMAN_MDS','MGMT_VIEW','SYSMAN_BIP','SYSMAN_APM','BIP','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','BIP','SYSMAN_OPSS','SYSMAN_RO') ;
SQL> select tablespace_name from dba_tablespaces where tablespace_name like 'MGMT%';
SQL> select comp_name from SCHEMA_VERSION_REGISTRY;

above four query should retrun 0 row.



reference:
metalink  EM 12c Cloud Control Re-Installation Fails at Repository Configuration With Error " RCU-6016:The specified prefix already exists" [ID 1365834.1]
metalink: 12c Cloud Control Repository: RepManager Dropall Command Fails To Drop all the Repository Objects [ID 1365820.1]
http://xiaoruanjian.iteye.com/blog/1365905
http://docs.oracle.com/cd/E24628_01/install.121/e24089/appdx_troubleshooting.htm
https://forums.oracle.com/forums/thread.jspa?threadID=1068831&tstart=45