Oracle Cloud Infrastructure v0.20.0, May 31 23

oci.Database.getDatabaseSoftwareImages

Explore with Pulumi AI

This data source provides the list of Database Software Images in Oracle Cloud Infrastructure Database service.

Gets a list of the database software images in the specified compartment.

Example Usage

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testDatabaseSoftwareImages = Oci.Database.GetDatabaseSoftwareImages.Invoke(new()
    {
        CompartmentId = @var.Compartment_id,
        DisplayName = @var.Database_software_image_display_name,
        ImageShapeFamily = @var.Database_software_image_image_shape_family,
        ImageType = @var.Database_software_image_image_type,
        IsUpgradeSupported = @var.Database_software_image_is_upgrade_supported,
        State = @var.Database_software_image_state,
    });

});

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.GetDatabaseSoftwareImages(ctx, &database.GetDatabaseSoftwareImagesArgs{
			CompartmentId:      _var.Compartment_id,
			DisplayName:        pulumi.StringRef(_var.Database_software_image_display_name),
			ImageShapeFamily:   pulumi.StringRef(_var.Database_software_image_image_shape_family),
			ImageType:          pulumi.StringRef(_var.Database_software_image_image_type),
			IsUpgradeSupported: pulumi.BoolRef(_var.Database_software_image_is_upgrade_supported),
			State:              pulumi.StringRef(_var.Database_software_image_state),
		}, 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.GetDatabaseSoftwareImagesArgs;
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 testDatabaseSoftwareImages = DatabaseFunctions.getDatabaseSoftwareImages(GetDatabaseSoftwareImagesArgs.builder()
            .compartmentId(var_.compartment_id())
            .displayName(var_.database_software_image_display_name())
            .imageShapeFamily(var_.database_software_image_image_shape_family())
            .imageType(var_.database_software_image_image_type())
            .isUpgradeSupported(var_.database_software_image_is_upgrade_supported())
            .state(var_.database_software_image_state())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_database_software_images = oci.Database.get_database_software_images(compartment_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    display_name=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    image_shape_family=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    image_type=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    is_upgrade_supported=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    state=%!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 testDatabaseSoftwareImages = oci.Database.getDatabaseSoftwareImages({
    compartmentId: _var.compartment_id,
    displayName: _var.database_software_image_display_name,
    imageShapeFamily: _var.database_software_image_image_shape_family,
    imageType: _var.database_software_image_image_type,
    isUpgradeSupported: _var.database_software_image_is_upgrade_supported,
    state: _var.database_software_image_state,
});

variables:
  testDatabaseSoftwareImages:
    fn::invoke:
      Function: oci:Database:getDatabaseSoftwareImages
      Arguments:
        compartmentId: ${var.compartment_id}
        displayName: ${var.database_software_image_display_name}
        imageShapeFamily: ${var.database_software_image_image_shape_family}
        imageType: ${var.database_software_image_image_type}
        isUpgradeSupported: ${var.database_software_image_is_upgrade_supported}
        state: ${var.database_software_image_state}

Using getDatabaseSoftwareImages

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 getDatabaseSoftwareImages(args: GetDatabaseSoftwareImagesArgs, opts?: InvokeOptions): Promise<GetDatabaseSoftwareImagesResult>
function getDatabaseSoftwareImagesOutput(args: GetDatabaseSoftwareImagesOutputArgs, opts?: InvokeOptions): Output<GetDatabaseSoftwareImagesResult>

def get_database_software_images(compartment_id: Optional[str] = None,
                                 display_name: Optional[str] = None,
                                 filters: Optional[Sequence[_database.GetDatabaseSoftwareImagesFilter]] = None,
                                 image_shape_family: Optional[str] = None,
                                 image_type: Optional[str] = None,
                                 is_upgrade_supported: Optional[bool] = None,
                                 state: Optional[str] = None,
                                 opts: Optional[InvokeOptions] = None) -> GetDatabaseSoftwareImagesResult
def get_database_software_images_output(compartment_id: Optional[pulumi.Input[str]] = None,
                                 display_name: Optional[pulumi.Input[str]] = None,
                                 filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDatabaseSoftwareImagesFilterArgs]]]] = None,
                                 image_shape_family: Optional[pulumi.Input[str]] = None,
                                 image_type: Optional[pulumi.Input[str]] = None,
                                 is_upgrade_supported: Optional[pulumi.Input[bool]] = None,
                                 state: Optional[pulumi.Input[str]] = None,
                                 opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseSoftwareImagesResult]

func GetDatabaseSoftwareImages(ctx *Context, args *GetDatabaseSoftwareImagesArgs, opts ...InvokeOption) (*GetDatabaseSoftwareImagesResult, error)
func GetDatabaseSoftwareImagesOutput(ctx *Context, args *GetDatabaseSoftwareImagesOutputArgs, opts ...InvokeOption) GetDatabaseSoftwareImagesResultOutput

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

public static class GetDatabaseSoftwareImages 
{
    public static Task<GetDatabaseSoftwareImagesResult> InvokeAsync(GetDatabaseSoftwareImagesArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseSoftwareImagesResult> Invoke(GetDatabaseSoftwareImagesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabaseSoftwareImagesResult> getDatabaseSoftwareImages(GetDatabaseSoftwareImagesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

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

The following arguments are supported:

CompartmentId string: 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<GetDatabaseSoftwareImagesFilter>
ImageShapeFamily string: A filter to return only resources that match the given image shape family exactly.
ImageType string: A filter to return only resources that match the given image type exactly.
IsUpgradeSupported bool: If provided, filters the results to the set of database versions which are supported for Upgrade.
State string: A filter to return only resources that match the given lifecycle state exactly.

CompartmentId string: 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 []GetDatabaseSoftwareImagesFilter
ImageShapeFamily string: A filter to return only resources that match the given image shape family exactly.
ImageType string: A filter to return only resources that match the given image type exactly.
IsUpgradeSupported bool: If provided, filters the results to the set of database versions which are supported for Upgrade.
State string: A filter to return only resources that match the given lifecycle state exactly.

compartmentId String: 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<GetSoftwareImagesFilter>
imageShapeFamily String: A filter to return only resources that match the given image shape family exactly.
imageType String: A filter to return only resources that match the given image type exactly.
isUpgradeSupported Boolean: If provided, filters the results to the set of database versions which are supported for Upgrade.
state String: A filter to return only resources that match the given lifecycle state exactly.

compartmentId string: 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 GetDatabaseSoftwareImagesFilter[]
imageShapeFamily string: A filter to return only resources that match the given image shape family exactly.
imageType string: A filter to return only resources that match the given image type exactly.
isUpgradeSupported boolean: If provided, filters the results to the set of database versions which are supported for Upgrade.
state string: A filter to return only resources that match the given lifecycle state exactly.

compartment_id str: 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 GetDatabaseSoftwareImagesFilter]
image_shape_family str: A filter to return only resources that match the given image shape family exactly.
image_type str: A filter to return only resources that match the given image type exactly.
is_upgrade_supported bool: If provided, filters the results to the set of database versions which are supported for Upgrade.
state str: A filter to return only resources that match the given lifecycle state exactly.

compartmentId String: 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>
imageShapeFamily String: A filter to return only resources that match the given image shape family exactly.
imageType String: A filter to return only resources that match the given image type exactly.
isUpgradeSupported Boolean: If provided, filters the results to the set of database versions which are supported for Upgrade.
state String: A filter to return only resources that match the given lifecycle state exactly.

getDatabaseSoftwareImages Result

The following output properties are available:

CompartmentId string: The OCID of the compartment.
DatabaseSoftwareImages List<GetDatabaseSoftwareImagesDatabaseSoftwareImage>: The list of database_software_images.
Id string: The provider-assigned unique ID for this managed resource.
DisplayName string: The user-friendly name for the database software image. The name does not have to be unique.
Filters List<GetDatabaseSoftwareImagesFilter>
ImageShapeFamily string: To what shape the image is meant for.
ImageType string: The type of software image. Can be grid or database.
IsUpgradeSupported bool: True if this Database software image is supported for Upgrade.
State string: The current state of the database software image.

CompartmentId string: The OCID of the compartment.
DatabaseSoftwareImages []GetDatabaseSoftwareImagesDatabaseSoftwareImage: The list of database_software_images.
Id string: The provider-assigned unique ID for this managed resource.
DisplayName string: The user-friendly name for the database software image. The name does not have to be unique.
Filters []GetDatabaseSoftwareImagesFilter
ImageShapeFamily string: To what shape the image is meant for.
ImageType string: The type of software image. Can be grid or database.
IsUpgradeSupported bool: True if this Database software image is supported for Upgrade.
State string: The current state of the database software image.

compartmentId String: The OCID of the compartment.
databaseSoftwareImages List<GetSoftwareImagesSoftwareImage>: The list of database_software_images.
id String: The provider-assigned unique ID for this managed resource.
displayName String: The user-friendly name for the database software image. The name does not have to be unique.
filters List<GetSoftwareImagesFilter>
imageShapeFamily String: To what shape the image is meant for.
imageType String: The type of software image. Can be grid or database.
isUpgradeSupported Boolean: True if this Database software image is supported for Upgrade.
state String: The current state of the database software image.

compartmentId string: The OCID of the compartment.
databaseSoftwareImages GetDatabaseSoftwareImagesDatabaseSoftwareImage[]: The list of database_software_images.
id string: The provider-assigned unique ID for this managed resource.
displayName string: The user-friendly name for the database software image. The name does not have to be unique.
filters GetDatabaseSoftwareImagesFilter[]
imageShapeFamily string: To what shape the image is meant for.
imageType string: The type of software image. Can be grid or database.
isUpgradeSupported boolean: True if this Database software image is supported for Upgrade.
state string: The current state of the database software image.

compartment_id str: The OCID of the compartment.
database_software_images GetDatabaseSoftwareImagesDatabaseSoftwareImage]: The list of database_software_images.
id str: The provider-assigned unique ID for this managed resource.
display_name str: The user-friendly name for the database software image. The name does not have to be unique.
filters GetDatabaseSoftwareImagesFilter]
image_shape_family str: To what shape the image is meant for.
image_type str: The type of software image. Can be grid or database.
is_upgrade_supported bool: True if this Database software image is supported for Upgrade.
state str: The current state of the database software image.

compartmentId String: The OCID of the compartment.
databaseSoftwareImages List<Property Map>: The list of database_software_images.
id String: The provider-assigned unique ID for this managed resource.
displayName String: The user-friendly name for the database software image. The name does not have to be unique.
filters List<Property Map>
imageShapeFamily String: To what shape the image is meant for.
imageType String: The type of software image. Can be grid or database.
isUpgradeSupported Boolean: True if this Database software image is supported for Upgrade.
state String: The current state of the database software image.

Supporting Types

GetDatabaseSoftwareImagesDatabaseSoftwareImage

CompartmentId string: The compartment OCID.
DatabaseSoftwareImageIncludedPatches List<string>: List of one-off patches for Database Homes.
DatabaseSoftwareImageOneOffPatches List<string>: List of one-off patches for Database Homes.
DatabaseVersion string: The database version with which the database software image is to be built.
DefinedTags Dictionary<string, object>: 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.
FreeformTags Dictionary<string, object>: 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 database software image.
ImageShapeFamily string: A filter to return only resources that match the given image shape family exactly.
ImageType string: A filter to return only resources that match the given image type exactly.
IncludedPatchesSummary string: The patches included in the image and the version of the image.
IsUpgradeSupported bool: If provided, filters the results to the set of database versions which are supported for Upgrade.
LifecycleDetails string: Detailed message for the lifecycle state.
LsInventory string: The output from the OPatch lsInventory command, which is passed as a string.
PatchSet string: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
SourceDbHomeId string
State string: A filter to return only resources that match the given lifecycle state exactly.
TimeCreated string: The date and time the database software image was created.

CompartmentId string: The compartment OCID.
DatabaseSoftwareImageIncludedPatches []string: List of one-off patches for Database Homes.
DatabaseSoftwareImageOneOffPatches []string: List of one-off patches for Database Homes.
DatabaseVersion string: The database version with which the database software image is to be built.
DefinedTags map[string]interface{}: 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.
FreeformTags map[string]interface{}: 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 database software image.
ImageShapeFamily string: A filter to return only resources that match the given image shape family exactly.
ImageType string: A filter to return only resources that match the given image type exactly.
IncludedPatchesSummary string: The patches included in the image and the version of the image.
IsUpgradeSupported bool: If provided, filters the results to the set of database versions which are supported for Upgrade.
LifecycleDetails string: Detailed message for the lifecycle state.
LsInventory string: The output from the OPatch lsInventory command, which is passed as a string.
PatchSet string: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
SourceDbHomeId string
State string: A filter to return only resources that match the given lifecycle state exactly.
TimeCreated string: The date and time the database software image was created.

compartmentId String: The compartment OCID.
databaseSoftwareImageIncludedPatches List<String>: List of one-off patches for Database Homes.
databaseSoftwareImageOneOffPatches List<String>: List of one-off patches for Database Homes.
databaseVersion String: The database version with which the database software image is to be built.
definedTags Map<String,Object>: 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.
freeformTags Map<String,Object>: 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 database software image.
imageShapeFamily String: A filter to return only resources that match the given image shape family exactly.
imageType String: A filter to return only resources that match the given image type exactly.
includedPatchesSummary String: The patches included in the image and the version of the image.
isUpgradeSupported Boolean: If provided, filters the results to the set of database versions which are supported for Upgrade.
lifecycleDetails String: Detailed message for the lifecycle state.
lsInventory String: The output from the OPatch lsInventory command, which is passed as a string.
patchSet String: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
sourceDbHomeId String
state String: A filter to return only resources that match the given lifecycle state exactly.
timeCreated String: The date and time the database software image was created.

compartmentId string: The compartment OCID.
databaseSoftwareImageIncludedPatches string[]: List of one-off patches for Database Homes.
databaseSoftwareImageOneOffPatches string[]: List of one-off patches for Database Homes.
databaseVersion string: The database version with which the database software image is to be built.
definedTags {[key: string]: any}: 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.
freeformTags {[key: string]: any}: 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 database software image.
imageShapeFamily string: A filter to return only resources that match the given image shape family exactly.
imageType string: A filter to return only resources that match the given image type exactly.
includedPatchesSummary string: The patches included in the image and the version of the image.
isUpgradeSupported boolean: If provided, filters the results to the set of database versions which are supported for Upgrade.
lifecycleDetails string: Detailed message for the lifecycle state.
lsInventory string: The output from the OPatch lsInventory command, which is passed as a string.
patchSet string: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
sourceDbHomeId string
state string: A filter to return only resources that match the given lifecycle state exactly.
timeCreated string: The date and time the database software image was created.

compartment_id str: The compartment OCID.
database_software_image_included_patches Sequence[str]: List of one-off patches for Database Homes.
database_software_image_one_off_patches Sequence[str]: List of one-off patches for Database Homes.
database_version str: The database version with which the database software image is to be built.
defined_tags Mapping[str, Any]: 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.
freeform_tags Mapping[str, Any]: 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 database software image.
image_shape_family str: A filter to return only resources that match the given image shape family exactly.
image_type str: A filter to return only resources that match the given image type exactly.
included_patches_summary str: The patches included in the image and the version of the image.
is_upgrade_supported bool: If provided, filters the results to the set of database versions which are supported for Upgrade.
lifecycle_details str: Detailed message for the lifecycle state.
ls_inventory str: The output from the OPatch lsInventory command, which is passed as a string.
patch_set str: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
source_db_home_id str
state str: A filter to return only resources that match the given lifecycle state exactly.
time_created str: The date and time the database software image was created.

compartmentId String: The compartment OCID.
databaseSoftwareImageIncludedPatches List<String>: List of one-off patches for Database Homes.
databaseSoftwareImageOneOffPatches List<String>: List of one-off patches for Database Homes.
databaseVersion String: The database version with which the database software image is to be built.
definedTags Map<Any>: 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.
freeformTags Map<Any>: 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 database software image.
imageShapeFamily String: A filter to return only resources that match the given image shape family exactly.
imageType String: A filter to return only resources that match the given image type exactly.
includedPatchesSummary String: The patches included in the image and the version of the image.
isUpgradeSupported Boolean: If provided, filters the results to the set of database versions which are supported for Upgrade.
lifecycleDetails String: Detailed message for the lifecycle state.
lsInventory String: The output from the OPatch lsInventory command, which is passed as a string.
patchSet String: The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
sourceDbHomeId String
state String: A filter to return only resources that match the given lifecycle state exactly.
timeCreated String: The date and time the database software image was created.

GetDatabaseSoftwareImagesFilter

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

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.