Creating and Managing Oracle Autonomous Databases (Oracle Cloud)

Follow these instructions to create an Oracle Cloud account, generate the required config file and key files, and connect the Oracle Cloud Infrastructure Explorer tree control to the Oracle Cloud. Once the Oracle Cloud Infrastructure Explorer is connected to the Oracle Cloud, you can create and manage Oracle Autonomous Databases:

  • To change the compartment or region: Right click on the profile name (usually DEFAULT) and select Change Compartment or Region from the menu

  • To create a new Autonomous Database (ADB), including an Always Free ADB, right click on Autonomous Transaction Processing Databases, Autonomous Data Warehouses, or Autonomous JSON Databases and select Create New.

  • To view an existing database, expand Autonomous Transaction Processing Databases, Autonomous Data Warehouses, or Autonomous JSON Databases and view the list of databases. Change the region or compartment if your databases are not shown. Database icons with a red ball are not available, those with a yellow ball are starting or stopping, and icons with no ball are available. Icons with a green star are Always Free databases. Icons containing a D are dedicated instances.

  • To easily and automatically create a connection in Database Explorer, right click on database icon and select Create Connection in Database Explorer. For more information, see Connecting Without Using Credentials Files or Connecting Using Oracle Cloud Infrastructure Explorer to Automatically Download Credentials Files (Wallets).

  • To download credentials files, right click on database icon and select Download Credentials Files.

  • To obtain a connection string for this database, right click on database icon and select Get Connection Strings. Select the Authentication type and TNS Name (Service Level) from the drop down lists.

  • To configure walletless connectivity and network access right click on database icon and select Configure Walletless Connectivity and Network Access. For more information, see Configuring Walletless Connectivity and Network Access for Oracle Autonomous Databases (Oracle Cloud).

  • To Start an ADB, right click on database icon and select Start.

  • To Stop an ADB, right click on database icon and select Stop.

  • To Terminate an ADB, right click on database icon and select Terminate.

  • To change the ADMIN password for an ADB, right click on database icon and select Change Administrator Password.

  • To refresh the tree control, click on any item and select Refresh