1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getExternalDbNodes
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

oci.DatabaseManagement.getExternalDbNodes

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

This data source provides the list of External Db Nodes in Oracle Cloud Infrastructure Database Management service.

Lists the external DB nodes in the specified external DB system.

Example Usage

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

const testExternalDbNodes = oci.DatabaseManagement.getExternalDbNodes({
    compartmentId: compartmentId,
    displayName: externalDbNodeDisplayName,
    externalDbSystemId: testExternalDbSystem.id,
});
Copy
import pulumi
import pulumi_oci as oci

test_external_db_nodes = oci.DatabaseManagement.get_external_db_nodes(compartment_id=compartment_id,
    display_name=external_db_node_display_name,
    external_db_system_id=test_external_db_system["id"])
Copy
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasemanagement.GetExternalDbNodes(ctx, &databasemanagement.GetExternalDbNodesArgs{
			CompartmentId:      pulumi.StringRef(compartmentId),
			DisplayName:        pulumi.StringRef(externalDbNodeDisplayName),
			ExternalDbSystemId: pulumi.StringRef(testExternalDbSystem.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 testExternalDbNodes = Oci.DatabaseManagement.GetExternalDbNodes.Invoke(new()
    {
        CompartmentId = compartmentId,
        DisplayName = externalDbNodeDisplayName,
        ExternalDbSystemId = testExternalDbSystem.Id,
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetExternalDbNodesArgs;
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 testExternalDbNodes = DatabaseManagementFunctions.getExternalDbNodes(GetExternalDbNodesArgs.builder()
            .compartmentId(compartmentId)
            .displayName(externalDbNodeDisplayName)
            .externalDbSystemId(testExternalDbSystem.id())
            .build());

    }
}
Copy
variables:
  testExternalDbNodes:
    fn::invoke:
      function: oci:DatabaseManagement:getExternalDbNodes
      arguments:
        compartmentId: ${compartmentId}
        displayName: ${externalDbNodeDisplayName}
        externalDbSystemId: ${testExternalDbSystem.id}
Copy

Using getExternalDbNodes

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 getExternalDbNodes(args: GetExternalDbNodesArgs, opts?: InvokeOptions): Promise<GetExternalDbNodesResult>
function getExternalDbNodesOutput(args: GetExternalDbNodesOutputArgs, opts?: InvokeOptions): Output<GetExternalDbNodesResult>
Copy
def get_external_db_nodes(compartment_id: Optional[str] = None,
                          display_name: Optional[str] = None,
                          external_db_system_id: Optional[str] = None,
                          filters: Optional[Sequence[_databasemanagement.GetExternalDbNodesFilter]] = None,
                          opts: Optional[InvokeOptions] = None) -> GetExternalDbNodesResult
def get_external_db_nodes_output(compartment_id: Optional[pulumi.Input[str]] = None,
                          display_name: Optional[pulumi.Input[str]] = None,
                          external_db_system_id: Optional[pulumi.Input[str]] = None,
                          filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetExternalDbNodesFilterArgs]]]] = None,
                          opts: Optional[InvokeOptions] = None) -> Output[GetExternalDbNodesResult]
Copy
func GetExternalDbNodes(ctx *Context, args *GetExternalDbNodesArgs, opts ...InvokeOption) (*GetExternalDbNodesResult, error)
func GetExternalDbNodesOutput(ctx *Context, args *GetExternalDbNodesOutputArgs, opts ...InvokeOption) GetExternalDbNodesResultOutput
Copy

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

public static class GetExternalDbNodes 
{
    public static Task<GetExternalDbNodesResult> InvokeAsync(GetExternalDbNodesArgs args, InvokeOptions? opts = null)
    public static Output<GetExternalDbNodesResult> Invoke(GetExternalDbNodesInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetExternalDbNodesResult> getExternalDbNodes(GetExternalDbNodesArgs args, InvokeOptions options)
public static Output<GetExternalDbNodesResult> getExternalDbNodes(GetExternalDbNodesArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getExternalDbNodes:getExternalDbNodes
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

CompartmentId string
The OCID of the compartment.
DisplayName string
A filter to only return the resources that match the entire display name.
ExternalDbSystemId string
The OCID of the external DB system.
Filters Changes to this property will trigger replacement. List<GetExternalDbNodesFilter>
CompartmentId string
The OCID of the compartment.
DisplayName string
A filter to only return the resources that match the entire display name.
ExternalDbSystemId string
The OCID of the external DB system.
Filters Changes to this property will trigger replacement. []GetExternalDbNodesFilter
compartmentId String
The OCID of the compartment.
displayName String
A filter to only return the resources that match the entire display name.
externalDbSystemId String
The OCID of the external DB system.
filters Changes to this property will trigger replacement. List<GetExternalDbNodesFilter>
compartmentId string
The OCID of the compartment.
displayName string
A filter to only return the resources that match the entire display name.
externalDbSystemId string
The OCID of the external DB system.
filters Changes to this property will trigger replacement. GetExternalDbNodesFilter[]
compartment_id str
The OCID of the compartment.
display_name str
A filter to only return the resources that match the entire display name.
external_db_system_id str
The OCID of the external DB system.
filters Changes to this property will trigger replacement. Sequence[databasemanagement.GetExternalDbNodesFilter]
compartmentId String
The OCID of the compartment.
displayName String
A filter to only return the resources that match the entire display name.
externalDbSystemId String
The OCID of the external DB system.
filters Changes to this property will trigger replacement. List<Property Map>

getExternalDbNodes Result

The following output properties are available:

ExternalDbNodeCollections List<GetExternalDbNodesExternalDbNodeCollection>
The list of external_db_node_collection.
Id string
The provider-assigned unique ID for this managed resource.
CompartmentId string
The OCID of the compartment.
DisplayName string
The user-friendly name for the external DB node. The name does not have to be unique.
ExternalDbSystemId string
The OCID of the external DB system that the DB node is a part of.
Filters List<GetExternalDbNodesFilter>
ExternalDbNodeCollections []GetExternalDbNodesExternalDbNodeCollection
The list of external_db_node_collection.
Id string
The provider-assigned unique ID for this managed resource.
CompartmentId string
The OCID of the compartment.
DisplayName string
The user-friendly name for the external DB node. The name does not have to be unique.
ExternalDbSystemId string
The OCID of the external DB system that the DB node is a part of.
Filters []GetExternalDbNodesFilter
externalDbNodeCollections List<GetExternalDbNodesExternalDbNodeCollection>
The list of external_db_node_collection.
id String
The provider-assigned unique ID for this managed resource.
compartmentId String
The OCID of the compartment.
displayName String
The user-friendly name for the external DB node. The name does not have to be unique.
externalDbSystemId String
The OCID of the external DB system that the DB node is a part of.
filters List<GetExternalDbNodesFilter>
externalDbNodeCollections GetExternalDbNodesExternalDbNodeCollection[]
The list of external_db_node_collection.
id string
The provider-assigned unique ID for this managed resource.
compartmentId string
The OCID of the compartment.
displayName string
The user-friendly name for the external DB node. The name does not have to be unique.
externalDbSystemId string
The OCID of the external DB system that the DB node is a part of.
filters GetExternalDbNodesFilter[]
external_db_node_collections Sequence[databasemanagement.GetExternalDbNodesExternalDbNodeCollection]
The list of external_db_node_collection.
id str
The provider-assigned unique ID for this managed resource.
compartment_id str
The OCID of the compartment.
display_name str
The user-friendly name for the external DB node. The name does not have to be unique.
external_db_system_id str
The OCID of the external DB system that the DB node is a part of.
filters Sequence[databasemanagement.GetExternalDbNodesFilter]
externalDbNodeCollections List<Property Map>
The list of external_db_node_collection.
id String
The provider-assigned unique ID for this managed resource.
compartmentId String
The OCID of the compartment.
displayName String
The user-friendly name for the external DB node. The name does not have to be unique.
externalDbSystemId String
The OCID of the external DB system that the DB node is a part of.
filters List<Property Map>

Supporting Types

GetExternalDbNodesExternalDbNodeCollection

items This property is required. List<Property Map>

GetExternalDbNodesExternalDbNodeCollectionItem

AdditionalDetails This property is required. Dictionary<string, string>
The additional details of the external DB node defined in {"key": "value"} format. Example: {"bar-key": "value"}
CompartmentId This property is required. string
The OCID of the compartment.
ComponentName This property is required. string
The name of the external DB node.
CpuCoreCount This property is required. double
The number of CPU cores available on the DB node.
DefinedTags This property is required. Dictionary<string, string>
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
DisplayName This property is required. string
A filter to only return the resources that match the entire display name.
DomainName This property is required. string
Name of the domain.
ExternalConnectorId This property is required. string
The OCID of the external connector.
ExternalDbNodeId This property is required. string
ExternalDbSystemId This property is required. string
The OCID of the external DB system.
FreeformTags This property is required. 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"}
HostName This property is required. string
The host name for the DB node.
Id This property is required. string
The OCID of the external DB node.
LifecycleDetails This property is required. string
Additional information about the current lifecycle state.
MemorySizeInGbs This property is required. double
The total memory in gigabytes (GB) on the DB node.
State This property is required. string
The current lifecycle state of the external DB node.
SystemTags This property is required. Dictionary<string, string>
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated This property is required. string
The date and time the external DB node was created.
TimeUpdated This property is required. string
The date and time the external DB node was last updated.
AdditionalDetails This property is required. map[string]string
The additional details of the external DB node defined in {"key": "value"} format. Example: {"bar-key": "value"}
CompartmentId This property is required. string
The OCID of the compartment.
ComponentName This property is required. string
The name of the external DB node.
CpuCoreCount This property is required. float64
The number of CPU cores available on the DB node.
DefinedTags This property is required. map[string]string
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
DisplayName This property is required. string
A filter to only return the resources that match the entire display name.
DomainName This property is required. string
Name of the domain.
ExternalConnectorId This property is required. string
The OCID of the external connector.
ExternalDbNodeId This property is required. string
ExternalDbSystemId This property is required. string
The OCID of the external DB system.
FreeformTags This property is required. 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"}
HostName This property is required. string
The host name for the DB node.
Id This property is required. string
The OCID of the external DB node.
LifecycleDetails This property is required. string
Additional information about the current lifecycle state.
MemorySizeInGbs This property is required. float64
The total memory in gigabytes (GB) on the DB node.
State This property is required. string
The current lifecycle state of the external DB node.
SystemTags This property is required. map[string]string
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated This property is required. string
The date and time the external DB node was created.
TimeUpdated This property is required. string
The date and time the external DB node was last updated.
additionalDetails This property is required. Map<String,String>
The additional details of the external DB node defined in {"key": "value"} format. Example: {"bar-key": "value"}
compartmentId This property is required. String
The OCID of the compartment.
componentName This property is required. String
The name of the external DB node.
cpuCoreCount This property is required. Double
The number of CPU cores available on the DB node.
definedTags This property is required. Map<String,String>
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
displayName This property is required. String
A filter to only return the resources that match the entire display name.
domainName This property is required. String
Name of the domain.
externalConnectorId This property is required. String
The OCID of the external connector.
externalDbNodeId This property is required. String
externalDbSystemId This property is required. String
The OCID of the external DB system.
freeformTags This property is required. 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"}
hostName This property is required. String
The host name for the DB node.
id This property is required. String
The OCID of the external DB node.
lifecycleDetails This property is required. String
Additional information about the current lifecycle state.
memorySizeInGbs This property is required. Double
The total memory in gigabytes (GB) on the DB node.
state This property is required. String
The current lifecycle state of the external DB node.
systemTags This property is required. Map<String,String>
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated This property is required. String
The date and time the external DB node was created.
timeUpdated This property is required. String
The date and time the external DB node was last updated.
additionalDetails This property is required. {[key: string]: string}
The additional details of the external DB node defined in {"key": "value"} format. Example: {"bar-key": "value"}
compartmentId This property is required. string
The OCID of the compartment.
componentName This property is required. string
The name of the external DB node.
cpuCoreCount This property is required. number
The number of CPU cores available on the DB node.
definedTags This property is required. {[key: string]: string}
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
displayName This property is required. string
A filter to only return the resources that match the entire display name.
domainName This property is required. string
Name of the domain.
externalConnectorId This property is required. string
The OCID of the external connector.
externalDbNodeId This property is required. string
externalDbSystemId This property is required. string
The OCID of the external DB system.
freeformTags This property is required. {[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"}
hostName This property is required. string
The host name for the DB node.
id This property is required. string
The OCID of the external DB node.
lifecycleDetails This property is required. string
Additional information about the current lifecycle state.
memorySizeInGbs This property is required. number
The total memory in gigabytes (GB) on the DB node.
state This property is required. string
The current lifecycle state of the external DB node.
systemTags This property is required. {[key: string]: string}
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated This property is required. string
The date and time the external DB node was created.
timeUpdated This property is required. string
The date and time the external DB node was last updated.
additional_details This property is required. Mapping[str, str]
The additional details of the external DB node defined in {"key": "value"} format. Example: {"bar-key": "value"}
compartment_id This property is required. str
The OCID of the compartment.
component_name This property is required. str
The name of the external DB node.
cpu_core_count This property is required. float
The number of CPU cores available on the DB node.
defined_tags This property is required. Mapping[str, str]
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
display_name This property is required. str
A filter to only return the resources that match the entire display name.
domain_name This property is required. str
Name of the domain.
external_connector_id This property is required. str
The OCID of the external connector.
external_db_node_id This property is required. str
external_db_system_id This property is required. str
The OCID of the external DB system.
freeform_tags This property is required. 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"}
host_name This property is required. str
The host name for the DB node.
id This property is required. str
The OCID of the external DB node.
lifecycle_details This property is required. str
Additional information about the current lifecycle state.
memory_size_in_gbs This property is required. float
The total memory in gigabytes (GB) on the DB node.
state This property is required. str
The current lifecycle state of the external DB node.
system_tags This property is required. Mapping[str, str]
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
time_created This property is required. str
The date and time the external DB node was created.
time_updated This property is required. str
The date and time the external DB node was last updated.
additionalDetails This property is required. Map<String>
The additional details of the external DB node defined in {"key": "value"} format. Example: {"bar-key": "value"}
compartmentId This property is required. String
The OCID of the compartment.
componentName This property is required. String
The name of the external DB node.
cpuCoreCount This property is required. Number
The number of CPU cores available on the DB node.
definedTags This property is required. Map<String>
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
displayName This property is required. String
A filter to only return the resources that match the entire display name.
domainName This property is required. String
Name of the domain.
externalConnectorId This property is required. String
The OCID of the external connector.
externalDbNodeId This property is required. String
externalDbSystemId This property is required. String
The OCID of the external DB system.
freeformTags This property is required. 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"}
hostName This property is required. String
The host name for the DB node.
id This property is required. String
The OCID of the external DB node.
lifecycleDetails This property is required. String
Additional information about the current lifecycle state.
memorySizeInGbs This property is required. Number
The total memory in gigabytes (GB) on the DB node.
state This property is required. String
The current lifecycle state of the external DB node.
systemTags This property is required. Map<String>
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated This property is required. String
The date and time the external DB node was created.
timeUpdated This property is required. String
The date and time the external DB node was last updated.

GetExternalDbNodesFilter

Name This property is required. string
Values This property is required. List<string>
Regex bool
Name This property is required. string
Values This property is required. []string
Regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean
name This property is required. string
values This property is required. string[]
regex boolean
name This property is required. str
values This property is required. Sequence[str]
regex bool
name This property is required. String
values This property is required. 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.
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi