Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Opsi
  5. getDatabaseInsight
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.Opsi.getDatabaseInsight

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides details about a specific Database Insight resource in Oracle Cloud Infrastructure Opsi service.

    Gets details of a database insight.

    Example Usage

    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.

    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 LookupDatabaseInsight(ctx *Context, args *LookupDatabaseInsightArgs, opts ...InvokeOption) (*LookupDatabaseInsightResult, error)
func LookupDatabaseInsightOutput(ctx *Context, args *LookupDatabaseInsightOutputArgs, opts ...InvokeOption) LookupDatabaseInsightResultOutput

    > Note: This function is named LookupDatabaseInsight 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[GetDatabaseInsightConnectionCredentialDetail]
    User credential details to connect to the database.
    connection_details Sequence[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[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[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.
    oci logo
    Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci