How to know which RCU schema is the "active" one

Question

Having inherited a machine on which the Oracle database and  WLS/FMC/OBIEE are installed, it appears that there were several attempts to install and configure the software.  As a result, there are many database schemas that look like the components of an RCU.

For example, I have many _BIPLATFORM schemas, many _IAU schemas, and so forth, each with a different prefix.

What can I query or look at to see which of those several installations contain the "real" RCU schema for my system (and which ones are just leftovers that weren't properly deleted)?

Mark.Thompson · Answer

No sweat, bro.  I just filled in the little details.  Knowing which highway to travel is the big thing!

[Deleted User] · Answer

Thanks for spelling things out

Mark.Thompson · Answer

Thank you, Christian.

FYI to others, as Christian indicated, navigate to Services => Data Sources.

On the Summary of JDBC Data Sources page, click any entry under the Name column in the displayed table.

Then click the Configuration tab and the Connection Pool subtab.

I found the reference to the RCU schema in the Properties field on that page.  Mine says user = ZBI02_BIPLATFORM, so it appears that my RCU prefix is ZBI02.  And sure enough, the thing I was looking for is present in the ZBI02_BIPLATFORM schema.

Correct answer awarded to Christian (as usual!!)