How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Oracle Db System API

The dbSystem API from Oracle — 16 operation(s) for dbsystem.

Oracle Db System API is one of 378 APIs that Oracle publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include dbSystem. The published artifact set on APIs.io includes an OpenAPI specification and an API reference.

This API exposes 21 operations across 16 paths, and defines 62 schemas. It is described by OpenAPI 3.2.0, at version 20190415.

Requests are made against a single base URL, http://mysql.{region}.ocp.oraclecloud.com/20190415.

21 operations 16 paths 62 schemas 2 DELETE6 GET11 POST2 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
20190415
Base URL
https://{host}:{port}/ords/
License
Oracle Corporation
Resource Areas
1

Paths & Operations 21

Across 16 paths, the API surfaces 21 operations — 2 DELETE, 6 GET, 11 POST, 2 PUT. Each is listed below with its method, path, parameters, and response codes.

dbSystem 21
GET
/dbSystems
List DB Systems.
ListDbSystems 13 params → 200400401404429500default
POST
/dbSystems
Create and launch a DB System.
CreateDbSystem 2 params body → 201400401404409429500default
DELETE
/dbSystems/{dbSystemId}
Delete a DB System.
DeleteDbSystem 3 params → 202400401404412429500default
GET
/dbSystems/{dbSystemId}
Get a DB System.
GetDbSystem 3 params → 200304400401404429500default
PUT
/dbSystems/{dbSystemId}
Update a DB System.
UpdateDbSystem 3 params body → 202400401404409412429500
POST
/dbSystems/{dbSystemId}/actions/controlledUpdate
Update the selected MySQL instance types.
ControlledUpdateDbSystem 4 params body → 202400401404409412429500
POST
/dbSystems/{dbSystemId}/actions/generateDbSystemStatus
Generate DB System status.
GenerateDbSystemStatus 3 params body → 201400401404409429500default
POST
/dbSystems/{dbSystemId}/actions/restart
Restarts a DB System.
RestartDbSystem 4 params body → 202400401404409412429500
POST
/dbSystems/{dbSystemId}/actions/start
Starts a DB System.
StartDbSystem 4 params → 202400401404409412429500
POST
/dbSystems/{dbSystemId}/actions/stop
Stops a DB System.
StopDbSystem 4 params body → 202400401404409412429500
GET
/dbSystems/{dbSystemId}/dbSystemStatus
Get DB System status.
GetDbSystemStatus 2 params → 200400401404409429500default
DELETE
/dbSystems/{dbSystemId}/heatWaveCluster
Delete HeatWave cluster.
DeleteHeatWaveCluster 3 params → 202400401404412429500default
GET
/dbSystems/{dbSystemId}/heatWaveCluster
Get HeatWave cluster details.
GetHeatWaveCluster 3 params → 200304400401404429500default
PUT
/dbSystems/{dbSystemId}/heatWaveCluster
Update HeatWave cluster.
UpdateHeatWaveCluster 3 params body → 202400401404409412429500
POST
/dbSystems/{dbSystemId}/heatWaveCluster/actions/add
Add HeatWave cluster.
AddHeatWaveCluster 4 params body → 201400401404409412429500
POST
/dbSystems/{dbSystemId}/heatWaveCluster/actions/restart
Restart HeatWave cluster.
RestartHeatWaveCluster 4 params → 202400401404409412429500
POST
/dbSystems/{dbSystemId}/heatWaveCluster/actions/start
Start HeatWave cluster.
StartHeatWaveCluster 4 params → 202400401404409412429500
POST
/dbSystems/{dbSystemId}/heatWaveCluster/actions/stop
Stop HeatWave cluster.
StopHeatWaveCluster 4 params → 202400401404409412429500
GET
/dbSystems/{dbSystemId}/heatWaveClusterMemoryEstimate
Get HeatWave cluster memory estimate.
GetHeatWaveClusterMemoryEstimate 2 params → 200400401404409429500default
POST
/dbSystems/{dbSystemId}/heatWaveClusterMemoryEstimate/actions/generate
Generate HeatWave cluster memory estimate.
GenerateHeatWaveClusterMemoryEstimate 3 params → 201400401404409429500default
GET
/dbSystems/{dbSystemId}/maintenanceEvents
List maintenance events.
ListMaintenanceEvents 11 params → 200400401404429500default

Schemas 62

The contract defines 62 schemas that model the data the API accepts and returns. The most detailed are DbSystem (50 properties), CreateDbSystemDetails (39 properties), UpdateDbSystemDetails (37 properties), DbSystemSummary (28 properties). Each schema is shown below with its type and property counts.

UpdateHeatWaveClusterDetails
object
Details about the HeatWave cluster properties to be updated.
3 properties
DataStorageDetails
object
Data Storage configuration properties.
2 properties
CustomerContact
object
Customer contact information that will be used by Oracle to provide notifications needed by DB System administrators.
1 property 1 required
StopDbSystemDetails
object
DB System shutdown parameters.
1 property 1 required
MaintenanceEvent
object
The details of a maintenance event.
14 properties 8 required
CreateDbSystemDetails
object
Details required to create a DB System.
39 properties 5 required
SecureConnectionDetails
object
Secure connection configuration details.
2 properties 1 required
DatabaseConsoleDetails
object
Database console configuration details.
2 properties 1 required
RestDetails
object
REST configuration details.
2 properties 1 required
DbSystemStatusResult
object
The status collected from the DB System.
8 properties
CreateReadEndpointDetails
Details required to create a Read Endpoint.
ControlledUpdate
The details of the last successfully processed controlled update action.
UpdateBackupPolicyDetails
object
Backup Policy as optionally used for DB System update.
8 properties
ChannelSummary
object
Summary of a Channel.
13 properties 9 required
DataStorage
Data Storage information.
BackupPolicy
object
The Backup policy for the DB System.
8 properties 3 required
ChannelStatusResult
object
Status information for the channel attached to the DB System.
5 properties 1 required
UpdateDeletionPolicyDetails
object
Policy for how the DB System and related resources should be handled at the time of its deletion.
3 properties
CreateMaintenanceDetails
object
The Maintenance Policy for the DB System or Read Replica that this model is included in.
5 properties 1 required
CreateRestDetails
object
Details required to configure REST while creating a DB System.
2 properties 1 required
CreateTelemetryConfigurationDetails
Details required to configure how MySQL telemetry should be exposed.
ReadEndpointDetails
object
The read endpoint of a DB System.
5 properties
ControlledUpdateDbSystemDetails
object
Details of the controlled update action, including the target subset of MySQL instances to update based on their role.
2 properties
EncryptDataDetails
object
Encrypt data details.
2 properties 1 required
UpdateRestDetails
object
Details required to configure REST while updating a DB System.
2 properties 1 required
AddHeatWaveClusterDetails
object
Details required to add a HeatWave cluster.
3 properties 2 required
GenerateDbSystemStatusDetails
object
Parameters for selecting which attributes to include in the DB System status.
3 properties
Ipv6AddressIpv6SubnetCidrPairDetails
object
Details to assign an IPv6 subnet prefix or IPv6 address to a resource.
2 properties
CreateBackupPolicyDetails
object
Backup policy as optionally used for DB System Creation.
8 properties
DeletionPolicyDetails
object
The Deletion policy for the DB System.
3 properties 3 required
PitrPolicy
object
The PITR policy for the DB System.
1 property 1 required
UpdateDbSystemDetails
object
Details required to update a DB System.
37 properties
HeatWaveClusterMemoryEstimate
object
HeatWave cluster memory estimate that can be used to determine a suitable HeatWave cluster size. For each MySQL user table the estimated memory footprint when…
5 properties 5 required
UpdateTelemetryConfigurationDetails
Details required to configure how MySQL telemetry should be exposed.
ChannelTarget
object
Details about the Channel target.
1 property 1 required
UpdateDatabaseConsoleDetails
object
Details required to configure the database console while updating a DB System.
2 properties 1 required
DestinationConfiguration
object
Configuration variable of a given destination.
2 properties 2 required
ChannelSource
object
Parameters detailing how to provision the source for the given Channel.
1 property 1 required
CreateDeletionPolicyDetails
object
Policy for how the DB System and related resources should be handled at the time of its deletion.
3 properties
CopyPolicy
object
A policy of a DB system to schedule cross-region DB system backup copy.
2 properties 1 required
RestartDbSystemDetails
object
DB System restart parameters.
1 property 1 required
DbSystemSource
object
Parameters detailing how to provision the initial data of the DB System.
1 property 1 required
LoggingDestinationConfiguration
object
Configuration parameters for a given destination.
3 properties 3 required
DbSystemStatus
object
Runtime status summary of a DbSystem, aggregating information about availability and operational indicators.
4 properties 3 required
HeatWaveClusterSummary
object
A summary of a HeatWave cluster.
6 properties 5 required
CreateDatabaseConsoleDetails
object
Details required to configure the database console while creating a DB System.
2 properties 1 required
CreateDbSystemSourceDetails
object
Parameters detailing how to provision the initial data of the system.
1 property 1 required
MaintenanceDisabledWindow
object
Time window during which downtime-inducing maintenance shall not be performed. Downtime-free maintenance may be performed to apply required security patches.
2 properties 2 required
PointInTimeRecoveryDetails
object
Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
2 properties 2 required
HeatWaveCluster
object
A HeatWave cluster is a database accelerator for a DB System.
9 properties 7 required
DbSystem
object
A DB System is the core logical unit of MySQL Database Service.
50 properties 14 required
HeatWaveNode
object
A HeatWave node is a compute host that is part of a HeatWave cluster.
4 properties 2 required
HeatWaveClusterTableMemoryEstimate
object
Estimated memory footprint for a MySQL user table when loaded to the HeatWave cluster memory.
6 properties 6 required
DbSystemEndpoint
object
A particular functional endpoint for access to a DB System, and the properties that apply to it.
8 properties 3 required
DbSystemPlacement
object
The availability domain and fault domain a DB System is placed in.
2 properties
DbSystemSummary
object
A summary of a DB System.
28 properties 8 required
UpdateReadEndpointDetails
Read Endpoint details.
HeatWaveClusterSchemaMemoryEstimate
object
Schema with estimated memory footprints for each MySQL user table of the schema when loaded to HeatWave cluster memory.
2 properties 2 required
Error
object
Sorry.
2 properties 2 required
TelemetryConfigurationDetails
object
Telemetry configuration details of a DB System or a read replica.
1 property
MaintenanceDetails
object
The Maintenance Policy for the DB System or Read Replica that this model is included in.
7 properties
UpdateMaintenanceDetails
object
The Maintenance Policy for the DB System or Read Replica that this model is included in.
5 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-dbsystem-api-openapi.yml Raw ↑

Other APIs Oracle publishes across the network.

Oracle Database REST APIs
Oracle Integration Cloud API
Oracle Fusion Cloud Applications API
Oracle Fusion Cloud Financials REST API
Oracle Fusion Cloud HCM REST API
Oracle Fusion Cloud CX Sales and Service REST API
Oracle Fusion Cloud SCM REST API
Oracle Fusion Cloud Procurement REST API
Oracle Content Management API
OCI Generative AI API
OCI AI Vision API
OCI AI Language API
Where this information came from

This is an independent, third-party profile of Oracle Db System API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.