How to Connect Oracle Autonomous with Oracle Client

June 24th, 2019

Oracle Autonomous Database is a powerful technology that provides data processing and management in the cloud for self-driving, self-securing and self-repairing databases which can operate with no human intervention. So, it’s quite unsurprising that many want to know how to establish a connection between Oracle Client and Oracle Autonomous. Let’s take a look at how this can be achieved.

Various applications can connect to Autonomous Transaction Processing through any of the connection types supported by Oracle Net Services. In this particular case, we’ll need to use an Oracle Call Interface connection also known as OCI.

The following steps outline the basic process of making any OCI-type connection:

  • Installing the client software
  • Downloading the client credentials
  • Configuring certain files and environment variables
  • Setting up the connection in the application

For the last step, we’ll use dbForge Studio for Oracle by Devart – an IDE that allows synchronizing data between different Oracle servers and automating schema change management during the development process.

Now, we’ll go through each of the steps in detail.

Installing the client software

First, you will need to install the Oracle Client software on your computer.

If you want to use the full Oracle Database Client edition, download version 11.2.0.4 or higher. Alternatively, you can use Oracle Instant Client. It contains the minimum required set of components for making an Oracle Call Interface connection. For most applications, Instant Client version 12.1.0.2 or higher will be sufficient.

Downloading the client credentials

Once the sufficient version of Oracle Client is installed, the next step would be to download the client credentials and store them on your machine.
Oracle client credentials, or wallet files, provide access to data in your Autonomous Transaction Processing database – so they should only be stored in a secure location. In addition, only authorized users should have access to credentials.

Feel free to follow this guide for detailed information on how to download client credentials via the Oracle Cloud Infrastructure console.

When the archive with necessary files is successfully downloaded, extract it to a secure folder on your computer – for example, D:\Wallet_DB201904201312

Configuring files and environment variables

Now, you will need to edit the sqlnet.ora file (%ORACLE_HOME%\network\admin ) in the folder to which you extracted the credentials file. The only thing you’ll need to do here is to replace ‘?/network/admin’ with the actual path to the folder containing the credentials.

For example, this is what the file looks like before editing:

And this is what it might look like after:

Next, open the tnsnames.ora file from the folder mentioned in step 3 and copy the connections to the tnsnames.ora file located in the %ORACLE_HOME%\network\admin folder.

Setting up the connection

With everything properly configured, we can finally set up the connection in dbForge and connect to the server.
To create a new connection, go to Database and click New Connection. Specify the necessary information such as connection type, server name, username and password. Once the connection is created, you will be able to connect to the server by double-clicking the connection in the Database Explorer section situated in dbForge’s top left corner:

dbForge Establish Connection

Summary

As we have seen, connecting Oracle Client to Oracle Autonomous Transaction Processing is not a complicated process as it only requires a few rather simple steps. However, you should still be diligent when performing them – especially when it comes to client credentials. You will need to make sure that all wallet files are stored in a secure place and are only accessible to authorized users.
If all steps are followed properly, the process should not cause any difficulties.

As for dbForge Studio for Oracle – you can download it and try out its robust database development and maintenance features for free.

Leave a Comment