oci.Opsi.DatabaseInsight
Explore with Pulumi AI
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:
- Compartment
Id string - (Updatable) Compartment Identifier of database
- Entity
Source string - (Updatable) Source of the database entity.
- Connection
Credential DatabaseDetails Insight Connection Credential Details - User credential details to connect to the database.
- Connection
Details DatabaseInsight Connection Details - Connection details to connect to the database. HostName, protocol, and port should be specified.
- Connector
Id string - The OCID of External Database Connector
- Credential
Details DatabaseInsight Credential Details - User credential details to connect to the database.
- Database
Connection stringStatus Details - 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 string - The OCID of the database.
- Database
Resource stringType - Oracle Cloud Infrastructure database resource type
- Dbm
Private stringEndpoint Id - 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.
- Dictionary<string, string>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Deployment
Type string - Database Deployment Type (EXACS will be supported in the future)
- Enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- Enterprise
Manager stringEntity Identifier - Enterprise Manager Entity Unique Identifier
- Enterprise
Manager stringIdentifier - Enterprise Manager Unique Identifier
- Exadata
Insight stringId - The OCID of the Exadata insight.
- 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"}
- Is
Advanced boolFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- Management
Agent stringId - The OCID of the Management Agent
- Opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- Service
Name 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 string - (Updatable) Compartment Identifier of database
- Entity
Source string - (Updatable) Source of the database entity.
- Connection
Credential DatabaseDetails Insight Connection Credential Details Args - User credential details to connect to the database.
- Connection
Details DatabaseInsight Connection Details Args - Connection details to connect to the database. HostName, protocol, and port should be specified.
- Connector
Id string - The OCID of External Database Connector
- Credential
Details DatabaseInsight Credential Details Args - User credential details to connect to the database.
- Database
Connection stringStatus Details - 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 string - The OCID of the database.
- Database
Resource stringType - Oracle Cloud Infrastructure database resource type
- Dbm
Private stringEndpoint Id - 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.
- map[string]string
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Deployment
Type string - Database Deployment Type (EXACS will be supported in the future)
- Enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- Enterprise
Manager stringEntity Identifier - Enterprise Manager Entity Unique Identifier
- Enterprise
Manager stringIdentifier - Enterprise Manager Unique Identifier
- Exadata
Insight stringId - The OCID of the Exadata insight.
- 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"}
- Is
Advanced boolFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- Management
Agent stringId - The OCID of the Management Agent
- Opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- Service
Name 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 String - (Updatable) Compartment Identifier of database
- entity
Source String - (Updatable) Source of the database entity.
- connection
Credential DatabaseDetails Insight Connection Credential Details - User credential details to connect to the database.
- connection
Details DatabaseInsight Connection Details - Connection details to connect to the database. HostName, protocol, and port should be specified.
- connector
Id String - The OCID of External Database Connector
- credential
Details DatabaseInsight Credential Details - User credential details to connect to the database.
- database
Connection StringStatus Details - 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 String - The OCID of the database.
- database
Resource StringType - Oracle Cloud Infrastructure database resource type
- dbm
Private StringEndpoint Id - 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.
- Map<String,String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type String - Database Deployment Type (EXACS will be supported in the future)
- enterprise
Manager StringBridge Id - OPSI Enterprise Manager Bridge OCID
- enterprise
Manager StringEntity Identifier - Enterprise Manager Entity Unique Identifier
- enterprise
Manager StringIdentifier - Enterprise Manager Unique Identifier
- exadata
Insight StringId - The OCID of the Exadata insight.
- 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"}
- is
Advanced BooleanFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- management
Agent StringId - The OCID of the Management Agent
- opsi
Private StringEndpoint Id - The OCID of the OPSI private endpoint
- service
Name 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 string - (Updatable) Compartment Identifier of database
- entity
Source string - (Updatable) Source of the database entity.
- connection
Credential DatabaseDetails Insight Connection Credential Details - User credential details to connect to the database.
- connection
Details DatabaseInsight Connection Details - Connection details to connect to the database. HostName, protocol, and port should be specified.
- connector
Id string - The OCID of External Database Connector
- credential
Details DatabaseInsight Credential Details - User credential details to connect to the database.
- database
Connection stringStatus Details - 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 string - The OCID of the database.
- database
Resource stringType - Oracle Cloud Infrastructure database resource type
- dbm
Private stringEndpoint Id - 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.
- {[key: string]: string}
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type string - Database Deployment Type (EXACS will be supported in the future)
- enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- enterprise
Manager stringEntity Identifier - Enterprise Manager Entity Unique Identifier
- enterprise
Manager stringIdentifier - Enterprise Manager Unique Identifier
- exadata
Insight stringId - The OCID of the Exadata insight.
- {[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"}
- is
Advanced booleanFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- management
Agent stringId - The OCID of the Management Agent
- opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- service
Name 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_ opsi.details Database Insight Connection Credential Details Args - User credential details to connect to the database.
- connection_
details opsi.Database Insight Connection Details Args - 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.Database Insight Credential Details Args - User credential details to connect to the database.
- database_
connection_ strstatus_ details - 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_ strtype - Oracle Cloud Infrastructure database resource type
- dbm_
private_ strendpoint_ id - 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.
- 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_ strbridge_ id - OPSI Enterprise Manager Bridge OCID
- enterprise_
manager_ strentity_ identifier - Enterprise Manager Entity Unique Identifier
- enterprise_
manager_ stridentifier - Enterprise Manager Unique Identifier
- exadata_
insight_ strid - The OCID of the Exadata insight.
- 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_ boolfeatures_ enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- management_
agent_ strid - The OCID of the Management Agent
- opsi_
private_ strendpoint_ id - 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.
- compartment
Id String - (Updatable) Compartment Identifier of database
- entity
Source String - (Updatable) Source of the database entity.
- connection
Credential Property MapDetails - User credential details to connect to the database.
- connection
Details Property Map - Connection details to connect to the database. HostName, protocol, and port should be specified.
- connector
Id String - The OCID of External Database Connector
- credential
Details Property Map - User credential details to connect to the database.
- database
Connection StringStatus Details - 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 String - The OCID of the database.
- database
Resource StringType - Oracle Cloud Infrastructure database resource type
- dbm
Private StringEndpoint Id - 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.
- Map<String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type String - Database Deployment Type (EXACS will be supported in the future)
- enterprise
Manager StringBridge Id - OPSI Enterprise Manager Bridge OCID
- enterprise
Manager StringEntity Identifier - Enterprise Manager Entity Unique Identifier
- enterprise
Manager StringIdentifier - Enterprise Manager Unique Identifier
- exadata
Insight StringId - The OCID of the Exadata insight.
- 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"}
- is
Advanced BooleanFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- management
Agent StringId - The OCID of the Management Agent
- opsi
Private StringEndpoint Id - The OCID of the OPSI private endpoint
- service
Name 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:
- Database
Display stringName - Display name of database
- Database
Name string - Name of database
- Database
Type string - Ops Insights internal representation of the database type.
- Database
Version string - The version of the database.
- Enterprise
Manager stringEntity Display Name - Enterprise Manager Entity Display Name
- Enterprise
Manager stringEntity Name - Enterprise Manager Entity Name
- Enterprise
Manager stringEntity Type - Enterprise Manager Entity Type
- Id string
- The provider-assigned unique ID for this managed resource.
- Is
Heat boolWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- Is
Highly boolAvailable - Specifies if MYSQL DB System is highly available.
- Lifecycle
Details 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.
- Parent
Id string - 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 string - The OCID of the Exadata Infrastructure.
- State string
- The current state of the database.
- Dictionary<string, string>
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- Time
Created string - The time the database insight was first enabled. An RFC3339 formatted datetime string
- Time
Updated string - The time the database insight was updated. An RFC3339 formatted datetime string
- Database
Display stringName - Display name of database
- Database
Name string - Name of database
- Database
Type string - Ops Insights internal representation of the database type.
- Database
Version string - The version of the database.
- Enterprise
Manager stringEntity Display Name - Enterprise Manager Entity Display Name
- Enterprise
Manager stringEntity Name - Enterprise Manager Entity Name
- Enterprise
Manager stringEntity Type - Enterprise Manager Entity Type
- Id string
- The provider-assigned unique ID for this managed resource.
- Is
Heat boolWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- Is
Highly boolAvailable - Specifies if MYSQL DB System is highly available.
- Lifecycle
Details 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.
- Parent
Id string - 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 string - The OCID of the Exadata Infrastructure.
- State string
- The current state of the database.
- map[string]string
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- Time
Created string - The time the database insight was first enabled. An RFC3339 formatted datetime string
- Time
Updated string - The time the database insight was updated. An RFC3339 formatted datetime string
- database
Display StringName - Display name of database
- database
Name String - Name of database
- database
Type String - Ops Insights internal representation of the database type.
- database
Version String - The version of the database.
- enterprise
Manager StringEntity Display Name - Enterprise Manager Entity Display Name
- enterprise
Manager StringEntity Name - Enterprise Manager Entity Name
- enterprise
Manager StringEntity Type - Enterprise Manager Entity Type
- id String
- The provider-assigned unique ID for this managed resource.
- is
Heat BooleanWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- is
Highly BooleanAvailable - Specifies if MYSQL DB System is highly available.
- lifecycle
Details 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.
- parent
Id String - The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
- processor
Count Integer - Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
- root
Id String - The OCID of the Exadata Infrastructure.
- state String
- The current state of the database.
- Map<String,String>
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created String - The time the database insight was first enabled. An RFC3339 formatted datetime string
- time
Updated String - The time the database insight was updated. An RFC3339 formatted datetime string
- database
Display stringName - Display name of database
- database
Name string - Name of database
- database
Type string - Ops Insights internal representation of the database type.
- database
Version string - The version of the database.
- enterprise
Manager stringEntity Display Name - Enterprise Manager Entity Display Name
- enterprise
Manager stringEntity Name - Enterprise Manager Entity Name
- enterprise
Manager stringEntity Type - Enterprise Manager Entity Type
- id string
- The provider-assigned unique ID for this managed resource.
- is
Heat booleanWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- is
Highly booleanAvailable - Specifies if MYSQL DB System is highly available.
- lifecycle
Details 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.
- parent
Id string - The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
- processor
Count number - Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
- root
Id string - The OCID of the Exadata Infrastructure.
- state string
- The current state of the database.
- {[key: string]: string}
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created string - The time the database insight was first enabled. An RFC3339 formatted datetime string
- time
Updated string - The time the database insight was updated. An RFC3339 formatted datetime string
- database_
display_ strname - 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_ strentity_ display_ name - Enterprise Manager Entity Display Name
- enterprise_
manager_ strentity_ name - Enterprise Manager Entity Name
- enterprise_
manager_ strentity_ type - Enterprise Manager Entity Type
- id str
- The provider-assigned unique ID for this managed resource.
- is_
heat_ boolwave_ cluster_ attached - Specifies if MYSQL DB System has heatwave cluster attached.
- is_
highly_ boolavailable - 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.
- 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
- database
Display StringName - Display name of database
- database
Name String - Name of database
- database
Type String - Ops Insights internal representation of the database type.
- database
Version String - The version of the database.
- enterprise
Manager StringEntity Display Name - Enterprise Manager Entity Display Name
- enterprise
Manager StringEntity Name - Enterprise Manager Entity Name
- enterprise
Manager StringEntity Type - Enterprise Manager Entity Type
- id String
- The provider-assigned unique ID for this managed resource.
- is
Heat BooleanWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- is
Highly BooleanAvailable - Specifies if MYSQL DB System is highly available.
- lifecycle
Details 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.
- parent
Id String - The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
- processor
Count Number - Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
- root
Id String - The OCID of the Exadata Infrastructure.
- state String
- The current state of the database.
- Map<String>
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created String - The time the database insight was first enabled. An RFC3339 formatted datetime string
- time
Updated 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.
- Compartment
Id string - (Updatable) Compartment Identifier of database
- Connection
Credential DatabaseDetails Insight Connection Credential Details - User credential details to connect to the database.
- Connection
Details DatabaseInsight Connection Details - Connection details to connect to the database. HostName, protocol, and port should be specified.
- Connector
Id string - The OCID of External Database Connector
- Credential
Details DatabaseInsight Credential Details - User credential details to connect to the database.
- Database
Connection stringStatus Details - 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 stringName - Display name of database
- Database
Id string - The OCID of the database.
- Database
Name string - Name of database
- Database
Resource stringType - Oracle Cloud Infrastructure database resource type
- Database
Type string - Ops Insights internal representation of the database type.
- Database
Version string - The version of the database.
- Dbm
Private stringEndpoint Id - 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.
- Dictionary<string, string>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Deployment
Type string - Database Deployment Type (EXACS will be supported in the future)
- Enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- Enterprise
Manager stringEntity Display Name - Enterprise Manager Entity Display Name
- Enterprise
Manager stringEntity Identifier - Enterprise Manager Entity Unique Identifier
- Enterprise
Manager stringEntity Name - Enterprise Manager Entity Name
- Enterprise
Manager stringEntity Type - Enterprise Manager Entity Type
- Enterprise
Manager stringIdentifier - Enterprise Manager Unique Identifier
- Entity
Source string - (Updatable) Source of the database entity.
- Exadata
Insight stringId - The OCID of the Exadata insight.
- 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"}
- Is
Advanced boolFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- Is
Heat boolWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- Is
Highly boolAvailable - Specifies if MYSQL DB System is highly available.
- Lifecycle
Details 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.
- Management
Agent stringId - The OCID of the Management Agent
- Opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- Parent
Id string - 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 string - The OCID of the Exadata Infrastructure.
- Service
Name 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.
- Dictionary<string, string>
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- Time
Created string - The time the database insight was first enabled. An RFC3339 formatted datetime string
- Time
Updated string - The time the database insight was updated. An RFC3339 formatted datetime string
- Compartment
Id string - (Updatable) Compartment Identifier of database
- Connection
Credential DatabaseDetails Insight Connection Credential Details Args - User credential details to connect to the database.
- Connection
Details DatabaseInsight Connection Details Args - Connection details to connect to the database. HostName, protocol, and port should be specified.
- Connector
Id string - The OCID of External Database Connector
- Credential
Details DatabaseInsight Credential Details Args - User credential details to connect to the database.
- Database
Connection stringStatus Details - 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 stringName - Display name of database
- Database
Id string - The OCID of the database.
- Database
Name string - Name of database
- Database
Resource stringType - Oracle Cloud Infrastructure database resource type
- Database
Type string - Ops Insights internal representation of the database type.
- Database
Version string - The version of the database.
- Dbm
Private stringEndpoint Id - 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.
- map[string]string
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Deployment
Type string - Database Deployment Type (EXACS will be supported in the future)
- Enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- Enterprise
Manager stringEntity Display Name - Enterprise Manager Entity Display Name
- Enterprise
Manager stringEntity Identifier - Enterprise Manager Entity Unique Identifier
- Enterprise
Manager stringEntity Name - Enterprise Manager Entity Name
- Enterprise
Manager stringEntity Type - Enterprise Manager Entity Type
- Enterprise
Manager stringIdentifier - Enterprise Manager Unique Identifier
- Entity
Source string - (Updatable) Source of the database entity.
- Exadata
Insight stringId - The OCID of the Exadata insight.
- 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"}
- Is
Advanced boolFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- Is
Heat boolWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- Is
Highly boolAvailable - Specifies if MYSQL DB System is highly available.
- Lifecycle
Details 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.
- Management
Agent stringId - The OCID of the Management Agent
- Opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- Parent
Id string - 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 string - The OCID of the Exadata Infrastructure.
- Service
Name 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.
- map[string]string
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- Time
Created string - The time the database insight was first enabled. An RFC3339 formatted datetime string
- Time
Updated string - The time the database insight was updated. An RFC3339 formatted datetime string
- compartment
Id String - (Updatable) Compartment Identifier of database
- connection
Credential DatabaseDetails Insight Connection Credential Details - User credential details to connect to the database.
- connection
Details DatabaseInsight Connection Details - Connection details to connect to the database. HostName, protocol, and port should be specified.
- connector
Id String - The OCID of External Database Connector
- credential
Details DatabaseInsight Credential Details - User credential details to connect to the database.
- database
Connection StringStatus Details - 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 StringName - Display name of database
- database
Id String - The OCID of the database.
- database
Name String - Name of database
- database
Resource StringType - Oracle Cloud Infrastructure database resource type
- database
Type String - Ops Insights internal representation of the database type.
- database
Version String - The version of the database.
- dbm
Private StringEndpoint Id - 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.
- Map<String,String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type String - Database Deployment Type (EXACS will be supported in the future)
- enterprise
Manager StringBridge Id - OPSI Enterprise Manager Bridge OCID
- enterprise
Manager StringEntity Display Name - Enterprise Manager Entity Display Name
- enterprise
Manager StringEntity Identifier - Enterprise Manager Entity Unique Identifier
- enterprise
Manager StringEntity Name - Enterprise Manager Entity Name
- enterprise
Manager StringEntity Type - Enterprise Manager Entity Type
- enterprise
Manager StringIdentifier - Enterprise Manager Unique Identifier
- entity
Source String - (Updatable) Source of the database entity.
- exadata
Insight StringId - The OCID of the Exadata insight.
- 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"}
- is
Advanced BooleanFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- is
Heat BooleanWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- is
Highly BooleanAvailable - Specifies if MYSQL DB System is highly available.
- lifecycle
Details 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.
- management
Agent StringId - The OCID of the Management Agent
- opsi
Private StringEndpoint Id - The OCID of the OPSI private endpoint
- parent
Id String - The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
- processor
Count Integer - Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
- root
Id String - The OCID of the Exadata Infrastructure.
- service
Name 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.
- Map<String,String>
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created String - The time the database insight was first enabled. An RFC3339 formatted datetime string
- time
Updated String - The time the database insight was updated. An RFC3339 formatted datetime string
- compartment
Id string - (Updatable) Compartment Identifier of database
- connection
Credential DatabaseDetails Insight Connection Credential Details - User credential details to connect to the database.
- connection
Details DatabaseInsight Connection Details - Connection details to connect to the database. HostName, protocol, and port should be specified.
- connector
Id string - The OCID of External Database Connector
- credential
Details DatabaseInsight Credential Details - User credential details to connect to the database.
- database
Connection stringStatus Details - 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 stringName - Display name of database
- database
Id string - The OCID of the database.
- database
Name string - Name of database
- database
Resource stringType - Oracle Cloud Infrastructure database resource type
- database
Type string - Ops Insights internal representation of the database type.
- database
Version string - The version of the database.
- dbm
Private stringEndpoint Id - 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.
- {[key: string]: string}
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type string - Database Deployment Type (EXACS will be supported in the future)
- enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- enterprise
Manager stringEntity Display Name - Enterprise Manager Entity Display Name
- enterprise
Manager stringEntity Identifier - Enterprise Manager Entity Unique Identifier
- enterprise
Manager stringEntity Name - Enterprise Manager Entity Name
- enterprise
Manager stringEntity Type - Enterprise Manager Entity Type
- enterprise
Manager stringIdentifier - Enterprise Manager Unique Identifier
- entity
Source string - (Updatable) Source of the database entity.
- exadata
Insight stringId - The OCID of the Exadata insight.
- {[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"}
- is
Advanced booleanFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- is
Heat booleanWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- is
Highly booleanAvailable - Specifies if MYSQL DB System is highly available.
- lifecycle
Details 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.
- management
Agent stringId - The OCID of the Management Agent
- opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- parent
Id string - The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
- processor
Count number - Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
- root
Id string - The OCID of the Exadata Infrastructure.
- service
Name 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.
- {[key: string]: string}
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created string - The time the database insight was first enabled. An RFC3339 formatted datetime string
- time
Updated string - The time the database insight was updated. An RFC3339 formatted datetime string
- compartment_
id str - (Updatable) Compartment Identifier of database
- connection_
credential_ opsi.details Database Insight Connection Credential Details Args - User credential details to connect to the database.
- connection_
details opsi.Database Insight Connection Details Args - 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.Database Insight Credential Details Args - User credential details to connect to the database.
- database_
connection_ strstatus_ details - 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_ strname - Display name of database
- database_
id str - The OCID of the database.
- database_
name str - Name of database
- database_
resource_ strtype - 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_ strendpoint_ id - 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.
- 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_ strbridge_ id - OPSI Enterprise Manager Bridge OCID
- enterprise_
manager_ strentity_ display_ name - Enterprise Manager Entity Display Name
- enterprise_
manager_ strentity_ identifier - Enterprise Manager Entity Unique Identifier
- enterprise_
manager_ strentity_ name - Enterprise Manager Entity Name
- enterprise_
manager_ strentity_ type - Enterprise Manager Entity Type
- enterprise_
manager_ stridentifier - Enterprise Manager Unique Identifier
- entity_
source str - (Updatable) Source of the database entity.
- exadata_
insight_ strid - The OCID of the Exadata insight.
- 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_ boolfeatures_ enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- is_
heat_ boolwave_ cluster_ attached - Specifies if MYSQL DB System has heatwave cluster attached.
- is_
highly_ boolavailable - 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_ strid - The OCID of the Management Agent
- opsi_
private_ strendpoint_ id - 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.
- 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
- compartment
Id String - (Updatable) Compartment Identifier of database
- connection
Credential Property MapDetails - User credential details to connect to the database.
- connection
Details Property Map - Connection details to connect to the database. HostName, protocol, and port should be specified.
- connector
Id String - The OCID of External Database Connector
- credential
Details Property Map - User credential details to connect to the database.
- database
Connection StringStatus Details - 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 StringName - Display name of database
- database
Id String - The OCID of the database.
- database
Name String - Name of database
- database
Resource StringType - Oracle Cloud Infrastructure database resource type
- database
Type String - Ops Insights internal representation of the database type.
- database
Version String - The version of the database.
- dbm
Private StringEndpoint Id - 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.
- Map<String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type String - Database Deployment Type (EXACS will be supported in the future)
- enterprise
Manager StringBridge Id - OPSI Enterprise Manager Bridge OCID
- enterprise
Manager StringEntity Display Name - Enterprise Manager Entity Display Name
- enterprise
Manager StringEntity Identifier - Enterprise Manager Entity Unique Identifier
- enterprise
Manager StringEntity Name - Enterprise Manager Entity Name
- enterprise
Manager StringEntity Type - Enterprise Manager Entity Type
- enterprise
Manager StringIdentifier - Enterprise Manager Unique Identifier
- entity
Source String - (Updatable) Source of the database entity.
- exadata
Insight StringId - The OCID of the Exadata insight.
- 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"}
- is
Advanced BooleanFeatures Enabled - Flag is to identify if advanced features for autonomous database is enabled or not
- is
Heat BooleanWave Cluster Attached - Specifies if MYSQL DB System has heatwave cluster attached.
- is
Highly BooleanAvailable - Specifies if MYSQL DB System is highly available.
- lifecycle
Details 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.
- management
Agent StringId - The OCID of the Management Agent
- opsi
Private StringEndpoint Id - The OCID of the OPSI private endpoint
- parent
Id String - The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.
- processor
Count Number - Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.
- root
Id String - The OCID of the Exadata Infrastructure.
- service
Name 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.
- Map<String>
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created String - The time the database insight was first enabled. An RFC3339 formatted datetime string
- time
Updated String - The time the database insight was updated. An RFC3339 formatted datetime string
Supporting Types
DatabaseInsightConnectionCredentialDetails, DatabaseInsightConnectionCredentialDetailsArgs
- Credential
Type string - Credential type.
- Credential
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- Password
Secret stringId - The secret OCID mapping to the database credentials.
- Role string
- database user role.
- User
Name string - database user name.
- Credential
Type string - Credential type.
- Credential
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- Password
Secret stringId - The secret OCID mapping to the database credentials.
- Role string
- database user role.
- User
Name string - database user name.
- credential
Type String - Credential type.
- credential
Source StringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- password
Secret StringId - The secret OCID mapping to the database credentials.
- role String
- database user role.
- user
Name String - database user name.
- credential
Type string - Credential type.
- credential
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- password
Secret stringId - The secret OCID mapping to the database credentials.
- role string
- database user role.
- user
Name string - database user name.
- credential_
type str - Credential type.
- credential_
source_ strname - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- password_
secret_ strid - The secret OCID mapping to the database credentials.
- role str
- database user role.
- user_
name str - database user name.
- credential
Type String - Credential type.
- credential
Source StringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- password
Secret StringId - The secret OCID mapping to the database credentials.
- role String
- database user role.
- user
Name String - database user name.
DatabaseInsightConnectionDetails, DatabaseInsightConnectionDetailsArgs
- Host
Name string - Name of the listener host that will be used to create the connect string to the database.
- Hosts
List<Database
Insight Connection Details Host> - 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.
- Service
Name string - Database service name used for connection requests.
- Host
Name string - Name of the listener host that will be used to create the connect string to the database.
- Hosts
[]Database
Insight Connection Details Host - 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.
- Service
Name string - Database service name used for connection requests.
- host
Name String - Name of the listener host that will be used to create the connect string to the database.
- hosts
List<Database
Insight Connection Details Host> - 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.
- service
Name String - Database service name used for connection requests.
- host
Name string - Name of the listener host that will be used to create the connect string to the database.
- hosts
Database
Insight Connection Details Host[] - 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.
- service
Name 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.
Database Insight Connection Details Host] - 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.
- host
Name 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.
- service
Name String - Database service name used for connection requests.
DatabaseInsightConnectionDetailsHost, DatabaseInsightConnectionDetailsHostArgs
DatabaseInsightCredentialDetails, DatabaseInsightCredentialDetailsArgs
- Credential
Type string - Credential type.
- Credential
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- Password
Secret stringId - The secret OCID mapping to the database credentials.
- Role string
- database user role.
- User
Name string - database user name.
- Wallet
Secret stringId - 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 string - Credential type.
- Credential
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- Password
Secret stringId - The secret OCID mapping to the database credentials.
- Role string
- database user role.
- User
Name string - database user name.
- Wallet
Secret stringId - 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 String - Credential type.
- credential
Source StringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- password
Secret StringId - The secret OCID mapping to the database credentials.
- role String
- database user role.
- user
Name String - database user name.
- wallet
Secret StringId - 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 string - Credential type.
- credential
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- password
Secret stringId - The secret OCID mapping to the database credentials.
- role string
- database user role.
- user
Name string - database user name.
- wallet
Secret stringId - 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_ strname - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- password_
secret_ strid - The secret OCID mapping to the database credentials.
- role str
- database user role.
- user_
name str - database user name.
- wallet_
secret_ strid - 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 String - Credential type.
- credential
Source StringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- password
Secret StringId - The secret OCID mapping to the database credentials.
- role String
- database user role.
- user
Name String - database user name.
- wallet
Secret StringId - 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.