EM 12c: RepManager Dropall Command Fails to Drop all the Enterprise Manager 12c Cloud Control Repository Objects (Doc ID 1365820.1)

Last updated on APRIL 19, 2023

Applies to:

Symptoms

Dropping the Enterprise Manager (EM) 12c Cloud Control Repository using "RepManager dropall" command does not drop all repository objects:

cd <OMS_HOME>/sysman/admin/emdrep/bin
RepManager repomachine.domain 1521 orcl -action dropall -dbUser sys -dbPassword <PASSWORD> -dbRole sysdba -mwHome <PATH>/oracle/Middleware
-mwOraHome /home/oracle/Middleware -oracleHome <PATH>/oracle/Middleware/oms

Terminal output shows:
==================
............
processing arguments
.
action logger filename finally: emschema.log
filename: <PATH>/oracle/Middleware/oms/sysman/log/schemamanager/emschema.log
newly created: <PATH>/oracle/Middleware/oms/sysman/log/schemamanager/emschema.log
Driver: oracle.jdbc.driver.OracleDriver
jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=<HOSTNAME>(Port=<PORT>)))(CONNECT_DATA=(SID=<SID>)))
action to perform is: drop
action is non-transx - RCU based action
logger null: check if repos user exists..
logger null: found connection for DB user
logger null: query DB for repos user existence check
logger null: REPOS_CONN is null in check repos user... creating new one
jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=<HOSTNAME>(Port=<PORT>)))(CONNECT_DATA=(SID=<SID>)))
jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=<HOSTNAME>)(Port=<PORT>)))(CONNECT_DATA=(SID=<SID>)))
logger null: connection is found null
Error found: Validation Failure for Action: [DROP]. The reason for failure was: [null repos-connection found]

Dropping MDS schema...
.
RCU Logfile : <PATH>/oracle/Middleware/oms/emmds.log
Component schemas dropped:
Component Status Logfile
Metadata Services Success <PATH>/oracle/Middleware/oms/mds.log
Repository Creation Utility - Drop : Operation Completed

Dropping OPSS schema...
.
RCU Logfile : <PATH>/oracle/Middleware/oms/cfgtoollogs/cfgfw/emsecrepmgr.log
Component schemas dropped:
Component Status Logfile
Oracle Platform Security Services Success <PATH>/oracle/Middleware/oms/cfgtoollogs/cfgfw/opss.log
Repository Creation Utility - Drop : Operation Completed
Successfully dropped schema

Dropping APM schema...
.
RCU Logfile : <PATH>/oracle/Middleware/oms/cfgtoollogs/cfgfw/emsecrepmgr.log
Component schemas dropped:
Component Status Logfile
Authorization Policy Manager Success <PATH>/oracle/Middleware/oms/cfgtoollogs/cfgfw/apm.log
Repository Creation Utility - Drop : Operation Completed
Successfully dropped schema

Dropping BIP schema...
.
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
RCU-6013:Specified prefix does not exist. Existing prefixes are: None
RCU-6091:Component name/schema prefix validation failed.
===========

-  There are no errors reported on the terminal or in any of the log files generated by the RepManager:

<OMS_HOME>/emmds.log
<OMS_HOME>/cfgtoollogs/cfgfw/opss.log
<OMS_HOME>/cfgtoollogs/cfgfw/emsecrepmgr.log
<OMS_HOME>/cfgtoollogs/cfgfw/apm.log

All the log files show that the drop operation has been completed successfully.

-  The BIP schema log <OMS_HOME>/embiplatform.log reports the following error:

ERROR rcu: oracle.sysman.assistants.rcu.backend.RCUCommandLineParser::setComponentSelections: RCU-6013:Specified prefix does not exist. Existing prefixes are: None

This error can be ignored as it occurs if the BIP user (for Oracle BI Publisher) has not been configured in the Cloud Console. As the user does not exist, attempting to drop it fails with "RCU-6013:Specified prefix does not exist"

• If all the Repository objects are not cleanly dropped, attempting to re-create the Cloud Control Repository in the same database will result in the issue described in
  <Document 1365818.1>: 12C Cloud Control UI: Accessing the Console UI Shows "ADFC-0619: Authorization check failed: 'Oracle.jbo.uicli.binding.JUFormDef@2bd9bbee' 'VIEW'."

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.