Trouble finding the RCU schemas in OAC — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Trouble finding the RCU schemas in OAC

Received Response
13
Views
3
Comments
Mark.Thompson
Mark.Thompson Rank 6 - Analytics Lead

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?

Answers

  • 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]
    [Deleted User] Rank 2 - Community Beginner

    It's all in MOS Doc ID 2286721.1

  • Bec_Wagner
    Bec_Wagner Rank 3 - Community Apprentice

    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