Obtain Tenancy Details
When you file a service request or when you need Autonomous Database tenancy details for other reasons you can obtain these details for your instance. Tenancy details for an 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. When you contact support, provide the first five items so that support can identify your instance.
- Database Name
- Region
- Tenancy OCID
- Database OCID
- Compartment OCID
- Outbound IP Address
- Availability Domain
If you are connected to the database you can obtain tenancy details by
querying the CLOUD_IDENTITY
column of the V$PDBS
view.
For example, running the following provides the cloud identity information for an instance:
SELECT cloud_identity FROM v$pdbs;
CLOUD_IDENTITY
-----------------------------------------------------------------
{
"DATABASE_NAME" : "DBxxxxxxxxxxxx",
"REGION" : "us-phoenix-1",
"TENANT_OCID" : "OCID1.TENANCY.REGION1..ID1",
"DATABASE_OCID" : "OCID1.AUTONOMOUSDATABASE.OC1.IAD.ID2",
"COMPARTMENT_OCID" : "ocid1.tenancy.region1..ID3"
"PUBLIC_DOMAIN_NAME" : "adb.us-ashburn-1.oraclecloud.com",
"TENANT_ACCOUNT_NAME" : "test_example",
"AUTOSCALABLE_STORAGE" : false,
"BASE_SIZE" : 1099511627776,
"INFRASTRUCTURE" : "Serverless",
"SERVICE" : "ADW",
"APPLICATIONS" :
[
"GRAPH",
"ODI",
"ORDS",
"DATABASEACTIONS",
"OMLMOD",
"APEX",
"OML"
],
"OUTBOUND_IP_ADDRESS" :
[
"192.0.2.254"
]
"AVAILABILITY_DOMAIN" : "SoSC:region-1-AD-1"
"COMPUTE_MODEL" : "ECPU",
"COMPUTE_COUNT" : 2,
"COMPUTE_AUTOSCALING" : true,
"AUTONOMOUS_DATA_GUARD" :
[
{
"STANDBY_TYPE" : "local",
"AVAILABILITY_DOMAIN" : "SoSC:region-AD-2"
},
{
"STANDBY_TYPE" : "cross-region",
"AVAILABILITY_DOMAIN" : "SoSC:region-AD-1"
}
]
}
If your Autonomous Database instance was created before the tenancy details 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.
Topics
- Database Name
- Region
- Tenancy OCID
- Database OCID
- Compartment OCID
- Outbound IP Address
- Availability Domain
Parent topic: Quick Start
Database Name
You set the database name when you provision a database or when you rename a database.
The Oracle Cloud Infrastructure Console shows the database name on the Autonomous Database Details page under General Information in the Database Name field.
Parent topic: Obtain Tenancy Details
Region
The Oracle Cloud Infrastructure Console shows the region on the console, in the Regions area.
Parent topic: Obtain Tenancy Details
Tenancy OCID
The tenancy details page shows the tenancy OCID.
See Managing the Tenancy for information on accessing the Tenancy Details page.
See Resource Identifiers for information on Oracle Cloud Identifiers.
Parent topic: Obtain Tenancy Details
Database OCID
The Oracle Cloud Infrastructure Console shows the database OCID on the Autonomous Database Details page under General Information in the OCID field.
See Resource Identifiers for information on Oracle Cloud Identifiers.
Parent topic: Obtain Tenancy Details
Compartment OCID
See Managing Compartments for more information on compartments.
See Resource Identifiers for information on Oracle Cloud Identifiers.
Parent topic: Obtain Tenancy Details
Outbound IP Address
The OUTBOUND_IP_ADDRESS
is the outbound IP address of your
Autonomous Database instance. You can use
the OUTBOUND_IP_ADDRESS
when you create a database link to another Autonomous Database instance that uses ACLs to
restrict access. In this case, you need to allow the specified outbound IP address to
connect to the target Autonomous Database and
then create the database link.
The OUTBOUND_IP_ADDRESS
shows the outbound IP address in the following
cases:
-
When your Autonomous Database instance uses a Public Endpoint.
-
When your Autonomous Database instance uses a Private Endpoint and the database property
ROUTE_OUTBOUND_CONNECTIONS
is set to''
(the default value).
When your Autonomous Database instance uses a Private Endpoint and you set the database property
ROUTE_OUTBOUND_CONNECTIONS
to 'PRIVATE_ENDPOINT'
, outbound connections go through the private endpoint.
See Create One-way TLS Database Links from an Autonomous Database to another Autonomous Database for information on creating database links.
See Client Access Control for information on configuring access control rules.
Parent topic: Obtain Tenancy Details
Availability Domain
You can view the Availability Domain of your Autonomous Database instance.
This is useful when you need to deploy your Application Servers when your Autonomous Database instance resides in a multi-Availability Domain region. In order to reduce latency as much as possible you would want to deploy your Application Server and database in the same Availability Domain.
See Regions and Availability Domains for more information on Availability Domains.
Parent topic: Obtain Tenancy Details