1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabases
Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabases

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 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,
});
Copy
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)
Copy
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
	})
}
Copy
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,
    });

});
Copy
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());

    }
}
Copy
variables:
  testManagedDatabases:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabases
      arguments:
        compartmentId: ${compartmentId}
        deploymentType: ${managedDatabaseDeploymentType}
        externalExadataInfrastructureId: ${testExternalExadataInfrastructure.id}
        id: ${managedDatabaseId}
        managementOption: ${managedDatabaseManagementOption}
        name: ${managedDatabaseName}
Copy

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>
Copy
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]
Copy
func GetManagedDatabases(ctx *Context, args *GetManagedDatabasesArgs, opts ...InvokeOption) (*GetManagedDatabasesResult, error)
func GetManagedDatabasesOutput(ctx *Context, args *GetManagedDatabasesOutputArgs, opts ...InvokeOption) GetManagedDatabasesResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetManagedDatabasesResult> getManagedDatabases(GetManagedDatabasesArgs args, InvokeOptions options)
public static Output<GetManagedDatabasesResult> getManagedDatabases(GetManagedDatabasesArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabases:getManagedDatabases
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

CompartmentId This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. 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 Changes to this property will trigger replacement. []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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. string
A filter to return only resources that match the entire name.
Values This property is required. List<string>
Regex bool
Name This property is required. string
A filter to return only resources that match the entire name.
Values This property is required. []string
Regex bool
name This property is required. String
A filter to return only resources that match the entire name.
values This property is required. List<String>
regex Boolean
name This property is required. string
A filter to return only resources that match the entire name.
values This property is required. string[]
regex boolean
name This property is required. str
A filter to return only resources that match the entire name.
values This property is required. Sequence[str]
regex bool
name This property is required. String
A filter to return only resources that match the entire name.
values This property is required. List<String>
regex Boolean

GetManagedDatabasesManagedDatabaseCollection

items This property is required. List<Property Map>

GetManagedDatabasesManagedDatabaseCollectionItem

AdditionalDetails This property is required. Dictionary<string, string>
The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
CompartmentId This property is required. string
The OCID of the compartment.
DatabasePlatformName This property is required. string
The operating system of database.
DatabaseStatus This property is required. string
The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
DatabaseSubType This property is required. 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 This property is required. string
The type of Oracle Database installation.
DatabaseVersion This property is required. string
The Oracle Database version.
DbSystemId This property is required. string
The OCID of the external DB system that this Managed Database is part of.
DbmgmtFeatureConfigs This property is required. List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig>
The list of feature configurations
DefinedTags This property is required. 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 This property is required. string
A filter to return Managed Databases of the specified deployment type.
FreeformTags This property is required. 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 This property is required. string
The identifier of the resource.
IsCluster This property is required. bool
Indicates whether the Oracle Database is part of a cluster.
ManagedDatabaseGroups This property is required. List<GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup>
A list of Managed Database Groups that the Managed Database belongs to.
ManagementOption This property is required. string
A filter to return Managed Databases with the specified management option.
Name This property is required. string
A filter to return only resources that match the entire name.
ParentContainerId This property is required. string
The OCID of the parent Container Database if Managed Database is a Pluggable Database.
StorageSystemId This property is required. string
The OCID of the storage DB system.
SystemTags This property is required. 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 This property is required. string
The date and time the Managed Database was created.
WorkloadType This property is required. string
The workload type of the Autonomous Database.
AdditionalDetails This property is required. map[string]string
The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
CompartmentId This property is required. string
The OCID of the compartment.
DatabasePlatformName This property is required. string
The operating system of database.
DatabaseStatus This property is required. string
The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
DatabaseSubType This property is required. 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 This property is required. string
The type of Oracle Database installation.
DatabaseVersion This property is required. string
The Oracle Database version.
DbSystemId This property is required. string
The OCID of the external DB system that this Managed Database is part of.
DbmgmtFeatureConfigs This property is required. []GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig
The list of feature configurations
DefinedTags This property is required. 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 This property is required. string
A filter to return Managed Databases of the specified deployment type.
FreeformTags This property is required. 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 This property is required. string
The identifier of the resource.
IsCluster This property is required. bool
Indicates whether the Oracle Database is part of a cluster.
ManagedDatabaseGroups This property is required. []GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup
A list of Managed Database Groups that the Managed Database belongs to.
ManagementOption This property is required. string
A filter to return Managed Databases with the specified management option.
Name This property is required. string
A filter to return only resources that match the entire name.
ParentContainerId This property is required. string
The OCID of the parent Container Database if Managed Database is a Pluggable Database.
StorageSystemId This property is required. string
The OCID of the storage DB system.
SystemTags This property is required. 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 This property is required. string
The date and time the Managed Database was created.
WorkloadType This property is required. string
The workload type of the Autonomous Database.
additionalDetails This property is required. Map<String,String>
The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
compartmentId This property is required. String
The OCID of the compartment.
databasePlatformName This property is required. String
The operating system of database.
databaseStatus This property is required. String
The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
databaseSubType This property is required. 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 This property is required. String
The type of Oracle Database installation.
databaseVersion This property is required. String
The Oracle Database version.
dbSystemId This property is required. String
The OCID of the external DB system that this Managed Database is part of.
dbmgmtFeatureConfigs This property is required. List<GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig>
The list of feature configurations
definedTags This property is required. 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 This property is required. String
A filter to return Managed Databases of the specified deployment type.
freeformTags This property is required. 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 This property is required. String
The identifier of the resource.
isCluster This property is required. Boolean
Indicates whether the Oracle Database is part of a cluster.
managedDatabaseGroups This property is required. List<GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup>
A list of Managed Database Groups that the Managed Database belongs to.
managementOption This property is required. String
A filter to return Managed Databases with the specified management option.
name This property is required. String
A filter to return only resources that match the entire name.
parentContainerId This property is required. String
The OCID of the parent Container Database if Managed Database is a Pluggable Database.
storageSystemId This property is required. String
The OCID of the storage DB system.
systemTags This property is required. 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 This property is required. String
The date and time the Managed Database was created.
workloadType This property is required. String
The workload type of the Autonomous Database.
additionalDetails This property is required. {[key: string]: string}
The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
compartmentId This property is required. string
The OCID of the compartment.
databasePlatformName This property is required. string
The operating system of database.
databaseStatus This property is required. string
The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
databaseSubType This property is required. 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 This property is required. string
The type of Oracle Database installation.
databaseVersion This property is required. string
The Oracle Database version.
dbSystemId This property is required. string
The OCID of the external DB system that this Managed Database is part of.
dbmgmtFeatureConfigs This property is required. GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig[]
The list of feature configurations
definedTags This property is required. {[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 This property is required. string
A filter to return Managed Databases of the specified deployment type.
freeformTags This property is required. {[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 This property is required. string
The identifier of the resource.
isCluster This property is required. boolean
Indicates whether the Oracle Database is part of a cluster.
managedDatabaseGroups This property is required. GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup[]
A list of Managed Database Groups that the Managed Database belongs to.
managementOption This property is required. string
A filter to return Managed Databases with the specified management option.
name This property is required. string
A filter to return only resources that match the entire name.
parentContainerId This property is required. string
The OCID of the parent Container Database if Managed Database is a Pluggable Database.
storageSystemId This property is required. string
The OCID of the storage DB system.
systemTags This property is required. {[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 This property is required. string
The date and time the Managed Database was created.
workloadType This property is required. string
The workload type of the Autonomous Database.
additional_details This property is required. Mapping[str, str]
The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
compartment_id This property is required. str
The OCID of the compartment.
database_platform_name This property is required. str
The operating system of database.
database_status This property is required. 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 This property is required. 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 This property is required. str
The type of Oracle Database installation.
database_version This property is required. str
The Oracle Database version.
db_system_id This property is required. str
The OCID of the external DB system that this Managed Database is part of.
dbmgmt_feature_configs This property is required. Sequence[databasemanagement.GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig]
The list of feature configurations
defined_tags This property is required. 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 This property is required. str
A filter to return Managed Databases of the specified deployment type.
freeform_tags This property is required. 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 This property is required. str
The identifier of the resource.
is_cluster This property is required. bool
Indicates whether the Oracle Database is part of a cluster.
managed_database_groups This property is required. Sequence[databasemanagement.GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup]
A list of Managed Database Groups that the Managed Database belongs to.
management_option This property is required. str
A filter to return Managed Databases with the specified management option.
name This property is required. str
A filter to return only resources that match the entire name.
parent_container_id This property is required. str
The OCID of the parent Container Database if Managed Database is a Pluggable Database.
storage_system_id This property is required. str
The OCID of the storage DB system.
system_tags This property is required. 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 This property is required. str
The date and time the Managed Database was created.
workload_type This property is required. str
The workload type of the Autonomous Database.
additionalDetails This property is required. Map<String>
The additional details specific to a type of database defined in {"key": "value"} format. Example: {"bar-key": "value"}
compartmentId This property is required. String
The OCID of the compartment.
databasePlatformName This property is required. String
The operating system of database.
databaseStatus This property is required. String
The status of the Oracle Database. Indicates whether the status of the database is UP, DOWN, or UNKNOWN at the current time.
databaseSubType This property is required. 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 This property is required. String
The type of Oracle Database installation.
databaseVersion This property is required. String
The Oracle Database version.
dbSystemId This property is required. String
The OCID of the external DB system that this Managed Database is part of.
dbmgmtFeatureConfigs This property is required. List<Property Map>
The list of feature configurations
definedTags This property is required. 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 This property is required. String
A filter to return Managed Databases of the specified deployment type.
freeformTags This property is required. 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 This property is required. String
The identifier of the resource.
isCluster This property is required. Boolean
Indicates whether the Oracle Database is part of a cluster.
managedDatabaseGroups This property is required. List<Property Map>
A list of Managed Database Groups that the Managed Database belongs to.
managementOption This property is required. String
A filter to return Managed Databases with the specified management option.
name This property is required. String
A filter to return only resources that match the entire name.
parentContainerId This property is required. String
The OCID of the parent Container Database if Managed Database is a Pluggable Database.
storageSystemId This property is required. String
The OCID of the storage DB system.
systemTags This property is required. 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 This property is required. String
The date and time the Managed Database was created.
workloadType This property is required. String
The workload type of the Autonomous Database.

GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfig

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

GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigConnectorDetail

ConnectorType This property is required. string
The list of supported connection types:

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

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

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

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

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

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

GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetail

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

GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionCredential

CredentialName This property is required. 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 This property is required. string
The type of credential used to connect to the database.
NamedCredentialId This property is required. string
The OCID of the Named Credential where the database password metadata is stored.
PasswordSecretId This property is required. string
The OCID of the secret containing the user password.
Role This property is required. string
The role of the user connecting to the database.
SslSecretId This property is required. string
The OCID of the secret containing the SSL keystore and truststore details.
UserName This property is required. string
The user name used to connect to the database.
CredentialName This property is required. 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 This property is required. string
The type of credential used to connect to the database.
NamedCredentialId This property is required. string
The OCID of the Named Credential where the database password metadata is stored.
PasswordSecretId This property is required. string
The OCID of the secret containing the user password.
Role This property is required. string
The role of the user connecting to the database.
SslSecretId This property is required. string
The OCID of the secret containing the SSL keystore and truststore details.
UserName This property is required. string
The user name used to connect to the database.
credentialName This property is required. 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 This property is required. String
The type of credential used to connect to the database.
namedCredentialId This property is required. String
The OCID of the Named Credential where the database password metadata is stored.
passwordSecretId This property is required. String
The OCID of the secret containing the user password.
role This property is required. String
The role of the user connecting to the database.
sslSecretId This property is required. String
The OCID of the secret containing the SSL keystore and truststore details.
userName This property is required. String
The user name used to connect to the database.
credentialName This property is required. 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 This property is required. string
The type of credential used to connect to the database.
namedCredentialId This property is required. string
The OCID of the Named Credential where the database password metadata is stored.
passwordSecretId This property is required. string
The OCID of the secret containing the user password.
role This property is required. string
The role of the user connecting to the database.
sslSecretId This property is required. string
The OCID of the secret containing the SSL keystore and truststore details.
userName This property is required. string
The user name used to connect to the database.
credential_name This property is required. 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 This property is required. str
The type of credential used to connect to the database.
named_credential_id This property is required. str
The OCID of the Named Credential where the database password metadata is stored.
password_secret_id This property is required. str
The OCID of the secret containing the user password.
role This property is required. str
The role of the user connecting to the database.
ssl_secret_id This property is required. str
The OCID of the secret containing the SSL keystore and truststore details.
user_name This property is required. str
The user name used to connect to the database.
credentialName This property is required. 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 This property is required. String
The type of credential used to connect to the database.
namedCredentialId This property is required. String
The OCID of the Named Credential where the database password metadata is stored.
passwordSecretId This property is required. String
The OCID of the secret containing the user password.
role This property is required. String
The role of the user connecting to the database.
sslSecretId This property is required. String
The OCID of the secret containing the SSL keystore and truststore details.
userName This property is required. String
The user name used to connect to the database.

GetManagedDatabasesManagedDatabaseCollectionItemDbmgmtFeatureConfigDatabaseConnectionDetailConnectionString

ConnectionType This property is required. string
The list of supported connection types:

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

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

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

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

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

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

GetManagedDatabasesManagedDatabaseCollectionItemManagedDatabaseGroup

CompartmentId This property is required. string
The OCID of the compartment.
Id This property is required. string
The identifier of the resource.
Name This property is required. string
A filter to return only resources that match the entire name.
CompartmentId This property is required. string
The OCID of the compartment.
Id This property is required. string
The identifier of the resource.
Name This property is required. string
A filter to return only resources that match the entire name.
compartmentId This property is required. String
The OCID of the compartment.
id This property is required. String
The identifier of the resource.
name This property is required. String
A filter to return only resources that match the entire name.
compartmentId This property is required. string
The OCID of the compartment.
id This property is required. string
The identifier of the resource.
name This property is required. string
A filter to return only resources that match the entire name.
compartment_id This property is required. str
The OCID of the compartment.
id This property is required. str
The identifier of the resource.
name This property is required. str
A filter to return only resources that match the entire name.
compartmentId This property is required. String
The OCID of the compartment.
id This property is required. String
The identifier of the resource.
name This property is required. 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.
Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi