Hi, I'm Henry Byorum, Senior Director of Product Management within Oracle's database development organization. In this session, I'll be covering how to use the OCI command-line interface to manage your autonomous database. The CLI is a small, lightweight tool that you can use either on its own or in conjunction with the console to complete OCI tasks. The command-line interface provides the same core functionality as the console plus additional commands. You can also use the command-line interface to run scripts. The CLI is built on Python, and it can run on Mac, Windows, or Linux. The Python code makes calls to the Oracle Cloud Infrastructure APIs to provide the functionality that's implemented within our various Cloud services. These REST APIs are the same APIs that are used by the console. To install and use the command-line interface, you need to have several items in place. First of all, you'll need an Oracle Cloud Infrastructure account. In addition, you will need a user in that account, in a group with a policy that grants the desired permissions. This account can be you, it can be another user, or it can be a system that is actually calling these APIs. You'll also need a keypair for signing the API requests. The public key is uploaded to Oracle and then the private key is held by the user. You'll need Python version 2.7.5 or 3.5 or later running on your system. Note, if you don't actually have Python on your system and you use the CLI installer, it will place the proper version of Python on your system. Here is an example of the command-line interface. The supported autonomous database commands that you can invoke using the OCI-CLI are create or delete an autonomous database, you can get the details of a specified autonomous database, you can get a list of autonomous databases. In addition, you can restore, start, stop, update, or backup your autonomous database. This example of an OCI-CLI call creates an autonomous database. Notice the variables are defined, including all of the parameters that are previously discussed that are needed to create an autonomous database. Then the command, oci db autonomous-data-warehouse, is run with the parameters. Here we can see, in the console, the autonomous database section. After having run the command-line interface command, we can see that the demo autonomous database that we have created using the command line scripts is now in the provisioning state. After a few minutes, we're able to see that it is now available. Examples of calls for some of the other supported OCI CLI commands that were previously described are shown in this slide. Note the format is always the same, starting with the oci db call then specifying the database service, in this case, autonomous data warehouse, followed by the command parameters and associated variables that are needed to run. To wrap things up, the OCI command-line interface is a small lightweight tool that gives you another option to create, run, and manage your autonomous database. Thank you.
