Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
GA ANNOUNCEMENT - SQL access to tenancy details for ADB — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GA ANNOUNCEMENT - SQL access to tenancy details for ADB

Question
5
Views
0
Comments
edited Jun 5, 2020 9:53AM in Autonomous Database

Content

When you file a service request for Autonomous Database, you need to provide the tenancy details for your instance. Tenancy details for the instance are available on the Oracle Cloud Infrastructure console. However, if you are connected to the database, you can now obtain these details by querying the CLOUD_IDENTITY column of the V$PDBS view. For example:

SELECT cloud_identity
FROM v$pdbs;

...will generate something similar to the following:

{"DATABASE_NAME" : "DBxxxxxxxxxxxx",
"REGION" : "us-phoenix-1", 
"TENANT_OCID" : "OCID1.TENANCY.REGION1..ID1",
"DATABASE_OCID" : "OCID1.AUTONOMOUSDATABASE.OC1.SEA.ID2",
"COMPARTMENT_OCID" : "ocid1.tenancy.region1..ID3"}

 

DOC: Obtain tenancy details for ADW to File a Service Request, 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!