Oracle Cloud Infrastructure v0.20.0, May 31 23

oci.Database.getDbServer

Explore with Pulumi AI

This data source provides details about a specific Db Server resource in Oracle Cloud Infrastructure Database service.

Gets information about the Exadata Db server.

Example Usage

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testDbServer = Oci.Database.GetDbServer.Invoke(new()
    {
        DbServerId = oci_database_db_server.Test_db_server.Id,
        ExadataInfrastructureId = oci_database_exadata_infrastructure.Test_exadata_infrastructure.Id,
    });

});

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.GetDbServer(ctx, &database.GetDbServerArgs{
			DbServerId:              oci_database_db_server.Test_db_server.Id,
			ExadataInfrastructureId: oci_database_exadata_infrastructure.Test_exadata_infrastructure.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Database.DatabaseFunctions;
import com.pulumi.oci.Database.inputs.GetDbServerArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testDbServer = DatabaseFunctions.getDbServer(GetDbServerArgs.builder()
            .dbServerId(oci_database_db_server.test_db_server().id())
            .exadataInfrastructureId(oci_database_exadata_infrastructure.test_exadata_infrastructure().id())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_db_server = oci.Database.get_db_server(db_server_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    exadata_infrastructure_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))

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

const testDbServer = oci.Database.getDbServer({
    dbServerId: oci_database_db_server.test_db_server.id,
    exadataInfrastructureId: oci_database_exadata_infrastructure.test_exadata_infrastructure.id,
});

variables:
  testDbServer:
    fn::invoke:
      Function: oci:Database:getDbServer
      Arguments:
        dbServerId: ${oci_database_db_server.test_db_server.id}
        exadataInfrastructureId: ${oci_database_exadata_infrastructure.test_exadata_infrastructure.id}

Using getDbServer

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 getDbServer(args: GetDbServerArgs, opts?: InvokeOptions): Promise<GetDbServerResult>
function getDbServerOutput(args: GetDbServerOutputArgs, opts?: InvokeOptions): Output<GetDbServerResult>

def get_db_server(db_server_id: Optional[str] = None,
                  exadata_infrastructure_id: Optional[str] = None,
                  opts: Optional[InvokeOptions] = None) -> GetDbServerResult
def get_db_server_output(db_server_id: Optional[pulumi.Input[str]] = None,
                  exadata_infrastructure_id: Optional[pulumi.Input[str]] = None,
                  opts: Optional[InvokeOptions] = None) -> Output[GetDbServerResult]

func GetDbServer(ctx *Context, args *GetDbServerArgs, opts ...InvokeOption) (*GetDbServerResult, error)
func GetDbServerOutput(ctx *Context, args *GetDbServerOutputArgs, opts ...InvokeOption) GetDbServerResultOutput

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

public static class GetDbServer 
{
    public static Task<GetDbServerResult> InvokeAsync(GetDbServerArgs args, InvokeOptions? opts = null)
    public static Output<GetDbServerResult> Invoke(GetDbServerInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDbServerResult> getDbServer(GetDbServerArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:Database/getDbServer:getDbServer
  arguments:
    # arguments dictionary

The following arguments are supported:

DbServerId string: The DB server OCID.
ExadataInfrastructureId string: The OCID of the ExadataInfrastructure.

DbServerId string: The DB server OCID.
ExadataInfrastructureId string: The OCID of the ExadataInfrastructure.

dbServerId String: The DB server OCID.
exadataInfrastructureId String: The OCID of the ExadataInfrastructure.

dbServerId string: The DB server OCID.
exadataInfrastructureId string: The OCID of the ExadataInfrastructure.

db_server_id str: The DB server OCID.
exadata_infrastructure_id str: The OCID of the ExadataInfrastructure.

dbServerId String: The DB server OCID.
exadataInfrastructureId String: The OCID of the ExadataInfrastructure.

getDbServer Result

The following output properties are available:

AutonomousVirtualMachineIds List<string>: The list of OCIDs of the Autonomous Virtual Machines associated with the Db server.
AutonomousVmClusterIds List<string>: The list of OCIDs of the Autonomous VM Clusters associated with the Db server.
CompartmentId string: The OCID of the compartment.
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.
DbServerId string
DbServerPatchingDetails List<GetDbServerDbServerPatchingDetail>: 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: The user-friendly name for the Db server. The name does not need to be unique.
ExadataInfrastructureId string: The OCID of the Exadata infrastructure.
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 provider-assigned unique ID for this managed resource.
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.
Shape string: The shape of the Db server. The shape determines the amount of CPU, storage, and memory resources available.
State string: The current state of the Db server.
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.

AutonomousVirtualMachineIds []string: The list of OCIDs of the Autonomous Virtual Machines associated with the Db server.
AutonomousVmClusterIds []string: The list of OCIDs of the Autonomous VM Clusters associated with the Db server.
CompartmentId string: The OCID of the compartment.
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.
DbServerId string
DbServerPatchingDetails []GetDbServerDbServerPatchingDetail: 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: The user-friendly name for the Db server. The name does not need to be unique.
ExadataInfrastructureId string: The OCID of the Exadata infrastructure.
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 provider-assigned unique ID for this managed resource.
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.
Shape string: The shape of the Db server. The shape determines the amount of CPU, storage, and memory resources available.
State string: The current state of the Db server.
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.

autonomousVirtualMachineIds List<String>: The list of OCIDs of the Autonomous Virtual Machines associated with the Db server.
autonomousVmClusterIds List<String>: The list of OCIDs of the Autonomous VM Clusters associated with the Db server.
compartmentId String: The OCID of the compartment.
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.
dbServerId String
dbServerPatchingDetails List<GetDbServerDbServerPatchingDetail>: 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: The user-friendly name for the Db server. The name does not need to be unique.
exadataInfrastructureId String: The OCID of the Exadata infrastructure.
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 provider-assigned unique ID for this managed resource.
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.
shape String: The shape of the Db server. The shape determines the amount of CPU, storage, and memory resources available.
state String: The current state of the Db server.
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.

autonomousVirtualMachineIds string[]: The list of OCIDs of the Autonomous Virtual Machines associated with the Db server.
autonomousVmClusterIds string[]: The list of OCIDs of the Autonomous VM Clusters associated with the Db server.
compartmentId string: The OCID of the compartment.
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.
dbServerId string
dbServerPatchingDetails GetDbServerDbServerPatchingDetail[]: 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: The user-friendly name for the Db server. The name does not need to be unique.
exadataInfrastructureId string: The OCID of the Exadata infrastructure.
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 provider-assigned unique ID for this managed resource.
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.
shape string: The shape of the Db server. The shape determines the amount of CPU, storage, and memory resources available.
state string: The current state of the Db server.
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.

autonomous_virtual_machine_ids Sequence[str]: The list of OCIDs of the Autonomous Virtual Machines associated with the Db server.
autonomous_vm_cluster_ids Sequence[str]: The list of OCIDs of the Autonomous VM Clusters associated with the Db server.
compartment_id str: The OCID of the compartment.
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_id str
db_server_patching_details GetDbServerDbServerPatchingDetail]: 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: The user-friendly name for the Db server. The name does not need to be unique.
exadata_infrastructure_id str: The OCID of the Exadata infrastructure.
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 provider-assigned unique ID for this managed resource.
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.
shape str: The shape of the Db server. The shape determines the amount of CPU, storage, and memory resources available.
state str: The current state of the Db server.
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.

autonomousVirtualMachineIds List<String>: The list of OCIDs of the Autonomous Virtual Machines associated with the Db server.
autonomousVmClusterIds List<String>: The list of OCIDs of the Autonomous VM Clusters associated with the Db server.
compartmentId String: The OCID of the compartment.
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.
dbServerId String
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: The user-friendly name for the Db server. The name does not need to be unique.
exadataInfrastructureId String: The OCID of the Exadata infrastructure.
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 provider-assigned unique ID for this managed resource.
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.
shape String: The shape of the Db server. The shape determines the amount of CPU, storage, and memory resources available.
state String: The current state of the Db server.
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.

Supporting Types

GetDbServerDbServerPatchingDetail

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.

Package Details

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