How to connect to Oracle Cloud Autonomous Database via PL/SQL Developer

Personal Chao yu
Jul 12, 2021
1 min read

Let us jump straight into it.

Go to you OCI autonomous database and click on DB Connection so you can download wallet.

Once the wallet is downloaded, unzip the wallet file. You can store it as i have done(optional).

I created a new folder called cloudwallet and placed in my network/admin folder

In side the cloudwallet folder, we have both the wallets related files plus sqlnet.ora & tnsnames.ora, these two files need to merged to its parent folder's slqnet.ora and tnsnames.ora.

slqnet.ora

In the parent folder ( in my case it is admin folder) , create file sqlnet.ora if it does not exists. The sqlnet.ora should look like this after you finish edit it. Please be aware the DIRECTORY should reflects your own path for your wallet.