This post is part of a series of blog posts on the Oracle Autonomous Database.
Autonomous Database – REST APIs
- Permit interaction with Oracle ADB cloud services programmatically over REST rather than log into the OCI Cloud Console and click through screens
- A mechanism for developing customized deployment and management scripts that can be saved and reused for deployments, set gold standards, and store entire application infrastructure stacks as version controlled code
- The Oracle Cloud Infrastructure APIs are typical REST APIs that use HTTPS requests and responses and support HTTPS and SSL protocol TLS 1.2
- Calls to Oracle Cloud Infrastructure using REST APIs can be written in popular scripting languages such as node.js, Python, Ruby, Perl, Java, C#, bash or curl
- All OCI API requests must be signed for authentication purposes
The steps to create and sign API requests are:
- Form the HTTPS request (SSL protocol TLS 1.2 protocol required)
- Create the signing string, which is based on parts of the request
- Create the signature from the signing string, using your private key and the RSA-SHA256 algorithm
- Add the resulting signature and other required information to the Authorization header in the request
- You will also need to generate an ssh key pair in the pem format
These avoid using username/passwords (insecure communication of the internet)
Autonomous Database – Using OCI-CLI
- The Command Line Interface (CLI) is a small footprint tool that you can use on its own or with the Shell Console to complete OCI tasks.
- The CLI provides the same core functionality as the Service Console, plus additional commands. Some of these, such as the ability to run scripts, extend the Console’s functionality.
- The CLI is built on Python. The Python code makes calls to OCI APIs to provide the functionality implemented for the various services.
- Preinstalled in OL7 (or download using yum or curl or download from github)
To install and use the CLI, you must have:
- An OCI account
- A user created in that account, in a group with a policy that grants the desired permissions
- A keypair used for signing API requests, with the public key uploaded to Oracle. Only the user calling the API should possess the private key
The Cloud shell will start up a shell console to access your tenancy. It is an ephemeral machine from which you can run OS commands and scripts across your whole tenancy.
$ oci db autonomous-database
Please refer to the documentation for the available commands: