oci.Opsi.DatabaseInsight
Explore with Pulumi AI
Example Usage
Coming soon!
Coming soon!
Coming soon!
Coming soon!
Coming soon!
resources:
testDatabaseInsight:
type: oci:Opsi:DatabaseInsight
name: test_database_insight
properties:
compartmentId: ${compartmentId}
entitySource: ${databaseInsightEntitySource}
connectionDetails:
hosts:
- hostIp: ${databaseInsightConnectionDetailsHostsHostIp}
port: ${databaseInsightConnectionDetailsHostsPort}
protocol: ${databaseInsightConnectionDetailsProtocol}
serviceName: ${testService.name}
credentialDetails:
credentialType: ${databaseInsightCredentialDetailsCredentialType}
credentialSourceName: ${databaseInsightCredentialDetailsCredentialSourceName}
passwordSecretId: ${testSecret.id}
role: ${databaseInsightCredentialDetailsRole}
userName: ${testUser.name}
walletSecretId: ${testSecret.id}
databaseId: ${testDatabase.id}
databaseResourceType: ${databaseInsightDatabaseResourceType}
dbmPrivateEndpointId: ${testPrivateEndpoint.id}
definedTags:
foo-namespace.bar-key: value
deploymentType: ${databaseInsightDeploymentType}
enterpriseManagerBridgeId: ${testEnterpriseManagerBridge.id}
enterpriseManagerEntityIdentifier: ${databaseInsightEnterpriseManagerEntityIdentifier}
enterpriseManagerIdentifier: ${databaseInsightEnterpriseManagerIdentifier}
exadataInsightId: ${testExadataInsight.id}
freeformTags:
bar-key: value
opsiPrivateEndpointId: ${testPrivateEndpoint.id}
serviceName: ${testService.name}
systemTags: ${databaseInsightSystemTags}
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,
defined_tags: Optional[Mapping[str, Any]] = None,
enterprise_manager_entity_identifier: Optional[str] = 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,
connection_details: Optional[_opsi.DatabaseInsightConnectionDetailsArgs] = None,
deployment_type: Optional[str] = None,
enterprise_manager_bridge_id: Optional[str] = None,
credential_details: Optional[_opsi.DatabaseInsightCredentialDetailsArgs] = 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, Any]] = 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",
DefinedTags =
{
{ "string", "any" },
},
EnterpriseManagerEntityIdentifier = "string",
DatabaseConnectionStatusDetails = "string",
DatabaseId = "string",
DatabaseResourceType = "string",
DbmPrivateEndpointId = "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",
},
DeploymentType = "string",
EnterpriseManagerBridgeId = "string",
CredentialDetails = new Oci.Opsi.Inputs.DatabaseInsightCredentialDetailsArgs
{
CredentialType = "string",
CredentialSourceName = "string",
PasswordSecretId = "string",
Role = "string",
UserName = "string",
WalletSecretId = "string",
},
EnterpriseManagerIdentifier = "string",
ConnectionCredentialDetails = new Oci.Opsi.Inputs.DatabaseInsightConnectionCredentialDetailsArgs
{
CredentialSourceName = "string",
CredentialType = "string",
PasswordSecretId = "string",
Role = "string",
UserName = "string",
WalletSecretId = "string",
},
ExadataInsightId = "string",
FreeformTags =
{
{ "string", "any" },
},
OpsiPrivateEndpointId = "string",
ServiceName = "string",
Status = "string",
});
example, err := Opsi.NewDatabaseInsight(ctx, "databaseInsightResource", &Opsi.DatabaseInsightArgs{
CompartmentId: pulumi.String("string"),
EntitySource: pulumi.String("string"),
DefinedTags: pulumi.Map{
"string": pulumi.Any("any"),
},
EnterpriseManagerEntityIdentifier: pulumi.String("string"),
DatabaseConnectionStatusDetails: pulumi.String("string"),
DatabaseId: pulumi.String("string"),
DatabaseResourceType: pulumi.String("string"),
DbmPrivateEndpointId: 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"),
},
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"),
},
EnterpriseManagerIdentifier: pulumi.String("string"),
ConnectionCredentialDetails: &opsi.DatabaseInsightConnectionCredentialDetailsArgs{
CredentialSourceName: pulumi.String("string"),
CredentialType: pulumi.String("string"),
PasswordSecretId: pulumi.String("string"),
Role: pulumi.String("string"),
UserName: pulumi.String("string"),
WalletSecretId: pulumi.String("string"),
},
ExadataInsightId: pulumi.String("string"),
FreeformTags: pulumi.Map{
"string": pulumi.Any("any"),
},
OpsiPrivateEndpointId: pulumi.String("string"),
ServiceName: pulumi.String("string"),
Status: pulumi.String("string"),
})
var databaseInsightResource = new DatabaseInsight("databaseInsightResource", DatabaseInsightArgs.builder()
.compartmentId("string")
.entitySource("string")
.definedTags(Map.of("string", "any"))
.enterpriseManagerEntityIdentifier("string")
.databaseConnectionStatusDetails("string")
.databaseId("string")
.databaseResourceType("string")
.dbmPrivateEndpointId("string")
.connectionDetails(DatabaseInsightConnectionDetailsArgs.builder()
.hostName("string")
.hosts(DatabaseInsightConnectionDetailsHostArgs.builder()
.hostIp("string")
.port(0)
.build())
.port(0)
.protocol("string")
.serviceName("string")
.build())
.deploymentType("string")
.enterpriseManagerBridgeId("string")
.credentialDetails(DatabaseInsightCredentialDetailsArgs.builder()
.credentialType("string")
.credentialSourceName("string")
.passwordSecretId("string")
.role("string")
.userName("string")
.walletSecretId("string")
.build())
.enterpriseManagerIdentifier("string")
.connectionCredentialDetails(DatabaseInsightConnectionCredentialDetailsArgs.builder()
.credentialSourceName("string")
.credentialType("string")
.passwordSecretId("string")
.role("string")
.userName("string")
.walletSecretId("string")
.build())
.exadataInsightId("string")
.freeformTags(Map.of("string", "any"))
.opsiPrivateEndpointId("string")
.serviceName("string")
.status("string")
.build());
database_insight_resource = oci.opsi.DatabaseInsight("databaseInsightResource",
compartment_id="string",
entity_source="string",
defined_tags={
"string": "any",
},
enterprise_manager_entity_identifier="string",
database_connection_status_details="string",
database_id="string",
database_resource_type="string",
dbm_private_endpoint_id="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",
),
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",
),
enterprise_manager_identifier="string",
connection_credential_details=oci.opsi.DatabaseInsightConnectionCredentialDetailsArgs(
credential_source_name="string",
credential_type="string",
password_secret_id="string",
role="string",
user_name="string",
wallet_secret_id="string",
),
exadata_insight_id="string",
freeform_tags={
"string": "any",
},
opsi_private_endpoint_id="string",
service_name="string",
status="string")
const databaseInsightResource = new oci.opsi.DatabaseInsight("databaseInsightResource", {
compartmentId: "string",
entitySource: "string",
definedTags: {
string: "any",
},
enterpriseManagerEntityIdentifier: "string",
databaseConnectionStatusDetails: "string",
databaseId: "string",
databaseResourceType: "string",
dbmPrivateEndpointId: "string",
connectionDetails: {
hostName: "string",
hosts: [{
hostIp: "string",
port: 0,
}],
port: 0,
protocol: "string",
serviceName: "string",
},
deploymentType: "string",
enterpriseManagerBridgeId: "string",
credentialDetails: {
credentialType: "string",
credentialSourceName: "string",
passwordSecretId: "string",
role: "string",
userName: "string",
walletSecretId: "string",
},
enterpriseManagerIdentifier: "string",
connectionCredentialDetails: {
credentialSourceName: "string",
credentialType: "string",
passwordSecretId: "string",
role: "string",
userName: "string",
walletSecretId: "string",
},
exadataInsightId: "string",
freeformTags: {
string: "any",
},
opsiPrivateEndpointId: "string",
serviceName: "string",
status: "string",
});
type: oci:Opsi:DatabaseInsight
properties:
compartmentId: string
connectionCredentialDetails:
credentialSourceName: string
credentialType: string
passwordSecretId: string
role: string
userName: string
walletSecretId: string
connectionDetails:
hostName: string
hosts:
- hostIp: string
port: 0
port: 0
protocol: string
serviceName: string
credentialDetails:
credentialSourceName: string
credentialType: string
passwordSecretId: string
role: string
userName: string
walletSecretId: string
databaseConnectionStatusDetails: string
databaseId: string
databaseResourceType: string
dbmPrivateEndpointId: string
definedTags:
string: any
deploymentType: string
enterpriseManagerBridgeId: string
enterpriseManagerEntityIdentifier: string
enterpriseManagerIdentifier: string
entitySource: string
exadataInsightId: string
freeformTags:
string: any
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. This is supplied via the External Database Service.
- Connection
Details DatabaseInsight Connection Details - Connection details of the private endpoints.
- Credential
Details DatabaseInsight Credential Details - User credential details to connect to the database. This is supplied via the External Database Service.
- 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, object>
- (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
- 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, object>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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. This is supplied via the External Database Service.
- Connection
Details DatabaseInsight Connection Details Args - Connection details of the private endpoints.
- Credential
Details DatabaseInsight Credential Details Args - User credential details to connect to the database. This is supplied via the External Database Service.
- 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]interface{}
- (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
- 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]interface{}
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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. This is supplied via the External Database Service.
- connection
Details DatabaseInsight Connection Details - Connection details of the private endpoints.
- credential
Details DatabaseInsight Credential Details - User credential details to connect to the database. This is supplied via the External Database Service.
- 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,Object>
- (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
- 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,Object>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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. This is supplied via the External Database Service.
- connection
Details DatabaseInsight Connection Details - Connection details of the private endpoints.
- credential
Details DatabaseInsight Credential Details - User credential details to connect to the database. This is supplied via the External Database Service.
- 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]: any}
- (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
- 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]: any}
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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. This is supplied via the External Database Service.
- connection_
details opsi.Database Insight Connection Details Args - Connection details of the private endpoints.
- credential_
details opsi.Database Insight Credential Details Args - User credential details to connect to the database. This is supplied via the External Database Service.
- 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, Any]
- (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
- 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, Any]
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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. This is supplied via the External Database Service.
- connection
Details Property Map - Connection details of the private endpoints.
- credential
Details Property Map - User credential details to connect to the database. This is supplied via the External Database Service.
- 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<Any>
- (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
- 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<Any>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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 - Operations 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.
- 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, object>
- 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 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 - Operations 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.
- 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]interface{}
- 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 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 - Operations 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.
- 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,Object>
- 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 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 - Operations 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.
- 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]: any}
- 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 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 - Operations 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.
- 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, Any]
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time_
created str - The time the the database insight was first enabled. An RFC3339 formatted datetime string
- time_
updated str - The time the database insight was updated. An RFC3339 formatted datetime string
- database
Display StringName - Display name of database
- database
Name String - Name of database
- database
Type String - Operations 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.
- 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<Any>
- 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 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,
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, Any]] = 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, Any]] = None,
lifecycle_details: 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, Any]] = 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. This is supplied via the External Database Service.
- Connection
Details DatabaseInsight Connection Details - Connection details of the private endpoints.
- Credential
Details DatabaseInsight Credential Details - User credential details to connect to the database. This is supplied via the External Database Service.
- 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 - Operations 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, object>
- (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
- 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, object>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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.
- 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, object>
- 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 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. This is supplied via the External Database Service.
- Connection
Details DatabaseInsight Connection Details Args - Connection details of the private endpoints.
- Credential
Details DatabaseInsight Credential Details Args - User credential details to connect to the database. This is supplied via the External Database Service.
- 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 - Operations 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]interface{}
- (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
- 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]interface{}
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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.
- 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]interface{}
- 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 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. This is supplied via the External Database Service.
- connection
Details DatabaseInsight Connection Details - Connection details of the private endpoints.
- credential
Details DatabaseInsight Credential Details - User credential details to connect to the database. This is supplied via the External Database Service.
- 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 - Operations 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,Object>
- (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
- 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,Object>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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.
- 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,Object>
- 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 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. This is supplied via the External Database Service.
- connection
Details DatabaseInsight Connection Details - Connection details of the private endpoints.
- credential
Details DatabaseInsight Credential Details - User credential details to connect to the database. This is supplied via the External Database Service.
- 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 - Operations 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]: any}
- (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
- 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]: any}
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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.
- 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]: any}
- 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 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. This is supplied via the External Database Service.
- connection_
details opsi.Database Insight Connection Details Args - Connection details of the private endpoints.
- credential_
details opsi.Database Insight Credential Details Args - User credential details to connect to the database. This is supplied via the External Database Service.
- 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 - Operations 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, Any]
- (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
- 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, Any]
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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.
- 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, Any]
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time_
created str - The time the the database insight was first enabled. An RFC3339 formatted datetime string
- time_
updated str - The time the database insight was updated. An RFC3339 formatted datetime string
- compartment
Id String - (Updatable) Compartment Identifier of database
- connection
Credential Property MapDetails - User credential details to connect to the database. This is supplied via the External Database Service.
- connection
Details Property Map - Connection details of the private endpoints.
- credential
Details Property Map - User credential details to connect to the database. This is supplied via the External Database Service.
- 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 - Operations 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<Any>
- (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
- 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<Any>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- 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.
- 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<Any>
- 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 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
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- Credential
Type string - Credential type.
- 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.
- Credential
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- Credential
Type string - Credential type.
- 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.
- credential
Source StringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- credential
Type String - Credential type.
- 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.
- credential
Source stringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- credential
Type string - Credential type.
- 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.
- credential_
source_ strname - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- credential_
type str - Credential type.
- 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.
- credential
Source StringName - Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
- credential
Type String - Credential type.
- 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.
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.
- 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.
- 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.
- 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.
- 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.
- 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.
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.