Autonomous AI Database

Configuring Network Security Group (NSG) and connection to Google Cloud VM instance are prerequisites for connecting to Autonomous AI Database.

1. Obtain Autonomous AI Database Wallet
   1. From the Google Cloud console, navigate to Autonomous AI Database, and then select your Autonomous AI Database from the list.
   2. From the Autonomous AI Database Details page, select the Connections tab.
   3. From the Download client credentials (Wallet) section, select the Download Wallet button.
      1. Enter a wallet password in the Password field and confirm the password in the Confirm password field.
   4. Select the Download button to save the client security credentials as zip file. By default the file name is: Wallet_databasename.zip. You can save this file as any file name you want.
2. Connect Oracle SQL Developer to Autonomous AI Database
   1. Upload the Wallet_databasename.zip file to Jump Box.
   2. On Jump Box, launch the SQL Developer application, and then select the + icon to create a new database connection.
   3. To configure SQL Developer, complete the following substeps:
      1. In the Name field, enter a descriptive name to use for this database connection.
      2. From the Database Type dropdown list, select Oracle.
      3. In the Username field, enter the name of the user for whom this database connection is being created. For example, you can enter ADMIN.
      4. In the Password field, enter the password of the user.
      5. In the Role field, select the default role to assign it to the user.
      6. Select the Save Password checkbox if your security rules allow.
      7. In the Connection Type field, select the Cloud Wallet option as your database connection type.
      8. In the Configuration File field, select the Browse button to select Wallet_databasename.zip file.
      9. In the Service dropdown list, select your service to use for this connection.
      10. Select the Test button to validate connection to the database.
      11. Once the connection is successful, the Status will change to Success.
      12. Select the Save button, and then select the Connect button.