1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDatabaseSoftwareImages
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

oci.Database.getDatabaseSoftwareImages

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

    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

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testDatabaseSoftwareImages = oci.Database.getDatabaseSoftwareImages({
        compartmentId: compartmentId,
        displayName: databaseSoftwareImageDisplayName,
        imageShapeFamily: databaseSoftwareImageImageShapeFamily,
        imageType: databaseSoftwareImageImageType,
        isUpgradeSupported: databaseSoftwareImageIsUpgradeSupported,
        state: databaseSoftwareImageState,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_database_software_images = oci.Database.get_database_software_images(compartment_id=compartment_id,
        display_name=database_software_image_display_name,
        image_shape_family=database_software_image_image_shape_family,
        image_type=database_software_image_image_type,
        is_upgrade_supported=database_software_image_is_upgrade_supported,
        state=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:      compartmentId,
    			DisplayName:        pulumi.StringRef(databaseSoftwareImageDisplayName),
    			ImageShapeFamily:   pulumi.StringRef(databaseSoftwareImageImageShapeFamily),
    			ImageType:          pulumi.StringRef(databaseSoftwareImageImageType),
    			IsUpgradeSupported: pulumi.BoolRef(databaseSoftwareImageIsUpgradeSupported),
    			State:              pulumi.StringRef(databaseSoftwareImageState),
    		}, 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 testDatabaseSoftwareImages = Oci.Database.GetDatabaseSoftwareImages.Invoke(new()
        {
            CompartmentId = compartmentId,
            DisplayName = databaseSoftwareImageDisplayName,
            ImageShapeFamily = databaseSoftwareImageImageShapeFamily,
            ImageType = databaseSoftwareImageImageType,
            IsUpgradeSupported = databaseSoftwareImageIsUpgradeSupported,
            State = databaseSoftwareImageState,
        });
    
    });
    
    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(compartmentId)
                .displayName(databaseSoftwareImageDisplayName)
                .imageShapeFamily(databaseSoftwareImageImageShapeFamily)
                .imageType(databaseSoftwareImageImageType)
                .isUpgradeSupported(databaseSoftwareImageIsUpgradeSupported)
                .state(databaseSoftwareImageState)
                .build());
    
        }
    }
    
    variables:
      testDatabaseSoftwareImages:
        fn::invoke:
          Function: oci:Database:getDatabaseSoftwareImages
          Arguments:
            compartmentId: ${compartmentId}
            displayName: ${databaseSoftwareImageDisplayName}
            imageShapeFamily: ${databaseSoftwareImageImageShapeFamily}
            imageType: ${databaseSoftwareImageImageType}
            isUpgradeSupported: ${databaseSoftwareImageIsUpgradeSupported}
            state: ${databaseSoftwareImageState}
    

    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 Sequence[database.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 Sequence[database.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 Sequence[database.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.
    oci logo
    Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi