How to connect to ATP Database from SQL Developer

How to connect to ATP Database from SQL Developer

In this blog, I am covering how to connect to an ATP database from SQL developer. Many times we face difficulties connecting to ATP databases from SQL developer; this is because we miss the prerequisite of connecting databases. In this blog I am going to highlight the same.

In this blog I will cover specifically the ATP database which created where "access type: 

Allow secure access from specified IPs and VCNs"

In my next blog I will cover how to connect ATP database from SQL developer where access type = Private endpoint. Click Here to goto that post.

Let see the first our Network access type is "Allow secure access from specified IPs and VCNs"

Now, the prerequisite is to configure the access control list. This is a very important an crucial part.

Click on Edit link under Network -> Access Control List. It will open a Pop-up window to add an IP address.

Here in my case I have added my laptop IP address from where I will connect to my ATP database.

Please refer to the screenshot below for your reference.

Click on Save button.

Once you add your specific IP address. Now let's look at the default security list of your VCN.

In my case this is the default security list which was configured during the creation of my VCN.

Below screenshot is just for your reference.

Now, Download the wallet file.

Click on the "Database connection" button highlighted in the screenshot below.

Click on "Download Wallet" button.

Provide wallet password. Must note this password somewhere in your notepad, This will be used whenever you will connect to the ATP database using a wallet file.

Click on the Download button to download the wallet file.

Till this point, we have completed the prerequisites. Now Open your SQL developer.

Click on "New Connection"

Fist give the connection Name,

• Provide Username as admin
• Password as < password > (This is the same password that you had given at the time of creating ATP database.)
• Connection typ = Cloud Wallet 
• Configuration File = < Path of your Cloud Wallet that you have just downloaded from ATP database connection page. 
• Service = Choose which service type you want to select. In my case it is cbtatp_tp

Now, click on "Test" button.

Hope this article will help you.

Thanks for reading.

Thanks & Regards,

Chandan Tanwani