RCU-6083 : Failed Drop/Remove Schema using RCU : Prerequisite OPSS failed

 

Oracle_RCU_onlineAppsDBA

Recently, one of our trainee came across the error when he was trying to drop RCU Schema that Prerequisite ” Oracle Platform Security services”  failed  . In this post, we will cover how to find what is the error and how to resolve this issue but before that one should know what is RCU.

RCU: Repository Creation Utility is tool to create schema and load repository in existing database for Fusion Middleware components. If you want to learn more about RCU then look at Post here.

You can use RCU to create or Drop Schema as shown in screenshot above

How to check Error:

Check rcu log files for error and find error messages as given below.

RCU Log file location:

RCU_HOME/rcu/log/logdir.date_timestamp/

In rcu.log file, It was showing that “RCU-6083:Failed – The Schema Owner DEV_OPSS Is Connected To The Database. Please Disconnect And Try Again” which was causing this issue.

dev_opss

Fix :

To resolve this issue, Restart Database and Listener as by doing this, it will disconnect the DEV_OPSS from Database and then we can drop RCU schema without any issue.

For stop and start database and listener you can use following steps:

To stop database and Listener:

1. Login to host where database is running.

2. Set environment variable of OAM Database.

. dbiam.env

3. stop Listener

lsnrctl stop

4. Connect to the database as ‘sysdba’

sqlplus "/as sysba"

5. stop database

SQL>shutdown immediate

To start database and listener:

1. Login to host where database is running.

2. Set environment variable of OAM Database.

. dbiam.env

3. stop Listener

lsnrctl start

4. Connect to the database as ‘sysdba’

sqlplus  "/as sysdba"

5. stop database

SQL> startup

If you want to learn more on Oracle Access Manager (OAM), then register for our free Minicourse by clicking on below image.

OAM_img

 

Series Navigation<< FREE Live Demo class with Hands-On : Oracle Access Manager : SundayOracle Access Manager: java.lang.OutOfMemoryError >>

Share This Post with Your Friends over Social Media!

About the Author Nancy Kamboj

Oracle Consultant at K21 Technologies - Oracle Gold Partner specialising in Design, Implement, and Support.

Leave a Comment: