How to drop EM13c repository – the nice way

If you want to cleanup your EM13c installation, you would like to drop EM repository information as well. This is the way to do it:

oracle@oms-srv:$ cd $OMS_HOME/sysman/admin/emdrep/bin/
oracle@oms-srv:$ ./RepManager -connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=omrdb-srv)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=emrep)))" -sys_password Welcome1 -action drop
processing arguments
compiling arguments for validation
 Checking if OMS is up...
Performing PreDropAll action...
Enter password for: SYS
process_id:1ef2lsl88hv0r
null
Done PreDropAll action...
Dropping BIP schema...
Enter SYS user password :
Verify :
Action on BIP schema succeed.
Dropping APM schema...
Component is already dropped
Dropping OPSS schema...
Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Drop
Repository Drop in progress.
Percent Complete: 22
Percent Complete: 47
Percent Complete: 49
Percent Complete: 100
Repository Creation Utility: Drop - Completion Summary
Database details:
Connect Descriptor                      : (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=omrdb-srv)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=emrep)))
Connected As                    : SYS
Prefix for (prefixable) Schema Owners : SYSMAN
RCU Logfile                     : /app/oracle/em13c/oms_home/cfgtoollogs/cfgfw/emsecrepmgr.log
Component schemas dropped:
Component                       Status  Logfile
Oracle Platform Security Services               Success /app/oracle/em13c/oms_home/cfgtoollogs/cfgfw/opss.log

Repository Creation Utility - Drop : Operation Completed
Successfully dropped schema
Dropping SYSMANUPGR_OPSS schema...
Component is already dropped
Dropping STB schema...
Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Drop
Repository Drop in progress.
Percent Complete: 9
Percent Complete: 9
Percent Complete: 9
Percent Complete: 46
Percent Complete: 100
Repository Creation Utility: Drop - Completion Summary
Database details:
Connect Descriptor                      : (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=omrdb-srv)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=emrep)))
Connected As                    : SYS
Prefix for (prefixable) Schema Owners : SYSMAN
RCU Logfile                     : /app/oracle/em13c/oms_home/cfgtoollogs/cfgfw/emsecrepmgr.log
Component schemas dropped:
Component                       Status  Logfile
Common Infrastructure Services          Success /app/oracle/em13c/oms_home/cfgtoollogs/cfgfw/stb.log

Repository Creation Utility - Drop : Operation Completed
Successfully dropped schema
Dropping MDS schema...
Enter SYS user password :
Verify :
Action on MDS schema succeed.
Enter password for: SYS
process_id:qe4eu8h79p10
Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Drop
Repository Drop in progress.
Repository Creation Utility: Drop - Completion Summary
Database details:
Connect Descriptor                      : (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=omrdb-srv)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=emrep)))
Connected As                    : SYS
RCU Logfile                     : /app/oracle/em13c/oms_home/sysman/log/schemamanager/m_042320_0154_PM/m_042320_0154_PM.DROP/rcu.log
Component schemas dropped:
Component                       Status  Logfile
EM Repository Drop              Success /app/oracle/em13c/oms_home/sysman/log/schemamanager/m_042320_0154_PM/m_042320_0154_PM.DROP/em_repos_drop.log

Repository Creation Utility - Drop : Operation Completed
Performing PostDropAll action...
Enter password for: SYS
process_id:edjh177e3gbr
drop completed successfully

Have fun!

Leave Comment

Your email address will not be published. Required fields are marked *