Oracle Cloud Infrastructure v3.9.0, Sep 24 25

Oracle Cloud Infrastructure v3.9.0 published on Wednesday, Sep 24, 2025 by Pulumi

oci.Database.getOneoffPatches

Oracle Cloud Infrastructure v3.9.0 published on Wednesday, Sep 24, 2025 by Pulumi

Example Usage

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

const testOneoffPatches = oci.Database.getOneoffPatches({
    compartmentId: compartmentId,
    displayName: oneoffPatchDisplayName,
    state: oneoffPatchState,
});

import pulumi
import pulumi_oci as oci

test_oneoff_patches = oci.Database.get_oneoff_patches(compartment_id=compartment_id,
    display_name=oneoff_patch_display_name,
    state=oneoff_patch_state)

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.GetOneoffPatches(ctx, &database.GetOneoffPatchesArgs{
			CompartmentId: compartmentId,
			DisplayName:   pulumi.StringRef(oneoffPatchDisplayName),
			State:         pulumi.StringRef(oneoffPatchState),
		}, 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 testOneoffPatches = Oci.Database.GetOneoffPatches.Invoke(new()
    {
        CompartmentId = compartmentId,
        DisplayName = oneoffPatchDisplayName,
        State = oneoffPatchState,
    });

});

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.GetOneoffPatchesArgs;
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 testOneoffPatches = DatabaseFunctions.getOneoffPatches(GetOneoffPatchesArgs.builder()
            .compartmentId(compartmentId)
            .displayName(oneoffPatchDisplayName)
            .state(oneoffPatchState)
            .build());

    }
}

variables:
  testOneoffPatches:
    fn::invoke:
      function: oci:Database:getOneoffPatches
      arguments:
        compartmentId: ${compartmentId}
        displayName: ${oneoffPatchDisplayName}
        state: ${oneoffPatchState}

Using getOneoffPatches

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 getOneoffPatches(args: GetOneoffPatchesArgs, opts?: InvokeOptions): Promise<GetOneoffPatchesResult>
function getOneoffPatchesOutput(args: GetOneoffPatchesOutputArgs, opts?: InvokeOptions): Output<GetOneoffPatchesResult>

def get_oneoff_patches(compartment_id: Optional[str] = None,
                       display_name: Optional[str] = None,
                       filters: Optional[Sequence[GetOneoffPatchesFilter]] = None,
                       state: Optional[str] = None,
                       opts: Optional[InvokeOptions] = None) -> GetOneoffPatchesResult
def get_oneoff_patches_output(compartment_id: Optional[pulumi.Input[str]] = None,
                       display_name: Optional[pulumi.Input[str]] = None,
                       filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetOneoffPatchesFilterArgs]]]] = None,
                       state: Optional[pulumi.Input[str]] = None,
                       opts: Optional[InvokeOptions] = None) -> Output[GetOneoffPatchesResult]

func GetOneoffPatches(ctx *Context, args *GetOneoffPatchesArgs, opts ...InvokeOption) (*GetOneoffPatchesResult, error)
func GetOneoffPatchesOutput(ctx *Context, args *GetOneoffPatchesOutputArgs, opts ...InvokeOption) GetOneoffPatchesResultOutput

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

public static class GetOneoffPatches 
{
    public static Task<GetOneoffPatchesResult> InvokeAsync(GetOneoffPatchesArgs args, InvokeOptions? opts = null)
    public static Output<GetOneoffPatchesResult> Invoke(GetOneoffPatchesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetOneoffPatchesResult> getOneoffPatches(GetOneoffPatchesArgs args, InvokeOptions options)
public static Output<GetOneoffPatchesResult> getOneoffPatches(GetOneoffPatchesArgs args, InvokeOptions options)

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

The following arguments are supported:

CompartmentId string: (Updatable) The compartment OCID.
DisplayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
Filters List<GetOneoffPatchesFilter>
State string: A filter to return only resources that match the given lifecycle state exactly

CompartmentId string: (Updatable) The compartment OCID.
DisplayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
Filters []GetOneoffPatchesFilter
State string: A filter to return only resources that match the given lifecycle state exactly

compartmentId String: (Updatable) The compartment OCID.
displayName String: A filter to return only resources that match the entire display name given. The match is not case sensitive.
filters List<GetOneoffPatchesFilter>
state String: A filter to return only resources that match the given lifecycle state exactly

compartmentId string: (Updatable) The compartment OCID.
displayName string: A filter to return only resources that match the entire display name given. The match is not case sensitive.
filters GetOneoffPatchesFilter[]
state string: A filter to return only resources that match the given lifecycle state exactly

compartment_id str: (Updatable) The compartment OCID.
display_name str: A filter to return only resources that match the entire display name given. The match is not case sensitive.
filters Sequence[GetOneoffPatchesFilter]
state str: A filter to return only resources that match the given lifecycle state exactly

compartmentId String: (Updatable) The compartment OCID.
displayName String: A filter to return only resources that match the entire display name given. The match is not case sensitive.
filters List<Property Map>
state String: A filter to return only resources that match the given lifecycle state exactly

getOneoffPatches Result

The following output properties are available:

CompartmentId string: The OCID of the compartment.
Id string: The provider-assigned unique ID for this managed resource.
OneoffPatches List<GetOneoffPatchesOneoffPatch>: The list of oneoff_patches.
DisplayName string: One-off patch name.
Filters List<GetOneoffPatchesFilter>
State string: The current state of the one-off patch.

CompartmentId string: The OCID of the compartment.
Id string: The provider-assigned unique ID for this managed resource.
OneoffPatches []GetOneoffPatchesOneoffPatch: The list of oneoff_patches.
DisplayName string: One-off patch name.
Filters []GetOneoffPatchesFilter
State string: The current state of the one-off patch.

compartmentId String: The OCID of the compartment.
id String: The provider-assigned unique ID for this managed resource.
oneoffPatches List<GetOneoffPatchesOneoffPatch>: The list of oneoff_patches.
displayName String: One-off patch name.
filters List<GetOneoffPatchesFilter>
state String: The current state of the one-off patch.

compartmentId string: The OCID of the compartment.
id string: The provider-assigned unique ID for this managed resource.
oneoffPatches GetOneoffPatchesOneoffPatch[]: The list of oneoff_patches.
displayName string: One-off patch name.
filters GetOneoffPatchesFilter[]
state string: The current state of the one-off patch.

compartment_id str: The OCID of the compartment.
id str: The provider-assigned unique ID for this managed resource.
oneoff_patches Sequence[GetOneoffPatchesOneoffPatch]: The list of oneoff_patches.
display_name str: One-off patch name.
filters Sequence[GetOneoffPatchesFilter]
state str: The current state of the one-off patch.

compartmentId String: The OCID of the compartment.
id String: The provider-assigned unique ID for this managed resource.
oneoffPatches List<Property Map>: The list of oneoff_patches.
displayName String: One-off patch name.
filters List<Property Map>
state String: The current state of the one-off patch.

Supporting Types

GetOneoffPatchesFilter

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

GetOneoffPatchesOneoffPatch

CompartmentId string: (Updatable) The compartment OCID.
DbVersion string: A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
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: A filter to return only resources that match the entire display name given. The match is not case sensitive.
DownloadOneoffPatchTrigger int
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 OCID of the one-off patch.
LifecycleDetails string: Detailed message for the lifecycle state.
OneOffPatches List<string>: List of one-off patches for Database Homes.
ReleaseUpdate string: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
Sha256sum string: SHA-256 checksum of the one-off patch.
SizeInKbs double: The size of one-off patch in kilobytes.
State string: A filter to return only resources that match the given lifecycle state exactly
SystemTags Dictionary<string, string>: System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
TimeCreated string: The date and time one-off patch was created.
TimeOfExpiration string: The date and time until which the one-off patch will be available for download.
TimeUpdated string: The date and time one-off patch was updated.

CompartmentId string: (Updatable) The compartment OCID.
DbVersion string: A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
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: A filter to return only resources that match the entire display name given. The match is not case sensitive.
DownloadOneoffPatchTrigger int
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 OCID of the one-off patch.
LifecycleDetails string: Detailed message for the lifecycle state.
OneOffPatches []string: List of one-off patches for Database Homes.
ReleaseUpdate string: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
Sha256sum string: SHA-256 checksum of the one-off patch.
SizeInKbs float64: The size of one-off patch in kilobytes.
State string: A filter to return only resources that match the given lifecycle state exactly
SystemTags map[string]string: System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
TimeCreated string: The date and time one-off patch was created.
TimeOfExpiration string: The date and time until which the one-off patch will be available for download.
TimeUpdated string: The date and time one-off patch was updated.

compartmentId String: (Updatable) The compartment OCID.
dbVersion String: A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
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: A filter to return only resources that match the entire display name given. The match is not case sensitive.
downloadOneoffPatchTrigger Integer
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 OCID of the one-off patch.
lifecycleDetails String: Detailed message for the lifecycle state.
oneOffPatches List<String>: List of one-off patches for Database Homes.
releaseUpdate String: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
sha256sum String: SHA-256 checksum of the one-off patch.
sizeInKbs Double: The size of one-off patch in kilobytes.
state String: A filter to return only resources that match the given lifecycle state exactly
systemTags Map<String,String>: System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
timeCreated String: The date and time one-off patch was created.
timeOfExpiration String: The date and time until which the one-off patch will be available for download.
timeUpdated String: The date and time one-off patch was updated.

compartmentId string: (Updatable) The compartment OCID.
dbVersion string: A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
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: A filter to return only resources that match the entire display name given. The match is not case sensitive.
downloadOneoffPatchTrigger number
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 OCID of the one-off patch.
lifecycleDetails string: Detailed message for the lifecycle state.
oneOffPatches string[]: List of one-off patches for Database Homes.
releaseUpdate string: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
sha256sum string: SHA-256 checksum of the one-off patch.
sizeInKbs number: The size of one-off patch in kilobytes.
state string: A filter to return only resources that match the given lifecycle state exactly
systemTags {[key: string]: string}: System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
timeCreated string: The date and time one-off patch was created.
timeOfExpiration string: The date and time until which the one-off patch will be available for download.
timeUpdated string: The date and time one-off patch was updated.

compartment_id str: (Updatable) The compartment OCID.
db_version str: A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
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: A filter to return only resources that match the entire display name given. The match is not case sensitive.
download_oneoff_patch_trigger int
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 OCID of the one-off patch.
lifecycle_details str: Detailed message for the lifecycle state.
one_off_patches Sequence[str]: List of one-off patches for Database Homes.
release_update str: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
sha256sum str: SHA-256 checksum of the one-off patch.
size_in_kbs float: The size of one-off patch in kilobytes.
state str: A filter to return only resources that match the given lifecycle state exactly
system_tags Mapping[str, str]: System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
time_created str: The date and time one-off patch was created.
time_of_expiration str: The date and time until which the one-off patch will be available for download.
time_updated str: The date and time one-off patch was updated.

compartmentId String: (Updatable) The compartment OCID.
dbVersion String: A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
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: A filter to return only resources that match the entire display name given. The match is not case sensitive.
downloadOneoffPatchTrigger Number
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 OCID of the one-off patch.
lifecycleDetails String: Detailed message for the lifecycle state.
oneOffPatches List<String>: List of one-off patches for Database Homes.
releaseUpdate String: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
sha256sum String: SHA-256 checksum of the one-off patch.
sizeInKbs Number: The size of one-off patch in kilobytes.
state String: A filter to return only resources that match the given lifecycle state exactly
systemTags Map<String>: System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
timeCreated String: The date and time one-off patch was created.
timeOfExpiration String: The date and time until which the one-off patch will be available for download.
timeUpdated String: The date and time one-off patch was updated.

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 v3.9.0 published on Wednesday, Sep 24, 2025 by Pulumi

pulumi/pulumi-oci

oci.Database.getOneoffPatches

On this page

On this page

Example Usage

Using getOneoffPatches

getOneoffPatches Result

Supporting Types

GetOneoffPatchesFilter

GetOneoffPatchesOneoffPatch

Package Details

On this page

On this page