Oracle Diagnosability API

The diagnosability API from Oracle — 4 operation(s) for diagnosability.

Documentation

📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/access-governance-cp/20220518/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/adm/20220421/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/advisor/20200606/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/ai-data-platform/20240831/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/analytics/20190331/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/announcements/0.0.1/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/api-gateway/20190501/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/apm-config/20210201/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/apm-control-plane/20200630/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/apm-synthetic-monitoring/20200630/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/apm-trace-explorer/20200630/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/audit/20190901/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/autoscaling/20181001/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/bastion/20210331/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/batch/20251031/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/bigdata/20190531/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/blockchain/20191010/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/budgets/20190111/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/certificates/20210224/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/certificatesmgmt/20210224/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/cloud-guard/20200131/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/clusterplacementgroups/20230801/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/compute-cloud-at-customer/20221208/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/container-instances/20210415/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/container-registry/20180419/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/containerengine/20180222/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/cost-anomaly/20190111/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/dashboard/20210731/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/data-catalog/20190325/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/data-flow/20200129/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/data-integration/20200430/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/data-safe/20181201/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/data-science/20190101/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/database-management/20201101/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/database-migration/20230518/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/database-multicloud-integrations/20240501/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/database/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/database-tools/20201005/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/database-tools-runtime/20230222/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/datacc/20251101/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/datalabeling-dp/20211001/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/datalabeling/20211001/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/delegate-access-control/20230801/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/devops/20210630/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/digital-assistant/20190506/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/disaster-recovery/20220125/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/dms/20211101/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/dns/20180115/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/document-understanding/20221109/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/edsfu/20220528/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/emaildelivery/20170907/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/emaildeliverysubmission/20220926/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/events/20181201/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/filestorage/20171215/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/fleet-management/20250228/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/functions/20181201/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/functionsdocgenpbf/1.0/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/fusion-applications/20211201/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/generative-ai-agents-client/20240531/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/generative-ai-agents/20240531/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/generative-ai-inference/20231130/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/generative-ai-nl2sql/20260325/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/generative-ai/20231130/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/generic/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/globally-distributed-database/20250101/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/goldengate/20200407/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/healthchecks/20180501/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/iaas/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/identity-domains/v1/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/identity-dp/v1/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/identity/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/incidentmanagement/20181231/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/instanceagent/20180530/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/integration/20190131/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/iot/20250531/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/itas/v1/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/jms-java-download/20230601/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/jms/20210610/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/jms-utils/20250521/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/kafka/20240901/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/key/release/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/language/20221001/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/licensemanager/20220430/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/limits-increase/20251101/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/limits/20181025/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/loadbalancer/20170115/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/logan-api-spec/20200601/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/logging-dataplane/20200831/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/logging-management/20200531/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/logging-search/20190909/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/lustre/20250228/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/managed-access/20220126/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/management-agent/20200202/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/managementdashboard/20200901/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/marketplace/20181001/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/mngdmac/20250320/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/monitoring/20180401/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/multicloud-omhub-cp/20180828/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/mysql/20190415/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/NetMonitor/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/network-firewall/20211001/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/network-firewall/20230501/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/networkloadbalancer/20200501/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/nosql-database/20190828/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/notification/20181201/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/objectstorage/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/OCB/20220509/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/occ/20230515/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/occds/20240430/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/occm/20231107/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/ocicache/20220315/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/ocm/20220919/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/opa/20210621/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/opensearch/20180828/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/operations-insights/20200630/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/operatoraccesscontrol/20200630/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/oracle-api-access-control/20241130/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/organizations/20230401/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/organizations/20200801/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/osmh/20220901/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/postgresql/20220915/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/psasvc/20240301/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/publisher/20241201/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/queue/20210201/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/recovery-service/20210216/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/registry/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/resource-analytics/20241031/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/resource-discovery-monitoring-control-api/20210330/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/resource-scheduler/20240430/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/resourcemanager/20180917/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/rover/20201210/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/s3objectstorage/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/scanning/20210215/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/search/20180409/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/secretmgmt/20180608/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/secretretrieval/20190301/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/secure-desktops/20220618/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/security-attribute/20240815/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/self/20260129/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/service-catalog/20210527/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/serviceconnectors/20200909/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/smp/20210914/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/speech/20220101/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/stack-monitoring/20210330/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/streaming/20180418/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/threat-intel/20220901/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/usage/20200107/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/usage-proxy/20190111/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/vision/20220125/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/visual-builder/20210601/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/visual-builder-studio/20180828/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/vmware/20200501/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/vmware/20230701/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/waa/20211230/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/waas/20181116/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/waf/20210930/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/wlms/20241101/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/workrequests/20160918/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/zero-trust-packet-routing/20240301/
📖
APIReference
https://docs.oracle.com/en-us/iaas/api/#/en/zero-trust-packet-routing-tools/20240301/

Specifications

OpenAPI Specification

oracle-diagnosability-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  description: "Use the Database Management API to monitor and manage resources such as\nOracle Databases, MySQL Databases, and External Database Systems. \nFor more information, see [Database Management](/iaas/database-management/home.htm).\n"
  title: Database Management Diagnosability API
  version: '20201101'
  x-provenance:
    method: harvested
    first_party: true
    publisher: Oracle
    source: https://docs.oracle.com/en-us/iaas/api/specs/e7e7138b3ad5254432bc9203d07c08e1e84e00d89a283cd6935a4ef61a6929cf.yaml
    harvested: '2026-08-04'
    note: Published by Oracle as the contract for the Database Management API OCI service and stored verbatim; API Evangelist added only this provenance block.
  x-evidence:
  - url: https://docs.oracle.com/en-us/iaas/api/specs/index.json
    what: Oracle's own index of every OCI service specification
  - url: https://docs.oracle.com/en-us/iaas/api/specs/e7e7138b3ad5254432bc9203d07c08e1e84e00d89a283cd6935a4ef61a6929cf.yaml
    what: the harvested document for Database Management API
servers:
- url: http://dbmgmt.{region}.oci.oraclecloud.com/20201101
- url: https://dbmgmt.{region}.oci.oraclecloud.com/20201101
tags:
- name: diagnosability
paths:
  /managedDatabases/{managedDatabaseId}/alertLogCounts:
    get:
      description: 'Get the counts of alert logs for the specified Managed Database.

        '
      operationId: SummarizeAlertLogCounts
      parameters:
      - $ref: '#/components/parameters/ManagedDatabaseIdPathParam'
      - $ref: '#/components/parameters/LogBeginTimeOptionalQueryParam'
      - $ref: '#/components/parameters/LogEndTimeOptionalQueryParam'
      - $ref: '#/components/parameters/AlertLogLevelFilterOptionalQueryParam'
      - $ref: '#/components/parameters/AlertLogGroupByOptionalQueryParam'
      - $ref: '#/components/parameters/LogTypeFilterOptionalQueryParam'
      - $ref: '#/components/parameters/LogSearchTextFilterOptionalQueryParam'
      - $ref: '#/components/parameters/IsLogSearchTextRegularExpressionQueryParam'
      - $ref: '#/components/parameters/PaginationTokenQueryParam'
      - $ref: '#/components/parameters/PaginationLimitQueryParam'
      - $ref: '#/components/parameters/RequestIdHeader'
      - $ref: '#/components/parameters/NamedCredentialIdHeader'
      responses:
        200:
          description: The counts of the alert logs was retrieved successfully.
          headers:
            opc-next-page:
              description: 'For pagination of a list of items. When paging through a list, if this header appears in the response,

                then a partial list might have been returned. Include this value as the `page` parameter for the

                subsequent GET request to get the next batch of items.

                '
              schema:
                type: string
            opc-request-id:
              description: 'Unique Oracle-assigned identifier for the request. If you need to contact

                Oracle about a particular request, please provide the request ID.

                '
              schema:
                type: string
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AlertLogCountsCollection'
        400:
          $ref: '#/components/responses/400'
        401:
          $ref: '#/components/responses/401'
        404:
          $ref: '#/components/responses/404'
        429:
          $ref: '#/components/responses/429'
        500:
          $ref: '#/components/responses/500'
        default:
          $ref: '#/components/responses/default'
      tags:
      - diagnosability
      x-example: "GET /20201101/managedDatabases/<var>&lt;managedDatabaseId&gt;</var>/alertLogCounts?groupBy=LEVEL\nHost: dbmgmt.us-phoenix-1.oraclecloud.com\n<var>&lt;authorization and other headers&gt;</var>\n{\n  \"managedDatabaseId\": \"managedDatabaseId\",\n  \"items\": [\n    {\n      \"category\": \"critical\",\n      \"count\": 20\n    },\n    {\n      \"category\": \"important\",\n      \"count\": 30\n    }\n  ]\n}\n"
      x-related-resource: '#/definitions/ManagedDatabase'
  /managedDatabases/{managedDatabaseId}/alertLogs:
    get:
      description: 'Lists the alert logs for the specified Managed Database.

        '
      operationId: ListAlertLogs
      parameters:
      - $ref: '#/components/parameters/ManagedDatabaseIdPathParam'
      - $ref: '#/components/parameters/LogBeginTimeOptionalQueryParam'
      - $ref: '#/components/parameters/LogEndTimeOptionalQueryParam'
      - $ref: '#/components/parameters/AlertLogLevelFilterOptionalQueryParam'
      - $ref: '#/components/parameters/LogTypeFilterOptionalQueryParam'
      - $ref: '#/components/parameters/LogSearchTextFilterOptionalQueryParam'
      - $ref: '#/components/parameters/IsLogSearchTextRegularExpressionQueryParam'
      - $ref: '#/components/parameters/AlertLogSortByQueryParam'
      - $ref: '#/components/parameters/SortOrderQueryParam'
      - $ref: '#/components/parameters/PaginationTokenQueryParam'
      - $ref: '#/components/parameters/PaginationLimitQueryParam'
      - $ref: '#/components/parameters/RequestIdHeader'
      - $ref: '#/components/parameters/NamedCredentialIdHeader'
      responses:
        200:
          description: The alert logs list was retrieved successfully.
          headers:
            opc-next-page:
              description: 'For pagination of a list of items. When paging through a list, if this header appears in the response,

                then a partial list might have been returned. Include this value as the `page` parameter for the

                subsequent GET request to get the next batch of items.

                '
              schema:
                type: string
            opc-request-id:
              description: 'Unique Oracle-assigned identifier for the request. If you need to contact

                Oracle about a particular request, please provide the request ID.

                '
              schema:
                type: string
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AlertLogCollection'
        400:
          $ref: '#/components/responses/400'
        401:
          $ref: '#/components/responses/401'
        404:
          $ref: '#/components/responses/404'
        429:
          $ref: '#/components/responses/429'
        500:
          $ref: '#/components/responses/500'
        default:
          $ref: '#/components/responses/default'
      tags:
      - diagnosability
      x-example: "GET /20201101/managedDatabases/<var>&lt;managedDatabaseId&gt;</var>/alertLogs?timeGreaterThanOrEqualTo=2022-01-01T22:00:00.00Z&timeLessThanOrEqualTo=2022-02-04T22:00:00.00Z\nHost: dbmgmt.us-phoenix-1.oraclecloud.com\n<var>&lt;authorization and other headers&gt;</var>\n{\n  \"managedDatabaseId\": \"managedDatabaseId\",\n  \"items\": [\n    {\n      \"messageLevel\": \"NORMAL\",\n      \"timestamp\": \"2022-01-23T20:35:57.699Z\",\n      \"messageType\": \"WARNING\",\n      \"messageContent\": \"Archived Log entry 14003 added for thread 1.\",\n      \"supplementalDetail\": \"Shutdown is initiated by sqlplus@perf (TNS V1-V3).\",\n      \"fileLocation\": \"/ade/b/2345/oracle/diag/rdbms/smece2/alert.log\"\n    }\n  ]\n}\n"
      x-related-resource: '#/definitions/ManagedDatabase'
  /managedDatabases/{managedDatabaseId}/attentionLogCounts:
    get:
      description: 'Get the counts of attention logs for the specified Managed Database.

        '
      operationId: SummarizeAttentionLogCounts
      parameters:
      - $ref: '#/components/parameters/ManagedDatabaseIdPathParam'
      - $ref: '#/components/parameters/LogBeginTimeOptionalQueryParam'
      - $ref: '#/components/parameters/LogEndTimeOptionalQueryParam'
      - $ref: '#/components/parameters/AttentionLogUrgencyFilterOptionalQueryParam'
      - $ref: '#/components/parameters/AttentionLogGroupByOptionalQueryParam'
      - $ref: '#/components/parameters/LogTypeFilterOptionalQueryParam'
      - $ref: '#/components/parameters/LogSearchTextFilterOptionalQueryParam'
      - $ref: '#/components/parameters/IsLogSearchTextRegularExpressionQueryParam'
      - $ref: '#/components/parameters/PaginationTokenQueryParam'
      - $ref: '#/components/parameters/PaginationLimitQueryParam'
      - $ref: '#/components/parameters/RequestIdHeader'
      - $ref: '#/components/parameters/NamedCredentialIdHeader'
      responses:
        200:
          description: The counts of the attention logs was retrieved successfully.
          headers:
            opc-next-page:
              description: 'For pagination of a list of items. When paging through a list, if this header appears in the response,

                then a partial list might have been returned. Include this value as the `page` parameter for the

                subsequent GET request to get the next batch of items.

                '
              schema:
                type: string
            opc-request-id:
              description: 'Unique Oracle-assigned identifier for the request. If you need to contact

                Oracle about a particular request, please provide the request ID.

                '
              schema:
                type: string
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AttentionLogCountsCollection'
        400:
          $ref: '#/components/responses/400'
        401:
          $ref: '#/components/responses/401'
        404:
          $ref: '#/components/responses/404'
        429:
          $ref: '#/components/responses/429'
        500:
          $ref: '#/components/responses/500'
        default:
          $ref: '#/components/responses/default'
      tags:
      - diagnosability
      x-example: "GET /20201101/managedDatabases/<var>&lt;managedDatabaseId&gt;</var>/attentionLogsCounts?groupBy=URGENCY\nHost: dbmgmt.us-phoenix-1.oraclecloud.com\n<var>&lt;authorization and other headers&gt;</var>\n{\n  \"managedDatabaseId\": \"managedDatabaseId\",\n  \"items\": [\n    {\n      \"category\": \"deferrable\",\n      \"count\": 20\n    },\n    {\n      \"category\": \"immediate\",\n      \"count\": 30\n    }\n  ]\n}\n"
      x-related-resource: '#/definitions/ManagedDatabase'
  /managedDatabases/{managedDatabaseId}/attentionLogs:
    get:
      description: 'Lists the attention logs for the specified Managed Database.

        '
      operationId: ListAttentionLogs
      parameters:
      - $ref: '#/components/parameters/ManagedDatabaseIdPathParam'
      - $ref: '#/components/parameters/LogBeginTimeOptionalQueryParam'
      - $ref: '#/components/parameters/LogEndTimeOptionalQueryParam'
      - $ref: '#/components/parameters/AttentionLogUrgencyFilterOptionalQueryParam'
      - $ref: '#/components/parameters/LogTypeFilterOptionalQueryParam'
      - $ref: '#/components/parameters/LogSearchTextFilterOptionalQueryParam'
      - $ref: '#/components/parameters/IsLogSearchTextRegularExpressionQueryParam'
      - $ref: '#/components/parameters/AttentionLogSortByQueryParam'
      - $ref: '#/components/parameters/SortOrderQueryParam'
      - $ref: '#/components/parameters/PaginationTokenQueryParam'
      - $ref: '#/components/parameters/PaginationLimitQueryParam'
      - $ref: '#/components/parameters/RequestIdHeader'
      - $ref: '#/components/parameters/NamedCredentialIdHeader'
      responses:
        200:
          description: The attention logs list was retrieved successfully.
          headers:
            opc-next-page:
              description: 'For pagination of a list of items. When paging through a list, if this header appears in the response,

                then a partial list might have been returned. Include this value as the `page` parameter for the

                subsequent GET request to get the next batch of items.

                '
              schema:
                type: string
            opc-request-id:
              description: 'Unique Oracle-assigned identifier for the request. If you need to contact

                Oracle about a particular request, please provide the request ID.

                '
              schema:
                type: string
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AttentionLogCollection'
        400:
          $ref: '#/components/responses/400'
        401:
          $ref: '#/components/responses/401'
        404:
          $ref: '#/components/responses/404'
        429:
          $ref: '#/components/responses/429'
        500:
          $ref: '#/components/responses/500'
        default:
          $ref: '#/components/responses/default'
      tags:
      - diagnosability
      x-example: "GET /20201101/managedDatabases/<var>&lt;managedDatabaseId&gt;</var>/attentionLogs?timeGreaterThanOrEqualTo=2022-01-01T22:00:00.00Z&timeLessThanOrEqualTo=2022-02-04T22:00:00.00Z\nHost: dbmgmt.us-phoenix-1.oraclecloud.com\n<var>&lt;authorization and other headers&gt;</var>\n{\n  \"managedDatabaseId\": \"managedDatabaseId\",\n  \"items\": [\n    {\n      \"messageUrgency\": \"INFO\",\n      \"timestamp\": \"2022-01-23T20:35:57.699Z\",\n      \"messageType\": \"NOTIFICATION\",\n      \"messageContent\": \"Archived Log entry 14003 added for thread 1.\",\n      \"scope\": 35,\n      \"targetUser\": \"Clusterware Admin\",\n      \"cause\": \"A command to shutdown the instance was executed.\",\n      \"action\": \"Check alert log for progress and completion of command.\",\n      \"supplementalDetail\": \"Shutdown is initiated by sqlplus@perf (TNS V1-V3).\",\n      \"fileLocation\": \"/ade/b/2345/oracle/diag/rdbms/smece2/attention.log\"\n    }\n  ]\n}\n"
      x-related-resource: '#/definitions/ManagedDatabase'
components:
  parameters:
    PaginationTokenQueryParam:
      description: 'The page token representing the page from where the next set of paginated results

        are retrieved. This is usually retrieved from a previous list call.

        '
      in: query
      name: page
      x-default-description: 'null'
      schema:
        type: string
        maxLength: 1024
        minLength: 1
    LogBeginTimeOptionalQueryParam:
      description: The optional greater than or equal to timestamp to filter the logs.
      in: query
      name: timeGreaterThanOrEqualTo
      required: false
      x-default-description: 'null'
      schema:
        type: string
        format: date-time
    LogSearchTextFilterOptionalQueryParam:
      description: The optional query parameter to filter the attention or alert logs by search text.
      in: query
      name: logSearchText
      required: false
      x-default-description: 'null'
      schema:
        type: string
    LogTypeFilterOptionalQueryParam:
      description: The optional parameter to filter the attention or alert logs by type.
      in: query
      name: typeFilter
      required: false
      schema:
        type: string
        enum:
        - UNKNOWN
        - INCIDENT_ERROR
        - ERROR
        - WARNING
        - NOTIFICATION
        - TRACE
        - ALL
        default: ALL
    AlertLogLevelFilterOptionalQueryParam:
      description: The optional parameter to filter the alert logs by log level.
      in: query
      name: levelFilter
      required: false
      schema:
        type: string
        enum:
        - CRITICAL
        - SEVERE
        - IMPORTANT
        - NORMAL
        - ALL
        default: ALL
    AttentionLogSortByQueryParam:
      description: The possible sortBy values of attention logs.
      in: query
      name: sortBy
      required: false
      schema:
        type: string
        enum:
        - URGENCY
        - TYPE
        - MESSAGE
        - TIMESTAMP
        - SCOPE
        - TARGET_USER
        default: TIMESTAMP
    PaginationLimitQueryParam:
      description: The maximum number of records returned in the paginated response.
      in: query
      name: limit
      schema:
        type: integer
        default: 10
        maximum: 1000
        minimum: 1
    NamedCredentialIdHeader:
      description: The OCID of the Named Credential.
      in: header
      name: opc-named-credential-id
      required: false
      x-default-description: 'null'
      schema:
        type: string
    SortOrderQueryParam:
      description: The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order.
      in: query
      name: sortOrder
      x-obmcs-top-level-enum: '#/definitions/SortOrders'
      schema:
        type: string
        enum:
        - ASC
        - DESC
        default: ASC
    IsLogSearchTextRegularExpressionQueryParam:
      description: The flag to indicate whether the search text is regular expression or not.
      in: query
      name: isRegularExpression
      required: false
      schema:
        type: boolean
        default: false
    AlertLogGroupByOptionalQueryParam:
      description: The optional parameter used to group different alert logs.
      in: query
      name: groupBy
      required: false
      schema:
        type: string
        enum:
        - LEVEL
        - TYPE
        default: TYPE
    AlertLogSortByQueryParam:
      description: The possible sortBy values of attention logs.
      in: query
      name: sortBy
      required: false
      schema:
        type: string
        enum:
        - LEVEL
        - TYPE
        - MESSAGE
        - TIMESTAMP
        default: TIMESTAMP
    RequestIdHeader:
      description: The client request ID for tracing.
      in: header
      name: opc-request-id
      schema:
        type: string
    ManagedDatabaseIdPathParam:
      description: The [OCID](/Content/General/Concepts/identifiers.htm) of the Managed Database.
      in: path
      name: managedDatabaseId
      required: true
      schema:
        type: string
        maxLength: 255
        minLength: 1
    AttentionLogUrgencyFilterOptionalQueryParam:
      description: The optional parameter to filter the attention logs by urgency.
      in: query
      name: urgencyFilter
      required: false
      schema:
        type: string
        enum:
        - IMMEDIATE
        - SOON
        - DEFERRABLE
        - INFO
        - ALL
        default: ALL
    LogEndTimeOptionalQueryParam:
      description: The optional less than or equal to timestamp to filter the logs.
      in: query
      name: timeLessThanOrEqualTo
      required: false
      x-default-description: 'null'
      schema:
        type: string
        format: date-time
    AttentionLogGroupByOptionalQueryParam:
      description: The optional parameter used to group different attention logs.
      in: query
      name: groupBy
      required: false
      schema:
        type: string
        enum:
        - URGENCY
        - TYPE
        default: TYPE
  schemas:
    Error:
      description: Error Information.
      properties:
        code:
          description: A short error code that defines the error, meant for programmatic parsing.
          type: string
        message:
          description: A human-readable error string.
          type: string
      required:
      - code
      - message
    AttentionLogCountSummary:
      description: 'The details for one attention log count entry.

        '
      properties:
        category:
          description: The category of different attention logs.
          enum:
          - UNKNOWN
          - INCIDENT_ERROR
          - ERROR
          - WARNING
          - NOTIFICATION
          - TRACE
          - IMMEDIATE
          - SOON
          - DEFERRABLE
          - INFO
          - OTHER
          type: string
        count:
          default: 0
          description: The count of attention logs with specific category.
          type: integer
      required:
      - category
      - count
      type: object
    AlertLogCountsCollection:
      description: The collection of the counts of different level or type of alert logs.
      properties:
        items:
          description: An array of the counts of different urgency or type of alert logs.
          items:
            $ref: '#/components/schemas/AlertLogCountSummary'
          type: array
        managedDatabaseId:
          description: The [OCID](/Content/General/Concepts/identifiers.htm) of the Managed Database.
          type: string
      required:
      - managedDatabaseId
      - items
      type: object
    AttentionLogSummary:
      description: 'The details for one attention log entry.

        '
      properties:
        action:
          description: The recommended action to handle the attention log.
          type: string
        cause:
          description: The cause of the attention log.
          type: string
        fileLocation:
          description: The attention log file location.
          type: string
        messageContent:
          description: The contents of the attention log message.
          type: string
        messageType:
          description: The type of attention log message.
          enum:
          - UNKNOWN
          - INCIDENT_ERROR
          - ERROR
          - WARNING
          - NOTIFICATION
          - TRACE
          - OTHER
          type: string
        messageUrgency:
          description: The urgency of the attention log.
          enum:
          - IMMEDIATE
          - SOON
          - DEFERRABLE
          - INFO
          - OTHER
          type: string
        scope:
          description: The database scope for the attention log.
          type: string
        supplementalDetail:
          description: The supplemental details of the attention log.
          type: string
        targetUser:
          description: The user who must act on the attention log message.
          type: string
        timestamp:
          description: The date and time the attention log was created.
          format: date-time
          type: string
      required:
      - messageUrgency
      - messageType
      type: object
    AttentionLogCountsCollection:
      description: The collection of the counts of different urgency or type of attention logs.
      properties:
        items:
          description: An array of the counts of different urgency or type of attention logs.
          items:
            $ref: '#/components/schemas/AttentionLogCountSummary'
          type: array
        managedDatabaseId:
          description: The [OCID](/Content/General/Concepts/identifiers.htm) of the Managed Database.
          type: string
      required:
      - managedDatabaseId
      - items
      type: object
    AlertLogSummary:
      description: 'The detail for one alert log entry.

        '
      properties:
        fileLocation:
          description: The alert log file location.
          type: string
        messageContent:
          description: The contents of the alert log message.
          type: string
        messageLevel:
          description: The level of the alert log.
          enum:
          - CRITICAL
          - SEVERE
          - IMPORTANT
          - NORMAL
          - OTHER
          type: string
        messageType:
          description: The type of alert log message.
          enum:
          - UNKNOWN
          - INCIDENT_ERROR
          - ERROR
          - WARNING
          - NOTIFICATION
          - TRACE
          - OTHER
          type: string
        supplementalDetail:
          description: The supplemental details of the alert log.
          type: string
        timestamp:
          description: The date and time the alert log was created.
          format: date-time
          type: string
      required:
      - messageLevel
      - messageType
      type: object
    AlertLogCountSummary:
      description: 'The details for one alert log count entry.

        '
      properties:
        category:
          description: The category of different alert logs.
          enum:
          - UNKNOWN
          - INCIDENT_ERROR
          - ERROR
          - WARNING
          - NOTIFICATION
          - TRACE
          - CRITICAL
          - SEVERE
          - IMPORTANT
          - NORMAL
          - OTHER
          type: string
        count:
          default: 0
          description: The count of alert logs with specific category.
          type: integer
      required:
      - category
      - count
      type: object
    AlertLogCollection:
      description: The list of alert logs.
      properties:
        items:
          description: An array of the alert logs.
          items:
            $ref: '#/components/schemas/AlertLogSummary'
          type: array
        managedDatabaseId:
          description: The [OCID](/Content/General/Concepts/identifiers.htm) of the Managed Database.
          type: string
      required:
      - managedDatabaseId
      - items
      type: object
    AttentionLogCollection:
      description: The list of attention logs.
      properties:
        items:
          description: An array of the attention logs.
          items:
            $ref: '#/components/schemas/AttentionLogSummary'
          type: array
        managedDatabaseId:
          description: The [OCID](/Content/General/Concepts/identifiers.htm) of the Managed Database.
          type: string
      required:
      - managedDatabaseId
      - items
      type: object
  responses:
    default:
      description: Unknown Error
      headers:
        opc-request-id:
          description: 'Unique Oracle-assigned identifier for the request. If you need to contact

            Oracle about a particular request, please provide the request ID.

            '
          schema:
            type: string
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
x-anchors:
  x-headers:
    content-location:
      description: Content Location of the resource.
      format: uri-reference
      type: string
    etag:
      description: 'For optimistic concurrency control. See `if-match`.

        '
      type: string
    location:
      description: Location of the resource.
      format: uri-reference
      type: string
    opc-next-page:
      description: 'For pagination of a list of items. When paging through a list, if this header appears in the response,

        then a partial list might have been returned. Include this value as the `page` parameter for the

        subsequent GET request to get the next batch of items.

        '
      type: string
    opc-request-id:
      description: 'Unique Oracle-assigned identifier for the request. If you need to contact

        Oracle about a particular request, please provide the request ID.

        '
      type: string
    opc-work-request-id:
      description: 'Unique Oracle-assigned identifier for the asynchronous request. You can use this to query status of the asynchronous operation.

        '
      type: string
  x-properties:
    Sunset:
      description: 'Sunset date when this operation will stop working, in <HTTP-date> format, Fri, 29 Jan 2027 00:00:00 GMT.

        '
      type: string
    cloudDbSystemConnectorCredentialName:
      description: 'The name of the credential information that used to connect to the DB system resource.

        The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters,

        and length of "y" has a maximum of 199 characters. The name strings can contain letters,

        numbers and the underscore character only. Other characters are not valid, except for

        the "." character that separates the "x" and "y" portions of the name.

        *IMPORTANT* - The name must be unique within the OCI region the credential is being created in.

        If you specify a name that duplicates the name of another credential within the same OCI region,

        you may overwrite or corrupt the credential that is already using the name.


        For example: inventorydb.abc112233445566778899

        '
      maxLength: 255
      minLength: 1
      type: string
    definedTags:
      additionalProperties:
        additionalProperties:
          description: 'The value of the tag. Only the String type is supported.

            '
          type: object
        description: 'Key-value pair representing a defined tag key and value, scoped to a namespace.

          Example: `{"CostCenter": "42"}`

          '
        type: object
      description: 'Defined tags for this resource. Each key is predefined and scoped to a namespace.

        For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).

        Example: `{"Operations": {"CostCenter": "42"}}`

        '
      type: object
    externalDbSystemConnectorCredentialName:
      description: 'The name of the credential information that used to connect to the DB system resource.

        The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters,

        and length of "y" has a maximum of 199 characters. The name strings can contain letters,

        numbers and the underscore character only. Other characters are not valid, except for

        the "." character that separates the "x" and "y" portions of the name.

        *IMPORTANT* - The name must be unique within the OCI region the credential is being created in.

        If you specify a name that duplicates the name of another credential within the same OCI region,

        you may overwrite or corrupt the credential that is already using the name.


        For example: inventorydb.abc112233445566778899

        '
      maxLength: 255
      minLength: 1
      type: string
    externalLicenseModel:
      description: 'The Oracle license model that applies to the external database.

        '
      enum:
      - LICENSE_INCLUDED
      - BRING_YOUR_OWN_LICENSE
      type: string
    freeformTags:
      additionalProperties:
        type: string
      description: 'Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace.

        For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).

        Example: `{"Department": "Finance"}`

        '
      type: object
    licenseModel:
      description: 'The Oracle license model that applies to the database management resources.

        '
      enum:
      - LICENSE_INCLUDED
      - BRING_YOUR_OWN_LICENSE
      type: string
    lifecycleState:
      description: The current lifecycle state of the database resource.
      enum:
      - CREATING
      - ACTIVE
      - INACTIVE
      - UPDATING
      - DELETING
      - DELETED
      - FAILED
      type: string
    securityAttributes:
      additionalProperties:
        additionalProperties:
          description: 'Attribute value and mode. Only the String type is supported for value. Mode is currently always "enforce".

            '
          type: object
        description: 'Key-value pair representing a security attribute key and value, scoped to a namespace.


          Example: `{"MaxEgressCount": {"value": "42", "mode": "enforce"}}`

          '
        type: object
      description: 'Security attributes for this resource. Each key is predefined and scoped to a namespace.

        For more information, see [Resource Tags](/iaas/Content/General/Concepts/resourcetags.htm).


        Example: `{"Oracle-ZPR": {"MaxEgressCount": {"value": "42", "mode": "enforce"}}}`

        '
      type: object
    systemTags:
      additionalProperties:
        additionalProperties:
          description: 'The value of the tag. Only string, integer and boolean types are supported.

            '
          type: object
        description: 'Key-value pair representing a defined tag key and value, scoped to a namespace.

          Example: `{"free-tier-retained": "true"}`

          '
        type: object
      description: 'System tags for this resource. Each key is predefined and scoped to a namespace.

        For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).

        System tags can be viewed by users, but can only be created by the system.


        Example: `{"orcl-cloud": {"free-tier-retained": "true"}}`

        '
      type: object
x-oracle-package: com.oracle.oci.dpd.dbmgmt