1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabases
Oracle Cloud Infrastructure v2.13.0 published on Tuesday, Oct 22, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabases

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.13.0 published on Tuesday, Oct 22, 2024 by Pulumi

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

    Gets the Managed Database for a specific ID or the list of Managed Databases in a specific compartment. Managed Databases can be filtered based on the name parameter. Only one of the parameters, ID or name should be provided. If neither of these parameters is provided, all the Managed Databases in the compartment are listed. Managed Databases can also be filtered based on the deployment type and management option. If the deployment type is not specified or if it is ONPREMISE, then the management option is not considered and Managed Databases with ADVANCED management option are listed.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedDatabases = oci.DatabaseManagement.getManagedDatabases({
        compartmentId: compartmentId,
        deploymentType: managedDatabaseDeploymentType,
        externalExadataInfrastructureId: testExternalExadataInfrastructure.id,
        id: managedDatabaseId,
        managementOption: managedDatabaseManagementOption,
        name: managedDatabaseName,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_databases = oci.DatabaseManagement.get_managed_databases(compartment_id=compartment_id,
        deployment_type=managed_database_deployment_type,
        external_exadata_infrastructure_id=test_external_exadata_infrastructure["id"],
        id=managed_database_id,
        management_option=managed_database_management_option,
        name=managed_database_name)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/DatabaseManagement"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := DatabaseManagement.GetManagedDatabases(ctx, &databasemanagement.GetManagedDatabasesArgs{
    			CompartmentId:                   compartmentId,
    			DeploymentType:                  pulumi.StringRef(managedDatabaseDeploymentType),
    			ExternalExadataInfrastructureId: pulumi.StringRef(testExternalExadataInfrastructure.Id),
    			Id:                              pulumi.StringRef(managedDatabaseId),
    			ManagementOption:                pulumi.StringRef(managedDatabaseManagementOption),
    			Name:                            pulumi.StringRef(managedDatabaseName),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testManagedDatabases = Oci.DatabaseManagement.GetManagedDatabases.Invoke(new()
        {
            CompartmentId = compartmentId,
            DeploymentType = managedDatabaseDeploymentType,
            ExternalExadataInfrastructureId = testExternalExadataInfrastructure.Id,
            Id = managedDatabaseId,
            ManagementOption = managedDatabaseManagementOption,
            Name = managedDatabaseName,
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
    import com.pulumi.oci.DatabaseManagement.inputs.GetManagedDatabasesArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var testManagedDatabases = DatabaseManagementFunctions.getManagedDatabases(GetManagedDatabasesArgs.builder()
                .compartmentId(compartmentId)
                .deploymentType(managedDatabaseDeploymentType)
                .externalExadataInfrastructureId(testExternalExadataInfrastructure.id())
                .id(managedDatabaseId)
                .managementOption(managedDatabaseManagementOption)
                .name(managedDatabaseName)
                .build());
    
        }
    }
    
    variables:
      testManagedDatabases:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedDatabases
          Arguments:
            compartmentId: ${compartmentId}
            deploymentType: ${managedDatabaseDeploymentType}
            externalExadataInfrastructureId: ${testExternalExadataInfrastructure.id}
            id: ${managedDatabaseId}
            managementOption: ${managedDatabaseManagementOption}
            name: ${managedDatabaseName}
    

    Using getManagedDatabases

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getManagedDatabases(args: GetManagedDatabasesArgs, opts?: InvokeOptions): Promise<GetManagedDatabasesResult>
    function getManagedDatabasesOutput(args: GetManagedDatabasesOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabasesResult>
    def get_managed_databases(compartment_id: Optional[str] = None,
                              deployment_type: Optional[str] = None,
                              external_exadata_infrastructure_id: Optional[str] = None,
                              filters: Optional[Sequence[_databasemanagement.GetManagedDatabasesFilter]] = None,
                              id: Optional[str] = None,
                              management_option: Optional[str] = None,
                              name: Optional[str] = None,
                              opts: Optional[InvokeOptions] = None) -> GetManagedDatabasesResult
    def get_managed_databases_output(compartment_id: Optional[pulumi.Input[str]] = None,
                              deployment_type: Optional[pulumi.Input[str]] = None,
                              external_exadata_infrastructure_id: Optional[pulumi.Input[str]] = None,
                              filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabasesFilterArgs]]]] = None,
                              id: Optional[pulumi.Input[str]] = None,
                              management_option: Optional[pulumi.Input[str]] = None,
                              name: Optional[pulumi.Input[str]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabasesResult]
    func GetManagedDatabases(ctx *Context, args *GetManagedDatabasesArgs, opts ...InvokeOption) (*GetManagedDatabasesResult, error)
    func GetManagedDatabasesOutput(ctx *Context, args *GetManagedDatabasesOutputArgs, opts ...InvokeOption) GetManagedDatabasesResultOutput

    > Note: This function is named GetManagedDatabases in the Go SDK.

    public static class GetManagedDatabases 
    {
        public static Task<GetManagedDatabasesResult> InvokeAsync(GetManagedDatabasesArgs args, InvokeOptions? opts = null)
        public static Output<GetManagedDatabasesResult> Invoke(GetManagedDatabasesInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetManagedDatabasesResult> getManagedDatabases(GetManagedDatabasesArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DatabaseManagement/getManagedDatabases:getManagedDatabases
      arguments:
        # arguments dictionary

    The following arguments are supported:

    CompartmentId string
    The OCID of the compartment.
    DeploymentType string
    A filter to return Managed Databases of the specified deployment type.
    ExternalExadataInfrastructureId string
    The OCID of the Exadata infrastructure.
    Filters List<GetManagedDatabasesFilter>
    Id string
    The identifier of the resource.
    ManagementOption string
    A filter to return Managed Databases with the specified management option.
    Name string
    A filter to return only resources that match the entire name.
    CompartmentId string
    The OCID of the compartment.
    DeploymentType string
    A filter to return Managed Databases of the specified deployment type.
    ExternalExadataInfrastructureId string
    The OCID of the Exadata infrastructure.
    Filters []GetManagedDatabasesFilter
    Id string
    The identifier of the resource.
    ManagementOption string
    A filter to return Managed Databases with the specified management option.
    Name string
    A filter to return only resources that match the entire name.
    compartmentId String
    The OCID of the compartment.
    deploymentType String
    A filter to return Managed Databases of the specified deployment type.
    externalExadataInfrastructureId String
    The OCID of the Exadata infrastructure.
    filters List<GetManagedDatabasesFilter>
    id String
    The identifier of the resource.
    managementOption String
    A filter to return Managed Databases with the specified management option.
    name String
    A filter to return only resources that match the entire name.
    compartmentId string
    The OCID of the compartment.
    deploymentType string
    A filter to return Managed Databases of the specified deployment type.
    externalExadataInfrastructureId string
    The OCID of the Exadata infrastructure.
    filters GetManagedDatabasesFilter[]
    id string
    The identifier of the resource.
    managementOption string
    A filter to return Managed Databases with the specified management option.
    name string
    A filter to return only resources that match the entire name.
    compartment_id str
    The OCID of the compartment.
    deployment_type str
    A filter to return Managed Databases of the specified deployment type.
    external_exadata_infrastructure_id str
    The OCID of the Exadata infrastructure.
    filters Sequence[databasemanagement.GetManagedDatabasesFilter]
    id str
    The identifier of the resource.
    management_option str
    A filter to return Managed Databases with the specified management option.
    name str
    A filter to return only resources that match the entire name.
    compartmentId String
    The OCID of the compartment.
    deploymentType String
    A filter to return Managed Databases of the specified deployment type.
    externalExadataInfrastructureId String
    The OCID of the Exadata infrastructure.
    filters List<Property Map>
    id String
    The identifier of the resource.
    managementOption String
    A filter to return Managed Databases with the specified management option.
    name String
    A filter to return only resources that match the entire name.

    getManagedDatabases Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment in which the Managed Database Group resides.
    ManagedDatabaseCollections List<GetManagedDatabasesManagedDatabaseCollection>
    The list of managed_database_collection.
    DeploymentType string
    The infrastructure used to deploy the Oracle Database.
    ExternalExadataInfrastructureId string
    Filters List<GetManagedDatabasesFilter>
    Id string
    The OCID of the Managed Database Group.
    ManagementOption string
    The management option used when enabling Database Management.
    Name string
    The name of the Managed Database.
    CompartmentId string
    The OCID of the compartment in which the Managed Database Group resides.
    ManagedDatabaseCollections []GetManagedDatabasesManagedDatabaseCollection
    The list of managed_database_collection.
    DeploymentType string
    The infrastructure used to deploy the Oracle Database.
    ExternalExadataInfrastructureId string
    Filters []GetManagedDatabasesFilter
    Id string
    The OCID of the Managed Database Group.
    ManagementOption string
    The management option used when enabling Database Management.
    Name string
    The name of the Managed Database.
    compartmentId String
    The OCID of the compartment in which the Managed Database Group resides.
    managedDatabaseCollections List<GetManagedDatabasesManagedDatabaseCollection>
    The list of managed_database_collection.
    deploymentType String
    The infrastructure used to deploy the Oracle Database.
    externalExadataInfrastructureId String
    filters List<GetManagedDatabasesFilter>
    id String
    The OCID of the Managed Database Group.
    managementOption String
    The management option used when enabling Database Management.
    name String
    The name of the Managed Database.
    compartmentId string
    The OCID of the compartment in which the Managed Database Group resides.
    managedDatabaseCollections GetManagedDatabasesManagedDatabaseCollection[]
    The list of managed_database_collection.
    deploymentType string
    The infrastructure used to deploy the Oracle Database.
    externalExadataInfrastructureId string
    filters GetManagedDatabasesFilter[]
    id string
    The OCID of the Managed Database Group.
    managementOption string
    The management option used when enabling Database Management.
    name string
    The name of the Managed Database.
    compartment_id str
    The OCID of the compartment in which the Managed Database Group resides.
    managed_database_collections Sequence[databasemanagement.GetManagedDatabasesManagedDatabaseCollection]
    The list of managed_database_collection.
    deployment_type str
    The infrastructure used to deploy the Oracle Database.
    external_exadata_infrastructure_id str
    filters Sequence[databasemanagement.GetManagedDatabasesFilter]
    id str
    The OCID of the Managed Database Group.
    management_option str
    The management option used when enabling Database Management.
    name str
    The name of the Managed Database.
    compartmentId String
    The OCID of the compartment in which the Managed Database Group resides.
    managedDatabaseCollections List<Property Map>
    The list of managed_database_collection.
    deploymentType String
    The infrastructure used to deploy the Oracle Database.
    externalExadataInfrastructureId String
    filters List<Property Map>
    id String
    The OCID of the Managed Database Group.
    managementOption String
    The management option used when enabling Database Management.
    name String
    The name of the Managed Database.

    Supporting Types

    GetManagedDatabasesFilter

    Name string
    A filter to return only resources that match the entire name.
    Values List<string>
    Regex bool
    Name string
    A filter to return only resources that match the entire name.
    Values []string
    Regex bool
    name String
    A filter to return only resources that match the entire name.
    values List<String>
    regex Boolean
    name string
    A filter to return only resources that match the entire name.
    values string[]
    regex boolean
    name str
    A filter to return only resources that match the entire name.
    values Sequence[str]
    regex bool
    name String
    A filter to return only resources that match the entire name.
    values List<String>
    regex Boolean

    GetManagedDatabasesManagedDatabaseCollection

    GetManagedDatabasesManagedDatabaseCollectionItem

    AdditionalDetails Dictionary<string, string>
    The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
    CompartmentId string
    The OCID of the compartment.
    DatabasePlatformName string
    The operating system of database.
    DatabaseStatus string
    The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
    DatabaseSubType string
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.
    DatabaseType string
    The type of Oracle Database installation.
    DatabaseVersion string
    The Oracle Database version.
    DbSystemId string
    The OCID of the external DB system that this Managed Database is part of.
    DbmgmtFeatureConfigs List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig>
    The list of feature configurations
    DefinedTags Dictionary<string, string>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
    DeploymentType string
    A filter to return Managed Databases of the specified deployment type.
    FreeformTags Dictionary<string, string>
    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 string
    The identifier of the resource.
    IsCluster bool
    Indicates whether the Oracle Database is part of a cluster.
    ManagedDatabaseGroups List<GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup>
    A list of Managed Database Groups that the Managed Database belongs to.
    ManagementOption string
    A filter to return Managed Databases with the specified management option.
    Name string
    A filter to return only resources that match the entire name.
    ParentContainerId string
    The OCID of the parent Container Database if Managed Database is a Pluggable Database.
    StorageSystemId string
    The OCID of the storage DB system.
    SystemTags Dictionary<string, string>
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The date and time the Managed Database was created.
    WorkloadType string
    The workload type of the Autonomous Database.
    AdditionalDetails map[string]string
    The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
    CompartmentId string
    The OCID of the compartment.
    DatabasePlatformName string
    The operating system of database.
    DatabaseStatus string
    The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
    DatabaseSubType string
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.
    DatabaseType string
    The type of Oracle Database installation.
    DatabaseVersion string
    The Oracle Database version.
    DbSystemId string
    The OCID of the external DB system that this Managed Database is part of.
    DbmgmtFeatureConfigs []GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig
    The list of feature configurations
    DefinedTags map[string]string
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
    DeploymentType string
    A filter to return Managed Databases of the specified deployment type.
    FreeformTags map[string]string
    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 string
    The identifier of the resource.
    IsCluster bool
    Indicates whether the Oracle Database is part of a cluster.
    ManagedDatabaseGroups []GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup
    A list of Managed Database Groups that the Managed Database belongs to.
    ManagementOption string
    A filter to return Managed Databases with the specified management option.
    Name string
    A filter to return only resources that match the entire name.
    ParentContainerId string
    The OCID of the parent Container Database if Managed Database is a Pluggable Database.
    StorageSystemId string
    The OCID of the storage DB system.
    SystemTags map[string]string
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The date and time the Managed Database was created.
    WorkloadType string
    The workload type of the Autonomous Database.
    additionalDetails Map<String,String>
    The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
    compartmentId String
    The OCID of the compartment.
    databasePlatformName String
    The operating system of database.
    databaseStatus String
    The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
    databaseSubType String
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.
    databaseType String
    The type of Oracle Database installation.
    databaseVersion String
    The Oracle Database version.
    dbSystemId String
    The OCID of the external DB system that this Managed Database is part of.
    dbmgmtFeatureConfigs List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig>
    The list of feature configurations
    definedTags Map<String,String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
    deploymentType String
    A filter to return Managed Databases of the specified deployment type.
    freeformTags Map<String,String>
    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 String
    The identifier of the resource.
    isCluster Boolean
    Indicates whether the Oracle Database is part of a cluster.
    managedDatabaseGroups List<GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup>
    A list of Managed Database Groups that the Managed Database belongs to.
    managementOption String
    A filter to return Managed Databases with the specified management option.
    name String
    A filter to return only resources that match the entire name.
    parentContainerId String
    The OCID of the parent Container Database if Managed Database is a Pluggable Database.
    storageSystemId String
    The OCID of the storage DB system.
    systemTags Map<String,String>
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The date and time the Managed Database was created.
    workloadType String
    The workload type of the Autonomous Database.
    additionalDetails {[key: string]: string}
    The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
    compartmentId string
    The OCID of the compartment.
    databasePlatformName string
    The operating system of database.
    databaseStatus string
    The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
    databaseSubType string
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.
    databaseType string
    The type of Oracle Database installation.
    databaseVersion string
    The Oracle Database version.
    dbSystemId string
    The OCID of the external DB system that this Managed Database is part of.
    dbmgmtFeatureConfigs GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig[]
    The list of feature configurations
    definedTags {[key: string]: string}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
    deploymentType string
    A filter to return Managed Databases of the specified deployment type.
    freeformTags {[key: string]: string}
    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 string
    The identifier of the resource.
    isCluster boolean
    Indicates whether the Oracle Database is part of a cluster.
    managedDatabaseGroups GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup[]
    A list of Managed Database Groups that the Managed Database belongs to.
    managementOption string
    A filter to return Managed Databases with the specified management option.
    name string
    A filter to return only resources that match the entire name.
    parentContainerId string
    The OCID of the parent Container Database if Managed Database is a Pluggable Database.
    storageSystemId string
    The OCID of the storage DB system.
    systemTags {[key: string]: string}
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated string
    The date and time the Managed Database was created.
    workloadType string
    The workload type of the Autonomous Database.
    additional_details Mapping[str, str]
    The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
    compartment_id str
    The OCID of the compartment.
    database_platform_name str
    The operating system of database.
    database_status str
    The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
    database_sub_type str
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.
    database_type str
    The type of Oracle Database installation.
    database_version str
    The Oracle Database version.
    db_system_id str
    The OCID of the external DB system that this Managed Database is part of.
    dbmgmt_feature_configs Sequence[databasemanagement.GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig]
    The list of feature configurations
    defined_tags Mapping[str, str]
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
    deployment_type str
    A filter to return Managed Databases of the specified deployment type.
    freeform_tags Mapping[str, str]
    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 str
    The identifier of the resource.
    is_cluster bool
    Indicates whether the Oracle Database is part of a cluster.
    managed_database_groups Sequence[databasemanagement.GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup]
    A list of Managed Database Groups that the Managed Database belongs to.
    management_option str
    A filter to return Managed Databases with the specified management option.
    name str
    A filter to return only resources that match the entire name.
    parent_container_id str
    The OCID of the parent Container Database if Managed Database is a Pluggable Database.
    storage_system_id str
    The OCID of the storage DB system.
    system_tags Mapping[str, str]
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created str
    The date and time the Managed Database was created.
    workload_type str
    The workload type of the Autonomous Database.
    additionalDetails Map<String>
    The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
    compartmentId String
    The OCID of the compartment.
    databasePlatformName String
    The operating system of database.
    databaseStatus String
    The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
    databaseSubType String
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.
    databaseType String
    The type of Oracle Database installation.
    databaseVersion String
    The Oracle Database version.
    dbSystemId String
    The OCID of the external DB system that this Managed Database is part of.
    dbmgmtFeatureConfigs List<Property Map>
    The list of feature configurations
    definedTags Map<String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
    deploymentType String
    A filter to return Managed Databases of the specified deployment type.
    freeformTags Map<String>
    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 String
    The identifier of the resource.
    isCluster Boolean
    Indicates whether the Oracle Database is part of a cluster.
    managedDatabaseGroups List<Property Map>
    A list of Managed Database Groups that the Managed Database belongs to.
    managementOption String
    A filter to return Managed Databases with the specified management option.
    name String
    A filter to return only resources that match the entire name.
    parentContainerId String
    The OCID of the parent Container Database if Managed Database is a Pluggable Database.
    storageSystemId String
    The OCID of the storage DB system.
    systemTags Map<String>
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The date and time the Managed Database was created.
    workloadType String
    The workload type of the Autonomous Database.

    GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig

    ConnectorDetails List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigConnectorDetail>
    The connector details required to connect to an Oracle cloud database.
    DatabaseConnectionDetails List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetail>
    The connection details required to connect to the database.
    Feature string
    The name of the Database Management feature.
    FeatureStatus string
    The list of statuses for Database Management features.
    LicenseModel string
    The Oracle license model that applies to the external database.
    ConnectorDetails []GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigConnectorDetail
    The connector details required to connect to an Oracle cloud database.
    DatabaseConnectionDetails []GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetail
    The connection details required to connect to the database.
    Feature string
    The name of the Database Management feature.
    FeatureStatus string
    The list of statuses for Database Management features.
    LicenseModel string
    The Oracle license model that applies to the external database.
    connectorDetails List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigConnectorDetail>
    The connector details required to connect to an Oracle cloud database.
    databaseConnectionDetails List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetail>
    The connection details required to connect to the database.
    feature String
    The name of the Database Management feature.
    featureStatus String
    The list of statuses for Database Management features.
    licenseModel String
    The Oracle license model that applies to the external database.
    connectorDetails GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigConnectorDetail[]
    The connector details required to connect to an Oracle cloud database.
    databaseConnectionDetails GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetail[]
    The connection details required to connect to the database.
    feature string
    The name of the Database Management feature.
    featureStatus string
    The list of statuses for Database Management features.
    licenseModel string
    The Oracle license model that applies to the external database.
    connector_details Sequence[databasemanagement.GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigConnectorDetail]
    The connector details required to connect to an Oracle cloud database.
    database_connection_details Sequence[databasemanagement.GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetail]
    The connection details required to connect to the database.
    feature str
    The name of the Database Management feature.
    feature_status str
    The list of statuses for Database Management features.
    license_model str
    The Oracle license model that applies to the external database.
    connectorDetails List<Property Map>
    The connector details required to connect to an Oracle cloud database.
    databaseConnectionDetails List<Property Map>
    The connection details required to connect to the database.
    feature String
    The name of the Database Management feature.
    featureStatus String
    The list of statuses for Database Management features.
    licenseModel String
    The Oracle license model that applies to the external database.

    GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigConnectorDetail

    ConnectorType string
    The list of supported connection types:

    • PE: Private endpoint
    • MACS: Management agent
    • EXTERNAL: External database connector
    DatabaseConnectorId string
    The OCID of the external database connector.
    ManagementAgentId string
    The OCID of the management agent.
    PrivateEndPointId string
    The OCID of the private endpoint.
    ConnectorType string
    The list of supported connection types:

    • PE: Private endpoint
    • MACS: Management agent
    • EXTERNAL: External database connector
    DatabaseConnectorId string
    The OCID of the external database connector.
    ManagementAgentId string
    The OCID of the management agent.
    PrivateEndPointId string
    The OCID of the private endpoint.
    connectorType String
    The list of supported connection types:

    • PE: Private endpoint
    • MACS: Management agent
    • EXTERNAL: External database connector
    databaseConnectorId String
    The OCID of the external database connector.
    managementAgentId String
    The OCID of the management agent.
    privateEndPointId String
    The OCID of the private endpoint.
    connectorType string
    The list of supported connection types:

    • PE: Private endpoint
    • MACS: Management agent
    • EXTERNAL: External database connector
    databaseConnectorId string
    The OCID of the external database connector.
    managementAgentId string
    The OCID of the management agent.
    privateEndPointId string
    The OCID of the private endpoint.
    connector_type str
    The list of supported connection types:

    • PE: Private endpoint
    • MACS: Management agent
    • EXTERNAL: External database connector
    database_connector_id str
    The OCID of the external database connector.
    management_agent_id str
    The OCID of the management agent.
    private_end_point_id str
    The OCID of the private endpoint.
    connectorType String
    The list of supported connection types:

    • PE: Private endpoint
    • MACS: Management agent
    • EXTERNAL: External database connector
    databaseConnectorId String
    The OCID of the external database connector.
    managementAgentId String
    The OCID of the management agent.
    privateEndPointId String
    The OCID of the private endpoint.

    GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetail

    ConnectionCredentials List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionCredential>
    The credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector credentials.
    ConnectionStrings List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionString>
    The details of the Oracle Database connection string.
    ConnectionCredentials []GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionCredential
    The credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector credentials.
    ConnectionStrings []GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionString
    The details of the Oracle Database connection string.
    connectionCredentials List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionCredential>
    The credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector credentials.
    connectionStrings List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionString>
    The details of the Oracle Database connection string.
    connectionCredentials GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionCredential[]
    The credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector credentials.
    connectionStrings GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionString[]
    The details of the Oracle Database connection string.
    connectionCredentials List<Property Map>
    The credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector credentials.
    connectionStrings List<Property Map>
    The details of the Oracle Database connection string.

    GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionCredential

    CredentialName string
    The name of the credential information that used to connect to the DB system resource. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.
    CredentialType string
    The type of credential used to connect to the database.
    NamedCredentialId string
    The OCID of the Named Credential where the database password metadata is stored.
    PasswordSecretId string
    The OCID of the secret containing the user password.
    Role string
    The role of the user connecting to the database.
    SslSecretId string
    The OCID of the secret containing the SSL keystore and truststore details.
    UserName string
    The user name used to connect to the database.
    CredentialName string
    The name of the credential information that used to connect to the DB system resource. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.
    CredentialType string
    The type of credential used to connect to the database.
    NamedCredentialId string
    The OCID of the Named Credential where the database password metadata is stored.
    PasswordSecretId string
    The OCID of the secret containing the user password.
    Role string
    The role of the user connecting to the database.
    SslSecretId string
    The OCID of the secret containing the SSL keystore and truststore details.
    UserName string
    The user name used to connect to the database.
    credentialName String
    The name of the credential information that used to connect to the DB system resource. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.
    credentialType String
    The type of credential used to connect to the database.
    namedCredentialId String
    The OCID of the Named Credential where the database password metadata is stored.
    passwordSecretId String
    The OCID of the secret containing the user password.
    role String
    The role of the user connecting to the database.
    sslSecretId String
    The OCID of the secret containing the SSL keystore and truststore details.
    userName String
    The user name used to connect to the database.
    credentialName string
    The name of the credential information that used to connect to the DB system resource. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.
    credentialType string
    The type of credential used to connect to the database.
    namedCredentialId string
    The OCID of the Named Credential where the database password metadata is stored.
    passwordSecretId string
    The OCID of the secret containing the user password.
    role string
    The role of the user connecting to the database.
    sslSecretId string
    The OCID of the secret containing the SSL keystore and truststore details.
    userName string
    The user name used to connect to the database.
    credential_name str
    The name of the credential information that used to connect to the DB system resource. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.
    credential_type str
    The type of credential used to connect to the database.
    named_credential_id str
    The OCID of the Named Credential where the database password metadata is stored.
    password_secret_id str
    The OCID of the secret containing the user password.
    role str
    The role of the user connecting to the database.
    ssl_secret_id str
    The OCID of the secret containing the SSL keystore and truststore details.
    user_name str
    The user name used to connect to the database.
    credentialName String
    The name of the credential information that used to connect to the DB system resource. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.
    credentialType String
    The type of credential used to connect to the database.
    namedCredentialId String
    The OCID of the Named Credential where the database password metadata is stored.
    passwordSecretId String
    The OCID of the secret containing the user password.
    role String
    The role of the user connecting to the database.
    sslSecretId String
    The OCID of the secret containing the SSL keystore and truststore details.
    userName String
    The user name used to connect to the database.

    GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionString

    ConnectionType string
    The list of supported connection types:

    • BASIC: Basic connection details
    Port int
    The port number used to connect to the database.
    Protocol string
    The protocol used to connect to the database.
    Service string
    The service name of the database.
    ConnectionType string
    The list of supported connection types:

    • BASIC: Basic connection details
    Port int
    The port number used to connect to the database.
    Protocol string
    The protocol used to connect to the database.
    Service string
    The service name of the database.
    connectionType String
    The list of supported connection types:

    • BASIC: Basic connection details
    port Integer
    The port number used to connect to the database.
    protocol String
    The protocol used to connect to the database.
    service String
    The service name of the database.
    connectionType string
    The list of supported connection types:

    • BASIC: Basic connection details
    port number
    The port number used to connect to the database.
    protocol string
    The protocol used to connect to the database.
    service string
    The service name of the database.
    connection_type str
    The list of supported connection types:

    • BASIC: Basic connection details
    port int
    The port number used to connect to the database.
    protocol str
    The protocol used to connect to the database.
    service str
    The service name of the database.
    connectionType String
    The list of supported connection types:

    • BASIC: Basic connection details
    port Number
    The port number used to connect to the database.
    protocol String
    The protocol used to connect to the database.
    service String
    The service name of the database.

    GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup

    CompartmentId string
    The OCID of the compartment.
    Id string
    The identifier of the resource.
    Name string
    A filter to return only resources that match the entire name.
    CompartmentId string
    The OCID of the compartment.
    Id string
    The identifier of the resource.
    Name string
    A filter to return only resources that match the entire name.
    compartmentId String
    The OCID of the compartment.
    id String
    The identifier of the resource.
    name String
    A filter to return only resources that match the entire name.
    compartmentId string
    The OCID of the compartment.
    id string
    The identifier of the resource.
    name string
    A filter to return only resources that match the entire name.
    compartment_id str
    The OCID of the compartment.
    id str
    The identifier of the resource.
    name str
    A filter to return only resources that match the entire name.
    compartmentId String
    The OCID of the compartment.
    id String
    The identifier of the resource.
    name String
    A filter to return only resources that match the entire name.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.13.0 published on Tuesday, Oct 22, 2024 by Pulumi