1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbServer
Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

oci.Database.getDbServer

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

    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=oci_database_db_server["test_db_server"]["id"],
        exadata_infrastructure_id=oci_database_exadata_infrastructure["test_exadata_infrastructure"]["id"])
    
    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.

    oci logo
    Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi