Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getDbServers

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

Lists the Exadata DB servers in the ExadataInfrastructureId and specified compartment.

Example Usage

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testDbServers = Output.Create(Oci.Database.GetDbServers.InvokeAsync(new Oci.Database.GetDbServersArgs
        {
            CompartmentId = @var.Compartment_id,
            ExadataInfrastructureId = oci_database_exadata_infrastructure.Test_exadata_infrastructure.Id,
            DisplayName = @var.Db_server_display_name,
            State = @var.Db_server_state,
        }));
    }

}
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := Database.GetDbServers(ctx, &database.GetDbServersArgs{
			CompartmentId:           _var.Compartment_id,
			ExadataInfrastructureId: oci_database_exadata_infrastructure.Test_exadata_infrastructure.Id,
			DisplayName:             pulumi.StringRef(_var.Db_server_display_name),
			State:                   pulumi.StringRef(_var.Db_server_state),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

import pulumi
import pulumi_oci as oci

test_db_servers = oci.Database.get_db_servers(compartment_id=var["compartment_id"],
    exadata_infrastructure_id=oci_database_exadata_infrastructure["test_exadata_infrastructure"]["id"],
    display_name=var["db_server_display_name"],
    state=var["db_server_state"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDbServers = oci.Database.getDbServers({
    compartmentId: _var.compartment_id,
    exadataInfrastructureId: oci_database_exadata_infrastructure.test_exadata_infrastructure.id,
    displayName: _var.db_server_display_name,
    state: _var.db_server_state,
});

Coming soon!

Using getDbServers

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 getDbServers(args: GetDbServersArgs, opts?: InvokeOptions): Promise<GetDbServersResult>
function getDbServersOutput(args: GetDbServersOutputArgs, opts?: InvokeOptions): Output<GetDbServersResult>
def get_db_servers(compartment_id: Optional[str] = None,
                   display_name: Optional[str] = None,
                   exadata_infrastructure_id: Optional[str] = None,
                   filters: Optional[Sequence[_database.GetDbServersFilter]] = None,
                   state: Optional[str] = None,
                   opts: Optional[InvokeOptions] = None) -> GetDbServersResult
def get_db_servers_output(compartment_id: Optional[pulumi.Input[str]] = None,
                   display_name: Optional[pulumi.Input[str]] = None,
                   exadata_infrastructure_id: Optional[pulumi.Input[str]] = None,
                   filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDbServersFilterArgs]]]] = None,
                   state: Optional[pulumi.Input[str]] = None,
                   opts: Optional[InvokeOptions] = None) -> Output[GetDbServersResult]
func GetDbServers(ctx *Context, args *GetDbServersArgs, opts ...InvokeOption) (*GetDbServersResult, error)
func GetDbServersOutput(ctx *Context, args *GetDbServersOutputArgs, opts ...InvokeOption) GetDbServersResultOutput

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

public static class GetDbServers 
{
    public static Task<GetDbServersResult> InvokeAsync(GetDbServersArgs args, InvokeOptions? opts = null)
    public static Output<GetDbServersResult> Invoke(GetDbServersInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDbServersResult> getDbServers(GetDbServersArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:Database/getDbServers:getDbServers
  Arguments:
    # Arguments dictionary

The following arguments are supported:

CompartmentId string

The compartment OCID.

ExadataInfrastructureId string

The OCID of the ExadataInfrastructure.

DisplayName string

A filter to return only resources that match the entire display name given. The match is not case sensitive.

Filters List<GetDbServersFilter>
State string

A filter to return only resources that match the given lifecycle state exactly.

CompartmentId string

The compartment OCID.

ExadataInfrastructureId string

The OCID of the ExadataInfrastructure.

DisplayName string

A filter to return only resources that match the entire display name given. The match is not case sensitive.

Filters []GetDbServersFilter
State string

A filter to return only resources that match the given lifecycle state exactly.

compartmentId String

The compartment OCID.

exadataInfrastructureId String

The OCID of the ExadataInfrastructure.

displayName String

A filter to return only resources that match the entire display name given. The match is not case sensitive.

filters List<GetDbServersFilter>
state String

A filter to return only resources that match the given lifecycle state exactly.

compartmentId string

The compartment OCID.

exadataInfrastructureId string

The OCID of the ExadataInfrastructure.

displayName string

A filter to return only resources that match the entire display name given. The match is not case sensitive.

filters GetDbServersFilter[]
state string

A filter to return only resources that match the given lifecycle state exactly.

compartment_id str

The compartment OCID.

exadata_infrastructure_id str

The OCID of the ExadataInfrastructure.

display_name str

A filter to return only resources that match the entire display name given. The match is not case sensitive.

filters GetDbServersFilter]
state str

A filter to return only resources that match the given lifecycle state exactly.

compartmentId String

The compartment OCID.

exadataInfrastructureId String

The OCID of the ExadataInfrastructure.

displayName String

A filter to return only resources that match the entire display name given. The match is not case sensitive.

filters List<Property Map>
state String

A filter to return only resources that match the given lifecycle state exactly.

getDbServers Result

The following output properties are available:

CompartmentId string

The OCID of the compartment.

DbServers List<GetDbServersDbServer>

The list of db_servers.

ExadataInfrastructureId string

The OCID of the Exadata infrastructure.

Id string

The provider-assigned unique ID for this managed resource.

DisplayName string

The user-friendly name for the Db server. The name does not need to be unique.

Filters List<GetDbServersFilter>
State string

The current state of the Db server.

CompartmentId string

The OCID of the compartment.

DbServers []GetDbServersDbServer

The list of db_servers.

ExadataInfrastructureId string

The OCID of the Exadata infrastructure.

Id string

The provider-assigned unique ID for this managed resource.

DisplayName string

The user-friendly name for the Db server. The name does not need to be unique.

Filters []GetDbServersFilter
State string

The current state of the Db server.

compartmentId String

The OCID of the compartment.

dbServers List<GetDbServersDbServer>

The list of db_servers.

exadataInfrastructureId String

The OCID of the Exadata infrastructure.

id String

The provider-assigned unique ID for this managed resource.

displayName String

The user-friendly name for the Db server. The name does not need to be unique.

filters List<GetDbServersFilter>
state String

The current state of the Db server.

compartmentId string

The OCID of the compartment.

dbServers GetDbServersDbServer[]

The list of db_servers.

exadataInfrastructureId string

The OCID of the Exadata infrastructure.

id string

The provider-assigned unique ID for this managed resource.

displayName string

The user-friendly name for the Db server. The name does not need to be unique.

filters GetDbServersFilter[]
state string

The current state of the Db server.

compartment_id str

The OCID of the compartment.

db_servers GetDbServersDbServer]

The list of db_servers.

exadata_infrastructure_id str

The OCID of the Exadata infrastructure.

id str

The provider-assigned unique ID for this managed resource.

display_name str

The user-friendly name for the Db server. The name does not need to be unique.

filters GetDbServersFilter]
state str

The current state of the Db server.

compartmentId String

The OCID of the compartment.

dbServers List<Property Map>

The list of db_servers.

exadataInfrastructureId String

The OCID of the Exadata infrastructure.

id String

The provider-assigned unique ID for this managed resource.

displayName String

The user-friendly name for the Db server. The name does not need to be unique.

filters List<Property Map>
state String

The current state of the Db server.

Supporting Types

GetDbServersDbServer

CompartmentId string

The compartment OCID.

CpuCoreCount int

The number of CPU cores enabled on the Db server.

DbNodeIds List<string>

The OCID of the Db nodes associated with the Db server.

DbNodeStorageSizeInGbs int

The allocated local node storage in GBs on the Db server.

DbServerPatchingDetails List<GetDbServersDbServerDbServerPatchingDetail>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

DefinedTags Dictionary<string, object>

Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DisplayName string

A filter to return only resources that match the entire display name given. The match is not case sensitive.

ExadataInfrastructureId string

The OCID of the ExadataInfrastructure.

FreeformTags Dictionary<string, object>

Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

Id string

The OCID of the Exacc Db server.

LifecycleDetails string

Additional information about the current lifecycle state.

MaxCpuCount int

The total number of CPU cores available.

MaxDbNodeStorageInGbs int

The total local node storage available in GBs.

MaxMemoryInGbs int

The total memory available in GBs.

MemorySizeInGbs int

The allocated memory in GBs on the Db server.

State string

A filter to return only resources that match the given lifecycle state exactly.

TimeCreated string

The date and time that the Db Server was created.

VmClusterIds List<string>

The OCID of the VM Clusters associated with the Db server.

CompartmentId string

The compartment OCID.

CpuCoreCount int

The number of CPU cores enabled on the Db server.

DbNodeIds []string

The OCID of the Db nodes associated with the Db server.

DbNodeStorageSizeInGbs int

The allocated local node storage in GBs on the Db server.

DbServerPatchingDetails []GetDbServersDbServerDbServerPatchingDetail

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

DefinedTags map[string]interface{}

Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DisplayName string

A filter to return only resources that match the entire display name given. The match is not case sensitive.

ExadataInfrastructureId string

The OCID of the ExadataInfrastructure.

FreeformTags map[string]interface{}

Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

Id string

The OCID of the Exacc Db server.

LifecycleDetails string

Additional information about the current lifecycle state.

MaxCpuCount int

The total number of CPU cores available.

MaxDbNodeStorageInGbs int

The total local node storage available in GBs.

MaxMemoryInGbs int

The total memory available in GBs.

MemorySizeInGbs int

The allocated memory in GBs on the Db server.

State string

A filter to return only resources that match the given lifecycle state exactly.

TimeCreated string

The date and time that the Db Server was created.

VmClusterIds []string

The OCID of the VM Clusters associated with the Db server.

compartmentId String

The compartment OCID.

cpuCoreCount Integer

The number of CPU cores enabled on the Db server.

dbNodeIds List<String>

The OCID of the Db nodes associated with the Db server.

dbNodeStorageSizeInGbs Integer

The allocated local node storage in GBs on the Db server.

dbServerPatchingDetails List<GetDbServersDbServerDbServerPatchingDetail>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

definedTags Map<String,Object>

Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName String

A filter to return only resources that match the entire display name given. The match is not case sensitive.

exadataInfrastructureId String

The OCID of the ExadataInfrastructure.

freeformTags Map<String,Object>

Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id String

The OCID of the Exacc Db server.

lifecycleDetails String

Additional information about the current lifecycle state.

maxCpuCount Integer

The total number of CPU cores available.

maxDbNodeStorageInGbs Integer

The total local node storage available in GBs.

maxMemoryInGbs Integer

The total memory available in GBs.

memorySizeInGbs Integer

The allocated memory in GBs on the Db server.

state String

A filter to return only resources that match the given lifecycle state exactly.

timeCreated String

The date and time that the Db Server was created.

vmClusterIds List<String>

The OCID of the VM Clusters associated with the Db server.

compartmentId string

The compartment OCID.

cpuCoreCount number

The number of CPU cores enabled on the Db server.

dbNodeIds string[]

The OCID of the Db nodes associated with the Db server.

dbNodeStorageSizeInGbs number

The allocated local node storage in GBs on the Db server.

dbServerPatchingDetails GetDbServersDbServerDbServerPatchingDetail[]

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

definedTags {[key: string]: any}

Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName string

A filter to return only resources that match the entire display name given. The match is not case sensitive.

exadataInfrastructureId string

The OCID of the ExadataInfrastructure.

freeformTags {[key: string]: any}

Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id string

The OCID of the Exacc Db server.

lifecycleDetails string

Additional information about the current lifecycle state.

maxCpuCount number

The total number of CPU cores available.

maxDbNodeStorageInGbs number

The total local node storage available in GBs.

maxMemoryInGbs number

The total memory available in GBs.

memorySizeInGbs number

The allocated memory in GBs on the Db server.

state string

A filter to return only resources that match the given lifecycle state exactly.

timeCreated string

The date and time that the Db Server was created.

vmClusterIds string[]

The OCID of the VM Clusters associated with the Db server.

compartment_id str

The compartment OCID.

cpu_core_count int

The number of CPU cores enabled on the Db server.

db_node_ids Sequence[str]

The OCID of the Db nodes associated with the Db server.

db_node_storage_size_in_gbs int

The allocated local node storage in GBs on the Db server.

db_server_patching_details GetDbServersDbServerDbServerPatchingDetail]

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

defined_tags Mapping[str, Any]

Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

display_name str

A filter to return only resources that match the entire display name given. The match is not case sensitive.

exadata_infrastructure_id str

The OCID of the ExadataInfrastructure.

freeform_tags Mapping[str, Any]

Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id str

The OCID of the Exacc Db server.

lifecycle_details str

Additional information about the current lifecycle state.

max_cpu_count int

The total number of CPU cores available.

max_db_node_storage_in_gbs int

The total local node storage available in GBs.

max_memory_in_gbs int

The total memory available in GBs.

memory_size_in_gbs int

The allocated memory in GBs on the Db server.

state str

A filter to return only resources that match the given lifecycle state exactly.

time_created str

The date and time that the Db Server was created.

vm_cluster_ids Sequence[str]

The OCID of the VM Clusters associated with the Db server.

compartmentId String

The compartment OCID.

cpuCoreCount Number

The number of CPU cores enabled on the Db server.

dbNodeIds List<String>

The OCID of the Db nodes associated with the Db server.

dbNodeStorageSizeInGbs Number

The allocated local node storage in GBs on the Db server.

dbServerPatchingDetails List<Property Map>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

definedTags Map<Any>

Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName String

A filter to return only resources that match the entire display name given. The match is not case sensitive.

exadataInfrastructureId String

The OCID of the ExadataInfrastructure.

freeformTags Map<Any>

Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id String

The OCID of the Exacc Db server.

lifecycleDetails String

Additional information about the current lifecycle state.

maxCpuCount Number

The total number of CPU cores available.

maxDbNodeStorageInGbs Number

The total local node storage available in GBs.

maxMemoryInGbs Number

The total memory available in GBs.

memorySizeInGbs Number

The allocated memory in GBs on the Db server.

state String

A filter to return only resources that match the given lifecycle state exactly.

timeCreated String

The date and time that the Db Server was created.

vmClusterIds List<String>

The OCID of the VM Clusters associated with the Db server.

GetDbServersDbServerDbServerPatchingDetail

EstimatedPatchDuration int

Estimated time, in minutes, to patch one database server.

PatchingStatus string

The status of the patching operation.

TimePatchingEnded string

The time when the patching operation ended.

TimePatchingStarted string

The time when the patching operation started.

EstimatedPatchDuration int

Estimated time, in minutes, to patch one database server.

PatchingStatus string

The status of the patching operation.

TimePatchingEnded string

The time when the patching operation ended.

TimePatchingStarted string

The time when the patching operation started.

estimatedPatchDuration Integer

Estimated time, in minutes, to patch one database server.

patchingStatus String

The status of the patching operation.

timePatchingEnded String

The time when the patching operation ended.

timePatchingStarted String

The time when the patching operation started.

estimatedPatchDuration number

Estimated time, in minutes, to patch one database server.

patchingStatus string

The status of the patching operation.

timePatchingEnded string

The time when the patching operation ended.

timePatchingStarted string

The time when the patching operation started.

estimated_patch_duration int

Estimated time, in minutes, to patch one database server.

patching_status str

The status of the patching operation.

time_patching_ended str

The time when the patching operation ended.

time_patching_started str

The time when the patching operation started.

estimatedPatchDuration Number

Estimated time, in minutes, to patch one database server.

patchingStatus String

The status of the patching operation.

timePatchingEnded String

The time when the patching operation ended.

timePatchingStarted String

The time when the patching operation started.

GetDbServersFilter

Name string
Values List<string>
Regex bool
Name string
Values []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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.