1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getOneoffPatch
Oracle Cloud Infrastructure v3.10.0 published on Wednesday, Nov 5, 2025 by Pulumi
pulumi/pulumi-oci

oci.Database.getOneoffPatch

Start a Neo task
Explain and create an oci.Database.getOneoffPatch resource
oci logo
Oracle Cloud Infrastructure v3.10.0 published on Wednesday, Nov 5, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides details about a specific Oneoff Patch resource in Oracle Cloud Infrastructure Database service.

    Gets information about the specified one-off patch.

    Example Usage

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

const testOneoffPatch = oci.Database.getOneoffPatch({
    oneoffPatchId: testOneoffPatchOciDatabaseOneoffPatch.id,
});

    import pulumi
import pulumi_oci as oci

test_oneoff_patch = oci.Database.get_oneoff_patch(oneoff_patch_id=test_oneoff_patch_oci_database_oneoff_patch["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.GetOneoffPatch(ctx, &database.GetOneoffPatchArgs{
			OneoffPatchId: testOneoffPatchOciDatabaseOneoffPatch.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 testOneoffPatch = Oci.Database.GetOneoffPatch.Invoke(new()
    {
        OneoffPatchId = testOneoffPatchOciDatabaseOneoffPatch.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.GetOneoffPatchArgs;
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 testOneoffPatch = DatabaseFunctions.getOneoffPatch(GetOneoffPatchArgs.builder()
            .oneoffPatchId(testOneoffPatchOciDatabaseOneoffPatch.id())
            .build());

    }
}

    variables:
  testOneoffPatch:
    fn::invoke:
      function: oci:Database:getOneoffPatch
      arguments:
        oneoffPatchId: ${testOneoffPatchOciDatabaseOneoffPatch.id}

    Using getOneoffPatch

    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 getOneoffPatch(args: GetOneoffPatchArgs, opts?: InvokeOptions): Promise<GetOneoffPatchResult>
function getOneoffPatchOutput(args: GetOneoffPatchOutputArgs, opts?: InvokeOptions): Output<GetOneoffPatchResult>
    def get_oneoff_patch(oneoff_patch_id: Optional[str] = None,
                     opts: Optional[InvokeOptions] = None) -> GetOneoffPatchResult
def get_oneoff_patch_output(oneoff_patch_id: Optional[pulumi.Input[str]] = None,
                     opts: Optional[InvokeOptions] = None) -> Output[GetOneoffPatchResult]
    func LookupOneoffPatch(ctx *Context, args *LookupOneoffPatchArgs, opts ...InvokeOption) (*LookupOneoffPatchResult, error)
func LookupOneoffPatchOutput(ctx *Context, args *LookupOneoffPatchOutputArgs, opts ...InvokeOption) LookupOneoffPatchResultOutput

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

    public static class GetOneoffPatch 
{
    public static Task<GetOneoffPatchResult> InvokeAsync(GetOneoffPatchArgs args, InvokeOptions? opts = null)
    public static Output<GetOneoffPatchResult> Invoke(GetOneoffPatchInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetOneoffPatchResult> getOneoffPatch(GetOneoffPatchArgs args, InvokeOptions options)
public static Output<GetOneoffPatchResult> getOneoffPatch(GetOneoffPatchArgs args, InvokeOptions options)

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

    The following arguments are supported:

    OneoffPatchId string
    The one-off patch OCID.
    OneoffPatchId string
    The one-off patch OCID.
    oneoffPatchId String
    The one-off patch OCID.
    oneoffPatchId string
    The one-off patch OCID.
    oneoff_patch_id str
    The one-off patch OCID.
    oneoffPatchId String
    The one-off patch OCID.

    getOneoffPatch Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment.
    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
    One-off patch name.
    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.
    OneoffPatchId string
    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
    The current state of the one-off patch.
    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
    The OCID of the compartment.
    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
    One-off patch name.
    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.
    OneoffPatchId string
    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
    The current state of the one-off patch.
    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
    The OCID of the compartment.
    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
    One-off patch name.
    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.
    oneoffPatchId String
    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
    The current state of the one-off patch.
    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
    The OCID of the compartment.
    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
    One-off patch name.
    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.
    oneoffPatchId string
    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
    The current state of the one-off patch.
    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
    The OCID of the compartment.
    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
    One-off patch name.
    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.
    oneoff_patch_id str
    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
    The current state of the one-off patch.
    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
    The OCID of the compartment.
    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
    One-off patch name.
    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.
    oneoffPatchId String
    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
    The current state of the one-off patch.
    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.
    oci logo
    Oracle Cloud Infrastructure v3.10.0 published on Wednesday, Nov 5, 2025 by Pulumi
    pulumi/pulumi-oci
      Meet Neo: Your AI Platform Teammate