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 Database General API

Core database instance status, version, and configuration services

Oracle Database General API is one of 29 APIs that Oracle Database publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 5 JSON Schema definitions.

The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a JSON-LD context, an API reference, and 5 JSON Schemas.

This API exposes 14 operations across 13 paths, and defines 15 schemas. It is described by OpenAPI 3.2.0, at version 25.4.0.

Requests are made against a single base URL, https://{host}:{port}/ords.

14 operations 13 paths 15 schemas 1 DELETE11 GET1 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
25.4.0
Server
https://{host}:{port}/ords
Authentication
OAuth 2.0, HTTP Basic
Terms of Service
Resource Areas
1

Authentication & Security 2

Oracle Database General API declares 2 security schemes for authenticating requests. It supports OAuth 2.0 (oauth2) using the clientCredentials and authorizationCode flows. It accepts HTTP basic authentication (basicAuth). By default, every request must be authenticated.

Paths & Operations 14

Across 13 paths, the API surfaces 14 operations — 1 DELETE, 11 GET, 1 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

General 14

Core database instance status, version, and configuration services

GET
/database/status
Oracle Database Get database status
getDatabaseStatus → 200401
GET
/database/version
Oracle Database Get database version
getDatabaseVersion → 200401
GET
/database/components/
Oracle Database Get all database components
getDatabaseComponents → 200401
GET
/database/parameters/
Oracle Database Get all database parameters
getDatabaseParameters 2 params → 200401
GET
/database/parameters/{name}
Oracle Database Get a specific database parameter
getDatabaseParameter 1 param → 200401404
GET
/database/security/users/
Oracle Database Get all database users
getDatabaseUsers → 200401
GET
/database/storage/bytes
Oracle Database Get storage usage in bytes
getStorageBytes → 200401
GET
/database/storage/tablespaces/
Oracle Database Get all tablespaces storage information
getTablespaces → 200401
GET
/database/storage/tablespaces/{tablespace_name}/
Oracle Database Get tablespace details
getTablespace 1 param → 200401404
GET
/database/storage/tablespaces/{tablespace_name}/datafiles/
Oracle Database Get tablespace datafiles
getDatafiles 1 param → 200401
GET
/database/feature_usage/
Oracle Database Get feature usage statistics
getFeatureUsage → 200401
POST
/database/sessionless-transactions/
Oracle Database Start a sessionless transaction
startSessionlessTransaction → 201401
PUT
/database/sessionless-transactions/{sessionlessTransactionID}
Oracle Database Commit a sessionless transaction
commitSessionlessTransaction 1 param → 200401404
DELETE
/database/sessionless-transactions/{sessionlessTransactionID}
Oracle Database Rollback a sessionless transaction
rollbackSessionlessTransaction 1 param → 200401404

Schemas 15

The contract defines 15 schemas that model the data the API accepts and returns. The most detailed are DatabaseParameter (7 properties), Tablespace (7 properties), PaginatedResponse (6 properties), DatabaseStatus (5 properties). Each schema is shown below with its type and property counts.

Error
object
3 properties
Tablespace
object
7 properties
StorageInfo
object
3 properties
ParameterList
TablespaceList
object
1 property
UserList
object
1 property
Link
object
2 properties
FeatureUsageList
object
1 property
SessionlessTransaction
object
1 property
PaginatedResponse
object
6 properties
DatabaseStatus
object
5 properties
ComponentList
object
1 property
DatafileList
object
1 property
DatabaseVersion
object
3 properties
DatabaseParameter
object
7 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-database-general-api-openapi.yml Raw ↑

Other APIs Oracle Database publishes across the network.

Oracle Database API for MongoDB
Oracle Database JDBC
Oracle Call Interface (OCI)
Oracle SQL Developer REST API
Oracle Transactional Event Queues (TxEventQ)
Oracle Database APEX API
Oracle Database Autonomous Databases API
Oracle Database Backups API
Oracle Database Bulk Operations API
Oracle Database Collections API
Oracle Database Data Dictionary API
Oracle Database Data Guard API
Where this information came from

This is an independent, third-party profile of Oracle Database General 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.