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

oci.Database.getOneoffPatch

Explore with Pulumi AI

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

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,
});
Copy
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"])
Copy
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
	})
}
Copy
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,
    });

});
Copy
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());

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

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

> 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)
}
Copy
public static CompletableFuture<GetOneoffPatchResult> getOneoffPatch(GetOneoffPatchArgs args, InvokeOptions options)
public static Output<GetOneoffPatchResult> getOneoffPatch(GetOneoffPatchArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:Database/getOneoffPatch:getOneoffPatch
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

OneoffPatchId This property is required. string
The one-off patch OCID.
OneoffPatchId This property is required. string
The one-off patch OCID.
oneoffPatchId This property is required. String
The one-off patch OCID.
oneoffPatchId This property is required. string
The one-off patch OCID.
oneoff_patch_id This property is required. str
The one-off patch OCID.
oneoffPatchId This property is required. 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.
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi