getDbSystems

Oracle Cloud Infrastructure v4.16.0, Jun 17 26

Viewing docs for Oracle Cloud Infrastructure v4.16.0
published on Wednesday, Jun 17, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-oci

Viewing docs for Oracle Cloud Infrastructure v4.16.0
published on Wednesday, Jun 17, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-oci

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDbSystems = oci.psql.getDbSystems({
    compartmentId: compartmentId,
    displayName: dbSystemDisplayName,
    id: dbSystemId,
    state: dbSystemState,
    systemRole: dbSystemSystemRole,
});

import pulumi
import pulumi_oci as oci

test_db_systems = oci.psql.get_db_systems(compartment_id=compartment_id,
    display_name=db_system_display_name,
    id=db_system_id,
    state=db_system_state,
    system_role=db_system_system_role)

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v4/go/oci/psql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := psql.GetDbSystems(ctx, &psql.GetDbSystemsArgs{
			CompartmentId: pulumi.StringRef(compartmentId),
			DisplayName:   pulumi.StringRef(dbSystemDisplayName),
			Id:            pulumi.StringRef(dbSystemId),
			State:         pulumi.StringRef(dbSystemState),
			SystemRole:    pulumi.StringRef(dbSystemSystemRole),
		}, 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 testDbSystems = Oci.Psql.GetDbSystems.Invoke(new()
    {
        CompartmentId = compartmentId,
        DisplayName = dbSystemDisplayName,
        Id = dbSystemId,
        State = dbSystemState,
        SystemRole = dbSystemSystemRole,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Psql.PsqlFunctions;
import com.pulumi.oci.Psql.inputs.GetDbSystemsArgs;
import java.util.ArrayList;
import java.util.Arrays;
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 testDbSystems = PsqlFunctions.getDbSystems(GetDbSystemsArgs.builder()
            .compartmentId(compartmentId)
            .displayName(dbSystemDisplayName)
            .id(dbSystemId)
            .state(dbSystemState)
            .systemRole(dbSystemSystemRole)
            .build());

    }
}

variables:
  testDbSystems:
    fn::invoke:
      function: oci:Psql:getDbSystems
      arguments:
        compartmentId: ${compartmentId}
        displayName: ${dbSystemDisplayName}
        id: ${dbSystemId}
        state: ${dbSystemState}
        systemRole: ${dbSystemSystemRole}

pulumi {
  required_providers {
    oci = {
      source = "pulumi/oci"
    }
  }
}

data "oci_psql_getdbsystems" "testDbSystems" {
  compartment_id = compartmentId
  display_name   = dbSystemDisplayName
  id             = dbSystemId
  state          = dbSystemState
  system_role    = dbSystemSystemRole
}

Using getDbSystems

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 getDbSystems(args: GetDbSystemsArgs, opts?: InvokeOptions): Promise<GetDbSystemsResult>
function getDbSystemsOutput(args: GetDbSystemsOutputArgs, opts?: InvokeOptions): Output<GetDbSystemsResult>

def get_db_systems(compartment_id: Optional[str] = None,
                   display_name: Optional[str] = None,
                   filters: Optional[Sequence[GetDbSystemsFilter]] = None,
                   id: Optional[str] = None,
                   state: Optional[str] = None,
                   system_role: Optional[str] = None,
                   opts: Optional[InvokeOptions] = None) -> GetDbSystemsResult
def get_db_systems_output(compartment_id: pulumi.Input[Optional[str]] = None,
                   display_name: pulumi.Input[Optional[str]] = None,
                   filters: pulumi.Input[Optional[Sequence[pulumi.Input[GetDbSystemsFilterArgs]]]] = None,
                   id: pulumi.Input[Optional[str]] = None,
                   state: pulumi.Input[Optional[str]] = None,
                   system_role: pulumi.Input[Optional[str]] = None,
                   opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemsResult]

func GetDbSystems(ctx *Context, args *GetDbSystemsArgs, opts ...InvokeOption) (*GetDbSystemsResult, error)
func GetDbSystemsOutput(ctx *Context, args *GetDbSystemsOutputArgs, opts ...InvokeOption) GetDbSystemsResultOutput

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

public static class GetDbSystems 
{
    public static Task<GetDbSystemsResult> InvokeAsync(GetDbSystemsArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemsResult> Invoke(GetDbSystemsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDbSystemsResult> getDbSystems(GetDbSystemsArgs args, InvokeOptions options)
public static Output<GetDbSystemsResult> getDbSystems(GetDbSystemsArgs args, InvokeOptions options)

fn::invoke:
  function: oci:Psql/getDbSystems:getDbSystems
  arguments:
    # arguments dictionary

data "oci_psql_getdbsystems" "name" {
    # arguments
}

The following arguments are supported:

CompartmentId string: The ID of the compartment in which to list resources.
DisplayName string: A filter to return only resources that match the entire display name given.
Filters List<GetDbSystemsFilter>
Id string: A unique identifier for the database system.
State string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
SystemRole string: A filter to return only DbSystem resources if their systemRole matches the given value.

CompartmentId string: The ID of the compartment in which to list resources.
DisplayName string: A filter to return only resources that match the entire display name given.
Filters []GetDbSystemsFilter
Id string: A unique identifier for the database system.
State string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
SystemRole string: A filter to return only DbSystem resources if their systemRole matches the given value.

compartment_id string: The ID of the compartment in which to list resources.
display_name string: A filter to return only resources that match the entire display name given.
filters list(object)
id string: A unique identifier for the database system.
state string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
system_role string: A filter to return only DbSystem resources if their systemRole matches the given value.

compartmentId String: The ID of the compartment in which to list resources.
displayName String: A filter to return only resources that match the entire display name given.
filters List<GetDbSystemsFilter>
id String: A unique identifier for the database system.
state String: A filter to return only resources if their lifecycleState matches the given lifecycleState.
systemRole String: A filter to return only DbSystem resources if their systemRole matches the given value.

compartmentId string: The ID of the compartment in which to list resources.
displayName string: A filter to return only resources that match the entire display name given.
filters GetDbSystemsFilter[]
id string: A unique identifier for the database system.
state string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
systemRole string: A filter to return only DbSystem resources if their systemRole matches the given value.

compartment_id str: The ID of the compartment in which to list resources.
display_name str: A filter to return only resources that match the entire display name given.
filters Sequence[GetDbSystemsFilter]
id str: A unique identifier for the database system.
state str: A filter to return only resources if their lifecycleState matches the given lifecycleState.
system_role str: A filter to return only DbSystem resources if their systemRole matches the given value.

compartmentId String: The ID of the compartment in which to list resources.
displayName String: A filter to return only resources that match the entire display name given.
filters List<Property Map>
id String: A unique identifier for the database system.
state String: A filter to return only resources if their lifecycleState matches the given lifecycleState.
systemRole String: A filter to return only DbSystem resources if their systemRole matches the given value.

getDbSystems Result

The following output properties are available:

DbSystemCollections List<GetDbSystemsDbSystemCollection>: The list of db_system_collection.
CompartmentId string: target compartment to place a new backup
DisplayName string: A user-friendly display name for the database instance node. Avoid entering confidential information.
Filters List<GetDbSystemsFilter>
Id string: A unique identifier for the database instance node. Immutable on creation.
State string: The current state of the database system.
SystemRole string: Type of the database system.

DbSystemCollections []GetDbSystemsDbSystemCollection: The list of db_system_collection.
CompartmentId string: target compartment to place a new backup
DisplayName string: A user-friendly display name for the database instance node. Avoid entering confidential information.
Filters []GetDbSystemsFilter
Id string: A unique identifier for the database instance node. Immutable on creation.
State string: The current state of the database system.
SystemRole string: Type of the database system.

db_system_collections list(object): The list of db_system_collection.
compartment_id string: target compartment to place a new backup
display_name string: A user-friendly display name for the database instance node. Avoid entering confidential information.
filters list(object)
id string: A unique identifier for the database instance node. Immutable on creation.
state string: The current state of the database system.
system_role string: Type of the database system.

dbSystemCollections List<GetDbSystemsDbSystemCollection>: The list of db_system_collection.
compartmentId String: target compartment to place a new backup
displayName String: A user-friendly display name for the database instance node. Avoid entering confidential information.
filters List<GetDbSystemsFilter>
id String: A unique identifier for the database instance node. Immutable on creation.
state String: The current state of the database system.
systemRole String: Type of the database system.

dbSystemCollections GetDbSystemsDbSystemCollection[]: The list of db_system_collection.
compartmentId string: target compartment to place a new backup
displayName string: A user-friendly display name for the database instance node. Avoid entering confidential information.
filters GetDbSystemsFilter[]
id string: A unique identifier for the database instance node. Immutable on creation.
state string: The current state of the database system.
systemRole string: Type of the database system.

db_system_collections Sequence[GetDbSystemsDbSystemCollection]: The list of db_system_collection.
compartment_id str: target compartment to place a new backup
display_name str: A user-friendly display name for the database instance node. Avoid entering confidential information.
filters Sequence[GetDbSystemsFilter]
id str: A unique identifier for the database instance node. Immutable on creation.
state str: The current state of the database system.
system_role str: Type of the database system.

dbSystemCollections List<Property Map>: The list of db_system_collection.
compartmentId String: target compartment to place a new backup
displayName String: A user-friendly display name for the database instance node. Avoid entering confidential information.
filters List<Property Map>
id String: A unique identifier for the database instance node. Immutable on creation.
state String: The current state of the database system.
systemRole String: Type of the database system.

Supporting Types

GetDbSystemsDbSystemCollection

Items List<GetDbSystemsDbSystemCollectionItem>

Items []GetDbSystemsDbSystemCollectionItem

items list(object)

items List<GetDbSystemsDbSystemCollectionItem>

items GetDbSystemsDbSystemCollectionItem[]

items Sequence[GetDbSystemsDbSystemCollectionItem]

items List<Property Map>

GetDbSystemsDbSystemCollectionItem

AdminUsername string: The database system administrator username.
ApplyChangeModeToStandAlone string
ApplyConfig string
CompartmentId string: The ID of the compartment in which to list resources.
ConfigId string: The OCID of the configuration associated with the database system.
Credentials List<GetDbSystemsDbSystemCollectionItemCredential>: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
DbVersion string: The major and minor versions of the database system software.
DefinedTags Dictionary<string, string>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
Description string: Description of the database instance node.
DisplayName string: A filter to return only resources that match the entire display name given.
FreeformTags Dictionary<string, string>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
Id string: A unique identifier for the database system.
InstanceCount int: Count of instances, or nodes, in the database system.
InstanceMemorySizeInGbs int: The total amount of memory available to each database instance node, in gigabytes.
InstanceOcpuCount int: The total number of OCPUs available to each database instance node.
Instances List<GetDbSystemsDbSystemCollectionItemInstance>: The list of instances, or nodes, in the database system.
InstancesDetails List<GetDbSystemsDbSystemCollectionItemInstancesDetail>
KerberosAuthDetails List<GetDbSystemsDbSystemCollectionItemKerberosAuthDetail>: Kerberos Authentication details for the database system.
LifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
ManagementPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicy>: PostgreSQL database system management policy.
NetworkDetails List<GetDbSystemsDbSystemCollectionItemNetworkDetail>: Network details for the database system.
OdspInsightDetails List<GetDbSystemsDbSystemCollectionItemOdspInsightDetail>: ODSP Insight details for the database system.
PatchOperations List<GetDbSystemsDbSystemCollectionItemPatchOperation>
ReplicationConfigs List<GetDbSystemsDbSystemCollectionItemReplicationConfig>: Replication configuration that is applicable on database systems with the PRIMARY_DB_SYSTEM role.
Shape string: The name of the shape for the database instance. Example: VM.Standard.E4.Flex
Sources List<GetDbSystemsDbSystemCollectionItemSource>: The source of the database system.
State string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
StorageDetails List<GetDbSystemsDbSystemCollectionItemStorageDetail>: Storage details of the database system.
SystemRole string: A filter to return only DbSystem resources if their systemRole matches the given value.
SystemTags Dictionary<string, string>: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
SystemType string: Type of the database system.
TimeCreated string: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
TimeUpdated string: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

AdminUsername string: The database system administrator username.
ApplyChangeModeToStandAlone string
ApplyConfig string
CompartmentId string: The ID of the compartment in which to list resources.
ConfigId string: The OCID of the configuration associated with the database system.
Credentials []GetDbSystemsDbSystemCollectionItemCredential: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
DbVersion string: The major and minor versions of the database system software.
DefinedTags map[string]string: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
Description string: Description of the database instance node.
DisplayName string: A filter to return only resources that match the entire display name given.
FreeformTags map[string]string: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
Id string: A unique identifier for the database system.
InstanceCount int: Count of instances, or nodes, in the database system.
InstanceMemorySizeInGbs int: The total amount of memory available to each database instance node, in gigabytes.
InstanceOcpuCount int: The total number of OCPUs available to each database instance node.
Instances []GetDbSystemsDbSystemCollectionItemInstance: The list of instances, or nodes, in the database system.
InstancesDetails []GetDbSystemsDbSystemCollectionItemInstancesDetail
KerberosAuthDetails []GetDbSystemsDbSystemCollectionItemKerberosAuthDetail: Kerberos Authentication details for the database system.
LifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
ManagementPolicies []GetDbSystemsDbSystemCollectionItemManagementPolicy: PostgreSQL database system management policy.
NetworkDetails []GetDbSystemsDbSystemCollectionItemNetworkDetail: Network details for the database system.
OdspInsightDetails []GetDbSystemsDbSystemCollectionItemOdspInsightDetail: ODSP Insight details for the database system.
PatchOperations []GetDbSystemsDbSystemCollectionItemPatchOperation
ReplicationConfigs []GetDbSystemsDbSystemCollectionItemReplicationConfig: Replication configuration that is applicable on database systems with the PRIMARY_DB_SYSTEM role.
Shape string: The name of the shape for the database instance. Example: VM.Standard.E4.Flex
Sources []GetDbSystemsDbSystemCollectionItemSource: The source of the database system.
State string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
StorageDetails []GetDbSystemsDbSystemCollectionItemStorageDetail: Storage details of the database system.
SystemRole string: A filter to return only DbSystem resources if their systemRole matches the given value.
SystemTags map[string]string: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
SystemType string: Type of the database system.
TimeCreated string: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
TimeUpdated string: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

admin_username string: The database system administrator username.
apply_change_mode_to_stand_alone string
apply_config string
compartment_id string: The ID of the compartment in which to list resources.
config_id string: The OCID of the configuration associated with the database system.
credentials list(object): List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
db_version string: The major and minor versions of the database system software.
defined_tags map(string): Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description string: Description of the database instance node.
display_name string: A filter to return only resources that match the entire display name given.
freeform_tags map(string): Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id string: A unique identifier for the database system.
instance_count number: Count of instances, or nodes, in the database system.
instance_memory_size_in_gbs number: The total amount of memory available to each database instance node, in gigabytes.
instance_ocpu_count number: The total number of OCPUs available to each database instance node.
instances list(object): The list of instances, or nodes, in the database system.
instances_details list(object)
kerberos_auth_details list(object): Kerberos Authentication details for the database system.
lifecycle_details string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
management_policies list(object): PostgreSQL database system management policy.
network_details list(object): Network details for the database system.
odsp_insight_details list(object): ODSP Insight details for the database system.
patch_operations list(object)
replication_configs list(object): Replication configuration that is applicable on database systems with the PRIMARY_DB_SYSTEM role.
shape string: The name of the shape for the database instance. Example: VM.Standard.E4.Flex
sources list(object): The source of the database system.
state string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
storage_details list(object): Storage details of the database system.
system_role string: A filter to return only DbSystem resources if their systemRole matches the given value.
system_tags map(string): System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
system_type string: Type of the database system.
time_created string: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
time_updated string: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

adminUsername String: The database system administrator username.
applyChangeModeToStandAlone String
applyConfig String
compartmentId String: The ID of the compartment in which to list resources.
configId String: The OCID of the configuration associated with the database system.
credentials List<GetDbSystemsDbSystemCollectionItemCredential>: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
dbVersion String: The major and minor versions of the database system software.
definedTags Map<String,String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description String: Description of the database instance node.
displayName String: A filter to return only resources that match the entire display name given.
freeformTags Map<String,String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id String: A unique identifier for the database system.
instanceCount Integer: Count of instances, or nodes, in the database system.
instanceMemorySizeInGbs Integer: The total amount of memory available to each database instance node, in gigabytes.
instanceOcpuCount Integer: The total number of OCPUs available to each database instance node.
instances List<GetDbSystemsDbSystemCollectionItemInstance>: The list of instances, or nodes, in the database system.
instancesDetails List<GetDbSystemsDbSystemCollectionItemInstancesDetail>
kerberosAuthDetails List<GetDbSystemsDbSystemCollectionItemKerberosAuthDetail>: Kerberos Authentication details for the database system.
lifecycleDetails String: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
managementPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicy>: PostgreSQL database system management policy.
networkDetails List<GetDbSystemsDbSystemCollectionItemNetworkDetail>: Network details for the database system.
odspInsightDetails List<GetDbSystemsDbSystemCollectionItemOdspInsightDetail>: ODSP Insight details for the database system.
patchOperations List<GetDbSystemsDbSystemCollectionItemPatchOperation>
replicationConfigs List<GetDbSystemsDbSystemCollectionItemReplicationConfig>: Replication configuration that is applicable on database systems with the PRIMARY_DB_SYSTEM role.
shape String: The name of the shape for the database instance. Example: VM.Standard.E4.Flex
sources List<GetDbSystemsDbSystemCollectionItemSource>: The source of the database system.
state String: A filter to return only resources if their lifecycleState matches the given lifecycleState.
storageDetails List<GetDbSystemsDbSystemCollectionItemStorageDetail>: Storage details of the database system.
systemRole String: A filter to return only DbSystem resources if their systemRole matches the given value.
systemTags Map<String,String>: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
systemType String: Type of the database system.
timeCreated String: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
timeUpdated String: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

adminUsername string: The database system administrator username.
applyChangeModeToStandAlone string
applyConfig string
compartmentId string: The ID of the compartment in which to list resources.
configId string: The OCID of the configuration associated with the database system.
credentials GetDbSystemsDbSystemCollectionItemCredential[]: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
dbVersion string: The major and minor versions of the database system software.
definedTags {[key: string]: string}: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description string: Description of the database instance node.
displayName string: A filter to return only resources that match the entire display name given.
freeformTags {[key: string]: string}: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id string: A unique identifier for the database system.
instanceCount number: Count of instances, or nodes, in the database system.
instanceMemorySizeInGbs number: The total amount of memory available to each database instance node, in gigabytes.
instanceOcpuCount number: The total number of OCPUs available to each database instance node.
instances GetDbSystemsDbSystemCollectionItemInstance[]: The list of instances, or nodes, in the database system.
instancesDetails GetDbSystemsDbSystemCollectionItemInstancesDetail[]
kerberosAuthDetails GetDbSystemsDbSystemCollectionItemKerberosAuthDetail[]: Kerberos Authentication details for the database system.
lifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
managementPolicies GetDbSystemsDbSystemCollectionItemManagementPolicy[]: PostgreSQL database system management policy.
networkDetails GetDbSystemsDbSystemCollectionItemNetworkDetail[]: Network details for the database system.
odspInsightDetails GetDbSystemsDbSystemCollectionItemOdspInsightDetail[]: ODSP Insight details for the database system.
patchOperations GetDbSystemsDbSystemCollectionItemPatchOperation[]
replicationConfigs GetDbSystemsDbSystemCollectionItemReplicationConfig[]: Replication configuration that is applicable on database systems with the PRIMARY_DB_SYSTEM role.
shape string: The name of the shape for the database instance. Example: VM.Standard.E4.Flex
sources GetDbSystemsDbSystemCollectionItemSource[]: The source of the database system.
state string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
storageDetails GetDbSystemsDbSystemCollectionItemStorageDetail[]: Storage details of the database system.
systemRole string: A filter to return only DbSystem resources if their systemRole matches the given value.
systemTags {[key: string]: string}: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
systemType string: Type of the database system.
timeCreated string: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
timeUpdated string: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

admin_username str: The database system administrator username.
apply_change_mode_to_stand_alone str
apply_config str
compartment_id str: The ID of the compartment in which to list resources.
config_id str: The OCID of the configuration associated with the database system.
credentials Sequence[GetDbSystemsDbSystemCollectionItemCredential]: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
db_version str: The major and minor versions of the database system software.
defined_tags Mapping[str, str]: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description str: Description of the database instance node.
display_name str: A filter to return only resources that match the entire display name given.
freeform_tags Mapping[str, str]: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id str: A unique identifier for the database system.
instance_count int: Count of instances, or nodes, in the database system.
instance_memory_size_in_gbs int: The total amount of memory available to each database instance node, in gigabytes.
instance_ocpu_count int: The total number of OCPUs available to each database instance node.
instances Sequence[GetDbSystemsDbSystemCollectionItemInstance]: The list of instances, or nodes, in the database system.
instances_details Sequence[GetDbSystemsDbSystemCollectionItemInstancesDetail]
kerberos_auth_details Sequence[GetDbSystemsDbSystemCollectionItemKerberosAuthDetail]: Kerberos Authentication details for the database system.
lifecycle_details str: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
management_policies Sequence[GetDbSystemsDbSystemCollectionItemManagementPolicy]: PostgreSQL database system management policy.
network_details Sequence[GetDbSystemsDbSystemCollectionItemNetworkDetail]: Network details for the database system.
odsp_insight_details Sequence[GetDbSystemsDbSystemCollectionItemOdspInsightDetail]: ODSP Insight details for the database system.
patch_operations Sequence[GetDbSystemsDbSystemCollectionItemPatchOperation]
replication_configs Sequence[GetDbSystemsDbSystemCollectionItemReplicationConfig]: Replication configuration that is applicable on database systems with the PRIMARY_DB_SYSTEM role.
shape str: The name of the shape for the database instance. Example: VM.Standard.E4.Flex
sources Sequence[GetDbSystemsDbSystemCollectionItemSource]: The source of the database system.
state str: A filter to return only resources if their lifecycleState matches the given lifecycleState.
storage_details Sequence[GetDbSystemsDbSystemCollectionItemStorageDetail]: Storage details of the database system.
system_role str: A filter to return only DbSystem resources if their systemRole matches the given value.
system_tags Mapping[str, str]: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
system_type str: Type of the database system.
time_created str: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
time_updated str: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

adminUsername String: The database system administrator username.
applyChangeModeToStandAlone String
applyConfig String
compartmentId String: The ID of the compartment in which to list resources.
configId String: The OCID of the configuration associated with the database system.
credentials List<Property Map>: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
dbVersion String: The major and minor versions of the database system software.
definedTags Map<String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description String: Description of the database instance node.
displayName String: A filter to return only resources that match the entire display name given.
freeformTags Map<String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id String: A unique identifier for the database system.
instanceCount Number: Count of instances, or nodes, in the database system.
instanceMemorySizeInGbs Number: The total amount of memory available to each database instance node, in gigabytes.
instanceOcpuCount Number: The total number of OCPUs available to each database instance node.
instances List<Property Map>: The list of instances, or nodes, in the database system.
instancesDetails List<Property Map>
kerberosAuthDetails List<Property Map>: Kerberos Authentication details for the database system.
lifecycleDetails String: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
managementPolicies List<Property Map>: PostgreSQL database system management policy.
networkDetails List<Property Map>: Network details for the database system.
odspInsightDetails List<Property Map>: ODSP Insight details for the database system.
patchOperations List<Property Map>
replicationConfigs List<Property Map>: Replication configuration that is applicable on database systems with the PRIMARY_DB_SYSTEM role.
shape String: The name of the shape for the database instance. Example: VM.Standard.E4.Flex
sources List<Property Map>: The source of the database system.
state String: A filter to return only resources if their lifecycleState matches the given lifecycleState.
storageDetails List<Property Map>: Storage details of the database system.
systemRole String: A filter to return only DbSystem resources if their systemRole matches the given value.
systemTags Map<String>: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
systemType String: Type of the database system.
timeCreated String: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
timeUpdated String: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

GetDbSystemsDbSystemCollectionItemCredential

PasswordDetails List<GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail>
Username string

PasswordDetails []GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail
Username string

password_details list(object)
username string

passwordDetails List<GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail>
username String

passwordDetails GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail[]
username string

password_details Sequence[GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail]
username str

passwordDetails List<Property Map>
username String

GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail

Password string
PasswordType string
SecretId string
SecretVersion string

Password string
PasswordType string
SecretId string
SecretVersion string

password string
password_type string
secret_id string
secret_version string

password String
passwordType String
secretId String
secretVersion String

password string
passwordType string
secretId string
secretVersion string

password str
password_type str
secret_id str
secret_version str

password String
passwordType String
secretId String
secretVersion String

GetDbSystemsDbSystemCollectionItemInstance

AvailabilityDomain string: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
Description string: Description of the database instance node.
DisplayName string: A filter to return only resources that match the entire display name given.
Id string: A unique identifier for the database system.
LifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
State string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
TimeCreated string: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
TimeUpdated string: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

AvailabilityDomain string: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
Description string: Description of the database instance node.
DisplayName string: A filter to return only resources that match the entire display name given.
Id string: A unique identifier for the database system.
LifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
State string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
TimeCreated string: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
TimeUpdated string: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

availability_domain string: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
description string: Description of the database instance node.
display_name string: A filter to return only resources that match the entire display name given.
id string: A unique identifier for the database system.
lifecycle_details string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
state string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
time_created string: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
time_updated string: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

availabilityDomain String: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
description String: Description of the database instance node.
displayName String: A filter to return only resources that match the entire display name given.
id String: A unique identifier for the database system.
lifecycleDetails String: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
state String: A filter to return only resources if their lifecycleState matches the given lifecycleState.
timeCreated String: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
timeUpdated String: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

availabilityDomain string: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
description string: Description of the database instance node.
displayName string: A filter to return only resources that match the entire display name given.
id string: A unique identifier for the database system.
lifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
state string: A filter to return only resources if their lifecycleState matches the given lifecycleState.
timeCreated string: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
timeUpdated string: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

availability_domain str: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
description str: Description of the database instance node.
display_name str: A filter to return only resources that match the entire display name given.
id str: A unique identifier for the database system.
lifecycle_details str: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
state str: A filter to return only resources if their lifecycleState matches the given lifecycleState.
time_created str: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
time_updated str: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

availabilityDomain String: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
description String: Description of the database instance node.
displayName String: A filter to return only resources that match the entire display name given.
id String: A unique identifier for the database system.
lifecycleDetails String: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
state String: A filter to return only resources if their lifecycleState matches the given lifecycleState.
timeCreated String: The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
timeUpdated String: The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

GetDbSystemsDbSystemCollectionItemInstancesDetail

Description string: Description of the database instance node.
DisplayName string: A filter to return only resources that match the entire display name given.
PrivateIp string

Description string: Description of the database instance node.
DisplayName string: A filter to return only resources that match the entire display name given.
PrivateIp string

description string: Description of the database instance node.
display_name string: A filter to return only resources that match the entire display name given.
private_ip string

description String: Description of the database instance node.
displayName String: A filter to return only resources that match the entire display name given.
privateIp String

description string: Description of the database instance node.
displayName string: A filter to return only resources that match the entire display name given.
privateIp string

description str: Description of the database instance node.
display_name str: A filter to return only resources that match the entire display name given.
private_ip str

description String: Description of the database instance node.
displayName String: A filter to return only resources that match the entire display name given.
privateIp String

GetDbSystemsDbSystemCollectionItemKerberosAuthDetail

BackupCredentials List<GetDbSystemsDbSystemCollectionItemKerberosAuthDetailBackupCredential>: Optional. List of Kerberos Credentials previously configured for the dbsystem. Currently supports only one entry.
Credentials List<GetDbSystemsDbSystemCollectionItemKerberosAuthDetailCredential>: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
Kind string: Specifies the management of Insight for the dbSystem.

BackupCredentials []GetDbSystemsDbSystemCollectionItemKerberosAuthDetailBackupCredential: Optional. List of Kerberos Credentials previously configured for the dbsystem. Currently supports only one entry.
Credentials []GetDbSystemsDbSystemCollectionItemKerberosAuthDetailCredential: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
Kind string: Specifies the management of Insight for the dbSystem.

backup_credentials list(object): Optional. List of Kerberos Credentials previously configured for the dbsystem. Currently supports only one entry.
credentials list(object): List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
kind string: Specifies the management of Insight for the dbSystem.

backupCredentials List<GetDbSystemsDbSystemCollectionItemKerberosAuthDetailBackupCredential>: Optional. List of Kerberos Credentials previously configured for the dbsystem. Currently supports only one entry.
credentials List<GetDbSystemsDbSystemCollectionItemKerberosAuthDetailCredential>: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
kind String: Specifies the management of Insight for the dbSystem.

backupCredentials GetDbSystemsDbSystemCollectionItemKerberosAuthDetailBackupCredential[]: Optional. List of Kerberos Credentials previously configured for the dbsystem. Currently supports only one entry.
credentials GetDbSystemsDbSystemCollectionItemKerberosAuthDetailCredential[]: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
kind string: Specifies the management of Insight for the dbSystem.

backup_credentials Sequence[GetDbSystemsDbSystemCollectionItemKerberosAuthDetailBackupCredential]: Optional. List of Kerberos Credentials previously configured for the dbsystem. Currently supports only one entry.
credentials Sequence[GetDbSystemsDbSystemCollectionItemKerberosAuthDetailCredential]: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
kind str: Specifies the management of Insight for the dbSystem.

backupCredentials List<Property Map>: Optional. List of Kerberos Credentials previously configured for the dbsystem. Currently supports only one entry.
credentials List<Property Map>: List of Kerberos Credentials to be configured for the dbsystem. Currently supports only one entry.
kind String: Specifies the management of Insight for the dbSystem.

GetDbSystemsDbSystemCollectionItemKerberosAuthDetailBackupCredential

KeytabSecretId string: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
KeytabSecretVersion string: The secret version of the stored Kerberos keytab file.
RealmName string: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

KeytabSecretId string: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
KeytabSecretVersion string: The secret version of the stored Kerberos keytab file.
RealmName string: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytab_secret_id string: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytab_secret_version string: The secret version of the stored Kerberos keytab file.
realm_name string: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytabSecretId String: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytabSecretVersion String: The secret version of the stored Kerberos keytab file.
realmName String: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytabSecretId string: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytabSecretVersion string: The secret version of the stored Kerberos keytab file.
realmName string: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytab_secret_id str: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytab_secret_version str: The secret version of the stored Kerberos keytab file.
realm_name str: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytabSecretId String: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytabSecretVersion String: The secret version of the stored Kerberos keytab file.
realmName String: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

GetDbSystemsDbSystemCollectionItemKerberosAuthDetailCredential

KeytabSecretId string: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
KeytabSecretVersion string: The secret version of the stored Kerberos keytab file.
RealmName string: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

KeytabSecretId string: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
KeytabSecretVersion string: The secret version of the stored Kerberos keytab file.
RealmName string: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytab_secret_id string: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytab_secret_version string: The secret version of the stored Kerberos keytab file.
realm_name string: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytabSecretId String: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytabSecretVersion String: The secret version of the stored Kerberos keytab file.
realmName String: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytabSecretId string: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytabSecretVersion string: The secret version of the stored Kerberos keytab file.
realmName string: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytab_secret_id str: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytab_secret_version str: The secret version of the stored Kerberos keytab file.
realm_name str: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

keytabSecretId String: The OCID of the secret where the Kerberos keytab file is stored as base64 text.
keytabSecretVersion String: The secret version of the stored Kerberos keytab file.
realmName String: Kerberos realm name. https://docs.oracle.com/cd/E36784_01/html/E37126/kplanning-27.html Realm names can consist of any ASCII string. Usually, the realm name is the same as your DNS domain name except that the realm name is in uppercase. This convention helps differentiate problems with the Kerberos service from problems with the DNS namespace, while keeping a name that is familiar. You can use any string, but configuration and maintenance might then require more work. Use realm names that follow the standard Internet naming structure.

GetDbSystemsDbSystemCollectionItemManagementPolicy

BackupPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy>: PostgreSQL database system backup policy.
MaintenanceWindowStart string: The start of the maintenance window.

BackupPolicies []GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy: PostgreSQL database system backup policy.
MaintenanceWindowStart string: The start of the maintenance window.

backup_policies list(object): PostgreSQL database system backup policy.
maintenance_window_start string: The start of the maintenance window.

backupPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy>: PostgreSQL database system backup policy.
maintenanceWindowStart String: The start of the maintenance window.

backupPolicies GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy[]: PostgreSQL database system backup policy.
maintenanceWindowStart string: The start of the maintenance window.

backup_policies Sequence[GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy]: PostgreSQL database system backup policy.
maintenance_window_start str: The start of the maintenance window.

backupPolicies List<Property Map>: PostgreSQL database system backup policy.
maintenanceWindowStart String: The start of the maintenance window.

GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy

BackupStart string: Hour of the day when the backup starts.
CopyPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy>: Backup copy details
DaysOfTheMonths List<int>: Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
DaysOfTheWeeks List<string>: The day of the week that the backup starts.
Kind string: Specifies the management of Insight for the dbSystem.
RetentionDays int: How many days the data should be stored after the database system deletion.

BackupStart string: Hour of the day when the backup starts.
CopyPolicies []GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy: Backup copy details
DaysOfTheMonths []int: Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
DaysOfTheWeeks []string: The day of the week that the backup starts.
Kind string: Specifies the management of Insight for the dbSystem.
RetentionDays int: How many days the data should be stored after the database system deletion.

backup_start string: Hour of the day when the backup starts.
copy_policies list(object): Backup copy details
days_of_the_months list(number): Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
days_of_the_weeks list(string): The day of the week that the backup starts.
kind string: Specifies the management of Insight for the dbSystem.
retention_days number: How many days the data should be stored after the database system deletion.

backupStart String: Hour of the day when the backup starts.
copyPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy>: Backup copy details
daysOfTheMonths List<Integer>: Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
daysOfTheWeeks List<String>: The day of the week that the backup starts.
kind String: Specifies the management of Insight for the dbSystem.
retentionDays Integer: How many days the data should be stored after the database system deletion.

backupStart string: Hour of the day when the backup starts.
copyPolicies GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy[]: Backup copy details
daysOfTheMonths number[]: Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
daysOfTheWeeks string[]: The day of the week that the backup starts.
kind string: Specifies the management of Insight for the dbSystem.
retentionDays number: How many days the data should be stored after the database system deletion.

backup_start str: Hour of the day when the backup starts.
copy_policies Sequence[GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy]: Backup copy details
days_of_the_months Sequence[int]: Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
days_of_the_weeks Sequence[str]: The day of the week that the backup starts.
kind str: Specifies the management of Insight for the dbSystem.
retention_days int: How many days the data should be stored after the database system deletion.

backupStart String: Hour of the day when the backup starts.
copyPolicies List<Property Map>: Backup copy details
daysOfTheMonths List<Number>: Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
daysOfTheWeeks List<String>: The day of the week that the backup starts.
kind String: Specifies the management of Insight for the dbSystem.
retentionDays Number: How many days the data should be stored after the database system deletion.

GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy

CompartmentId string: The ID of the compartment in which to list resources.
Regions List<string>: List of region names of the remote region
RetentionPeriod int: Retention period in days of the backup copy.

CompartmentId string: The ID of the compartment in which to list resources.
Regions []string: List of region names of the remote region
RetentionPeriod int: Retention period in days of the backup copy.

compartment_id string: The ID of the compartment in which to list resources.
regions list(string): List of region names of the remote region
retention_period number: Retention period in days of the backup copy.

compartmentId String: The ID of the compartment in which to list resources.
regions List<String>: List of region names of the remote region
retentionPeriod Integer: Retention period in days of the backup copy.

compartmentId string: The ID of the compartment in which to list resources.
regions string[]: List of region names of the remote region
retentionPeriod number: Retention period in days of the backup copy.

compartment_id str: The ID of the compartment in which to list resources.
regions Sequence[str]: List of region names of the remote region
retention_period int: Retention period in days of the backup copy.

compartmentId String: The ID of the compartment in which to list resources.
regions List<String>: List of region names of the remote region
retentionPeriod Number: Retention period in days of the backup copy.

GetDbSystemsDbSystemCollectionItemNetworkDetail

IsReaderEndpointEnabled bool: Specifies if the reader endpoint is enabled on the dbSystem.
NsgIds List<string>: List of customer Network Security Group OCIDs associated with the database system.
PrimaryDbEndpointPrivateIp string: Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
SubnetId string: The OCID of the customer subnet associated with the database system.

IsReaderEndpointEnabled bool: Specifies if the reader endpoint is enabled on the dbSystem.
NsgIds []string: List of customer Network Security Group OCIDs associated with the database system.
PrimaryDbEndpointPrivateIp string: Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
SubnetId string: The OCID of the customer subnet associated with the database system.

is_reader_endpoint_enabled bool: Specifies if the reader endpoint is enabled on the dbSystem.
nsg_ids list(string): List of customer Network Security Group OCIDs associated with the database system.
primary_db_endpoint_private_ip string: Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
subnet_id string: The OCID of the customer subnet associated with the database system.

isReaderEndpointEnabled Boolean: Specifies if the reader endpoint is enabled on the dbSystem.
nsgIds List<String>: List of customer Network Security Group OCIDs associated with the database system.
primaryDbEndpointPrivateIp String: Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
subnetId String: The OCID of the customer subnet associated with the database system.

isReaderEndpointEnabled boolean: Specifies if the reader endpoint is enabled on the dbSystem.
nsgIds string[]: List of customer Network Security Group OCIDs associated with the database system.
primaryDbEndpointPrivateIp string: Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
subnetId string: The OCID of the customer subnet associated with the database system.

is_reader_endpoint_enabled bool: Specifies if the reader endpoint is enabled on the dbSystem.
nsg_ids Sequence[str]: List of customer Network Security Group OCIDs associated with the database system.
primary_db_endpoint_private_ip str: Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
subnet_id str: The OCID of the customer subnet associated with the database system.

isReaderEndpointEnabled Boolean: Specifies if the reader endpoint is enabled on the dbSystem.
nsgIds List<String>: List of customer Network Security Group OCIDs associated with the database system.
primaryDbEndpointPrivateIp String: Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
subnetId String: The OCID of the customer subnet associated with the database system.

GetDbSystemsDbSystemCollectionItemOdspInsightDetail

Kind string: Specifies the management of Insight for the dbSystem.
OdspInsightLists List<GetDbSystemsDbSystemCollectionItemOdspInsightDetailOdspInsightList>: List of ODSP Insight and their configurations.

Kind string: Specifies the management of Insight for the dbSystem.
OdspInsightLists []GetDbSystemsDbSystemCollectionItemOdspInsightDetailOdspInsightList: List of ODSP Insight and their configurations.

kind string: Specifies the management of Insight for the dbSystem.
odsp_insight_lists list(object): List of ODSP Insight and their configurations.

kind String: Specifies the management of Insight for the dbSystem.
odspInsightLists List<GetDbSystemsDbSystemCollectionItemOdspInsightDetailOdspInsightList>: List of ODSP Insight and their configurations.

kind string: Specifies the management of Insight for the dbSystem.
odspInsightLists GetDbSystemsDbSystemCollectionItemOdspInsightDetailOdspInsightList[]: List of ODSP Insight and their configurations.

kind str: Specifies the management of Insight for the dbSystem.
odsp_insight_lists Sequence[GetDbSystemsDbSystemCollectionItemOdspInsightDetailOdspInsightList]: List of ODSP Insight and their configurations.

kind String: Specifies the management of Insight for the dbSystem.
odspInsightLists List<Property Map>: List of ODSP Insight and their configurations.

GetDbSystemsDbSystemCollectionItemOdspInsightDetailOdspInsightList

InsightType string: Type of Insight collected for the database system.
RetentionPeriodInDays int: Retention period for Insight data, in days. Current supported value is 7 days. the system default is 7 days.

InsightType string: Type of Insight collected for the database system.
RetentionPeriodInDays int: Retention period for Insight data, in days. Current supported value is 7 days. the system default is 7 days.

insight_type string: Type of Insight collected for the database system.
retention_period_in_days number: Retention period for Insight data, in days. Current supported value is 7 days. the system default is 7 days.

insightType String: Type of Insight collected for the database system.
retentionPeriodInDays Integer: Retention period for Insight data, in days. Current supported value is 7 days. the system default is 7 days.

insightType string: Type of Insight collected for the database system.
retentionPeriodInDays number: Retention period for Insight data, in days. Current supported value is 7 days. the system default is 7 days.

insight_type str: Type of Insight collected for the database system.
retention_period_in_days int: Retention period for Insight data, in days. Current supported value is 7 days. the system default is 7 days.

insightType String: Type of Insight collected for the database system.
retentionPeriodInDays Number: Retention period for Insight data, in days. Current supported value is 7 days. the system default is 7 days.

GetDbSystemsDbSystemCollectionItemPatchOperation

From string
Operation string
Position string
SelectedItem string
Selection string
Value Dictionary<string, string>

From string
Operation string
Position string
SelectedItem string
Selection string
Value map[string]string

from string
operation string
position string
selected_item string
selection string
value map(string)

from String
operation String
position String
selectedItem String
selection String
value Map<String,String>

from string
operation string
position string
selectedItem string
selection string
value {[key: string]: string}

from_ str
operation str
position str
selected_item str
selection str
value Mapping[str, str]

from String
operation String
position String
selectedItem String
selection String
value Map<String>

GetDbSystemsDbSystemCollectionItemReplicationConfig

IsRpoEnforced bool: Specifies if Recovery point objective (RPO) enforcement is enabled on the database system.
RpoInSeconds string: Specifies the Recovery point objective (RPO) in seconds that will be enforced, if the isRpoEnforced flag is true.

IsRpoEnforced bool: Specifies if Recovery point objective (RPO) enforcement is enabled on the database system.
RpoInSeconds string: Specifies the Recovery point objective (RPO) in seconds that will be enforced, if the isRpoEnforced flag is true.

is_rpo_enforced bool: Specifies if Recovery point objective (RPO) enforcement is enabled on the database system.
rpo_in_seconds string: Specifies the Recovery point objective (RPO) in seconds that will be enforced, if the isRpoEnforced flag is true.

isRpoEnforced Boolean: Specifies if Recovery point objective (RPO) enforcement is enabled on the database system.
rpoInSeconds String: Specifies the Recovery point objective (RPO) in seconds that will be enforced, if the isRpoEnforced flag is true.

isRpoEnforced boolean: Specifies if Recovery point objective (RPO) enforcement is enabled on the database system.
rpoInSeconds string: Specifies the Recovery point objective (RPO) in seconds that will be enforced, if the isRpoEnforced flag is true.

is_rpo_enforced bool: Specifies if Recovery point objective (RPO) enforcement is enabled on the database system.
rpo_in_seconds str: Specifies the Recovery point objective (RPO) in seconds that will be enforced, if the isRpoEnforced flag is true.

isRpoEnforced Boolean: Specifies if Recovery point objective (RPO) enforcement is enabled on the database system.
rpoInSeconds String: Specifies the Recovery point objective (RPO) in seconds that will be enforced, if the isRpoEnforced flag is true.

GetDbSystemsDbSystemCollectionItemSource

BackupId string: The OCID of the database system backup.
IsHavingRestoreConfigOverrides bool: Deprecated. Don't use.
PrimaryDbSystemId string: The [OCID] of the primary database system.
SourceType string: The source descriminator.

BackupId string: The OCID of the database system backup.
IsHavingRestoreConfigOverrides bool: Deprecated. Don't use.
PrimaryDbSystemId string: The [OCID] of the primary database system.
SourceType string: The source descriminator.

backup_id string: The OCID of the database system backup.
is_having_restore_config_overrides bool: Deprecated. Don't use.
primary_db_system_id string: The [OCID] of the primary database system.
source_type string: The source descriminator.

backupId String: The OCID of the database system backup.
isHavingRestoreConfigOverrides Boolean: Deprecated. Don't use.
primaryDbSystemId String: The [OCID] of the primary database system.
sourceType String: The source descriminator.

backupId string: The OCID of the database system backup.
isHavingRestoreConfigOverrides boolean: Deprecated. Don't use.
primaryDbSystemId string: The [OCID] of the primary database system.
sourceType string: The source descriminator.

backup_id str: The OCID of the database system backup.
is_having_restore_config_overrides bool: Deprecated. Don't use.
primary_db_system_id str: The [OCID] of the primary database system.
source_type str: The source descriminator.

backupId String: The OCID of the database system backup.
isHavingRestoreConfigOverrides Boolean: Deprecated. Don't use.
primaryDbSystemId String: The [OCID] of the primary database system.
sourceType String: The source descriminator.

GetDbSystemsDbSystemCollectionItemStorageDetail

AvailabilityDomain string: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
Iops string: Guaranteed input/output storage requests per second (IOPS) available to the database system.
IsRegionallyDurable bool: Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
SystemType string: Type of the database system.

AvailabilityDomain string: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
Iops string: Guaranteed input/output storage requests per second (IOPS) available to the database system.
IsRegionallyDurable bool: Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
SystemType string: Type of the database system.

availability_domain string: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
iops string: Guaranteed input/output storage requests per second (IOPS) available to the database system.
is_regionally_durable bool: Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
system_type string: Type of the database system.

availabilityDomain String: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
iops String: Guaranteed input/output storage requests per second (IOPS) available to the database system.
isRegionallyDurable Boolean: Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
systemType String: Type of the database system.

availabilityDomain string: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
iops string: Guaranteed input/output storage requests per second (IOPS) available to the database system.
isRegionallyDurable boolean: Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
systemType string: Type of the database system.

availability_domain str: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
iops str: Guaranteed input/output storage requests per second (IOPS) available to the database system.
is_regionally_durable bool: Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
system_type str: Type of the database system.

availabilityDomain String: Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
iops String: Guaranteed input/output storage requests per second (IOPS) available to the database system.
isRegionallyDurable Boolean: Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
systemType String: Type of the database system.

GetDbSystemsFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name string
values list(string)
regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Viewing docs for Oracle Cloud Infrastructure v4.16.0
published on Wednesday, Jun 17, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-oci

oci.Psql.getDbSystems

On this page

On this page

Example Usage

Using getDbSystems

getDbSystems Result

Supporting Types

GetDbSystemsDbSystemCollection

GetDbSystemsDbSystemCollectionItem

GetDbSystemsDbSystemCollectionItemCredential

GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail

GetDbSystemsDbSystemCollectionItemInstance

GetDbSystemsDbSystemCollectionItemInstancesDetail

GetDbSystemsDbSystemCollectionItemKerberosAuthDetail

GetDbSystemsDbSystemCollectionItemKerberosAuthDetailBackupCredential

GetDbSystemsDbSystemCollectionItemKerberosAuthDetailCredential

GetDbSystemsDbSystemCollectionItemManagementPolicy

GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy

GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy

GetDbSystemsDbSystemCollectionItemNetworkDetail

GetDbSystemsDbSystemCollectionItemOdspInsightDetail

GetDbSystemsDbSystemCollectionItemOdspInsightDetailOdspInsightList

GetDbSystemsDbSystemCollectionItemPatchOperation

GetDbSystemsDbSystemCollectionItemReplicationConfig

GetDbSystemsDbSystemCollectionItemSource

GetDbSystemsDbSystemCollectionItemStorageDetail

GetDbSystemsFilter

Package Details

On this page

On this page

Try Pulumi Cloud free.
Your team will thank you.

oci.Psql.getDbSystems

On this page

On this page

Example Usage

Using getDbSystems

getDbSystems Result

Supporting Types

GetDbSystemsDbSystemCollection

GetDbSystemsDbSystemCollectionItem

GetDbSystemsDbSystemCollectionItemCredential

GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail

GetDbSystemsDbSystemCollectionItemInstance

GetDbSystemsDbSystemCollectionItemInstancesDetail

GetDbSystemsDbSystemCollectionItemKerberosAuthDetail

GetDbSystemsDbSystemCollectionItemKerberosAuthDetailBackupCredential

GetDbSystemsDbSystemCollectionItemKerberosAuthDetailCredential

GetDbSystemsDbSystemCollectionItemManagementPolicy

GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy

GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy

GetDbSystemsDbSystemCollectionItemNetworkDetail

GetDbSystemsDbSystemCollectionItemOdspInsightDetail

GetDbSystemsDbSystemCollectionItemOdspInsightDetailOdspInsightList

GetDbSystemsDbSystemCollectionItemPatchOperation

GetDbSystemsDbSystemCollectionItemReplicationConfig

GetDbSystemsDbSystemCollectionItemSource

GetDbSystemsDbSystemCollectionItemStorageDetail

GetDbSystemsFilter

Package Details

On this page

On this page

Try Pulumi Cloud free.Your team will thank you.

Try Pulumi Cloud free.
Your team will thank you.