Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
oci.Database.getDbHome
Explore with Pulumi AI
This data source provides details about a specific Db Home resource in Oracle Cloud Infrastructure Database service.
Gets information about the specified Database Home.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testDbHome = oci.Database.getDbHome({
    dbHomeId: dbHomeId,
});
import pulumi
import pulumi_oci as oci
test_db_home = oci.Database.get_db_home(db_home_id=db_home_id)
package main
import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/database"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := database.GetDbHome(ctx, &database.GetDbHomeArgs{
			DbHomeId: dbHomeId,
		}, 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 testDbHome = Oci.Database.GetDbHome.Invoke(new()
    {
        DbHomeId = dbHomeId,
    });
});
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.GetDbHomeArgs;
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 testDbHome = DatabaseFunctions.getDbHome(GetDbHomeArgs.builder()
            .dbHomeId(dbHomeId)
            .build());
    }
}
variables:
  testDbHome:
    fn::invoke:
      function: oci:Database:getDbHome
      arguments:
        dbHomeId: ${dbHomeId}
Using getDbHome
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 getDbHome(args: GetDbHomeArgs, opts?: InvokeOptions): Promise<GetDbHomeResult>
function getDbHomeOutput(args: GetDbHomeOutputArgs, opts?: InvokeOptions): Output<GetDbHomeResult>def get_db_home(db_home_id: Optional[str] = None,
                opts: Optional[InvokeOptions] = None) -> GetDbHomeResult
def get_db_home_output(db_home_id: Optional[pulumi.Input[str]] = None,
                opts: Optional[InvokeOptions] = None) -> Output[GetDbHomeResult]func GetDbHome(ctx *Context, args *GetDbHomeArgs, opts ...InvokeOption) (*GetDbHomeResult, error)
func GetDbHomeOutput(ctx *Context, args *GetDbHomeOutputArgs, opts ...InvokeOption) GetDbHomeResultOutput> Note: This function is named GetDbHome in the Go SDK.
public static class GetDbHome 
{
    public static Task<GetDbHomeResult> InvokeAsync(GetDbHomeArgs args, InvokeOptions? opts = null)
    public static Output<GetDbHomeResult> Invoke(GetDbHomeInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetDbHomeResult> getDbHome(GetDbHomeArgs args, InvokeOptions options)
public static Output<GetDbHomeResult> getDbHome(GetDbHomeArgs args, InvokeOptions options)
fn::invoke:
  function: oci:Database/getDbHome:getDbHome
  arguments:
    # arguments dictionaryThe following arguments are supported:
- db_
home_ strid  - The Database Home OCID.
 
getDbHome Result
The following output properties are available:
- Compartment
Id string - The OCID of the compartment.
 - Database
Software stringImage Id  - The database software image OCID
 - Databases
List<Get
Db Home Database>  - Db
Home stringId  - Db
Home stringLocation  - The location of the Oracle Database Home.
 - Db
System stringId  - The OCID of the DB system.
 - Db
Version string - The Oracle Database version.
 - Dictionary<string, string>
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - Display
Name string - The user-provided name for the Database Home. The name does not need to be unique.
 - Enable
Database boolDelete  - Dictionary<string, string>
 - 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 Home.
 - Is
Desupported boolVersion  - Is
Unified boolAuditing Enabled  - Indicates whether unified autiding is enabled or not.
 - Kms
Key stringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - Kms
Key stringVersion Id  - Last
Patch stringHistory Entry Id  - The OCID of the last patch history. This value is updated as soon as a patch operation is started.
 - Lifecycle
Details string - Additional information about the current lifecycle state.
 - Source string
 - State string
 - The current state of the Database Home.
 - Time
Created string - The date and time the Database Home was created.
 - Vm
Cluster stringId  - The OCID of the VM cluster.
 
- Compartment
Id string - The OCID of the compartment.
 - Database
Software stringImage Id  - The database software image OCID
 - Databases
[]Get
Db Home Database  - Db
Home stringId  - Db
Home stringLocation  - The location of the Oracle Database Home.
 - Db
System stringId  - The OCID of the DB system.
 - Db
Version string - The Oracle Database version.
 - map[string]string
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - Display
Name string - The user-provided name for the Database Home. The name does not need to be unique.
 - Enable
Database boolDelete  - map[string]string
 - 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 Home.
 - Is
Desupported boolVersion  - Is
Unified boolAuditing Enabled  - Indicates whether unified autiding is enabled or not.
 - Kms
Key stringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - Kms
Key stringVersion Id  - Last
Patch stringHistory Entry Id  - The OCID of the last patch history. This value is updated as soon as a patch operation is started.
 - Lifecycle
Details string - Additional information about the current lifecycle state.
 - Source string
 - State string
 - The current state of the Database Home.
 - Time
Created string - The date and time the Database Home was created.
 - Vm
Cluster stringId  - The OCID of the VM cluster.
 
- compartment
Id String - The OCID of the compartment.
 - database
Software StringImage Id  - The database software image OCID
 - databases
List<Get
Db Home>  - db
Home StringId  - db
Home StringLocation  - The location of the Oracle Database Home.
 - db
System StringId  - The OCID of the DB system.
 - db
Version String - The Oracle Database version.
 - Map<String,String>
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - display
Name String - The user-provided name for the Database Home. The name does not need to be unique.
 - enable
Database BooleanDelete  - Map<String,String>
 - 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 Home.
 - is
Desupported BooleanVersion  - is
Unified BooleanAuditing Enabled  - Indicates whether unified autiding is enabled or not.
 - kms
Key StringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - kms
Key StringVersion Id  - last
Patch StringHistory Entry Id  - The OCID of the last patch history. This value is updated as soon as a patch operation is started.
 - lifecycle
Details String - Additional information about the current lifecycle state.
 - source String
 - state String
 - The current state of the Database Home.
 - time
Created String - The date and time the Database Home was created.
 - vm
Cluster StringId  - The OCID of the VM cluster.
 
- compartment
Id string - The OCID of the compartment.
 - database
Software stringImage Id  - The database software image OCID
 - databases
Get
Db Home Database[]  - db
Home stringId  - db
Home stringLocation  - The location of the Oracle Database Home.
 - db
System stringId  - The OCID of the DB system.
 - db
Version string - The Oracle Database version.
 - {[key: string]: string}
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - display
Name string - The user-provided name for the Database Home. The name does not need to be unique.
 - enable
Database booleanDelete  - {[key: string]: string}
 - 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 Home.
 - is
Desupported booleanVersion  - is
Unified booleanAuditing Enabled  - Indicates whether unified autiding is enabled or not.
 - kms
Key stringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - kms
Key stringVersion Id  - last
Patch stringHistory Entry Id  - The OCID of the last patch history. This value is updated as soon as a patch operation is started.
 - lifecycle
Details string - Additional information about the current lifecycle state.
 - source string
 - state string
 - The current state of the Database Home.
 - time
Created string - The date and time the Database Home was created.
 - vm
Cluster stringId  - The OCID of the VM cluster.
 
- compartment_
id str - The OCID of the compartment.
 - database_
software_ strimage_ id  - The database software image OCID
 - databases
Sequence[database.
Get Db Home Database]  - db_
home_ strid  - db_
home_ strlocation  - The location of the Oracle Database Home.
 - db_
system_ strid  - The OCID of the DB system.
 - db_
version str - The Oracle Database version.
 - Mapping[str, str]
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - display_
name str - The user-provided name for the Database Home. The name does not need to be unique.
 - enable_
database_ booldelete  - Mapping[str, str]
 - 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 Home.
 - is_
desupported_ boolversion  - is_
unified_ boolauditing_ enabled  - Indicates whether unified autiding is enabled or not.
 - kms_
key_ strid  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - kms_
key_ strversion_ id  - last_
patch_ strhistory_ entry_ id  - The OCID of the last patch history. This value is updated as soon as a patch operation is started.
 - lifecycle_
details str - Additional information about the current lifecycle state.
 - source str
 - state str
 - The current state of the Database Home.
 - time_
created str - The date and time the Database Home was created.
 - vm_
cluster_ strid  - The OCID of the VM cluster.
 
- compartment
Id String - The OCID of the compartment.
 - database
Software StringImage Id  - The database software image OCID
 - databases List<Property Map>
 - db
Home StringId  - db
Home StringLocation  - The location of the Oracle Database Home.
 - db
System StringId  - The OCID of the DB system.
 - db
Version String - The Oracle Database version.
 - Map<String>
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - display
Name String - The user-provided name for the Database Home. The name does not need to be unique.
 - enable
Database BooleanDelete  - Map<String>
 - 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 Home.
 - is
Desupported BooleanVersion  - is
Unified BooleanAuditing Enabled  - Indicates whether unified autiding is enabled or not.
 - kms
Key StringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - kms
Key StringVersion Id  - last
Patch StringHistory Entry Id  - The OCID of the last patch history. This value is updated as soon as a patch operation is started.
 - lifecycle
Details String - Additional information about the current lifecycle state.
 - source String
 - state String
 - The current state of the Database Home.
 - time
Created String - The date and time the Database Home was created.
 - vm
Cluster StringId  - The OCID of the VM cluster.
 
Supporting Types
GetDbHomeDatabase   
- Admin
Password string - Backup
Id string - Backup
Tde stringPassword  - Character
Set string - Connection
Strings List<GetDb Home Database Connection String>  - Database
Id string - Database
Software stringImage Id  - The database software image OCID
 - Db
Backup List<GetConfigs Db Home Database Db Backup Config>  - Db
Name string - Db
Unique stringName  - Db
Workload string - Dictionary<string, string>
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - Encryption
Key List<GetLocation Details Db Home Database Encryption Key Location Detail>  - Dictionary<string, string>
 - 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 Home.
 - Key
Store stringId  - Kms
Key stringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - Kms
Key stringVersion Id  - Lifecycle
Details string - Additional information about the current lifecycle state.
 - Ncharacter
Set string - One
Off List<string>Patches  - List of one-off patches for Database Homes.
 - Pdb
Name string - Pluggable
Databases List<string> - Sid
Prefix string - State string
 - The current state of the Database Home.
 - Tde
Wallet stringPassword  - Time
Created string - The date and time the Database Home was created.
 - Time
Stamp stringFor Point In Time Recovery  - Vault
Id string 
- Admin
Password string - Backup
Id string - Backup
Tde stringPassword  - Character
Set string - Connection
Strings []GetDb Home Database Connection String  - Database
Id string - Database
Software stringImage Id  - The database software image OCID
 - Db
Backup []GetConfigs Db Home Database Db Backup Config  - Db
Name string - Db
Unique stringName  - Db
Workload string - map[string]string
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - Encryption
Key []GetLocation Details Db Home Database Encryption Key Location Detail  - map[string]string
 - 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 Home.
 - Key
Store stringId  - Kms
Key stringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - Kms
Key stringVersion Id  - Lifecycle
Details string - Additional information about the current lifecycle state.
 - Ncharacter
Set string - One
Off []stringPatches  - List of one-off patches for Database Homes.
 - Pdb
Name string - Pluggable
Databases []string - Sid
Prefix string - State string
 - The current state of the Database Home.
 - Tde
Wallet stringPassword  - Time
Created string - The date and time the Database Home was created.
 - Time
Stamp stringFor Point In Time Recovery  - Vault
Id string 
- admin
Password String - backup
Id String - backup
Tde StringPassword  - character
Set String - connection
Strings List<GetDb Home Connection String>  - database
Id String - database
Software StringImage Id  - The database software image OCID
 - db
Backup List<GetConfigs Db Home Db Backup Config>  - db
Name String - db
Unique StringName  - db
Workload String - Map<String,String>
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - encryption
Key List<GetLocation Details Db Home Encryption Key Location Detail>  - Map<String,String>
 - 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 Home.
 - key
Store StringId  - kms
Key StringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - kms
Key StringVersion Id  - lifecycle
Details String - Additional information about the current lifecycle state.
 - ncharacter
Set String - one
Off List<String>Patches  - List of one-off patches for Database Homes.
 - pdb
Name String - pluggable
Databases List<String> - sid
Prefix String - state String
 - The current state of the Database Home.
 - tde
Wallet StringPassword  - time
Created String - The date and time the Database Home was created.
 - time
Stamp StringFor Point In Time Recovery  - vault
Id String 
- admin
Password string - backup
Id string - backup
Tde stringPassword  - character
Set string - connection
Strings GetDb Home Database Connection String[]  - database
Id string - database
Software stringImage Id  - The database software image OCID
 - db
Backup GetConfigs Db Home Database Db Backup Config[]  - db
Name string - db
Unique stringName  - db
Workload string - {[key: string]: string}
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - encryption
Key GetLocation Details Db Home Database Encryption Key Location Detail[]  - {[key: string]: string}
 - 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 Home.
 - key
Store stringId  - kms
Key stringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - kms
Key stringVersion Id  - lifecycle
Details string - Additional information about the current lifecycle state.
 - ncharacter
Set string - one
Off string[]Patches  - List of one-off patches for Database Homes.
 - pdb
Name string - pluggable
Databases string[] - sid
Prefix string - state string
 - The current state of the Database Home.
 - tde
Wallet stringPassword  - time
Created string - The date and time the Database Home was created.
 - time
Stamp stringFor Point In Time Recovery  - vault
Id string 
- admin_
password str - backup_
id str - backup_
tde_ strpassword  - character_
set str - connection_
strings Sequence[database.Get Db Home Database Connection String]  - database_
id str - database_
software_ strimage_ id  - The database software image OCID
 - db_
backup_ Sequence[database.configs Get Db Home Database Db Backup Config]  - db_
name str - db_
unique_ strname  - db_
workload str - Mapping[str, str]
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - encryption_
key_ Sequence[database.location_ details Get Db Home Database Encryption Key Location Detail]  - Mapping[str, str]
 - 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 Home.
 - key_
store_ strid  - kms_
key_ strid  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - kms_
key_ strversion_ id  - lifecycle_
details str - Additional information about the current lifecycle state.
 - ncharacter_
set str - one_
off_ Sequence[str]patches  - List of one-off patches for Database Homes.
 - pdb_
name str - pluggable_
databases Sequence[str] - sid_
prefix str - state str
 - The current state of the Database Home.
 - tde_
wallet_ strpassword  - time_
created str - The date and time the Database Home was created.
 - time_
stamp_ strfor_ point_ in_ time_ recovery  - vault_
id str 
- admin
Password String - backup
Id String - backup
Tde StringPassword  - character
Set String - connection
Strings List<Property Map> - database
Id String - database
Software StringImage Id  - The database software image OCID
 - db
Backup List<Property Map>Configs  - db
Name String - db
Unique StringName  - db
Workload String - Map<String>
 - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
 - encryption
Key List<Property Map>Location Details  - Map<String>
 - 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 Home.
 - key
Store StringId  - kms
Key StringId  - The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
 - kms
Key StringVersion Id  - lifecycle
Details String - Additional information about the current lifecycle state.
 - ncharacter
Set String - one
Off List<String>Patches  - List of one-off patches for Database Homes.
 - pdb
Name String - pluggable
Databases List<String> - sid
Prefix String - state String
 - The current state of the Database Home.
 - tde
Wallet StringPassword  - time
Created String - The date and time the Database Home was created.
 - time
Stamp StringFor Point In Time Recovery  - vault
Id String 
GetDbHomeDatabaseConnectionString     
- All
Connection Dictionary<string, string>Strings  - Cdb
Default string - Cdb
Ip stringDefault  
- All
Connection map[string]stringStrings  - Cdb
Default string - Cdb
Ip stringDefault  
- all
Connection Map<String,String>Strings  - cdb
Default String - cdb
Ip StringDefault  
- all
Connection {[key: string]: string}Strings  - cdb
Default string - cdb
Ip stringDefault  
- all_
connection_ Mapping[str, str]strings  - cdb_
default str - cdb_
ip_ strdefault  
- all
Connection Map<String>Strings  - cdb
Default String - cdb
Ip StringDefault  
GetDbHomeDatabaseDbBackupConfig      
- auto
Backup BooleanEnabled  - auto
Backup StringWindow  - auto
Full StringBackup Day  - auto
Full StringBackup Window  - backup
Deletion StringPolicy  - backup
Destination List<GetDetails Db Home Db Backup Config Backup Destination Detail>  - recovery
Window IntegerIn Days  - run
Immediate BooleanFull Backup  
- auto
Backup BooleanEnabled  - auto
Backup StringWindow  - auto
Full StringBackup Day  - auto
Full StringBackup Window  - backup
Deletion StringPolicy  - backup
Destination List<Property Map>Details  - recovery
Window NumberIn Days  - run
Immediate BooleanFull Backup  
GetDbHomeDatabaseDbBackupConfigBackupDestinationDetail         
- Dbrs
Policy stringId  - Id string
 - The OCID of the Database Home.
 - Type string
 
- Dbrs
Policy stringId  - Id string
 - The OCID of the Database Home.
 - Type string
 
- dbrs
Policy StringId  - id String
 - The OCID of the Database Home.
 - type String
 
- dbrs
Policy stringId  - id string
 - The OCID of the Database Home.
 - type string
 
- dbrs_
policy_ strid  - id str
 - The OCID of the Database Home.
 - type str
 
- dbrs
Policy StringId  - id String
 - The OCID of the Database Home.
 - type String
 
GetDbHomeDatabaseEncryptionKeyLocationDetail       
- Hsm
Password string - Provider
Type string 
- Hsm
Password string - Provider
Type string 
- hsm
Password String - provider
Type String 
- hsm
Password string - provider
Type string 
- hsm_
password str - provider_
type str 
- hsm
Password String - provider
Type String 
Package Details
- Repository
 - oci pulumi/pulumi-oci
 - License
 - Apache-2.0
 - Notes
 - This Pulumi package is based on the 
ociTerraform Provider.