Connect to Autonomous Transaction Processing Using a Client Application

Autonomous Transaction Processing is preconfigured to support Oracle Net Services through a TNS listener is installed and configured to use either TCPS connections (secured using client credentials) or TCP connections.

The client computer must be prepared to use Oracle Net Services to connect to Autonomous Transaction Processing.

About Connecting to Autonomous Transaction Processing Using a Client Application

Applications can connect to Autonomous Transaction Processing using any of the connection types supported by Oracle Net Services.

The following steps describe the process of connecting to Autonomous Transaction Processing using a client application:

  1. Determine what connection type your application uses, (for example OCI, ODBC, JDBC Thin, and so on).

  2. Prepare your client computer for the type of connection used by your application. See the following sections.

  3. Within your application, set up the connection.

The steps required to prepare the client computer depend on the type of connection used by the client application. In all cases, client credentials in the form of the wallet file must be downloaded to the client.

Prepare for Oracle Call Interface (OCI), ODBC, and JDBC OCI Connections

You prepare for Oracle Call Interface (OCI), ODBC, and JDBC OCI connections by downloading and installing Oracle Instant Client and then downloading the client credentials for your dedicated Autonomous Transaction Processing database and making them available to Oracle Instant Client.

  1. Download and install the Oracle Instant Client basic package for your system's OS and architecture:

    • Oracle Linux:

      1. Enable the Instant Client channel:

        yum -y install oracle-release-el7
      2. Download and install the Instant Client 19.3 basic package:

        yum -y install oracle-instantclient19.3-basic

        (To see a list of all Instant Client packages, go to http://yum.oracle.com/repo/OracleLinux/OL7/oracle/instantclient/x86_64/index.html.)

    • Other OSes and architectures:

      1. Go to the Oracle Instant Client Downloads page and select the download for your system's OS and architecture.

      2. On the download page, accept the Oracle Technology Network License Agreement, download the latest version of the Basic Package, and then install it by following the instructions at the bottom of the download page.

  2. Download the zip file containing client credentials for your database to a secure directory on your computer.

    This zip file is available for download from the database's Details page in the Oracle Cloud console. Download the credentials as follows.

    1. In your web browser, sign in to Oracle Cloud and navigate to the Details page for the dedicated Autonomous Transaction Processing database.

    2. Click DB Connection.

    3. On the Database Connection page click Download.

    4. In the Download Wallet dialog, enter a wallet password in the Password field and confirm the password in the Confirm Password field.

      The password must be at least 8 characters long and must include at least 1 letter and either 1 numeric character or 1 special character.

    5. Click Download to save the client credentials zip file to a secure directory.

  3. After downloading the zip file, follow these steps:

    1. Unzip the client credentials zip file.

    2. Edit the sqlnet.ora file provided in the client credentials, replacing "?/network/admin" with the full path of the directory where you unzipped the client credentials; for example, change:

      (DIRECTORY="?/network/admin")

      to:

      (DIRECTORY="/users/jdoe/adbcredentials")
    3. Create the TNS_ADMIN environment variable, setting its value to the full path of the directory where you unzipped the client credentials.

Prepare for JDBC Thin Connections

You prepare for JDBC thin connections by downloading and installing Oracle Database JDBC Driver and then downloading the client credentials for your dedicated Autonomous Transaction Processing database and making them available to Oracle Database JDBC Driver.

  1. Go to the Oracle JDBC Downloads page and select the latest version of the drivers.

  2. On the Driver & UCP Downloads page, accept the OTN License Agreement, and then download ojdbc10-full.tar.gz or ojdbc8-full.tar.gz, depending on the version of JDK you are using.

  3. Download the zip file containing client credentials for your database to a secure directory on your computer.

    This zip file is available for download from the database's Details page in the Oracle Cloud console. Download the credentials as follows.

    1. In your web browser, sign in to Oracle Cloud and navigate to the Details page for the dedicated Autonomous Transaction Processing database.

    2. Click DB Connection.

    3. On the Database Connection page click Download.

    4. In the Download Wallet dialog, enter a wallet password in the Password field and confirm the password in the Confirm Password field.

      The password must be at least 8 characters long and must include at least 1 letter and either 1 numeric character or 1 special character.

    5. Click Download to save the client credentials zip file to a secure directory.

  4. Unzip the client credentials zip file.

  5. Create the TNS_ADMIN environment variable, setting its value to the full path of the directory where you unzipped the client credentials.

Applications with Built-In Support for Wallet ZIP Files

Some applications allow you to choose a credentials ZIP file as part of the connection properties.

For example, in SQL Developer 18.3 and higher, in the Connection Type field select the value Cloud Wallet that allows you to enter a credentials ZIP file in the Configuration File field. SQL Developer then presents a list of the available connections in the Service field (the connections are included in the credentials files).

If your application provides support for wallets or provides specific support for an Autonomous Transaction Processing connection, for example, Oracle SQL Developer, Oracle recommends that you use that type of connection.