1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Opsi
  5. DatabaseInsight
Oracle Cloud Infrastructure v2.15.0 published on Thursday, Oct 31, 2024 by Pulumi

oci.Opsi.DatabaseInsight

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.15.0 published on Thursday, Oct 31, 2024 by Pulumi

    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,
                        deployment_type: Optional[str] = None,
                        enterprise_manager_bridge_id: Optional[str] = None,
                        credential_details: Optional[_opsi.DatabaseInsightCredentialDetailsArgs] = None,
                        database_connection_status_details: 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,
                        connection_details: Optional[_opsi.DatabaseInsightConnectionDetailsArgs] = None,
                        connector_id: Optional[str] = None,
                        enterprise_manager_entity_identifier: Optional[str] = None,
                        enterprise_manager_identifier: Optional[str] = None,
                        connection_credential_details: Optional[_opsi.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",
        DeploymentType = "string",
        EnterpriseManagerBridgeId = "string",
        CredentialDetails = new Oci.Opsi.Inputs.DatabaseInsightCredentialDetailsArgs
        {
            CredentialType = "string",
            CredentialSourceName = "string",
            PasswordSecretId = "string",
            Role = "string",
            UserName = "string",
            WalletSecretId = "string",
        },
        DatabaseConnectionStatusDetails = "string",
        DatabaseId = "string",
        DatabaseResourceType = "string",
        DbmPrivateEndpointId = "string",
        DefinedTags = 
        {
            { "string", "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",
        },
        ConnectorId = "string",
        EnterpriseManagerEntityIdentifier = "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"),
    	DeploymentType:            pulumi.String("string"),
    	EnterpriseManagerBridgeId: 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"),
    	},
    	DatabaseConnectionStatusDetails: pulumi.String("string"),
    	DatabaseId:                      pulumi.String("string"),
    	DatabaseResourceType:            pulumi.String("string"),
    	DbmPrivateEndpointId:            pulumi.String("string"),
    	DefinedTags: pulumi.StringMap{
    		"string": 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"),
    	},
    	ConnectorId:                       pulumi.String("string"),
    	EnterpriseManagerEntityIdentifier: 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")
        .deploymentType("string")
        .enterpriseManagerBridgeId("string")
        .credentialDetails(DatabaseInsightCredentialDetailsArgs.builder()
            .credentialType("string")
            .credentialSourceName("string")
            .passwordSecretId("string")
            .role("string")
            .userName("string")
            .walletSecretId("string")
            .build())
        .databaseConnectionStatusDetails("string")
        .databaseId("string")
        .databaseResourceType("string")
        .dbmPrivateEndpointId("string")
        .definedTags(Map.of("string", "string"))
        .connectionDetails(DatabaseInsightConnectionDetailsArgs.builder()
            .hostName("string")
            .hosts(DatabaseInsightConnectionDetailsHostArgs.builder()
                .hostIp("string")
                .port(0)
                .build())
            .port(0)
            .protocol("string")
            .serviceName("string")
            .build())
        .connectorId("string")
        .enterpriseManagerEntityIdentifier("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",
        deployment_type="string",
        enterprise_manager_bridge_id="string",
        credential_details=oci.opsi.DatabaseInsightCredentialDetailsArgs(
            credential_type="string",
            credential_source_name="string",
            password_secret_id="string",
            role="string",
            user_name="string",
            wallet_secret_id="string",
        ),
        database_connection_status_details="string",
        database_id="string",
        database_resource_type="string",
        dbm_private_endpoint_id="string",
        defined_tags={
            "string": "string",
        },
        connection_details=oci.opsi.DatabaseInsightConnectionDetailsArgs(
            host_name="string",
            hosts=[oci.opsi.DatabaseInsightConnectionDetailsHostArgs(
                host_ip="string",
                port=0,
            )],
            port=0,
            protocol="string",
            service_name="string",
        ),
        connector_id="string",
        enterprise_manager_entity_identifier="string",
        enterprise_manager_identifier="string",
        connection_credential_details=oci.opsi.DatabaseInsightConnectionCredentialDetailsArgs(
            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",
        deploymentType: "string",
        enterpriseManagerBridgeId: "string",
        credentialDetails: {
            credentialType: "string",
            credentialSourceName: "string",
            passwordSecretId: "string",
            role: "string",
            userName: "string",
            walletSecretId: "string",
        },
        databaseConnectionStatusDetails: "string",
        databaseId: "string",
        databaseResourceType: "string",
        dbmPrivateEndpointId: "string",
        definedTags: {
            string: "string",
        },
        connectionDetails: {
            hostName: "string",
            hosts: [{
                hostIp: "string",
                port: 0,
            }],
            port: 0,
            protocol: "string",
            serviceName: "string",
        },
        connectorId: "string",
        enterpriseManagerEntityIdentifier: "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
        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

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

    ** 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 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.
    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 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"

    ** 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 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.
    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 {[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"

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

    compartment_id str
    (Updatable) Compartment Identifier of database
    entity_source str
    (Updatable) Source of the database entity.
    connection_credential_details opsi.DatabaseInsightConnectionCredentialDetailsArgs
    User credential details to connect to the database.
    connection_details opsi.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 opsi.DatabaseInsightCredentialDetailsArgs
    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_id str
    The OCID of the database.
    database_resource_type str
    Oracle Cloud Infrastructure database resource type
    dbm_private_endpoint_id str
    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.
    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"

    ** 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 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
    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.
    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 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"

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

    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[_opsi.DatabaseInsightConnectionCredentialDetailsArgs] = None,
            connection_details: Optional[_opsi.DatabaseInsightConnectionDetailsArgs] = None,
            connector_id: Optional[str] = None,
            credential_details: Optional[_opsi.DatabaseInsightCredentialDetailsArgs] = None,
            database_connection_status_details: 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)
    Resource lookup is not supported in YAML
    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
    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.
    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
    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
    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"

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

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

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

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

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

    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
    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.
    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
    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 {[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"

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

    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 opsi.DatabaseInsightConnectionCredentialDetailsArgs
    User credential details to connect to the database.
    connection_details opsi.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 opsi.DatabaseInsightCredentialDetailsArgs
    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_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
    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.
    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"

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

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

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

    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[opsi.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.
    oci logo
    Oracle Cloud Infrastructure v2.15.0 published on Thursday, Oct 31, 2024 by Pulumi