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

oci.Database.getOneoffPatch

Explore with Pulumi AI

oci logo
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 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/v2/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 GetOneoffPatch(ctx *Context, args *GetOneoffPatchArgs, opts ...InvokeOption) (*GetOneoffPatchResult, error)
func GetOneoffPatchOutput(ctx *Context, args *GetOneoffPatchOutputArgs, opts ...InvokeOption) GetOneoffPatchResultOutput

    > Note: This function is named GetOneoffPatch 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.
    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.
    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.
    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.
    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.
    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.
    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 v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
    pulumi/pulumi-oci