GA ANNOUNCEMENT - SQL access to tenancy details for ADB

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,