Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbServer
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-oci

oci.Database.getDbServer

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-oci

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

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

const testDbServer = oci.Database.getDbServer({
    dbServerId: testDbServerOciDatabaseDbServer.id,
    exadataInfrastructureId: testExadataInfrastructure.id,
});
Copy
import pulumi
import pulumi_oci as oci

test_db_server = oci.Database.get_db_server(db_server_id=test_db_server_oci_database_db_server["id"],
    exadata_infrastructure_id=test_exadata_infrastructure["id"])
Copy
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/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:              testDbServerOciDatabaseDbServer.Id,
			ExadataInfrastructureId: testExadataInfrastructure.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testDbServer = Oci.Database.GetDbServer.Invoke(new()
    {
        DbServerId = testDbServerOciDatabaseDbServer.Id,
        ExadataInfrastructureId = testExadataInfrastructure.Id,
    });

});
Copy
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(testDbServerOciDatabaseDbServer.id())
            .exadataInfrastructureId(testExadataInfrastructure.id())
            .build());

    }
}
Copy
variables:
  testDbServer:
    fn::invoke:
      function: oci:Database:getDbServer
      arguments:
        dbServerId: ${testDbServerOciDatabaseDbServer.id}
        exadataInfrastructureId: ${testExadataInfrastructure.id}
Copy

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>
Copy
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]
Copy
func GetDbServer(ctx *Context, args *GetDbServerArgs, opts ...InvokeOption) (*GetDbServerResult, error)
func GetDbServerOutput(ctx *Context, args *GetDbServerOutputArgs, opts ...InvokeOption) GetDbServerResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetDbServerResult> getDbServer(GetDbServerArgs args, InvokeOptions options)
public static Output<GetDbServerResult> getDbServer(GetDbServerArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:Database/getDbServer:getDbServer
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

DbServerId This property is required. string
The DB server OCID.
ExadataInfrastructureId This property is required. string
The OCID of the ExadataInfrastructure.
DbServerId This property is required. string
The DB server OCID.
ExadataInfrastructureId This property is required. string
The OCID of the ExadataInfrastructure.
dbServerId This property is required. String
The DB server OCID.
exadataInfrastructureId This property is required. String
The OCID of the ExadataInfrastructure.
dbServerId This property is required. string
The DB server OCID.
exadataInfrastructureId This property is required. string
The OCID of the ExadataInfrastructure.
db_server_id This property is required. str
The DB server OCID.
exadata_infrastructure_id This property is required. str
The OCID of the ExadataInfrastructure.
dbServerId This property is required. String
The DB server OCID.
exadataInfrastructureId This property is required. 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.
ComputeModel string
The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
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, string>
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, string>
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
Id 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.
ComputeModel string
The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
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]string
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]string
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
Id 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.
computeModel String
The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
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,String>
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,String>
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
id 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.
computeModel string
The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
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]: string}
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]: string}
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
id 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.
compute_model str
The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
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 Sequence[database.GetDbServerDbServerPatchingDetail]
The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
defined_tags Mapping[str, str]
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, str]
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
id 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.
computeModel String
The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
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<String>
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>
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 This property is required. int
Estimated time, in minutes, to patch one database server.
PatchingStatus This property is required. string
The status of the patching operation.
TimePatchingEnded This property is required. string
The time when the patching operation ended.
TimePatchingStarted This property is required. string
The time when the patching operation started.
EstimatedPatchDuration This property is required. int
Estimated time, in minutes, to patch one database server.
PatchingStatus This property is required. string
The status of the patching operation.
TimePatchingEnded This property is required. string
The time when the patching operation ended.
TimePatchingStarted This property is required. string
The time when the patching operation started.
estimatedPatchDuration This property is required. Integer
Estimated time, in minutes, to patch one database server.
patchingStatus This property is required. String
The status of the patching operation.
timePatchingEnded This property is required. String
The time when the patching operation ended.
timePatchingStarted This property is required. String
The time when the patching operation started.
estimatedPatchDuration This property is required. number
Estimated time, in minutes, to patch one database server.
patchingStatus This property is required. string
The status of the patching operation.
timePatchingEnded This property is required. string
The time when the patching operation ended.
timePatchingStarted This property is required. string
The time when the patching operation started.
estimated_patch_duration This property is required. int
Estimated time, in minutes, to patch one database server.
patching_status This property is required. str
The status of the patching operation.
time_patching_ended This property is required. str
The time when the patching operation ended.
time_patching_started This property is required. str
The time when the patching operation started.
estimatedPatchDuration This property is required. Number
Estimated time, in minutes, to patch one database server.
patchingStatus This property is required. String
The status of the patching operation.
timePatchingEnded This property is required. String
The time when the patching operation ended.
timePatchingStarted This property is required. 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.
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-oci