oci.Opsi.getDatabaseInsights
Explore with Pulumi AI
This data source provides the list of Database Insights in Oracle Cloud Infrastructure Opsi service.
Gets a list of database insights based on the query parameters specified. Either compartmentId or id query parameter must be specified. When both compartmentId and compartmentIdInSubtree are specified, a list of database insights in that compartment and in all sub-compartments will be returned.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testDatabaseInsights = oci.Opsi.getDatabaseInsights({
compartmentId: compartmentId,
compartmentIdInSubtree: databaseInsightCompartmentIdInSubtree,
databaseIds: testDatabase.id,
databaseTypes: databaseInsightDatabaseType,
enterpriseManagerBridgeId: testEnterpriseManagerBridge.id,
exadataInsightId: testExadataInsight.id,
fields: databaseInsightFields,
id: databaseInsightId,
opsiPrivateEndpointId: testPrivateEndpoint.id,
states: databaseInsightState,
statuses: databaseInsightStatus,
});
import pulumi
import pulumi_oci as oci
test_database_insights = oci.Opsi.get_database_insights(compartment_id=compartment_id,
compartment_id_in_subtree=database_insight_compartment_id_in_subtree,
database_ids=test_database["id"],
database_types=database_insight_database_type,
enterprise_manager_bridge_id=test_enterprise_manager_bridge["id"],
exadata_insight_id=test_exadata_insight["id"],
fields=database_insight_fields,
id=database_insight_id,
opsi_private_endpoint_id=test_private_endpoint["id"],
states=database_insight_state,
statuses=database_insight_status)
package main
import (
"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/Opsi"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := Opsi.GetDatabaseInsights(ctx, &opsi.GetDatabaseInsightsArgs{
CompartmentId: pulumi.StringRef(compartmentId),
CompartmentIdInSubtree: pulumi.BoolRef(databaseInsightCompartmentIdInSubtree),
DatabaseIds: testDatabase.Id,
DatabaseTypes: databaseInsightDatabaseType,
EnterpriseManagerBridgeId: pulumi.StringRef(testEnterpriseManagerBridge.Id),
ExadataInsightId: pulumi.StringRef(testExadataInsight.Id),
Fields: databaseInsightFields,
Id: pulumi.StringRef(databaseInsightId),
OpsiPrivateEndpointId: pulumi.StringRef(testPrivateEndpoint.Id),
States: databaseInsightState,
Statuses: databaseInsightStatus,
}, nil)
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var testDatabaseInsights = Oci.Opsi.GetDatabaseInsights.Invoke(new()
{
CompartmentId = compartmentId,
CompartmentIdInSubtree = databaseInsightCompartmentIdInSubtree,
DatabaseIds = testDatabase.Id,
DatabaseTypes = databaseInsightDatabaseType,
EnterpriseManagerBridgeId = testEnterpriseManagerBridge.Id,
ExadataInsightId = testExadataInsight.Id,
Fields = databaseInsightFields,
Id = databaseInsightId,
OpsiPrivateEndpointId = testPrivateEndpoint.Id,
States = databaseInsightState,
Statuses = databaseInsightStatus,
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Opsi.OpsiFunctions;
import com.pulumi.oci.Opsi.inputs.GetDatabaseInsightsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var testDatabaseInsights = OpsiFunctions.getDatabaseInsights(GetDatabaseInsightsArgs.builder()
.compartmentId(compartmentId)
.compartmentIdInSubtree(databaseInsightCompartmentIdInSubtree)
.databaseIds(testDatabase.id())
.databaseTypes(databaseInsightDatabaseType)
.enterpriseManagerBridgeId(testEnterpriseManagerBridge.id())
.exadataInsightId(testExadataInsight.id())
.fields(databaseInsightFields)
.id(databaseInsightId)
.opsiPrivateEndpointId(testPrivateEndpoint.id())
.states(databaseInsightState)
.statuses(databaseInsightStatus)
.build());
}
}
variables:
testDatabaseInsights:
fn::invoke:
Function: oci:Opsi:getDatabaseInsights
Arguments:
compartmentId: ${compartmentId}
compartmentIdInSubtree: ${databaseInsightCompartmentIdInSubtree}
databaseIds: ${testDatabase.id}
databaseTypes: ${databaseInsightDatabaseType}
enterpriseManagerBridgeId: ${testEnterpriseManagerBridge.id}
exadataInsightId: ${testExadataInsight.id}
fields: ${databaseInsightFields}
id: ${databaseInsightId}
opsiPrivateEndpointId: ${testPrivateEndpoint.id}
states: ${databaseInsightState}
statuses: ${databaseInsightStatus}
Using getDatabaseInsights
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getDatabaseInsights(args: GetDatabaseInsightsArgs, opts?: InvokeOptions): Promise<GetDatabaseInsightsResult>
function getDatabaseInsightsOutput(args: GetDatabaseInsightsOutputArgs, opts?: InvokeOptions): Output<GetDatabaseInsightsResult>
def get_database_insights(compartment_id: Optional[str] = None,
compartment_id_in_subtree: Optional[bool] = None,
database_ids: Optional[Sequence[str]] = None,
database_types: Optional[Sequence[str]] = None,
enterprise_manager_bridge_id: Optional[str] = None,
exadata_insight_id: Optional[str] = None,
fields: Optional[Sequence[str]] = None,
filters: Optional[Sequence[_opsi.GetDatabaseInsightsFilter]] = None,
id: Optional[str] = None,
opsi_private_endpoint_id: Optional[str] = None,
states: Optional[Sequence[str]] = None,
statuses: Optional[Sequence[str]] = None,
opts: Optional[InvokeOptions] = None) -> GetDatabaseInsightsResult
def get_database_insights_output(compartment_id: Optional[pulumi.Input[str]] = None,
compartment_id_in_subtree: Optional[pulumi.Input[bool]] = None,
database_ids: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
database_types: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
enterprise_manager_bridge_id: Optional[pulumi.Input[str]] = None,
exadata_insight_id: Optional[pulumi.Input[str]] = None,
fields: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
filters: Optional[pulumi.Input[Sequence[pulumi.Input[_opsi.GetDatabaseInsightsFilterArgs]]]] = None,
id: Optional[pulumi.Input[str]] = None,
opsi_private_endpoint_id: Optional[pulumi.Input[str]] = None,
states: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
statuses: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseInsightsResult]
func GetDatabaseInsights(ctx *Context, args *GetDatabaseInsightsArgs, opts ...InvokeOption) (*GetDatabaseInsightsResult, error)
func GetDatabaseInsightsOutput(ctx *Context, args *GetDatabaseInsightsOutputArgs, opts ...InvokeOption) GetDatabaseInsightsResultOutput
> Note: This function is named GetDatabaseInsights
in the Go SDK.
public static class GetDatabaseInsights
{
public static Task<GetDatabaseInsightsResult> InvokeAsync(GetDatabaseInsightsArgs args, InvokeOptions? opts = null)
public static Output<GetDatabaseInsightsResult> Invoke(GetDatabaseInsightsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDatabaseInsightsResult> getDatabaseInsights(GetDatabaseInsightsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:Opsi/getDatabaseInsights:getDatabaseInsights
arguments:
# arguments dictionary
The following arguments are supported:
- Compartment
Id string - The OCID of the compartment.
- Compartment
Id boolIn Subtree - A flag to search all resources within a given compartment and all sub-compartments.
- Database
Ids List<string> - Optional list of database OCIDs of the associated DBaaS entity.
- Database
Types List<string> - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- Enterprise
Manager stringBridge Id - Unique Enterprise Manager bridge identifier
- Exadata
Insight stringId - OCID of exadata insight resource.
- Fields List<string>
- Specifies the fields to return in a database summary response. By default all fields are returned if omitted.
- Filters
List<Get
Database Insights Filter> - Id string
- Optional list of database insight resource OCIDs.
- Opsi
Private stringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- States List<string>
- Lifecycle states
- Statuses List<string>
- Resource Status
- Compartment
Id string - The OCID of the compartment.
- Compartment
Id boolIn Subtree - A flag to search all resources within a given compartment and all sub-compartments.
- Database
Ids []string - Optional list of database OCIDs of the associated DBaaS entity.
- Database
Types []string - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- Enterprise
Manager stringBridge Id - Unique Enterprise Manager bridge identifier
- Exadata
Insight stringId - OCID of exadata insight resource.
- Fields []string
- Specifies the fields to return in a database summary response. By default all fields are returned if omitted.
- Filters
[]Get
Database Insights Filter - Id string
- Optional list of database insight resource OCIDs.
- Opsi
Private stringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- States []string
- Lifecycle states
- Statuses []string
- Resource Status
- compartment
Id String - The OCID of the compartment.
- compartment
Id BooleanIn Subtree - A flag to search all resources within a given compartment and all sub-compartments.
- database
Ids List<String> - Optional list of database OCIDs of the associated DBaaS entity.
- database
Types List<String> - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- enterprise
Manager StringBridge Id - Unique Enterprise Manager bridge identifier
- exadata
Insight StringId - OCID of exadata insight resource.
- fields List<String>
- Specifies the fields to return in a database summary response. By default all fields are returned if omitted.
- filters
List<Get
Database Insights Filter> - id String
- Optional list of database insight resource OCIDs.
- opsi
Private StringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- states List<String>
- Lifecycle states
- statuses List<String>
- Resource Status
- compartment
Id string - The OCID of the compartment.
- compartment
Id booleanIn Subtree - A flag to search all resources within a given compartment and all sub-compartments.
- database
Ids string[] - Optional list of database OCIDs of the associated DBaaS entity.
- database
Types string[] - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- enterprise
Manager stringBridge Id - Unique Enterprise Manager bridge identifier
- exadata
Insight stringId - OCID of exadata insight resource.
- fields string[]
- Specifies the fields to return in a database summary response. By default all fields are returned if omitted.
- filters
Get
Database Insights Filter[] - id string
- Optional list of database insight resource OCIDs.
- opsi
Private stringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- states string[]
- Lifecycle states
- statuses string[]
- Resource Status
- compartment_
id str - The OCID of the compartment.
- compartment_
id_ boolin_ subtree - A flag to search all resources within a given compartment and all sub-compartments.
- database_
ids Sequence[str] - Optional list of database OCIDs of the associated DBaaS entity.
- database_
types Sequence[str] - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- enterprise_
manager_ strbridge_ id - Unique Enterprise Manager bridge identifier
- exadata_
insight_ strid - OCID of exadata insight resource.
- fields Sequence[str]
- Specifies the fields to return in a database summary response. By default all fields are returned if omitted.
- filters
Sequence[opsi.
Get Database Insights Filter] - id str
- Optional list of database insight resource OCIDs.
- opsi_
private_ strendpoint_ id - Unique Operations Insights PrivateEndpoint identifier
- states Sequence[str]
- Lifecycle states
- statuses Sequence[str]
- Resource Status
- compartment
Id String - The OCID of the compartment.
- compartment
Id BooleanIn Subtree - A flag to search all resources within a given compartment and all sub-compartments.
- database
Ids List<String> - Optional list of database OCIDs of the associated DBaaS entity.
- database
Types List<String> - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- enterprise
Manager StringBridge Id - Unique Enterprise Manager bridge identifier
- exadata
Insight StringId - OCID of exadata insight resource.
- fields List<String>
- Specifies the fields to return in a database summary response. By default all fields are returned if omitted.
- filters List<Property Map>
- id String
- Optional list of database insight resource OCIDs.
- opsi
Private StringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- states List<String>
- Lifecycle states
- statuses List<String>
- Resource Status
getDatabaseInsights Result
The following output properties are available:
- Database
Insights List<GetCollections Database Insights Database Insights Collection> - The list of database_insights_collection.
- Compartment
Id string - Compartment identifier of the database
- Compartment
Id boolIn Subtree - Database
Ids List<string> - The OCID of the database.
- Database
Types List<string> - Ops Insights internal representation of the database type.
- Enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- Exadata
Insight stringId - The OCID of the Exadata insight.
- Fields List<string>
- Filters
List<Get
Database Insights Filter> - Id string
- Database insight identifier
- Opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- States List<string>
- The current state of the database.
- Statuses List<string>
- Indicates the status of a database insight in Operations Insights
- Database
Insights []GetCollections Database Insights Database Insights Collection - The list of database_insights_collection.
- Compartment
Id string - Compartment identifier of the database
- Compartment
Id boolIn Subtree - Database
Ids []string - The OCID of the database.
- Database
Types []string - Ops Insights internal representation of the database type.
- Enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- Exadata
Insight stringId - The OCID of the Exadata insight.
- Fields []string
- Filters
[]Get
Database Insights Filter - Id string
- Database insight identifier
- Opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- States []string
- The current state of the database.
- Statuses []string
- Indicates the status of a database insight in Operations Insights
- database
Insights List<GetCollections Database Insights Database Insights Collection> - The list of database_insights_collection.
- compartment
Id String - Compartment identifier of the database
- compartment
Id BooleanIn Subtree - database
Ids List<String> - The OCID of the database.
- database
Types List<String> - Ops Insights internal representation of the database type.
- enterprise
Manager StringBridge Id - OPSI Enterprise Manager Bridge OCID
- exadata
Insight StringId - The OCID of the Exadata insight.
- fields List<String>
- filters
List<Get
Database Insights Filter> - id String
- Database insight identifier
- opsi
Private StringEndpoint Id - The OCID of the OPSI private endpoint
- states List<String>
- The current state of the database.
- statuses List<String>
- Indicates the status of a database insight in Operations Insights
- database
Insights GetCollections Database Insights Database Insights Collection[] - The list of database_insights_collection.
- compartment
Id string - Compartment identifier of the database
- compartment
Id booleanIn Subtree - database
Ids string[] - The OCID of the database.
- database
Types string[] - Ops Insights internal representation of the database type.
- enterprise
Manager stringBridge Id - OPSI Enterprise Manager Bridge OCID
- exadata
Insight stringId - The OCID of the Exadata insight.
- fields string[]
- filters
Get
Database Insights Filter[] - id string
- Database insight identifier
- opsi
Private stringEndpoint Id - The OCID of the OPSI private endpoint
- states string[]
- The current state of the database.
- statuses string[]
- Indicates the status of a database insight in Operations Insights
- database_
insights_ Sequence[opsi.collections Get Database Insights Database Insights Collection] - The list of database_insights_collection.
- compartment_
id str - Compartment identifier of the database
- compartment_
id_ boolin_ subtree - database_
ids Sequence[str] - The OCID of the database.
- database_
types Sequence[str] - Ops Insights internal representation of the database type.
- enterprise_
manager_ strbridge_ id - OPSI Enterprise Manager Bridge OCID
- exadata_
insight_ strid - The OCID of the Exadata insight.
- fields Sequence[str]
- filters
Sequence[opsi.
Get Database Insights Filter] - id str
- Database insight identifier
- opsi_
private_ strendpoint_ id - The OCID of the OPSI private endpoint
- states Sequence[str]
- The current state of the database.
- statuses Sequence[str]
- Indicates the status of a database insight in Operations Insights
- database
Insights List<Property Map>Collections - The list of database_insights_collection.
- compartment
Id String - Compartment identifier of the database
- compartment
Id BooleanIn Subtree - database
Ids List<String> - The OCID of the database.
- database
Types List<String> - Ops Insights internal representation of the database type.
- enterprise
Manager StringBridge Id - OPSI Enterprise Manager Bridge OCID
- exadata
Insight StringId - The OCID of the Exadata insight.
- fields List<String>
- filters List<Property Map>
- id String
- Database insight identifier
- opsi
Private StringEndpoint Id - The OCID of the OPSI private endpoint
- states List<String>
- The current state of the database.
- statuses List<String>
- Indicates the status of a database insight in Operations Insights
Supporting Types
GetDatabaseInsightsDatabaseInsightsCollection
GetDatabaseInsightsDatabaseInsightsCollectionItem
- Compartment
Id string - The OCID of the compartment.
- Connection
Credential List<GetDetails Database Insights Database Insights Collection Item Connection Credential Detail> - User credential details to connect to the database.
- Connection
Details List<GetDatabase Insights Database Insights Collection Item Connection Detail> - 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 List<GetDatabase Insights Database Insights Collection Item Credential Detail> - 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 - Optional list of database OCIDs of the associated DBaaS entity.
- Database
Name string - Name of database
- Database
Resource stringType - Oracle Cloud Infrastructure database resource type
- Database
Type string - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- Database
Version string - The version of the database.
- Dbm
Private stringEndpoint Id - Dictionary<string, string>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Deployment
Type string - Enterprise
Manager stringBridge Id - Unique Enterprise Manager bridge identifier
- 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 Unqiue Identifier
- Entity
Source string - Source of the database entity.
- Exadata
Insight stringId - OCID of exadata insight resource.
- Dictionary<string, string>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- Id string
- Optional list of database insight resource OCIDs.
- 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 - Opsi
Private stringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- 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
- Lifecycle states
- Status string
- Resource Status
- 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 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 - The OCID of the compartment.
- Connection
Credential []GetDetails Database Insights Database Insights Collection Item Connection Credential Detail - User credential details to connect to the database.
- Connection
Details []GetDatabase Insights Database Insights Collection Item Connection Detail - 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 []GetDatabase Insights Database Insights Collection Item Credential Detail - 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 - Optional list of database OCIDs of the associated DBaaS entity.
- Database
Name string - Name of database
- Database
Resource stringType - Oracle Cloud Infrastructure database resource type
- Database
Type string - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- Database
Version string - The version of the database.
- Dbm
Private stringEndpoint Id - map[string]string
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Deployment
Type string - Enterprise
Manager stringBridge Id - Unique Enterprise Manager bridge identifier
- 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 Unqiue Identifier
- Entity
Source string - Source of the database entity.
- Exadata
Insight stringId - OCID of exadata insight resource.
- map[string]string
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- Id string
- Optional list of database insight resource OCIDs.
- 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 - Opsi
Private stringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- 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
- Lifecycle states
- Status string
- Resource Status
- 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 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 - The OCID of the compartment.
- connection
Credential List<GetDetails Database Insights Database Insights Collection Item Connection Credential Detail> - User credential details to connect to the database.
- connection
Details List<GetDatabase Insights Database Insights Collection Item Connection Detail> - 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 List<GetDatabase Insights Database Insights Collection Item Credential Detail> - 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 - Optional list of database OCIDs of the associated DBaaS entity.
- database
Name String - Name of database
- database
Resource StringType - Oracle Cloud Infrastructure database resource type
- database
Type String - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- database
Version String - The version of the database.
- dbm
Private StringEndpoint Id - Map<String,String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type String - enterprise
Manager StringBridge Id - Unique Enterprise Manager bridge identifier
- 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 Unqiue Identifier
- entity
Source String - Source of the database entity.
- exadata
Insight StringId - OCID of exadata insight resource.
- Map<String,String>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- id String
- Optional list of database insight resource OCIDs.
- 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 - opsi
Private StringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- 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
- Lifecycle states
- status String
- Resource Status
- 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 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 - The OCID of the compartment.
- connection
Credential GetDetails Database Insights Database Insights Collection Item Connection Credential Detail[] - User credential details to connect to the database.
- connection
Details GetDatabase Insights Database Insights Collection Item Connection Detail[] - 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 GetDatabase Insights Database Insights Collection Item Credential Detail[] - 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 - Optional list of database OCIDs of the associated DBaaS entity.
- database
Name string - Name of database
- database
Resource stringType - Oracle Cloud Infrastructure database resource type
- database
Type string - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- database
Version string - The version of the database.
- dbm
Private stringEndpoint Id - {[key: string]: string}
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type string - enterprise
Manager stringBridge Id - Unique Enterprise Manager bridge identifier
- 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 Unqiue Identifier
- entity
Source string - Source of the database entity.
- exadata
Insight stringId - OCID of exadata insight resource.
- {[key: string]: string}
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- id string
- Optional list of database insight resource OCIDs.
- 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 - opsi
Private stringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- 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
- Lifecycle states
- status string
- Resource Status
- {[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 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 - The OCID of the compartment.
- connection_
credential_ Sequence[opsi.details Get Database Insights Database Insights Collection Item Connection Credential Detail] - User credential details to connect to the database.
- connection_
details Sequence[opsi.Get Database Insights Database Insights Collection Item Connection Detail] - Connection details to connect to the database. HostName, protocol, and port should be specified.
- connector_
id str - The OCID of External Database Connector
- credential_
details Sequence[opsi.Get Database Insights Database Insights Collection Item Credential Detail] - 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 - Optional list of database OCIDs of the associated DBaaS entity.
- database_
name str - Name of database
- database_
resource_ strtype - Oracle Cloud Infrastructure database resource type
- database_
type str - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- database_
version str - The version of the database.
- dbm_
private_ strendpoint_ id - Mapping[str, str]
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment_
type str - enterprise_
manager_ strbridge_ id - Unique Enterprise Manager bridge identifier
- 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 Unqiue Identifier
- entity_
source str - Source of the database entity.
- exadata_
insight_ strid - OCID of exadata insight resource.
- Mapping[str, str]
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- id str
- Optional list of database insight resource OCIDs.
- 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 - opsi_
private_ strendpoint_ id - Unique Operations Insights PrivateEndpoint identifier
- 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
- Lifecycle states
- status str
- Resource Status
- Mapping[str, str]
- System tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time_
created str - The time the the database insight was first enabled. An RFC3339 formatted datetime string
- time_
updated str - The time the database insight was updated. An RFC3339 formatted datetime string
- compartment
Id String - The OCID of the compartment.
- connection
Credential List<Property Map>Details - User credential details to connect to the database.
- connection
Details List<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 List<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 - Optional list of database OCIDs of the associated DBaaS entity.
- database
Name String - Name of database
- database
Resource StringType - Oracle Cloud Infrastructure database resource type
- database
Type String - Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
- database
Version String - The version of the database.
- dbm
Private StringEndpoint Id - Map<String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deployment
Type String - enterprise
Manager StringBridge Id - Unique Enterprise Manager bridge identifier
- 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 Unqiue Identifier
- entity
Source String - Source of the database entity.
- exadata
Insight StringId - OCID of exadata insight resource.
- Map<String>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- id String
- Optional list of database insight resource OCIDs.
- 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 - opsi
Private StringEndpoint Id - Unique Operations Insights PrivateEndpoint identifier
- 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
- Lifecycle states
- status String
- Resource Status
- 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 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
GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionCredentialDetail
- 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- Password
Secret stringId - The secret OCID mapping to the database credentials.
- Role string
- database user role.
- User
Name string - database user name.
- 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- Password
Secret stringId - The secret OCID mapping to the database credentials.
- Role string
- database user role.
- User
Name string - database user name.
- 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- password
Secret StringId - The secret OCID mapping to the database credentials.
- role String
- database user role.
- user
Name String - database user name.
- 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- password
Secret stringId - The secret OCID mapping to the database credentials.
- role string
- database user role.
- user
Name string - database user name.
- 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- password_
secret_ strid - The secret OCID mapping to the database credentials.
- role str
- database user role.
- user_
name str - database user name.
- 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- password
Secret StringId - The secret OCID mapping to the database credentials.
- role String
- database user role.
- user
Name String - database user name.
GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetail
- Host
Name string - Name of the listener host that will be used to create the connect string to the database.
- Hosts
List<Get
Database Insights Database Insights Collection Item Connection Detail 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
[]Get
Database Insights Database Insights Collection Item Connection Detail 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<Get
Database Insights Database Insights Collection Item Connection Detail 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
Get
Database Insights Database Insights Collection Item Connection Detail 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.
Get Database Insights Database Insights Collection Item Connection Detail 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.
GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetailHost
GetDatabaseInsightsDatabaseInsightsCollectionItemCredentialDetail
- 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- Password
Secret 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- Password
Secret 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- password
Secret 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- password
Secret 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- password_
secret_ 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 - CREDENTIALS_BY_SOURCE is supplied via the External Database Service. CREDENTIALS_BY_VAULT is supplied by secret service to connection PE_COMANAGED_DATABASE and ADB as well. CREDENTIALS_BY_IAM is used db-token to connect only for Autonomous Database.
- password
Secret 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.
GetDatabaseInsightsFilter
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
oci
Terraform Provider.