D.1 Using a Walletless TLS Connection

You can connect to Autonomous AI Database using a walletless Transport Layer Security (TLS) authentication.

Perform the following steps to connect to Autonomous AI Database without a wallet.
  1. Sign in to Oracle Cloud and select your Autonomous AI Database instance.
    This opens the Autonomous AI Database details page.
  2. Start your Autonomous AI Database instance if it is not in Available state.
  3. Locate the Network section on the Autonomous AI Database details page.
    You can view the network information for your Autonomous AI Database such as access type, access control list, availability domain and other network configurations.
  4. Specify an access control rule.
    1. Click Edit next to the Access Control List (ACL).
    2. Click Add access control and configure an access control rule by adding the IP address of your client machine.
    3. Click Save to add the new value to the access control list.
      Once the update is complete, the network ACLs from the access control list are in effect.
  5. Disable Mutual TLS (mTLS) Authentication.
    1. Click Edit next to the Mutual TLS (mTLS) Authentication.
    2. Uncheck Require mutual TLS (mTLS) authentication.
    3. Click Save.
  6. Obtain the database connection string.
    1. Click Database Connection the Autonomous AI Database details page.
    2. Select TLS under TLS Authentication.
      You can view the list of connection strings.
    3. Copy the required Connection String.
      The following shows an example of a connection string:

      (description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=<host_name>.oraclecloud.com))(connect_data=(service_name=<service_name>.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes))

      If necessary, you can add network proxy information to the address description as follows:

      (description=(retry_count=20)(retry_delay=3)(address=(https_proxy=<proxy_host>)(https_proxy_port=80)(protocol=tcps)(port=1522)(host=<host_name>.oraclecloud.com))(connect_data=(service_name=<service_name>.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))

  7. Build the JDBC URL using the connection string.
    Append the connection string to jdbc:oracle:thin:@ to obtain the JDBC URL to connect to Autonomous AI Database. For example, the following shows the JDBC URL using the sample connection string shown in the previous step:

    jdbc:oracle:thin:@(description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=<host_name>.oraclecloud.com))(connect_data=(service_name=<service_name>.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))