» Data Source: oci_database_autonomous_database

This data source provides details about a specific Autonomous Database resource in Oracle Cloud Infrastructure Database service.

Gets the details of the specified Autonomous Database.

» Example Usage

data "oci_database_autonomous_database" "test_autonomous_database" {
    #Required
    autonomous_database_id = "${oci_database_autonomous_database.test_autonomous_database.id}"
}

» Argument Reference

The following arguments are supported:

» Attributes Reference

The following attributes are exported:

  • autonomous_container_database_id - The Autonomous Container Database OCID.
  • compartment_id - The OCID of the compartment.
  • connection_strings - The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.
    • all_connection_strings - Returns all connection strings that can be used to connect to the Autonomous Database. For more information, please see Predefined Database Service Names for Autonomous Transaction Processing
    • dedicated - The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.
    • high - The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements.
    • low - The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.
    • medium - The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements.
  • connection_urls -
  • cpu_core_count - The number of CPU cores to be made available to the database.
  • data_safe_status - Status of the Data Safe registration for this Autonomous Database.
  • data_storage_size_in_tbs - The quantity of data in the database, in terabytes.
  • db_name - The database name.
  • db_version - A valid Oracle Database version for Autonomous Database.
  • db_workload - The Autonomous Database workload type. OLTP indicates an Autonomous Transaction Processing database and DW indicates an Autonomous Data Warehouse database.
  • defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
  • display_name - The user-friendly name for the Autonomous Database. The name does not have to be unique.
  • freeform_tags - Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
  • id - The OCID of the Autonomous Database.
  • is_auto_scaling_enabled - Indicates if auto scaling is enabled for the Autonomous Database CPU core count. Note that auto scaling is available for serverless deployments only.
  • is_dedicated - True if the database uses the dedicated deployment option.
  • is_free_tier - Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB memory. For Always Free databases, memory and CPU cannot be scaled.
  • is_preview - Indicates if the Autonomous Database version is a preview version.
  • license_model - The Oracle license model that applies to the Oracle Autonomous Database. The default for Autonomous Database using the [shared deployment] is BRING_YOUR_OWN_LICENSE. Note that when provisioning an Autonomous Database using the dedicated deployment option, this attribute must be null because the attribute is already set on Autonomous Exadata Infrastructure level.
  • lifecycle_details - Information about the current lifecycle state.
  • service_console_url - The URL of the Service Console for the Autonomous Database.
  • state - The current state of the database.
  • system_tags - System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
  • time_created - The date and time the database was created.
  • time_deletion_of_free_autonomous_database - The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.
  • time_reclamation_of_free_autonomous_database - The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.
  • used_data_storage_size_in_tbs - The amount of storage that has been used, in terabytes.
  • whitelisted_ips - The client IP access control list (ACL). This feature is available for serverless deployments only. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance. This is an array of CIDR (Classless Inter-Domain Routing) notations for a subnet or VCN OCID. To add the whitelist VCN specific subnet or IP, use a semicoln ';' as a deliminator to add the VCN specific subnets or IPs. Example: ["1.1.1.1","1.1.1.0/24","ocid1.vcn.oc1.sea.aaaaaaaard2hfx2nn3e5xeo6j6o62jga44xjizkw","ocid1.vcn.oc1.sea.aaaaaaaard2hfx2nn3e5xeo6j6o62jga44xjizkw;1.1.1.1","ocid1.vcn.oc1.sea.aaaaaaaard2hfx2nn3e5xeo6j6o62jga44xjizkw;1.1.0.0/16"]