What are RCU schemas for?

3310714

Hi,

During the installation of OBIEE 12c, the RCU tool creates about 7 database schemas such as (bi_platform, mds, etc).  I was wondering what they are used for? 

Our DBA notified me some of the schema accounts expired and receiving "failed login errors" on the database end.  However, I am able to log into Analytics and run reports.  Can anyone shed some insights on what these schemas are used for?

Gbenga Ajakaye

Many of the Oracle Fusion Middleware components require the existence of schemas in a database prior to installation. These schemas are created and loaded in your database using the Repository Creation Utility (RCU).

From: https://docs.oracle.com/cd/E21764_01/doc.1111/e14259/overview.htm#RCUUG101

3310714

Hi Gbenga,

I know they are required, but what are they used for? 

rmoff

Holding internal application data, including Usage Tracking, job scheduling metadata, and a lot more. They are not optional; even if analyses are running, your system will break/be unstable if the RCU schemas are unavailable.

GermanA-Oracle

You can find the description for each of the schemas and their dependencies in the Fusion Middleware Creating Schemas with the Repository Creation Utility Guide, https://docs.oracle.com/middleware/12212/lcm/RCUUG/GUID-41B96F7C-B4CC-4FA1-85BA-1933B0728B38.htm#RCUUG170 .