» Data Source: oci_database_databases

This data source provides the list of Databases in Oracle Cloud Infrastructure Database service.

Gets a list of the databases in the specified database home.

» Example Usage

data "oci_database_databases" "test_databases" {
    #Required
    compartment_id = "${var.compartment_id}"
    db_home_id = "${oci_database_db_home.test_db_home.id}"

    #Optional
    db_name = "${var.database_db_name}"
    state = "${var.database_state}"
}

» Argument Reference

The following arguments are supported:

  • compartment_id - (Required) The compartment OCID.
  • db_home_id - (Required) A database home OCID.
  • db_name - (Optional) A filter to return only resources that match the entire database name given. The match is not case sensitive.
  • state - (Optional) A filter to return only resources that match the given lifecycle state exactly.

» Attributes Reference

The following attributes are exported:

» Database Reference

The following attributes are exported:

  • character_set - The character set for the database.
  • compartment_id - The OCID of the compartment.
  • connection_strings - The Connection strings used to connect to the Oracle Database.
  • db_backup_config -
    • auto_backup_enabled - If set to true, configures automatic backups. If you previously used RMAN or dbcli to configure backups and then you switch to using the Console or the API for backups, a new backup configuration is created and associated with your database. This means that you can no longer rely on your previously configured unmanaged backups to work.
  • db_home_id - The OCID of the database home.
  • db_name - The database name.
  • db_unique_name - A system-generated name for the database to ensure uniqueness within an Oracle Data Guard group (a primary database and its standby databases). The unique name cannot be changed.
  • db_workload - The database workload type.
  • defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
  • 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 database.
  • lifecycle_details - Additional information about the current lifecycleState.
  • ncharacter_set - The national character set for the database.
  • pdb_name - The name of the pluggable database. The name must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted. Pluggable database should not be same as database name.
  • state - The current state of the database.
  • time_created - The date and time the database was created.