Oracle Cloud Infrastructure v2.33.0, May 1 25

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

oci.Opsi.DatabaseInsight

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

pulumi/pulumi-oci

Example Usage

Create DatabaseInsight Resource

Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

Constructor syntax

new DatabaseInsight(name: string, args: DatabaseInsightArgs, opts?: CustomResourceOptions);

@overload
def DatabaseInsight(resource_name: str,
                    args: DatabaseInsightArgs,
                    opts: Optional[ResourceOptions] = None)

@overload
def DatabaseInsight(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    compartment_id: Optional[str] = None,
                    entity_source: Optional[str] = None,
                    database_connection_status_details: Optional[str] = None,
                    enterprise_manager_entity_identifier: Optional[str] = None,
                    credential_details: Optional[DatabaseInsightCredentialDetailsArgs] = None,
                    connection_details: Optional[DatabaseInsightConnectionDetailsArgs] = None,
                    database_connector_id: Optional[str] = None,
                    database_id: Optional[str] = None,
                    database_resource_type: Optional[str] = None,
                    dbm_private_endpoint_id: Optional[str] = None,
                    defined_tags: Optional[Mapping[str, str]] = None,
                    deployment_type: Optional[str] = None,
                    enterprise_manager_bridge_id: Optional[str] = None,
                    connector_id: Optional[str] = None,
                    enterprise_manager_identifier: Optional[str] = None,
                    connection_credential_details: Optional[DatabaseInsightConnectionCredentialDetailsArgs] = None,
                    exadata_insight_id: Optional[str] = None,
                    freeform_tags: Optional[Mapping[str, str]] = None,
                    is_advanced_features_enabled: Optional[bool] = None,
                    management_agent_id: Optional[str] = None,
                    opsi_private_endpoint_id: Optional[str] = None,
                    service_name: Optional[str] = None,
                    status: Optional[str] = None)

func NewDatabaseInsight(ctx *Context, name string, args DatabaseInsightArgs, opts ...ResourceOption) (*DatabaseInsight, error)

public DatabaseInsight(string name, DatabaseInsightArgs args, CustomResourceOptions? opts = null)

public DatabaseInsight(String name, DatabaseInsightArgs args)
public DatabaseInsight(String name, DatabaseInsightArgs args, CustomResourceOptions options)

type: oci:Opsi:DatabaseInsight
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name string: The unique name of the resource.
args DatabaseInsightArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args DatabaseInsightArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args DatabaseInsightArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args DatabaseInsightArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args DatabaseInsightArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

Constructor example

The following reference example uses placeholder values for all input properties.

var databaseInsightResource = new Oci.Opsi.DatabaseInsight("databaseInsightResource", new()
{
    CompartmentId = "string",
    EntitySource = "string",
    DatabaseConnectionStatusDetails = "string",
    EnterpriseManagerEntityIdentifier = "string",
    CredentialDetails = new Oci.Opsi.Inputs.DatabaseInsightCredentialDetailsArgs
    {
        CredentialType = "string",
        CredentialSourceName = "string",
        PasswordSecretId = "string",
        Role = "string",
        UserName = "string",
        WalletSecretId = "string",
    },
    ConnectionDetails = new Oci.Opsi.Inputs.DatabaseInsightConnectionDetailsArgs
    {
        HostName = "string",
        Hosts = new[]
        {
            new Oci.Opsi.Inputs.DatabaseInsightConnectionDetailsHostArgs
            {
                HostIp = "string",
                Port = 0,
            },
        },
        Port = 0,
        Protocol = "string",
        ServiceName = "string",
    },
    DatabaseConnectorId = "string",
    DatabaseId = "string",
    DatabaseResourceType = "string",
    DbmPrivateEndpointId = "string",
    DefinedTags = 
    {
        { "string", "string" },
    },
    DeploymentType = "string",
    EnterpriseManagerBridgeId = "string",
    ConnectorId = "string",
    EnterpriseManagerIdentifier = "string",
    ConnectionCredentialDetails = new Oci.Opsi.Inputs.DatabaseInsightConnectionCredentialDetailsArgs
    {
        CredentialType = "string",
        CredentialSourceName = "string",
        PasswordSecretId = "string",
        Role = "string",
        UserName = "string",
    },
    ExadataInsightId = "string",
    FreeformTags = 
    {
        { "string", "string" },
    },
    IsAdvancedFeaturesEnabled = false,
    ManagementAgentId = "string",
    OpsiPrivateEndpointId = "string",
    ServiceName = "string",
    Status = "string",
});

example, err := opsi.NewDatabaseInsight(ctx, "databaseInsightResource", &opsi.DatabaseInsightArgs{
	CompartmentId:                     pulumi.String("string"),
	EntitySource:                      pulumi.String("string"),
	DatabaseConnectionStatusDetails:   pulumi.String("string"),
	EnterpriseManagerEntityIdentifier: pulumi.String("string"),
	CredentialDetails: &opsi.DatabaseInsightCredentialDetailsArgs{
		CredentialType:       pulumi.String("string"),
		CredentialSourceName: pulumi.String("string"),
		PasswordSecretId:     pulumi.String("string"),
		Role:                 pulumi.String("string"),
		UserName:             pulumi.String("string"),
		WalletSecretId:       pulumi.String("string"),
	},
	ConnectionDetails: &opsi.DatabaseInsightConnectionDetailsArgs{
		HostName: pulumi.String("string"),
		Hosts: opsi.DatabaseInsightConnectionDetailsHostArray{
			&opsi.DatabaseInsightConnectionDetailsHostArgs{
				HostIp: pulumi.String("string"),
				Port:   pulumi.Int(0),
			},
		},
		Port:        pulumi.Int(0),
		Protocol:    pulumi.String("string"),
		ServiceName: pulumi.String("string"),
	},
	DatabaseConnectorId:  pulumi.String("string"),
	DatabaseId:           pulumi.String("string"),
	DatabaseResourceType: pulumi.String("string"),
	DbmPrivateEndpointId: pulumi.String("string"),
	DefinedTags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	DeploymentType:              pulumi.String("string"),
	EnterpriseManagerBridgeId:   pulumi.String("string"),
	ConnectorId:                 pulumi.String("string"),
	EnterpriseManagerIdentifier: pulumi.String("string"),
	ConnectionCredentialDetails: &opsi.DatabaseInsightConnectionCredentialDetailsArgs{
		CredentialType:       pulumi.String("string"),
		CredentialSourceName: pulumi.String("string"),
		PasswordSecretId:     pulumi.String("string"),
		Role:                 pulumi.String("string"),
		UserName:             pulumi.String("string"),
	},
	ExadataInsightId: pulumi.String("string"),
	FreeformTags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	IsAdvancedFeaturesEnabled: pulumi.Bool(false),
	ManagementAgentId:         pulumi.String("string"),
	OpsiPrivateEndpointId:     pulumi.String("string"),
	ServiceName:               pulumi.String("string"),
	Status:                    pulumi.String("string"),
})

var databaseInsightResource = new DatabaseInsight("databaseInsightResource", DatabaseInsightArgs.builder()
    .compartmentId("string")
    .entitySource("string")
    .databaseConnectionStatusDetails("string")
    .enterpriseManagerEntityIdentifier("string")
    .credentialDetails(DatabaseInsightCredentialDetailsArgs.builder()
        .credentialType("string")
        .credentialSourceName("string")
        .passwordSecretId("string")
        .role("string")
        .userName("string")
        .walletSecretId("string")
        .build())
    .connectionDetails(DatabaseInsightConnectionDetailsArgs.builder()
        .hostName("string")
        .hosts(DatabaseInsightConnectionDetailsHostArgs.builder()
            .hostIp("string")
            .port(0)
            .build())
        .port(0)
        .protocol("string")
        .serviceName("string")
        .build())
    .databaseConnectorId("string")
    .databaseId("string")
    .databaseResourceType("string")
    .dbmPrivateEndpointId("string")
    .definedTags(Map.of("string", "string"))
    .deploymentType("string")
    .enterpriseManagerBridgeId("string")
    .connectorId("string")
    .enterpriseManagerIdentifier("string")
    .connectionCredentialDetails(DatabaseInsightConnectionCredentialDetailsArgs.builder()
        .credentialType("string")
        .credentialSourceName("string")
        .passwordSecretId("string")
        .role("string")
        .userName("string")
        .build())
    .exadataInsightId("string")
    .freeformTags(Map.of("string", "string"))
    .isAdvancedFeaturesEnabled(false)
    .managementAgentId("string")
    .opsiPrivateEndpointId("string")
    .serviceName("string")
    .status("string")
    .build());

database_insight_resource = oci.opsi.DatabaseInsight("databaseInsightResource",
    compartment_id="string",
    entity_source="string",
    database_connection_status_details="string",
    enterprise_manager_entity_identifier="string",
    credential_details={
        "credential_type": "string",
        "credential_source_name": "string",
        "password_secret_id": "string",
        "role": "string",
        "user_name": "string",
        "wallet_secret_id": "string",
    },
    connection_details={
        "host_name": "string",
        "hosts": [{
            "host_ip": "string",
            "port": 0,
        }],
        "port": 0,
        "protocol": "string",
        "service_name": "string",
    },
    database_connector_id="string",
    database_id="string",
    database_resource_type="string",
    dbm_private_endpoint_id="string",
    defined_tags={
        "string": "string",
    },
    deployment_type="string",
    enterprise_manager_bridge_id="string",
    connector_id="string",
    enterprise_manager_identifier="string",
    connection_credential_details={
        "credential_type": "string",
        "credential_source_name": "string",
        "password_secret_id": "string",
        "role": "string",
        "user_name": "string",
    },
    exadata_insight_id="string",
    freeform_tags={
        "string": "string",
    },
    is_advanced_features_enabled=False,
    management_agent_id="string",
    opsi_private_endpoint_id="string",
    service_name="string",
    status="string")

const databaseInsightResource = new oci.opsi.DatabaseInsight("databaseInsightResource", {
    compartmentId: "string",
    entitySource: "string",
    databaseConnectionStatusDetails: "string",
    enterpriseManagerEntityIdentifier: "string",
    credentialDetails: {
        credentialType: "string",
        credentialSourceName: "string",
        passwordSecretId: "string",
        role: "string",
        userName: "string",
        walletSecretId: "string",
    },
    connectionDetails: {
        hostName: "string",
        hosts: [{
            hostIp: "string",
            port: 0,
        }],
        port: 0,
        protocol: "string",
        serviceName: "string",
    },
    databaseConnectorId: "string",
    databaseId: "string",
    databaseResourceType: "string",
    dbmPrivateEndpointId: "string",
    definedTags: {
        string: "string",
    },
    deploymentType: "string",
    enterpriseManagerBridgeId: "string",
    connectorId: "string",
    enterpriseManagerIdentifier: "string",
    connectionCredentialDetails: {
        credentialType: "string",
        credentialSourceName: "string",
        passwordSecretId: "string",
        role: "string",
        userName: "string",
    },
    exadataInsightId: "string",
    freeformTags: {
        string: "string",
    },
    isAdvancedFeaturesEnabled: false,
    managementAgentId: "string",
    opsiPrivateEndpointId: "string",
    serviceName: "string",
    status: "string",
});

type: oci:Opsi:DatabaseInsight
properties:
    compartmentId: string
    connectionCredentialDetails:
        credentialSourceName: string
        credentialType: string
        passwordSecretId: string
        role: string
        userName: string
    connectionDetails:
        hostName: string
        hosts:
            - hostIp: string
              port: 0
        port: 0
        protocol: string
        serviceName: string
    connectorId: string
    credentialDetails:
        credentialSourceName: string
        credentialType: string
        passwordSecretId: string
        role: string
        userName: string
        walletSecretId: string
    databaseConnectionStatusDetails: string
    databaseConnectorId: string
    databaseId: string
    databaseResourceType: string
    dbmPrivateEndpointId: string
    definedTags:
        string: string
    deploymentType: string
    enterpriseManagerBridgeId: string
    enterpriseManagerEntityIdentifier: string
    enterpriseManagerIdentifier: string
    entitySource: string
    exadataInsightId: string
    freeformTags:
        string: string
    isAdvancedFeaturesEnabled: false
    managementAgentId: string
    opsiPrivateEndpointId: string
    serviceName: string
    status: string

DatabaseInsight Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

The DatabaseInsight resource accepts the following input properties:

CompartmentId string

(Updatable) Compartment Identifier of database

EntitySource string

(Updatable) Source of the database entity.

ConnectionCredentialDetails DatabaseInsightConnectionCredentialDetails

User credential details to connect to the database.

ConnectionDetails DatabaseInsightConnectionDetails

Connection details to connect to the database. HostName, protocol, and port should be specified.

ConnectorId string

The OCID of External Database Connector

CredentialDetails DatabaseInsightCredentialDetails

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

(Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.

DatabaseId string

The OCID of the database.

DatabaseResourceType string

Oracle Cloud Infrastructure database resource type

DbmPrivateEndpointId string

The OCID of the Database Management private endpoint. This field and opsi_private_endpoint_id are mutually exclusive. If DBM private endpoint ID is provided, a new OPSI private endpoint ID will be created.

DefinedTags Dictionary<string, string>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

DeploymentType string

Database Deployment Type (EXACS will be supported in the future)

EnterpriseManagerBridgeId string

OPSI Enterprise Manager Bridge OCID

EnterpriseManagerEntityIdentifier string

Enterprise Manager Entity Unique Identifier

EnterpriseManagerIdentifier string

Enterprise Manager Unique Identifier

ExadataInsightId string

The OCID of the Exadata insight.

FreeformTags Dictionary<string, string>

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

IsAdvancedFeaturesEnabled bool

Flag is to identify if advanced features for autonomous database is enabled or not

ManagementAgentId string

The OCID of the Management Agent

OpsiPrivateEndpointId string

The OCID of the OPSI private endpoint

ServiceName string

Database service name used for connection requests.

Status string

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values. The resource destruction here is basically a soft delete. User cannot create resource using the same EM managed bridge OCID. If resource is in enabled state during destruction, the resource will be disabled automatically before performing delete operation.

CompartmentId string

(Updatable) Compartment Identifier of database

EntitySource string

(Updatable) Source of the database entity.

ConnectionCredentialDetails DatabaseInsightConnectionCredentialDetailsArgs

User credential details to connect to the database.

ConnectionDetails DatabaseInsightConnectionDetailsArgs

Connection details to connect to the database. HostName, protocol, and port should be specified.

ConnectorId string

The OCID of External Database Connector

CredentialDetails DatabaseInsightCredentialDetailsArgs

User credential details to connect to the database.

DatabaseConnectionStatusDetails string

DatabaseConnectorId string

(Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.

DatabaseId string

The OCID of the database.

DatabaseResourceType string

Oracle Cloud Infrastructure database resource type

DbmPrivateEndpointId string

DefinedTags map[string]string

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

DeploymentType string

Database Deployment Type (EXACS will be supported in the future)

EnterpriseManagerBridgeId string

OPSI Enterprise Manager Bridge OCID

EnterpriseManagerEntityIdentifier string

Enterprise Manager Entity Unique Identifier

EnterpriseManagerIdentifier string

Enterprise Manager Unique Identifier

ExadataInsightId string

The OCID of the Exadata insight.

FreeformTags map[string]string

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

IsAdvancedFeaturesEnabled bool

Flag is to identify if advanced features for autonomous database is enabled or not

ManagementAgentId string

The OCID of the Management Agent

OpsiPrivateEndpointId string

The OCID of the OPSI private endpoint

ServiceName string

Database service name used for connection requests.

Status string

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

compartmentId String

(Updatable) Compartment Identifier of database

entitySource String

(Updatable) Source of the database entity.

connectionCredentialDetails DatabaseInsightConnectionCredentialDetails

User credential details to connect to the database.

connectionDetails DatabaseInsightConnectionDetails

Connection details to connect to the database. HostName, protocol, and port should be specified.

connectorId String

The OCID of External Database Connector

credentialDetails DatabaseInsightCredentialDetails

User credential details to connect to the database.

databaseConnectionStatusDetails String

databaseConnectorId String

(Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.

databaseId String

The OCID of the database.

databaseResourceType String

Oracle Cloud Infrastructure database resource type

dbmPrivateEndpointId String

definedTags Map<String,String>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deploymentType String

Database Deployment Type (EXACS will be supported in the future)

enterpriseManagerBridgeId String

OPSI Enterprise Manager Bridge OCID

enterpriseManagerEntityIdentifier String

Enterprise Manager Entity Unique Identifier

enterpriseManagerIdentifier String

Enterprise Manager Unique Identifier

exadataInsightId String

The OCID of the Exadata insight.

freeformTags Map<String,String>

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

isAdvancedFeaturesEnabled Boolean

Flag is to identify if advanced features for autonomous database is enabled or not

managementAgentId String

The OCID of the Management Agent

opsiPrivateEndpointId String

The OCID of the OPSI private endpoint

serviceName String

Database service name used for connection requests.

status String

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

compartmentId string

(Updatable) Compartment Identifier of database

entitySource string

(Updatable) Source of the database entity.

connectionCredentialDetails DatabaseInsightConnectionCredentialDetails

User credential details to connect to the database.

connectionDetails DatabaseInsightConnectionDetails

Connection details to connect to the database. HostName, protocol, and port should be specified.

connectorId string

The OCID of External Database Connector

credentialDetails DatabaseInsightCredentialDetails

User credential details to connect to the database.

databaseConnectionStatusDetails string

databaseConnectorId string

(Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.

databaseId string

The OCID of the database.

databaseResourceType string

Oracle Cloud Infrastructure database resource type

dbmPrivateEndpointId string

definedTags {[key: string]: string}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deploymentType string

Database Deployment Type (EXACS will be supported in the future)

enterpriseManagerBridgeId string

OPSI Enterprise Manager Bridge OCID

enterpriseManagerEntityIdentifier string

Enterprise Manager Entity Unique Identifier

enterpriseManagerIdentifier string

Enterprise Manager Unique Identifier

exadataInsightId string

The OCID of the Exadata insight.

freeformTags {[key: string]: string}

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

isAdvancedFeaturesEnabled boolean

Flag is to identify if advanced features for autonomous database is enabled or not

managementAgentId string

The OCID of the Management Agent

opsiPrivateEndpointId string

The OCID of the OPSI private endpoint

serviceName string

Database service name used for connection requests.

status string

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

compartment_id str

(Updatable) Compartment Identifier of database

entity_source str

(Updatable) Source of the database entity.

connection_credential_details DatabaseInsightConnectionCredentialDetailsArgs

User credential details to connect to the database.

connection_details DatabaseInsightConnectionDetailsArgs

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 DatabaseInsightCredentialDetailsArgs

User credential details to connect to the database.

database_connection_status_details str

database_connector_id str

(Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.

database_id str

The OCID of the database.

database_resource_type str

Oracle Cloud Infrastructure database resource type

dbm_private_endpoint_id str

defined_tags Mapping[str, str]

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deployment_type str

Database Deployment Type (EXACS will be supported in the future)

enterprise_manager_bridge_id str

OPSI Enterprise Manager Bridge OCID

enterprise_manager_entity_identifier str

Enterprise Manager Entity Unique Identifier

enterprise_manager_identifier str

Enterprise Manager Unique Identifier

exadata_insight_id str

The OCID of the Exadata insight.

freeform_tags Mapping[str, str]

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

is_advanced_features_enabled bool

Flag is to identify if advanced features for autonomous database is enabled or not

management_agent_id str

The OCID of the Management Agent

opsi_private_endpoint_id str

The OCID of the OPSI private endpoint

service_name str

Database service name used for connection requests.

status str

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

compartmentId String

(Updatable) Compartment Identifier of database

entitySource String

(Updatable) Source of the database entity.

connectionCredentialDetails Property Map

User credential details to connect to the database.

connectionDetails 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 Property Map

User credential details to connect to the database.

databaseConnectionStatusDetails String

databaseConnectorId String

(Updatable) The DBM owned database connector OCID mapping to the database credentials and connection details.

databaseId String

The OCID of the database.

databaseResourceType String

Oracle Cloud Infrastructure database resource type

dbmPrivateEndpointId String

definedTags Map<String>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deploymentType String

Database Deployment Type (EXACS will be supported in the future)

enterpriseManagerBridgeId String

OPSI Enterprise Manager Bridge OCID

enterpriseManagerEntityIdentifier String

Enterprise Manager Entity Unique Identifier

enterpriseManagerIdentifier String

Enterprise Manager Unique Identifier

exadataInsightId String

The OCID of the Exadata insight.

freeformTags Map<String>

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

isAdvancedFeaturesEnabled Boolean

Flag is to identify if advanced features for autonomous database is enabled or not

managementAgentId String

The OCID of the Management Agent

opsiPrivateEndpointId String

The OCID of the OPSI private endpoint

serviceName String

Database service name used for connection requests.

status String

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

Outputs

All input properties are implicitly available as output properties. Additionally, the DatabaseInsight resource produces the following output properties:

DatabaseDisplayName string: Display name of database
DatabaseName string: Name of database
DatabaseType string: Ops Insights internal representation of the database type.
DatabaseVersion string: The version of the database.
EnterpriseManagerEntityDisplayName string: Enterprise Manager Entity Display Name
EnterpriseManagerEntityName string: Enterprise Manager Entity Name
EnterpriseManagerEntityType string: Enterprise Manager Entity Type
Id string: The provider-assigned unique ID for this managed resource.
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.
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.
State string: The current state of the database.
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 database insight was first enabled. An RFC3339 formatted datetime string
TimeUpdated string: The time the database insight was updated. An RFC3339 formatted datetime string

DatabaseDisplayName string: Display name of database
DatabaseName string: Name of database
DatabaseType string: Ops Insights internal representation of the database type.
DatabaseVersion string: The version of the database.
EnterpriseManagerEntityDisplayName string: Enterprise Manager Entity Display Name
EnterpriseManagerEntityName string: Enterprise Manager Entity Name
EnterpriseManagerEntityType string: Enterprise Manager Entity Type
Id string: The provider-assigned unique ID for this managed resource.
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.
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.
State string: The current state of the database.
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 database insight was first enabled. An RFC3339 formatted datetime string
TimeUpdated string: The time the database insight was updated. An RFC3339 formatted datetime string

databaseDisplayName String: Display name of database
databaseName String: Name of database
databaseType String: Ops Insights internal representation of the database type.
databaseVersion String: The version of the database.
enterpriseManagerEntityDisplayName String: Enterprise Manager Entity Display Name
enterpriseManagerEntityName String: Enterprise Manager Entity Name
enterpriseManagerEntityType String: Enterprise Manager Entity Type
id String: The provider-assigned unique ID for this managed resource.
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.
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.
state String: The current state of the database.
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 database insight was first enabled. An RFC3339 formatted datetime string
timeUpdated String: The time the database insight was updated. An RFC3339 formatted datetime string

databaseDisplayName string: Display name of database
databaseName string: Name of database
databaseType string: Ops Insights internal representation of the database type.
databaseVersion string: The version of the database.
enterpriseManagerEntityDisplayName string: Enterprise Manager Entity Display Name
enterpriseManagerEntityName string: Enterprise Manager Entity Name
enterpriseManagerEntityType string: Enterprise Manager Entity Type
id string: The provider-assigned unique ID for this managed resource.
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.
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.
state string: The current state of the database.
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 database insight was first enabled. An RFC3339 formatted datetime string
timeUpdated string: The time the database insight was updated. An RFC3339 formatted datetime string

database_display_name str: Display name of database
database_name str: Name of database
database_type str: Ops Insights internal representation of the database type.
database_version str: The version of the database.
enterprise_manager_entity_display_name str: Enterprise Manager Entity Display Name
enterprise_manager_entity_name str: Enterprise Manager Entity Name
enterprise_manager_entity_type str: Enterprise Manager Entity Type
id str: The provider-assigned unique ID for this managed resource.
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.
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.
state str: The current state of the database.
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 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

databaseDisplayName String: Display name of database
databaseName String: Name of database
databaseType String: Ops Insights internal representation of the database type.
databaseVersion String: The version of the database.
enterpriseManagerEntityDisplayName String: Enterprise Manager Entity Display Name
enterpriseManagerEntityName String: Enterprise Manager Entity Name
enterpriseManagerEntityType String: Enterprise Manager Entity Type
id String: The provider-assigned unique ID for this managed resource.
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.
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.
state String: The current state of the database.
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 database insight was first enabled. An RFC3339 formatted datetime string
timeUpdated String: The time the database insight was updated. An RFC3339 formatted datetime string

Look up Existing DatabaseInsight Resource

Get an existing DatabaseInsight resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: DatabaseInsightState, opts?: CustomResourceOptions): DatabaseInsight

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        compartment_id: Optional[str] = None,
        connection_credential_details: Optional[DatabaseInsightConnectionCredentialDetailsArgs] = None,
        connection_details: Optional[DatabaseInsightConnectionDetailsArgs] = None,
        connector_id: Optional[str] = None,
        credential_details: Optional[DatabaseInsightCredentialDetailsArgs] = None,
        database_connection_status_details: Optional[str] = None,
        database_connector_id: Optional[str] = None,
        database_display_name: Optional[str] = None,
        database_id: Optional[str] = None,
        database_name: Optional[str] = None,
        database_resource_type: Optional[str] = None,
        database_type: Optional[str] = None,
        database_version: Optional[str] = None,
        dbm_private_endpoint_id: Optional[str] = None,
        defined_tags: Optional[Mapping[str, str]] = None,
        deployment_type: Optional[str] = None,
        enterprise_manager_bridge_id: Optional[str] = None,
        enterprise_manager_entity_display_name: Optional[str] = None,
        enterprise_manager_entity_identifier: Optional[str] = None,
        enterprise_manager_entity_name: Optional[str] = None,
        enterprise_manager_entity_type: Optional[str] = None,
        enterprise_manager_identifier: Optional[str] = None,
        entity_source: Optional[str] = None,
        exadata_insight_id: Optional[str] = None,
        freeform_tags: Optional[Mapping[str, str]] = None,
        is_advanced_features_enabled: Optional[bool] = None,
        is_heat_wave_cluster_attached: Optional[bool] = None,
        is_highly_available: Optional[bool] = None,
        lifecycle_details: Optional[str] = None,
        management_agent_id: Optional[str] = None,
        opsi_private_endpoint_id: Optional[str] = None,
        parent_id: Optional[str] = None,
        processor_count: Optional[int] = None,
        root_id: Optional[str] = None,
        service_name: Optional[str] = None,
        state: Optional[str] = None,
        status: Optional[str] = None,
        system_tags: Optional[Mapping[str, str]] = None,
        time_created: Optional[str] = None,
        time_updated: Optional[str] = None) -> DatabaseInsight

func GetDatabaseInsight(ctx *Context, name string, id IDInput, state *DatabaseInsightState, opts ...ResourceOption) (*DatabaseInsight, error)

public static DatabaseInsight Get(string name, Input<string> id, DatabaseInsightState? state, CustomResourceOptions? opts = null)

public static DatabaseInsight get(String name, Output<String> id, DatabaseInsightState state, CustomResourceOptions options)

resources:  _:    type: oci:Opsi:DatabaseInsight    get:      id: ${id}

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

resource_name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

The following state arguments are supported:

CompartmentId string

(Updatable) Compartment Identifier of database

ConnectionCredentialDetails DatabaseInsightConnectionCredentialDetails

User credential details to connect to the database.

ConnectionDetails DatabaseInsightConnectionDetails

Connection details to connect to the database. HostName, protocol, and port should be specified.

ConnectorId string

The OCID of External Database Connector

CredentialDetails DatabaseInsightCredentialDetails

User credential details to connect to the database.

DatabaseConnectionStatusDetails string

DatabaseConnectorId string

(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.

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>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

DeploymentType string

Database Deployment Type (EXACS will be supported in the future)

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 Unique Identifier

EntitySource string

(Updatable) Source of the database entity.

ExadataInsightId string

The OCID of the Exadata insight.

FreeformTags Dictionary<string, string>

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

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

The OCID of the Management Agent

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

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

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 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

(Updatable) Compartment Identifier of database

ConnectionCredentialDetails DatabaseInsightConnectionCredentialDetailsArgs

User credential details to connect to the database.

ConnectionDetails DatabaseInsightConnectionDetailsArgs

Connection details to connect to the database. HostName, protocol, and port should be specified.

ConnectorId string

The OCID of External Database Connector

CredentialDetails DatabaseInsightCredentialDetailsArgs

User credential details to connect to the database.

DatabaseConnectionStatusDetails string

DatabaseConnectorId string

(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.

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

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

DeploymentType string

Database Deployment Type (EXACS will be supported in the future)

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 Unique Identifier

EntitySource string

(Updatable) Source of the database entity.

ExadataInsightId string

The OCID of the Exadata insight.

FreeformTags map[string]string

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

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

The OCID of the Management Agent

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

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

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 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

(Updatable) Compartment Identifier of database

connectionCredentialDetails DatabaseInsightConnectionCredentialDetails

User credential details to connect to the database.

connectionDetails DatabaseInsightConnectionDetails

Connection details to connect to the database. HostName, protocol, and port should be specified.

connectorId String

The OCID of External Database Connector

credentialDetails DatabaseInsightCredentialDetails

User credential details to connect to the database.

databaseConnectionStatusDetails String

databaseConnectorId String

(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.

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>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deploymentType String

Database Deployment Type (EXACS will be supported in the future)

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 Unique Identifier

entitySource String

(Updatable) Source of the database entity.

exadataInsightId String

The OCID of the Exadata insight.

freeformTags Map<String,String>

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

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

The OCID of the Management Agent

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

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

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 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

(Updatable) Compartment Identifier of database

connectionCredentialDetails DatabaseInsightConnectionCredentialDetails

User credential details to connect to the database.

connectionDetails DatabaseInsightConnectionDetails

Connection details to connect to the database. HostName, protocol, and port should be specified.

connectorId string

The OCID of External Database Connector

credentialDetails DatabaseInsightCredentialDetails

User credential details to connect to the database.

databaseConnectionStatusDetails string

databaseConnectorId string

(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.

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}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deploymentType string

Database Deployment Type (EXACS will be supported in the future)

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 Unique Identifier

entitySource string

(Updatable) Source of the database entity.

exadataInsightId string

The OCID of the Exadata insight.

freeformTags {[key: string]: string}

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

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

The OCID of the Management Agent

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

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

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 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

(Updatable) Compartment Identifier of database

connection_credential_details DatabaseInsightConnectionCredentialDetailsArgs

User credential details to connect to the database.

connection_details DatabaseInsightConnectionDetailsArgs

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 DatabaseInsightCredentialDetailsArgs

User credential details to connect to the database.

database_connection_status_details str

database_connector_id str

(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_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]

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deployment_type str

Database Deployment Type (EXACS will be supported in the future)

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 Unique Identifier

entity_source str

(Updatable) Source of the database entity.

exadata_insight_id str

The OCID of the Exadata insight.

freeform_tags Mapping[str, str]

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

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

The OCID of the Management Agent

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

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

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 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

(Updatable) Compartment Identifier of database

connectionCredentialDetails Property Map

User credential details to connect to the database.

connectionDetails 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 Property Map

User credential details to connect to the database.

databaseConnectionStatusDetails String

databaseConnectorId String

(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.

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>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

deploymentType String

Database Deployment Type (EXACS will be supported in the future)

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 Unique Identifier

entitySource String

(Updatable) Source of the database entity.

exadataInsightId String

The OCID of the Exadata insight.

freeformTags Map<String>

(Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

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

The OCID of the Management Agent

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

(Updatable) Status of the resource. Example: "ENABLED", "DISABLED". Resource can be either enabled or disabled by updating the value of status field to either "ENABLED" or "DISABLED"

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 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

DatabaseInsightConnectionCredentialDetails, DatabaseInsightConnectionCredentialDetailsArgs

CredentialType string: Credential type.
CredentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
PasswordSecretId string: The secret OCID mapping to the database credentials.
Role string: database user role.
UserName string: database user name.

CredentialType string: Credential type.
CredentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
PasswordSecretId string: The secret OCID mapping to the database credentials.
Role string: database user role.
UserName string: database user name.

credentialType String: Credential type.
credentialSourceName String: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
passwordSecretId String: The secret OCID mapping to the database credentials.
role String: database user role.
userName String: database user name.

credentialType string: Credential type.
credentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
passwordSecretId string: The secret OCID mapping to the database credentials.
role string: database user role.
userName string: database user name.

credential_type str: Credential type.
credential_source_name str: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
password_secret_id str: The secret OCID mapping to the database credentials.
role str: database user role.
user_name str: database user name.

credentialType String: Credential type.
credentialSourceName String: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
passwordSecretId String: The secret OCID mapping to the database credentials.
role String: database user role.
userName String: database user name.

DatabaseInsightConnectionDetails, DatabaseInsightConnectionDetailsArgs

HostName string: Name of the listener host that will be used to create the connect string to the database.
Hosts List<DatabaseInsightConnectionDetailsHost>: 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 []DatabaseInsightConnectionDetailsHost: 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<DatabaseInsightConnectionDetailsHost>: 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 DatabaseInsightConnectionDetailsHost[]: 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[DatabaseInsightConnectionDetailsHost]: 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.

DatabaseInsightConnectionDetailsHost, DatabaseInsightConnectionDetailsHostArgs

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

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

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

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

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

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

DatabaseInsightCredentialDetails, DatabaseInsightCredentialDetailsArgs

CredentialType string: Credential type.
CredentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
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. This is used for TCPS support in BM/VM/ExaCS cases.

CredentialType string: Credential type.
CredentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
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. This is used for TCPS support in BM/VM/ExaCS cases.

credentialType String: Credential type.
credentialSourceName String: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
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. This is used for TCPS support in BM/VM/ExaCS cases.

credentialType string: Credential type.
credentialSourceName string: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
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. This is used for TCPS support in BM/VM/ExaCS cases.

credential_type str: Credential type.
credential_source_name str: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
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. This is used for TCPS support in BM/VM/ExaCS cases.

credentialType String: Credential type.
credentialSourceName String: Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
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. This is used for TCPS support in BM/VM/ExaCS cases.

Import

DatabaseInsights can be imported using the id, e.g.

$ pulumi import oci:Opsi/databaseInsight:DatabaseInsight test_database_insight "id"

To learn more about importing existing cloud resources, see Importing resources.

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.33.0 published on Thursday, May 1, 2025 by Pulumi

pulumi/pulumi-oci

oci.Opsi.DatabaseInsight

On this page

On this page

Example Usage

Create DatabaseInsight Resource

Constructor syntax

Parameters

Constructor example

DatabaseInsight Resource Properties

Inputs

Outputs

Look up Existing DatabaseInsight Resource

Supporting Types

DatabaseInsightConnectionCredentialDetails, DatabaseInsightConnectionCredentialDetailsArgs

DatabaseInsightConnectionDetails, DatabaseInsightConnectionDetailsArgs

DatabaseInsightConnectionDetailsHost, DatabaseInsightConnectionDetailsHostArgs

DatabaseInsightCredentialDetails, DatabaseInsightCredentialDetailsArgs

Import

Package Details

On this page

On this page