Download, Install and Configure Oracle Instant Client

Follow these steps to download and install Oracle Instant Client and then download the client credentials for your dedicated Autonomous Transaction Processing database and make 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. If you have an Oracle Cloud user account that permits you to access this page, download the credentials as follows. If you don't have such an account, you need to get the zip file from the administrator of the database, together with the password that was used to protect the zip file.

    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.