1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDatabaseUpgradeHistoryEntries
Oracle Cloud Infrastructure v1.29.0 published on Thursday, Mar 28, 2024 by Pulumi

oci.Database.getDatabaseUpgradeHistoryEntries

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.29.0 published on Thursday, Mar 28, 2024 by Pulumi

    This data source provides the list of Database Upgrade History Entries in Oracle Cloud Infrastructure Database service.

    Gets the upgrade history for a specified database in a bare metal or virtual machine DB system.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testDatabaseUpgradeHistoryEntries = oci.Database.getDatabaseUpgradeHistoryEntries({
        databaseId: oci_database_database.test_database.id,
        state: _var.database_upgrade_history_entry_state,
        upgradeAction: _var.database_upgrade_history_entry_upgrade_action,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_database_upgrade_history_entries = oci.Database.get_database_upgrade_history_entries(database_id=oci_database_database["test_database"]["id"],
        state=var["database_upgrade_history_entry_state"],
        upgrade_action=var["database_upgrade_history_entry_upgrade_action"])
    
    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.GetDatabaseUpgradeHistoryEntries(ctx, &database.GetDatabaseUpgradeHistoryEntriesArgs{
    			DatabaseId:    oci_database_database.Test_database.Id,
    			State:         pulumi.StringRef(_var.Database_upgrade_history_entry_state),
    			UpgradeAction: pulumi.StringRef(_var.Database_upgrade_history_entry_upgrade_action),
    		}, 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 testDatabaseUpgradeHistoryEntries = Oci.Database.GetDatabaseUpgradeHistoryEntries.Invoke(new()
        {
            DatabaseId = oci_database_database.Test_database.Id,
            State = @var.Database_upgrade_history_entry_state,
            UpgradeAction = @var.Database_upgrade_history_entry_upgrade_action,
        });
    
    });
    
    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.GetDatabaseUpgradeHistoryEntriesArgs;
    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 testDatabaseUpgradeHistoryEntries = DatabaseFunctions.getDatabaseUpgradeHistoryEntries(GetDatabaseUpgradeHistoryEntriesArgs.builder()
                .databaseId(oci_database_database.test_database().id())
                .state(var_.database_upgrade_history_entry_state())
                .upgradeAction(var_.database_upgrade_history_entry_upgrade_action())
                .build());
    
        }
    }
    
    variables:
      testDatabaseUpgradeHistoryEntries:
        fn::invoke:
          Function: oci:Database:getDatabaseUpgradeHistoryEntries
          Arguments:
            databaseId: ${oci_database_database.test_database.id}
            state: ${var.database_upgrade_history_entry_state}
            upgradeAction: ${var.database_upgrade_history_entry_upgrade_action}
    

    Using getDatabaseUpgradeHistoryEntries

    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 getDatabaseUpgradeHistoryEntries(args: GetDatabaseUpgradeHistoryEntriesArgs, opts?: InvokeOptions): Promise<GetDatabaseUpgradeHistoryEntriesResult>
    function getDatabaseUpgradeHistoryEntriesOutput(args: GetDatabaseUpgradeHistoryEntriesOutputArgs, opts?: InvokeOptions): Output<GetDatabaseUpgradeHistoryEntriesResult>
    def get_database_upgrade_history_entries(database_id: Optional[str] = None,
                                             filters: Optional[Sequence[_database.GetDatabaseUpgradeHistoryEntriesFilter]] = None,
                                             state: Optional[str] = None,
                                             upgrade_action: Optional[str] = None,
                                             opts: Optional[InvokeOptions] = None) -> GetDatabaseUpgradeHistoryEntriesResult
    def get_database_upgrade_history_entries_output(database_id: Optional[pulumi.Input[str]] = None,
                                             filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDatabaseUpgradeHistoryEntriesFilterArgs]]]] = None,
                                             state: Optional[pulumi.Input[str]] = None,
                                             upgrade_action: Optional[pulumi.Input[str]] = None,
                                             opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseUpgradeHistoryEntriesResult]
    func GetDatabaseUpgradeHistoryEntries(ctx *Context, args *GetDatabaseUpgradeHistoryEntriesArgs, opts ...InvokeOption) (*GetDatabaseUpgradeHistoryEntriesResult, error)
    func GetDatabaseUpgradeHistoryEntriesOutput(ctx *Context, args *GetDatabaseUpgradeHistoryEntriesOutputArgs, opts ...InvokeOption) GetDatabaseUpgradeHistoryEntriesResultOutput

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

    public static class GetDatabaseUpgradeHistoryEntries 
    {
        public static Task<GetDatabaseUpgradeHistoryEntriesResult> InvokeAsync(GetDatabaseUpgradeHistoryEntriesArgs args, InvokeOptions? opts = null)
        public static Output<GetDatabaseUpgradeHistoryEntriesResult> Invoke(GetDatabaseUpgradeHistoryEntriesInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetDatabaseUpgradeHistoryEntriesResult> getDatabaseUpgradeHistoryEntries(GetDatabaseUpgradeHistoryEntriesArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:Database/getDatabaseUpgradeHistoryEntries:getDatabaseUpgradeHistoryEntries
      arguments:
        # arguments dictionary

    The following arguments are supported:

    DatabaseId string
    The database OCID.
    Filters List<GetDatabaseUpgradeHistoryEntriesFilter>
    State string
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    UpgradeAction string
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    DatabaseId string
    The database OCID.
    Filters []GetDatabaseUpgradeHistoryEntriesFilter
    State string
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    UpgradeAction string
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    databaseId String
    The database OCID.
    filters List<GetUpgradeHistoryEntriesFilter>
    state String
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    upgradeAction String
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    databaseId string
    The database OCID.
    filters GetDatabaseUpgradeHistoryEntriesFilter[]
    state string
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    upgradeAction string
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    database_id str
    The database OCID.
    filters GetDatabaseUpgradeHistoryEntriesFilter]
    state str
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    upgrade_action str
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    databaseId String
    The database OCID.
    filters List<Property Map>
    state String
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    upgradeAction String
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

    getDatabaseUpgradeHistoryEntries Result

    The following output properties are available:

    DatabaseId string
    DatabaseUpgradeHistoryEntries List<GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry>
    The list of database_upgrade_history_entries.
    Id string
    The provider-assigned unique ID for this managed resource.
    Filters List<GetDatabaseUpgradeHistoryEntriesFilter>
    State string
    Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
    UpgradeAction string
    DatabaseId string
    DatabaseUpgradeHistoryEntries []GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry
    The list of database_upgrade_history_entries.
    Id string
    The provider-assigned unique ID for this managed resource.
    Filters []GetDatabaseUpgradeHistoryEntriesFilter
    State string
    Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
    UpgradeAction string
    databaseId String
    databaseUpgradeHistoryEntries List<GetUpgradeHistoryEntriesUpgradeHistoryEntry>
    The list of database_upgrade_history_entries.
    id String
    The provider-assigned unique ID for this managed resource.
    filters List<GetUpgradeHistoryEntriesFilter>
    state String
    Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
    upgradeAction String
    databaseId string
    databaseUpgradeHistoryEntries GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry[]
    The list of database_upgrade_history_entries.
    id string
    The provider-assigned unique ID for this managed resource.
    filters GetDatabaseUpgradeHistoryEntriesFilter[]
    state string
    Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
    upgradeAction string
    database_id str
    database_upgrade_history_entries GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry]
    The list of database_upgrade_history_entries.
    id str
    The provider-assigned unique ID for this managed resource.
    filters GetDatabaseUpgradeHistoryEntriesFilter]
    state str
    Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
    upgrade_action str
    databaseId String
    databaseUpgradeHistoryEntries List<Property Map>
    The list of database_upgrade_history_entries.
    id String
    The provider-assigned unique ID for this managed resource.
    filters List<Property Map>
    state String
    Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
    upgradeAction String

    Supporting Types

    GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry

    Action string
    The database upgrade action.
    Id string
    The OCID of the database upgrade history.
    LifecycleDetails string
    Additional information about the current lifecycle state.
    Options string
    Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"
    Source string
    The source of the Oracle Database software to be used for the upgrade.

    • Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
    • Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.
    SourceDbHomeId string
    The OCID of the Database Home.
    State string
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    TargetDatabaseSoftwareImageId string
    the database software image used for upgrading database.
    TargetDbHomeId string
    The OCID of the Database Home.
    TargetDbVersion string
    A valid Oracle Database version. For a list of supported versions, use the ListDbVersions operation.
    TimeEnded string
    The date and time when the database upgrade ended.
    TimeStarted string
    The date and time when the database upgrade started.
    Action string
    The database upgrade action.
    Id string
    The OCID of the database upgrade history.
    LifecycleDetails string
    Additional information about the current lifecycle state.
    Options string
    Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"
    Source string
    The source of the Oracle Database software to be used for the upgrade.

    • Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
    • Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.
    SourceDbHomeId string
    The OCID of the Database Home.
    State string
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    TargetDatabaseSoftwareImageId string
    the database software image used for upgrading database.
    TargetDbHomeId string
    The OCID of the Database Home.
    TargetDbVersion string
    A valid Oracle Database version. For a list of supported versions, use the ListDbVersions operation.
    TimeEnded string
    The date and time when the database upgrade ended.
    TimeStarted string
    The date and time when the database upgrade started.
    action String
    The database upgrade action.
    id String
    The OCID of the database upgrade history.
    lifecycleDetails String
    Additional information about the current lifecycle state.
    options String
    Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"
    source String
    The source of the Oracle Database software to be used for the upgrade.

    • Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
    • Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.
    sourceDbHomeId String
    The OCID of the Database Home.
    state String
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    targetDatabaseSoftwareImageId String
    the database software image used for upgrading database.
    targetDbHomeId String
    The OCID of the Database Home.
    targetDbVersion String
    A valid Oracle Database version. For a list of supported versions, use the ListDbVersions operation.
    timeEnded String
    The date and time when the database upgrade ended.
    timeStarted String
    The date and time when the database upgrade started.
    action string
    The database upgrade action.
    id string
    The OCID of the database upgrade history.
    lifecycleDetails string
    Additional information about the current lifecycle state.
    options string
    Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"
    source string
    The source of the Oracle Database software to be used for the upgrade.

    • Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
    • Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.
    sourceDbHomeId string
    The OCID of the Database Home.
    state string
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    targetDatabaseSoftwareImageId string
    the database software image used for upgrading database.
    targetDbHomeId string
    The OCID of the Database Home.
    targetDbVersion string
    A valid Oracle Database version. For a list of supported versions, use the ListDbVersions operation.
    timeEnded string
    The date and time when the database upgrade ended.
    timeStarted string
    The date and time when the database upgrade started.
    action str
    The database upgrade action.
    id str
    The OCID of the database upgrade history.
    lifecycle_details str
    Additional information about the current lifecycle state.
    options str
    Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"
    source str
    The source of the Oracle Database software to be used for the upgrade.

    • Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
    • Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.
    source_db_home_id str
    The OCID of the Database Home.
    state str
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    target_database_software_image_id str
    the database software image used for upgrading database.
    target_db_home_id str
    The OCID of the Database Home.
    target_db_version str
    A valid Oracle Database version. For a list of supported versions, use the ListDbVersions operation.
    time_ended str
    The date and time when the database upgrade ended.
    time_started str
    The date and time when the database upgrade started.
    action String
    The database upgrade action.
    id String
    The OCID of the database upgrade history.
    lifecycleDetails String
    Additional information about the current lifecycle state.
    options String
    Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"
    source String
    The source of the Oracle Database software to be used for the upgrade.

    • Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
    • Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.
    sourceDbHomeId String
    The OCID of the Database Home.
    state String
    A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
    targetDatabaseSoftwareImageId String
    the database software image used for upgrading database.
    targetDbHomeId String
    The OCID of the Database Home.
    targetDbVersion String
    A valid Oracle Database version. For a list of supported versions, use the ListDbVersions operation.
    timeEnded String
    The date and time when the database upgrade ended.
    timeStarted String
    The date and time when the database upgrade started.

    GetDatabaseUpgradeHistoryEntriesFilter

    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.29.0 published on Thursday, Mar 28, 2024 by Pulumi