Trouble finding the RCU schemas in OAC

Mark.Thompson · Mar 19, 2018 2:32PM

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?

Gianni Ceresa · Mar 19, 2018 3:14PM

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.

[Deleted User] · Mar 19, 2018 3:23PM

It's all in MOS Doc ID 2286721.1

Bec_Wagner · Mar 19, 2018 4:32PM

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

Oracle Analytics Cloud and Server

Categories

Trouble finding the RCU schemas in OAC

Answers