1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDatabaseUpgradeHistoryEntries
Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

oci.Database.getDatabaseUpgradeHistoryEntries

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 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

    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 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
    	})
    }
    
    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());
    
        }
    }
    
    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"])
    
    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,
    });
    
    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.16.1 published on Wednesday, Nov 22, 2023 by Pulumi