Trouble finding the RCU schemas in OAC

Question

I have created a new database in Storage Classic, and then installed OAC and pointed to that database.  Let's say that the IP address for that database is 123.456.789.012, and the OAC instance is 234.567.890.123.

One of the options in the OAC installation is the Schema Prefix, in which I entered OAC01.

I created a SQL Developer connection to 123.456.789.012, using the credentials that I specified during installation.  But when I connect to the database and look under 'Other Users', I do not see any schemas that start with OAC01, such as OAC01_BIPLATFORM.

I am attempting to activate Usage Tracking, and to do so I believe I need to execute a command such as grant select, insert, update on S_NQ_DB_ACCT to OAC01_BIPLATFORM;

I am not finding the OAC_### schemas.  Where should I be looking?

Bec_Wagner · Answer

Mark,

I was seeing this same issue and just found the fix.

Log into your OAC weblogic console (I had to create an access rule to 7001). Go to Services - Data Sources - click on biplatform_datasource - go to the Connection Pool tab.

From here, you will need to see two things.

1. your URL - will have a crazy Service Name DEV.#######.Oraclecloud.INTERNAL

a. Use this in SQL Developer (or whatever tool) as your Service Name.

2. Your user=<OAC>_BIPLATFORM

Once your SQL Developer has the correct Service Name, you should be able to see OTHER_USERS, or do a select * from all_users.

Hope this helps!!!!

--Becky

[Deleted User] · Answer

It's all in MOS Doc ID 2286721.1

Gianni Ceresa · Answer

Do you really need to grant these things?

OAC01_BIPLATFORM is the owner of the S_NQ_DB_ACCT table, so by default I would imagine it already has all the permissions on it...

You need that grant if you use a different user.