Docs Packages
  1. Pulumi Registry
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbSystemPatches
oci logo
Oracle Cloud Infrastructure v0.19.0, May 26 23

oci.Database.getDbSystemPatches

Explore with Pulumi AI

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

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 = oci_database_db_system.Test_db_system.Id,
    });

});

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/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: oci_database_db_system.Test_db_system.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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(oci_database_db_system.test_db_system().id())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_db_system_patches = oci.Database.get_db_system_patches(db_system_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))

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

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

variables:
  testDbSystemPatches:
    fn::invoke:
      Function: oci:Database:getDbSystemPatches
      Arguments:
        dbSystemId: ${oci_database_db_system.test_db_system.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[_database.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[_database.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)
// Output-based functions aren't available in Java yet

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 GetDbSystemPatchesPatch]

The list of patches.

filters 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.