Oracle Cloud Infrastructure Documentation

Autonomous AI Database (Serverless)

This topic explains the required steps to connect to Autonomous AI Database from Azure Virtual Machine (VM). Configuring Network Security Group (NSG) and connection to Azure VM are prerequisites for connecting to Autonomous AI Database.

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

  1. Obtain Autonomous AI Database Wallet
    1. From Azure portal, navigate to Autonomous AI Database, and then select Database from list.
    2. From the database Overview, navigate to Settings, and then Connections.
    3. Select the Download wallet, select Instance wallet for Wallet Type and enter a wallet password in the Password field and confirm the password in the Confirm password field.
    4. Select Download to save the client security credentials 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 Azure VM.
    2. On Azure VM, Launch the SQL Developer application and 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. From the Role dropdown list, select the default role to assign to the user.
      6. Select the Save Password checkbox if your security rules allow.
      7. From 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 zip file.
      9. From the Service dropdown list, select your service to use for this connection.
      10. Select the Test button to validate connection to the database.
      11. Select the Test button. The Status at the bottom of the connection list should show Success.This screenshot shows how to connect to Autonomous AI Database.
      12. Once the connection is successful, select the Save button.This screenshot shows how to connect to Autonomous AI Database.