Download, Install and Configure Oracle Database JDBC Driver

Follow these steps to download and install Oracle Database JDBC Driver and then download the client credentials for your dedicated Autonomous Transaction Processing database and make 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. 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 will 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.

  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.