Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi IDP Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbSystemPatches
Oracle Cloud Infrastructure v3.0.0 published on Thursday, Jun 5, 2025 by Pulumi
pulumi/pulumi-oci

oci.Database.getDbSystemPatches

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v3.0.0 published on Thursday, Jun 5, 2025 by Pulumi
pulumi/pulumi-oci

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

    Lists the patches applicable to the specified DB system.

    Example Usage

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

const testDbSystemPatches = oci.Database.getDbSystemPatches({
    dbSystemId: testDbSystem.id,
});

    import pulumi
import pulumi_oci as oci

test_db_system_patches = oci.Database.get_db_system_patches(db_system_id=test_db_system["id"])

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := database.GetDbSystemPatches(ctx, &database.GetDbSystemPatchesArgs{
			DbSystemId: testDbSystem.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var testDbSystemPatches = Oci.Database.GetDbSystemPatches.Invoke(new()
    {
        DbSystemId = testDbSystem.Id,
    });

});

    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.GetDbSystemPatchesArgs;
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 testDbSystemPatches = DatabaseFunctions.getDbSystemPatches(GetDbSystemPatchesArgs.builder()
            .dbSystemId(testDbSystem.id())
            .build());

    }
}

    variables:
  testDbSystemPatches:
    fn::invoke:
      function: oci:Database:getDbSystemPatches
      arguments:
        dbSystemId: ${testDbSystem.id}

    Using getDbSystemPatches

    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 getDbSystemPatches(args: GetDbSystemPatchesArgs, opts?: InvokeOptions): Promise<GetDbSystemPatchesResult>
function getDbSystemPatchesOutput(args: GetDbSystemPatchesOutputArgs, opts?: InvokeOptions): Output<GetDbSystemPatchesResult>
    def get_db_system_patches(db_system_id: Optional[str] = None,
                          filters: Optional[Sequence[GetDbSystemPatchesFilter]] = None,
                          opts: Optional[InvokeOptions] = None) -> GetDbSystemPatchesResult
def get_db_system_patches_output(db_system_id: Optional[pulumi.Input[str]] = None,
                          filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetDbSystemPatchesFilterArgs]]]] = None,
                          opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemPatchesResult]
    func GetDbSystemPatches(ctx *Context, args *GetDbSystemPatchesArgs, opts ...InvokeOption) (*GetDbSystemPatchesResult, error)
func GetDbSystemPatchesOutput(ctx *Context, args *GetDbSystemPatchesOutputArgs, opts ...InvokeOption) GetDbSystemPatchesResultOutput

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

    public static class GetDbSystemPatches 
{
    public static Task<GetDbSystemPatchesResult> InvokeAsync(GetDbSystemPatchesArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemPatchesResult> Invoke(GetDbSystemPatchesInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDbSystemPatchesResult> getDbSystemPatches(GetDbSystemPatchesArgs args, InvokeOptions options)
public static Output<GetDbSystemPatchesResult> getDbSystemPatches(GetDbSystemPatchesArgs args, InvokeOptions options)

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

    The following arguments are supported:

    getDbSystemPatches Result

    The following output properties are available:

    DbSystemId string
    Id string
    The provider-assigned unique ID for this managed resource.
    Patches List<GetDbSystemPatchesPatch>
    The list of patches.
    Filters List<GetDbSystemPatchesFilter>
    DbSystemId string
    Id string
    The provider-assigned unique ID for this managed resource.
    Patches []GetDbSystemPatchesPatch
    The list of patches.
    Filters []GetDbSystemPatchesFilter
    dbSystemId String
    id String
    The provider-assigned unique ID for this managed resource.
    patches List<GetDbSystemPatchesPatch>
    The list of patches.
    filters List<GetDbSystemPatchesFilter>
    dbSystemId string
    id string
    The provider-assigned unique ID for this managed resource.
    patches GetDbSystemPatchesPatch[]
    The list of patches.
    filters GetDbSystemPatchesFilter[]
    db_system_id str
    id str
    The provider-assigned unique ID for this managed resource.
    patches Sequence[GetDbSystemPatchesPatch]
    The list of patches.
    filters Sequence[GetDbSystemPatchesFilter]
    dbSystemId String
    id String
    The provider-assigned unique ID for this managed resource.
    patches List<Property Map>
    The list of patches.
    filters List<Property Map>

    Supporting Types

    GetDbSystemPatchesFilter

    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

    GetDbSystemPatchesPatch

    AvailableActions List<string>
    Actions that can possibly be performed using this patch.
    Description string
    The text describing this patch package.
    Id string
    The OCID of the patch.
    LastAction string
    Action that is currently being performed or was completed last.
    LifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
    State string
    The current state of the patch as a result of lastAction.
    TimeReleased string
    The date and time that the patch was released.
    Version string
    The version of this patch package.
    AvailableActions []string
    Actions that can possibly be performed using this patch.
    Description string
    The text describing this patch package.
    Id string
    The OCID of the patch.
    LastAction string
    Action that is currently being performed or was completed last.
    LifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
    State string
    The current state of the patch as a result of lastAction.
    TimeReleased string
    The date and time that the patch was released.
    Version string
    The version of this patch package.
    availableActions List<String>
    Actions that can possibly be performed using this patch.
    description String
    The text describing this patch package.
    id String
    The OCID of the patch.
    lastAction String
    Action that is currently being performed or was completed last.
    lifecycleDetails String
    A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
    state String
    The current state of the patch as a result of lastAction.
    timeReleased String
    The date and time that the patch was released.
    version String
    The version of this patch package.
    availableActions string[]
    Actions that can possibly be performed using this patch.
    description string
    The text describing this patch package.
    id string
    The OCID of the patch.
    lastAction string
    Action that is currently being performed or was completed last.
    lifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
    state string
    The current state of the patch as a result of lastAction.
    timeReleased string
    The date and time that the patch was released.
    version string
    The version of this patch package.
    available_actions Sequence[str]
    Actions that can possibly be performed using this patch.
    description str
    The text describing this patch package.
    id str
    The OCID of the patch.
    last_action str
    Action that is currently being performed or was completed last.
    lifecycle_details str
    A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
    state str
    The current state of the patch as a result of lastAction.
    time_released str
    The date and time that the patch was released.
    version str
    The version of this patch package.
    availableActions List<String>
    Actions that can possibly be performed using this patch.
    description String
    The text describing this patch package.
    id String
    The OCID of the patch.
    lastAction String
    Action that is currently being performed or was completed last.
    lifecycleDetails String
    A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
    state String
    The current state of the patch as a result of lastAction.
    timeReleased String
    The date and time that the patch was released.
    version String
    The version of this patch package.

    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 v3.0.0 published on Thursday, Jun 5, 2025 by Pulumi
    pulumi/pulumi-oci