F Obtain Tenancy Details to File a Service Request

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 or you can obtain these details by querying the database.

If you need to file a service request use Oracle Cloud Support or contact your support representative and provide the following information:

  • Database name
  • Region
  • Tenant OCID
  • Database OCID
  • Compartment OCID

If you are connected to the database you can obtain these details by querying the CLOUD_IDENTITY column of the V$PDBS view.

For example:

SELECT cloud_identity FROM v$pdbs;
{
  "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"
}

Note:

If your Autonomous Database instance was created before this feature was added and has not been restarted, then this query does not return tenancy details. In this case, as a one-time operation, restart your instance and run the query again. You can restart your instance from the Oracle Cloud Infrastructure console or using the restart API.

See Restart Autonomous Data Warehouse for information on using restart from the Oracle Cloud Infrastructure console.

See RestartAutonomousDatabase for information on the restart API.

See Resource Identifiers for information on Oracle Cloud Identifiers.