Google

Oracle Database@Google Cloud API

The Oracle Database@Google Cloud API provides a set of APIs to manage Oracle database services, such as Exadata and Autonomous Databases.

Data & analytics#openapi

Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.

Overview

The Oracle Database@Google Cloud API provides a set of APIs to manage Oracle database services, such as Exadata and Autonomous Databases.

Endpoints 67

projects.locations.pluggableDatabases

  • GETGets details of a single PluggableDatabase./v1/:nameGets details of a single PluggableDatabase.
  • GETLists all the PluggableDatabases for the given project, location and Container Database./v1/:parent/pluggableDatabases?filter=string&pageSize=0&pageToken=stringLists all the PluggableDatabases for the given project, location and Container Database.

projects.locations.operations

  • DELETEDeletes a long-running operation/v1/:nameDeletes a long-running operation. This method indicates that the client is no longer interested in the operation result. It does not cancel the operation. If…
  • POSTStarts asynchronous cancellation on a long-running operation/v1/:name:cancelStarts asynchronous cancellation on a long-running operation. The server makes a best effort to cancel the operation, but success is not guaranteed. If the…
  • GETLists operations that match the specified filter in the request/v1/:name/operations?filter=string&pageSize=0&pageToken=string&returnPartialSuccess=trueLists operations that match the specified filter in the request. If the server doesn't support this method, it returns UNIMPLEMENTED.

projects.locations.odbNetworks.odbSubnets

  • PATCHUpdates the `labels` of a single ODB Subnet./v1/:name?requestId=string&updateMask=stringUpdates the labels of a single ODB Subnet.
  • GETLists all the ODB Subnets in a given ODB Network./v1/:parent/odbSubnets?filter=string&orderBy=string&pageSize=0&pageToken=stringLists all the ODB Subnets in a given ODB Network.
  • POSTCreates a new ODB Subnet in a given ODB Network./v1/:parent/odbSubnets?odbSubnetId=string&requestId=stringCreates a new ODB Subnet in a given ODB Network.

projects.locations

  • GETLists information about the supported locations for this service/v1/:name/locations?extraLocationTypes=string&filter=string&pageSize=0&pageToken=stringLists information about the supported locations for this service. This method lists locations based on the resource scope provided in the…

projects.locations.autonomousDatabaseBackups

  • GETLists the long-term and automatic backups of an Autonomous Database./v1/:parent/autonomousDatabaseBackups?filter=string&pageSize=0&pageToken=stringLists the long-term and automatic backups of an Autonomous Database.

projects.locations.autonomousDatabaseCharacterSets

  • GETLists Autonomous Database Character Sets in a given project and location./v1/:parent/autonomousDatabaseCharacterSets?filter=string&pageSize=0&pageToken=stringLists Autonomous Database Character Sets in a given project and location.

projects.locations.autonomousDatabases

  • GETLists the Autonomous Databases in a given project and location./v1/:parent/autonomousDatabases?filter=string&orderBy=string&pageSize=0&pageToken=stringLists the Autonomous Databases in a given project and location.
  • POSTCreates a new Autonomous Database in a given project and location./v1/:parent/autonomousDatabases?autonomousDatabaseId=string&requestId=stringCreates a new Autonomous Database in a given project and location.
  • POSTInitiates a failover to target autonomous database from the associated primary database./v1/:name:failoverInitiates a failover to target autonomous database from the associated primary database.
  • POSTGenerates a wallet for an Autonomous Database./v1/:name:generateWalletGenerates a wallet for an Autonomous Database.
  • GETGets the refreshable clones for a given Autonomous Database./v1/:name:getRefreshableClonesGets the refreshable clones for a given Autonomous Database.
  • POSTRefreshes the refreshable clone of an Autonomous Database./v1/:name:refreshRefreshes the refreshable clone of an Autonomous Database.
  • POSTRestarts an Autonomous Database./v1/:name:restartRestarts an Autonomous Database.
  • POSTRestores a single Autonomous Database./v1/:name:restoreRestores a single Autonomous Database.
  • POSTInitiates a switchover of specified autonomous database to the associated peer database./v1/:name:switchoverInitiates a switchover of specified autonomous database to the associated peer database.

projects.locations.goldengateDeployments

  • POSTStarts a single GoldengateDeployment./v1/:name:startStarts a single GoldengateDeployment.
  • POSTStops a single GoldengateDeployment./v1/:name:stopStops a single GoldengateDeployment.
  • GETLists all the GoldengateDeployments for the given project and location./v1/:parent/goldengateDeployments?filter=string&orderBy=string&pageSize=0&pageToken=stringLists all the GoldengateDeployments for the given project and location.
  • POSTCreates a new GoldengateDeployment in a given project and location./v1/:parent/goldengateDeployments?goldengateDeploymentId=string&requestId=stringCreates a new GoldengateDeployment in a given project and location.

projects.locations.autonomousDbVersions

  • GETLists all the available Autonomous Database versions for a project and location./v1/:parent/autonomousDbVersions?pageSize=0&pageToken=stringLists all the available Autonomous Database versions for a project and location.

projects.locations.cloudExadataInfrastructures

  • POSTConfigures Exascale for a single Exadata Infrastructure./v1/:name:configureExascaleConfigures Exascale for a single Exadata Infrastructure.
  • GETLists Exadata Infrastructures in a given project and location./v1/:parent/cloudExadataInfrastructures?filter=string&orderBy=string&pageSize=0&pageToken=stringLists Exadata Infrastructures in a given project and location.
  • POSTCreates a new Exadata Infrastructure in a given project and location./v1/:parent/cloudExadataInfrastructures?cloudExadataInfrastructureId=string&requestId=stringCreates a new Exadata Infrastructure in a given project and location.

projects.locations.cloudExadataInfrastructures.dbServers

  • GETLists the database servers of an Exadata Infrastructure instance./v1/:parent/dbServers?pageSize=0&pageToken=stringLists the database servers of an Exadata Infrastructure instance.

projects.locations.cloudVmClusters

  • GETLists the VM Clusters in a given project and location./v1/:parent/cloudVmClusters?filter=string&pageSize=0&pageToken=stringLists the VM Clusters in a given project and location.
  • POSTCreates a new VM Cluster in a given project and location./v1/:parent/cloudVmClusters?cloudVmClusterId=string&requestId=stringCreates a new VM Cluster in a given project and location.

projects.locations.exadbVmClusters

  • POSTDisables the Workload Identity Connector for an Exadb VM Cluster./v1/:name:disableIdentityConnectorDisables the Workload Identity Connector for an Exadb VM Cluster.
  • POSTEnables the Workload Identity Connector for an Exadb VM Cluster./v1/:name:enableIdentityConnectorEnables the Workload Identity Connector for an Exadb VM Cluster.
  • GETLists all the Exadb (Exascale) VM Clusters for the given project and location./v1/:parent/exadbVmClusters?filter=string&orderBy=string&pageSize=0&pageToken=stringLists all the Exadb (Exascale) VM Clusters for the given project and location.
  • POSTCreates a new Exadb (Exascale) VM Cluster resource./v1/:parent/exadbVmClusters?exadbVmClusterId=string&requestId=stringCreates a new Exadb (Exascale) VM Cluster resource.
  • POSTRemoves virtual machines from an existing exadb vm cluster./v1/:name:removeVirtualMachineRemoves virtual machines from an existing exadb vm cluster.

projects.locations.exadbVmClusters.dbNodes

  • GETLists the database nodes of a VM Cluster./v1/:parent/dbNodes?pageSize=0&pageToken=stringLists the database nodes of a VM Cluster.

projects.locations.databaseCharacterSets

  • GETList DatabaseCharacterSets for the given project and location./v1/:parent/databaseCharacterSets?filter=string&pageSize=0&pageToken=stringList DatabaseCharacterSets for the given project and location.

projects.locations.databaseConnections

  • GETLists DatabaseConnections in a given project and location./v1/:parent/databaseConnections?filter=string&orderBy=string&pageSize=0&pageToken=stringLists DatabaseConnections in a given project and location.
  • POSTCreates a new DatabaseConnection in a given project and location./v1/:parent/databaseConnections?databaseConnectionId=string&requestId=stringCreates a new DatabaseConnection in a given project and location.
  • POSTExecutes a SQL statement on a DatabaseConnection./v1/:name:executeSqlExecutes a SQL statement on a DatabaseConnection.

projects.locations.goldengateConnectionAssignments

  • POSTTests a single GoldengateConnectionAssignment./v1/:name:testTests a single GoldengateConnectionAssignment.
  • GETLists GoldengateConnectionAssignments in a given project and location./v1/:parent/goldengateConnectionAssignments?filter=string&orderBy=string&pageSize=0&pageToken=stringLists GoldengateConnectionAssignments in a given project and location.
  • POSTCreates a new GoldengateConnectionAssignment in a given project and location./v1/:parent/goldengateConnectionAssignments?goldengateConnectionAssignmentId=string&requestId=stringCreates a new GoldengateConnectionAssignment in a given project and location.

projects.locations.databases

  • GETLists all the Databases for the given project, location and DbSystem./v1/:parent/databases?filter=string&pageSize=0&pageToken=stringLists all the Databases for the given project, location and DbSystem.

projects.locations.dbSystemComputePerformances

  • GETLists all the DbSystemComputePerformances for the given project and location./v1/:parent/dbSystemComputePerformances?filter=string&pageSize=0&pageToken=stringLists all the DbSystemComputePerformances for the given project and location.

projects.locations.dbSystemInitialStorageSizes

  • GETLists all the DbSystemInitialStorageSizes for the given project and location./v1/:parent/dbSystemInitialStorageSizes?pageSize=0&pageToken=stringLists all the DbSystemInitialStorageSizes for the given project and location.

projects.locations.dbSystemShapes

  • GETLists the database system shapes available for the project and location./v1/:parent/dbSystemShapes?filter=string&pageSize=0&pageToken=stringLists the database system shapes available for the project and location.

projects.locations.dbSystems

  • GETLists all the DbSystems for the given project and location./v1/:parent/dbSystems?filter=string&orderBy=string&pageSize=0&pageToken=stringLists all the DbSystems for the given project and location.
  • POSTCreates a new DbSystem in a given project and location./v1/:parent/dbSystems?dbSystemId=string&requestId=stringCreates a new DbSystem in a given project and location.

projects.locations.dbVersions

  • GETList DbVersions for the given project and location./v1/:parent/dbVersions?filter=string&pageSize=0&pageToken=stringList DbVersions for the given project and location.

projects.locations.entitlements

  • GETLists the entitlements in a given project./v1/:parent/entitlements?pageSize=0&pageToken=stringLists the entitlements in a given project.

projects.locations.exascaleDbStorageVaults

  • GETLists all the ExascaleDB Storage Vaults for the given project and location./v1/:parent/exascaleDbStorageVaults?filter=string&orderBy=string&pageSize=0&pageToken=stringLists all the ExascaleDB Storage Vaults for the given project and location.
  • POSTCreates a new ExascaleDB Storage Vault resource./v1/:parent/exascaleDbStorageVaults?exascaleDbStorageVaultId=string&requestId=stringCreates a new ExascaleDB Storage Vault resource.

projects.locations.flexComponents

  • GETLists Flex Components in a given project and location./v1/:parent/flexComponents?filter=string&pageSize=0&pageToken=stringLists Flex Components in a given project and location.

projects.locations.giVersions

  • GETLists all the valid Oracle Grid Infrastructure (GI) versions for the given project and location./v1/:parent/giVersions?filter=string&pageSize=0&pageToken=stringLists all the valid Oracle Grid Infrastructure (GI) versions for the given project and location.

projects.locations.giVersions.minorVersions

  • GETLists all the valid minor versions for the given project, location, gi version and shape family./v1/:parent/minorVersions?filter=string&pageSize=0&pageToken=stringLists all the valid minor versions for the given project, location, gi version and shape family.

projects.locations.goldengateConnectionTypes

  • GETLists GoldengateConnectionTypes in a given project and location./v1/:parent/goldengateConnectionTypes?filter=string&pageSize=0&pageToken=stringLists GoldengateConnectionTypes in a given project and location.

projects.locations.goldengateConnections

  • GETLists all the GoldengateConnections for the given project and location./v1/:parent/goldengateConnections?filter=string&orderBy=string&pageSize=0&pageToken=stringLists all the GoldengateConnections for the given project and location.
  • POSTCreates a new GoldengateConnection in a given project and location./v1/:parent/goldengateConnections?goldengateConnectionId=string&requestId=stringCreates a new GoldengateConnection in a given project and location.

projects.locations.goldengateDeploymentEnvironments

  • GETLists GoldengateDeploymentEnvironments in a given project and location./v1/:parent/goldengateDeploymentEnvironments?pageSize=0&pageToken=stringLists GoldengateDeploymentEnvironments in a given project and location.

projects.locations.goldengateDeploymentTypes

  • GETLists GoldenGateDeploymentTypes in a given project and location./v1/:parent/goldengateDeploymentTypes?filter=string&orderBy=string&pageSize=0&pageToken=stringLists GoldenGateDeploymentTypes in a given project and location.

projects.locations.goldengateDeploymentVersions

  • GETLists GoldengateDeploymentVersions in a given project and location./v1/:parent/goldengateDeploymentVersions?filter=string&pageSize=0&pageToken=stringLists GoldengateDeploymentVersions in a given project and location.

projects.locations.odbNetworks

  • GETLists the ODB Networks in a given project and location./v1/:parent/odbNetworks?filter=string&orderBy=string&pageSize=0&pageToken=stringLists the ODB Networks in a given project and location.
  • POSTCreates a new ODB Network in a given project and location./v1/:parent/odbNetworks?odbNetworkId=string&requestId=stringCreates a new ODB Network in a given project and location.

projects.locations.odbNetworks.odbDnsZones

  • GETLists all the ODB DNS Zones in a given ODB Network./v1/:parent/odbDnsZones?filter=string&orderBy=string&pageSize=0&pageToken=stringLists all the ODB DNS Zones in a given ODB Network.
  • POSTCreates a new ODB DNS Zone in a given ODB Network./v1/:parent/odbDnsZones?odbDnsZoneId=string&requestId=stringCreates a new ODB DNS Zone in a given ODB Network.

API details

Base URL
https://oracledatabase.googleapis.com
Authentication
OAuth 2.0 (authorization code flow) with 1 scope
An API key in the key query parameter
Operations
67 operations on 52 pathsGET 37POST 28PATCH 1DELETE 1
Main resources
projects.locations.autonomousDatabases 9projects.locations.exadbVmClusters 5projects.locations.goldengateDeployments 4projects.locations.cloudExadataInfrastructures 3projects.locations.databaseConnections 3projects.locations.goldengateConnectionAssignments 3projects.locations.odbNetworks.odbSubnets 3projects.locations.operations 3projects.locations.cloudVmClusters 2projects.locations.dbSystems 2
Response formats
application/json
Description format
Google API Discovery, API version v1

How to test the Oracle Database@Google Cloud API in Swastik Codes

  1. Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
  2. Fork it into your workspaceChoose a workspace. You get your own copy of the Oracle Database@Google Cloud API collection, without the publisher's secrets.
  3. Add your credentialsThis API uses OAuth 2.0 (authorization code flow) with 1 scope. Add yours in the collection's variables or an environment; the requests already reference it.
  4. Send a requestPick an endpoint, for example “Gets details of a single PluggableDatabase.” (GET /v1/:name), and press Send. Check the response, add tests and run the whole collection with the runner.

Frequently asked questions

What is the Oracle Database@Google Cloud API?

The Oracle Database@Google Cloud API provides a set of APIs to manage Oracle database services, such as Exadata and Autonomous Databases. It is listed under Data & analytics and has 67 endpoints.

Who publishes the Oracle Database@Google Cloud API?

It is listed from Google's public API description (an OpenAPI document), not published by Google on Swastik Codes. Anyone who controls googleapis.com can claim the profile by adding a DNS TXT record.

What is the base URL of the Oracle Database@Google Cloud API?

Requests go to https://oracledatabase.googleapis.com. Endpoint paths are added to this base URL.

How do I authenticate with the Oracle Database@Google Cloud API?

It accepts 2 methods: OAuth 2.0 (authorization code flow) with 1 scope; an API key in the key query parameter.

How many endpoints does the Oracle Database@Google Cloud API have?

67 operations on 52 paths (37 GET, 28 POST, 1 PATCH, 1 DELETE). The largest groups are projects.locations.autonomousDatabases, projects.locations.exadbVmClusters, projects.locations.goldengateDeployments, projects.locations.cloudExadataInfrastructures.

Is forking the Oracle Database@Google Cloud API free?

Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.

Suggest an API

Tell us which public API is missing. We check it, then add it here with its endpoints when it has an OpenAPI (Swagger) description.