Oracle Cloud Infrastructure v2.29.0, Apr 9 25

Oracle Cloud Infrastructure v2.29.0 published on Wednesday, Apr 9, 2025 by Pulumi

oci.Opsi.getDatabaseInsight

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.29.0 published on Wednesday, Apr 9, 2025 by Pulumi

Example Usage

TypeScript
Python
Go
C#
Java
YAML

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDatabaseInsight = oci.Opsi.getDatabaseInsight({
    databaseInsightId: testDatabaseInsightOciOpsiDatabaseInsight.id,
});

import pulumi
import pulumi_oci as oci

test_database_insight = oci.Opsi.get_database_insight(database_insight_id=test_database_insight_oci_opsi_database_insight["id"])

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/opsi"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := opsi.GetDatabaseInsight(ctx, &opsi.GetDatabaseInsightArgs{
			DatabaseInsightId: testDatabaseInsightOciOpsiDatabaseInsight.Id,
		}, 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 testDatabaseInsight = Oci.Opsi.GetDatabaseInsight.Invoke(new()
    {
        DatabaseInsightId = testDatabaseInsightOciOpsiDatabaseInsight.Id,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Opsi.OpsiFunctions;
import com.pulumi.oci.Opsi.inputs.GetDatabaseInsightArgs;
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 testDatabaseInsight = OpsiFunctions.getDatabaseInsight(GetDatabaseInsightArgs.builder()
            .databaseInsightId(testDatabaseInsightOciOpsiDatabaseInsight.id())
            .build());

    }
}

variables:
  testDatabaseInsight:
    fn::invoke:
      function: oci:Opsi:getDatabaseInsight
      arguments:
        databaseInsightId: ${testDatabaseInsightOciOpsiDatabaseInsight.id}

Using getDatabaseInsight

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.

TypeScript
Python
Go
C#
Java
YAML

function getDatabaseInsight(args: GetDatabaseInsightArgs, opts?: InvokeOptions): Promise<GetDatabaseInsightResult>
function getDatabaseInsightOutput(args: GetDatabaseInsightOutputArgs, opts?: InvokeOptions): Output<GetDatabaseInsightResult>

def get_database_insight(database_insight_id: Optional[str] = None,
                         opts: Optional[InvokeOptions] = None) -> GetDatabaseInsightResult
def get_database_insight_output(database_insight_id: Optional[pulumi.Input[str]] = None,
                         opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseInsightResult]

func GetDatabaseInsight(ctx *Context, args *GetDatabaseInsightArgs, opts ...InvokeOption) (*GetDatabaseInsightResult, error)
func GetDatabaseInsightOutput(ctx *Context, args *GetDatabaseInsightOutputArgs, opts ...InvokeOption) GetDatabaseInsightResultOutput

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

public static class GetDatabaseInsight 
{
    public static Task<GetDatabaseInsightResult> InvokeAsync(GetDatabaseInsightArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseInsightResult> Invoke(GetDatabaseInsightInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabaseInsightResult> getDatabaseInsight(GetDatabaseInsightArgs args, InvokeOptions options)
public static Output<GetDatabaseInsightResult> getDatabaseInsight(GetDatabaseInsightArgs args, InvokeOptions options)

fn::invoke:
  function: oci:Opsi/getDatabaseInsight:getDatabaseInsight
  arguments:
    # arguments dictionary

The following arguments are supported:

DatabaseInsightId string: Unique database insight identifier

DatabaseInsightId string: Unique database insight identifier

databaseInsightId String: Unique database insight identifier

databaseInsightId string: Unique database insight identifier

database_insight_id str: Unique database insight identifier

databaseInsightId String: Unique database insight identifier

getDatabaseInsight Result

The following output properties are available:

CompartmentId string: Compartment identifier of the database
ConnectionCredentialDetails List<GetDatabaseInsightConnectionCredentialDetail>: User credential details to connect to the database.
ConnectionDetails List<GetDatabaseInsightConnectionDetail>: Connection details to connect to the database. HostName, protocol, and port should be specified.
ConnectorId string: The OCID of External Database Connector
CredentialDetails List<GetDatabaseInsightCredentialDetail>: User credential details to connect to the database.
DatabaseConnectionStatusDetails string: A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.
DatabaseConnectorId string: (Required when entity_source=EXTERNAL_MYSQL_DATABASE_SYSTEM) (Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.
DatabaseDisplayName string: Display name of database
DatabaseId string: The OCID of the database.
DatabaseInsightId string
DatabaseName string: Name of database
DatabaseResourceType string: Oracle Cloud Infrastructure database resource type
DatabaseType string: Ops Insights internal representation of the database type.
DatabaseVersion string: The version of the database.
DbmPrivateEndpointId string
DefinedTags Dictionary<string, string>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
DeploymentType string
EnterpriseManagerBridgeId string: OPSI Enterprise Manager Bridge OCID
EnterpriseManagerEntityDisplayName string: Enterprise Manager Entity Display Name
EnterpriseManagerEntityIdentifier string: Enterprise Manager Entity Unique Identifier
EnterpriseManagerEntityName string: Enterprise Manager Entity Name
EnterpriseManagerEntityType string: Enterprise Manager Entity Type
EnterpriseManagerIdentifier string: Enterprise Manager Unqiue Identifier
EntitySource string: Source of the database entity.
ExadataInsightId string: The OCID of the Exadata insight.
FreeformTags Dictionary<string, string>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
Id string: Database insight identifier
IsAdvancedFeaturesEnabled bool: Flag is to identify if advanced features for autonomous database is enabled or not
IsHeatWaveClusterAttached bool: Specifies if MYSQL DB System has heatwave cluster attached.
IsHighlyAvailable bool: Specifies if MYSQL DB System is highly available.
LifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
ManagementAgentId string
OpsiPrivateEndpointId string: The OCID of the OPSI private endpoint
ParentId string: The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
ProcessorCount int: Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
RootId string: The OCID of the Exadata Infrastructure.
ServiceName string: Database service name used for connection requests.
State string: The current state of the database.
Status string: Indicates the status of a database insight in Operations Insights
SystemTags Dictionary<string, string>: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated string: The time the the database insight was first enabled. An RFC3339 formatted datetime string
TimeUpdated string: The time the database insight was updated. An RFC3339 formatted datetime string

CompartmentId string: Compartment identifier of the database
ConnectionCredentialDetails []GetDatabaseInsightConnectionCredentialDetail: User credential details to connect to the database.
ConnectionDetails []GetDatabaseInsightConnectionDetail: Connection details to connect to the database. HostName, protocol, and port should be specified.
ConnectorId string: The OCID of External Database Connector
CredentialDetails []GetDatabaseInsightCredentialDetail: User credential details to connect to the database.
DatabaseConnectionStatusDetails string: A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.
DatabaseConnectorId string: (Required when entity_source=EXTERNAL_MYSQL_DATABASE_SYSTEM) (Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.
DatabaseDisplayName string: Display name of database
DatabaseId string: The OCID of the database.
DatabaseInsightId string
DatabaseName string: Name of database
DatabaseResourceType string: Oracle Cloud Infrastructure database resource type
DatabaseType string: Ops Insights internal representation of the database type.
DatabaseVersion string: The version of the database.
DbmPrivateEndpointId string
DefinedTags map[string]string: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
DeploymentType string
EnterpriseManagerBridgeId string: OPSI Enterprise Manager Bridge OCID
EnterpriseManagerEntityDisplayName string: Enterprise Manager Entity Display Name
EnterpriseManagerEntityIdentifier string: Enterprise Manager Entity Unique Identifier
EnterpriseManagerEntityName string: Enterprise Manager Entity Name
EnterpriseManagerEntityType string: Enterprise Manager Entity Type
EnterpriseManagerIdentifier string: Enterprise Manager Unqiue Identifier
EntitySource string: Source of the database entity.
ExadataInsightId string: The OCID of the Exadata insight.
FreeformTags map[string]string: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
Id string: Database insight identifier
IsAdvancedFeaturesEnabled bool: Flag is to identify if advanced features for autonomous database is enabled or not
IsHeatWaveClusterAttached bool: Specifies if MYSQL DB System has heatwave cluster attached.
IsHighlyAvailable bool: Specifies if MYSQL DB System is highly available.
LifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
ManagementAgentId string
OpsiPrivateEndpointId string: The OCID of the OPSI private endpoint
ParentId string: The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
ProcessorCount int: Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
RootId string: The OCID of the Exadata Infrastructure.
ServiceName string: Database service name used for connection requests.
State string: The current state of the database.
Status string: Indicates the status of a database insight in Operations Insights
SystemTags map[string]string: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated string: The time the the database insight was first enabled. An RFC3339 formatted datetime string
TimeUpdated string: The time the database insight was updated. An RFC3339 formatted datetime string

compartmentId String: Compartment identifier of the database
connectionCredentialDetails List<GetDatabaseInsightConnectionCredentialDetail>: User credential details to connect to the database.
connectionDetails List<GetDatabaseInsightConnectionDetail>: Connection details to connect to the database. HostName, protocol, and port should be specified.
connectorId String: The OCID of External Database Connector
credentialDetails List<GetDatabaseInsightCredentialDetail>: User credential details to connect to the database.
databaseConnectionStatusDetails String: A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.
databaseConnectorId String: (Required when entity_source=EXTERNAL_MYSQL_DATABASE_SYSTEM) (Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.
databaseDisplayName String: Display name of database
databaseId String: The OCID of the database.
databaseInsightId String
databaseName String: Name of database
databaseResourceType String: Oracle Cloud Infrastructure database resource type
databaseType String: Ops Insights internal representation of the database type.
databaseVersion String: The version of the database.
dbmPrivateEndpointId String
definedTags Map<String,String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
deploymentType String
enterpriseManagerBridgeId String: OPSI Enterprise Manager Bridge OCID
enterpriseManagerEntityDisplayName String: Enterprise Manager Entity Display Name
enterpriseManagerEntityIdentifier String: Enterprise Manager Entity Unique Identifier
enterpriseManagerEntityName String: Enterprise Manager Entity Name
enterpriseManagerEntityType String: Enterprise Manager Entity Type
enterpriseManagerIdentifier String: Enterprise Manager Unqiue Identifier
entitySource String: Source of the database entity.
exadataInsightId String: The OCID of the Exadata insight.
freeformTags Map<String,String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id String: Database insight identifier
isAdvancedFeaturesEnabled Boolean: Flag is to identify if advanced features for autonomous database is enabled or not
isHeatWaveClusterAttached Boolean: Specifies if MYSQL DB System has heatwave cluster attached.
isHighlyAvailable Boolean: Specifies if MYSQL DB System is highly available.
lifecycleDetails String: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
managementAgentId String
opsiPrivateEndpointId String: The OCID of the OPSI private endpoint
parentId String: The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
processorCount Integer: Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
rootId String: The OCID of the Exadata Infrastructure.
serviceName String: Database service name used for connection requests.
state String: The current state of the database.
status String: Indicates the status of a database insight in Operations Insights
systemTags Map<String,String>: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated String: The time the the database insight was first enabled. An RFC3339 formatted datetime string
timeUpdated String: The time the database insight was updated. An RFC3339 formatted datetime string

compartmentId string: Compartment identifier of the database
connectionCredentialDetails GetDatabaseInsightConnectionCredentialDetail[]: User credential details to connect to the database.
connectionDetails GetDatabaseInsightConnectionDetail[]: Connection details to connect to the database. HostName, protocol, and port should be specified.
connectorId string: The OCID of External Database Connector
credentialDetails GetDatabaseInsightCredentialDetail[]: User credential details to connect to the database.
databaseConnectionStatusDetails string: A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.
databaseConnectorId string: (Required when entity_source=EXTERNAL_MYSQL_DATABASE_SYSTEM) (Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.
databaseDisplayName string: Display name of database
databaseId string: The OCID of the database.
databaseInsightId string
databaseName string: Name of database
databaseResourceType string: Oracle Cloud Infrastructure database resource type
databaseType string: Ops Insights internal representation of the database type.
databaseVersion string: The version of the database.
dbmPrivateEndpointId string
definedTags {[key: string]: string}: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
deploymentType string
enterpriseManagerBridgeId string: OPSI Enterprise Manager Bridge OCID
enterpriseManagerEntityDisplayName string: Enterprise Manager Entity Display Name
enterpriseManagerEntityIdentifier string: Enterprise Manager Entity Unique Identifier
enterpriseManagerEntityName string: Enterprise Manager Entity Name
enterpriseManagerEntityType string: Enterprise Manager Entity Type
enterpriseManagerIdentifier string: Enterprise Manager Unqiue Identifier
entitySource string: Source of the database entity.
exadataInsightId string: The OCID of the Exadata insight.
freeformTags {[key: string]: string}: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id string: Database insight identifier
isAdvancedFeaturesEnabled boolean: Flag is to identify if advanced features for autonomous database is enabled or not
isHeatWaveClusterAttached boolean: Specifies if MYSQL DB System has heatwave cluster attached.
isHighlyAvailable boolean: Specifies if MYSQL DB System is highly available.
lifecycleDetails string: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
managementAgentId string
opsiPrivateEndpointId string: The OCID of the OPSI private endpoint
parentId string: The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
processorCount number: Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
rootId string: The OCID of the Exadata Infrastructure.
serviceName string: Database service name used for connection requests.
state string: The current state of the database.
status string: Indicates the status of a database insight in Operations Insights
systemTags {[key: string]: string}: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated string: The time the the database insight was first enabled. An RFC3339 formatted datetime string
timeUpdated string: The time the database insight was updated. An RFC3339 formatted datetime string

compartment_id str: Compartment identifier of the database
connection_credential_details Sequence[opsi.GetDatabaseInsightConnectionCredentialDetail]: User credential details to connect to the database.
connection_details Sequence[opsi.GetDatabaseInsightConnectionDetail]: Connection details to connect to the database. HostName, protocol, and port should be specified.
connector_id str: The OCID of External Database Connector
credential_details Sequence[opsi.GetDatabaseInsightCredentialDetail]: User credential details to connect to the database.
database_connection_status_details str: A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.
database_connector_id str: (Required when entity_source=EXTERNAL_MYSQL_DATABASE_SYSTEM) (Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.
database_display_name str: Display name of database
database_id str: The OCID of the database.
database_insight_id str
database_name str: Name of database
database_resource_type str: Oracle Cloud Infrastructure database resource type
database_type str: Ops Insights internal representation of the database type.
database_version str: The version of the database.
dbm_private_endpoint_id str
defined_tags Mapping[str, str]: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
deployment_type str
enterprise_manager_bridge_id str: OPSI Enterprise Manager Bridge OCID
enterprise_manager_entity_display_name str: Enterprise Manager Entity Display Name
enterprise_manager_entity_identifier str: Enterprise Manager Entity Unique Identifier
enterprise_manager_entity_name str: Enterprise Manager Entity Name
enterprise_manager_entity_type str: Enterprise Manager Entity Type
enterprise_manager_identifier str: Enterprise Manager Unqiue Identifier
entity_source str: Source of the database entity.
exadata_insight_id str: The OCID of the Exadata insight.
freeform_tags Mapping[str, str]: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id str: Database insight identifier
is_advanced_features_enabled bool: Flag is to identify if advanced features for autonomous database is enabled or not
is_heat_wave_cluster_attached bool: Specifies if MYSQL DB System has heatwave cluster attached.
is_highly_available bool: Specifies if MYSQL DB System is highly available.
lifecycle_details str: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
management_agent_id str
opsi_private_endpoint_id str: The OCID of the OPSI private endpoint
parent_id str: The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
processor_count int: Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
root_id str: The OCID of the Exadata Infrastructure.
service_name str: Database service name used for connection requests.
state str: The current state of the database.
status str: Indicates the status of a database insight in Operations Insights
system_tags Mapping[str, str]: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
time_created str: The time the the database insight was first enabled. An RFC3339 formatted datetime string
time_updated str: The time the database insight was updated. An RFC3339 formatted datetime string

compartmentId String: Compartment identifier of the database
connectionCredentialDetails List<Property Map>: User credential details to connect to the database.
connectionDetails List<Property Map>: Connection details to connect to the database. HostName, protocol, and port should be specified.
connectorId String: The OCID of External Database Connector
credentialDetails List<Property Map>: User credential details to connect to the database.
databaseConnectionStatusDetails String: A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.
databaseConnectorId String: (Required when entity_source=EXTERNAL_MYSQL_DATABASE_SYSTEM) (Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.
databaseDisplayName String: Display name of database
databaseId String: The OCID of the database.
databaseInsightId String
databaseName String: Name of database
databaseResourceType String: Oracle Cloud Infrastructure database resource type
databaseType String: Ops Insights internal representation of the database type.
databaseVersion String: The version of the database.
dbmPrivateEndpointId String
definedTags Map<String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
deploymentType String
enterpriseManagerBridgeId String: OPSI Enterprise Manager Bridge OCID
enterpriseManagerEntityDisplayName String: Enterprise Manager Entity Display Name
enterpriseManagerEntityIdentifier String: Enterprise Manager Entity Unique Identifier
enterpriseManagerEntityName String: Enterprise Manager Entity Name
enterpriseManagerEntityType String: Enterprise Manager Entity Type
enterpriseManagerIdentifier String: Enterprise Manager Unqiue Identifier
entitySource String: Source of the database entity.
exadataInsightId String: The OCID of the Exadata insight.
freeformTags Map<String>: Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
id String: Database insight identifier
isAdvancedFeaturesEnabled Boolean: Flag is to identify if advanced features for autonomous database is enabled or not
isHeatWaveClusterAttached Boolean: Specifies if MYSQL DB System has heatwave cluster attached.
isHighlyAvailable Boolean: Specifies if MYSQL DB System is highly available.
lifecycleDetails String: A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
managementAgentId String
opsiPrivateEndpointId String: The OCID of the OPSI private endpoint
parentId String: The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
processorCount Number: Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
rootId String: The OCID of the Exadata Infrastructure.
serviceName String: Database service name used for connection requests.
state String: The current state of the database.
status String: Indicates the status of a database insight in Operations Insights
systemTags Map<String>: System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated String: The time the the database insight was first enabled. An RFC3339 formatted datetime string
timeUpdated String: The time the database insight was updated. An RFC3339 formatted datetime string

Supporting Types

GetDatabaseInsightConnectionCredentialDetail

CredentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
CredentialType string: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
PasswordSecretId string: The secret OCID mapping to the database credentials.
Role string: database user role.
UserName string: database user name.

CredentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
CredentialType string: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
PasswordSecretId string: The secret OCID mapping to the database credentials.
Role string: database user role.
UserName string: database user name.

credentialSourceName String: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
credentialType String: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
passwordSecretId String: The secret OCID mapping to the database credentials.
role String: database user role.
userName String: database user name.

credentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
credentialType string: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
passwordSecretId string: The secret OCID mapping to the database credentials.
role string: database user role.
userName string: database user name.

credential_source_name str: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
credential_type str: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
password_secret_id str: The secret OCID mapping to the database credentials.
role str: database user role.
user_name str: database user name.

credentialSourceName String: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
credentialType String: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
passwordSecretId String: The secret OCID mapping to the database credentials.
role String: database user role.
userName String: database user name.

GetDatabaseInsightConnectionDetail

HostName string: Name of the listener host that will be used to create the connect string to the database.
Hosts List<GetDatabaseInsightConnectionDetailHost>: List of hosts and port for private endpoint accessed database resource.
Port int: Listener port number used for connection requests.
Protocol string: Protocol used for connection requests for private endpoint accssed database resource.
ServiceName string: Database service name used for connection requests.

HostName string: Name of the listener host that will be used to create the connect string to the database.
Hosts []GetDatabaseInsightConnectionDetailHost: List of hosts and port for private endpoint accessed database resource.
Port int: Listener port number used for connection requests.
Protocol string: Protocol used for connection requests for private endpoint accssed database resource.
ServiceName string: Database service name used for connection requests.

hostName String: Name of the listener host that will be used to create the connect string to the database.
hosts List<GetDatabaseInsightConnectionDetailHost>: List of hosts and port for private endpoint accessed database resource.
port Integer: Listener port number used for connection requests.
protocol String: Protocol used for connection requests for private endpoint accssed database resource.
serviceName String: Database service name used for connection requests.

hostName string: Name of the listener host that will be used to create the connect string to the database.
hosts GetDatabaseInsightConnectionDetailHost[]: List of hosts and port for private endpoint accessed database resource.
port number: Listener port number used for connection requests.
protocol string: Protocol used for connection requests for private endpoint accssed database resource.
serviceName string: Database service name used for connection requests.

host_name str: Name of the listener host that will be used to create the connect string to the database.
hosts Sequence[opsi.GetDatabaseInsightConnectionDetailHost]: List of hosts and port for private endpoint accessed database resource.
port int: Listener port number used for connection requests.
protocol str: Protocol used for connection requests for private endpoint accssed database resource.
service_name str: Database service name used for connection requests.

hostName String: Name of the listener host that will be used to create the connect string to the database.
hosts List<Property Map>: List of hosts and port for private endpoint accessed database resource.
port Number: Listener port number used for connection requests.
protocol String: Protocol used for connection requests for private endpoint accssed database resource.
serviceName String: Database service name used for connection requests.

GetDatabaseInsightConnectionDetailHost

HostIp string: Host IP used for connection requests for Cloud DB resource.
Port int: Listener port number used for connection requests.

HostIp string: Host IP used for connection requests for Cloud DB resource.
Port int: Listener port number used for connection requests.

hostIp String: Host IP used for connection requests for Cloud DB resource.
port Integer: Listener port number used for connection requests.

hostIp string: Host IP used for connection requests for Cloud DB resource.
port number: Listener port number used for connection requests.

host_ip str: Host IP used for connection requests for Cloud DB resource.
port int: Listener port number used for connection requests.

hostIp String: Host IP used for connection requests for Cloud DB resource.
port Number: Listener port number used for connection requests.

GetDatabaseInsightCredentialDetail

CredentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
CredentialType string: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
PasswordSecretId string: The secret OCID mapping to the database credentials.
Role string: database user role.
UserName string: database user name.
WalletSecretId string: The OCID of the Secret where the database keystore contents are stored.

CredentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
CredentialType string: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
PasswordSecretId string: The secret OCID mapping to the database credentials.
Role string: database user role.
UserName string: database user name.
WalletSecretId string: The OCID of the Secret where the database keystore contents are stored.

credentialSourceName String: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
credentialType String: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
passwordSecretId String: The secret OCID mapping to the database credentials.
role String: database user role.
userName String: database user name.
walletSecretId String: The OCID of the Secret where the database keystore contents are stored.

credentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
credentialType string: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
passwordSecretId string: The secret OCID mapping to the database credentials.
role string: database user role.
userName string: database user name.
walletSecretId string: The OCID of the Secret where the database keystore contents are stored.

credential_source_name str: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
credential_type str: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
password_secret_id str: The secret OCID mapping to the database credentials.
role str: database user role.
user_name str: database user name.
wallet_secret_id str: The OCID of the Secret where the database keystore contents are stored.

credentialSourceName String: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
credentialType String: CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
passwordSecretId String: The secret OCID mapping to the database credentials.
role String: database user role.
userName String: database user name.
walletSecretId String: The OCID of the Secret where the database keystore contents are stored.

Package Details

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

Oracle Cloud Infrastructure v2.29.0 published on Wednesday, Apr 9, 2025 by Pulumi

pulumi/pulumi-oci

oci.Opsi.getDatabaseInsight

On this page

On this page

Example Usage

Using getDatabaseInsight

getDatabaseInsight Result

Supporting Types

GetDatabaseInsightConnectionCredentialDetail

GetDatabaseInsightConnectionDetail

GetDatabaseInsightConnectionDetailHost

GetDatabaseInsightCredentialDetail

Package Details

On this page

On this page