This post covers things you must know in order to connect to the Autonomous Database on Oracle Cloud. If you don’t know what is Autonomous Database, then I would suggest you check my previous post on [Video] Oracle Autonomous Data Warehouse Cloud Service 18c Now on OCI
Database Service In Oracle Cloud Infrastructure
Databases in Oracle Cloud Infrastructure can be put in Two main categories:
- Autonomous Database: Autonomous Database includes
– Autonomous Transaction Processing (ATP)
– Autonomous Data Warehouse (ADW)
Autonomous databases are preconfigured, fully-managed environments that are suitable for either transaction processing or for data warehouse workloads, ie it is serverless, you don’t have access to servers where it is running, Well so connecting to Autonomous Database is quite simple and you can connect from various tools like SQL Developer, Oracle Data Integrator (ODI), Goldengate, any Oracle TNS Client or JDBC, etc.
NOTE: To know more about ADW & ATP click here - User-Managed Database: User-managed Database is Databases on bare metal, virtual machine, and Exadata DB systems that enable you to customize with the resources and settings that meet your requirement.
Steps To Connect Autonomous Database
Note: Make sure you have provisioned the Autonomous Database Instance in Oracle Cloud if you don’t know then check our previous Video Blog where we have given a live demo how to provisioned Autonomous Database in Oracle Cloud Infrastructure.
1. Download & Install the SQL Developer (Version 18.2 or above).
(Links at the end to Download SQL Developer)
2. Download the Client Credentials (Wallet) from the OCI Console, which we will be using while connecting to Autonomous Database Instance via SQL Developer.
Note: Make sure you have downloaded the SQL Developer version 18.2 or a higher one, else these features not supported on it.
4. Once you filled above details click on Test if the status changed to successful then you can click on connect to your Autonomous Database Instance
Now you are ready to perform your administrative task on Autonomous Database Instance.
(Now it’s your turn to post your doubts in the comment section and let us know where you are facing challenges while connecting to Autonomous Database Instance using SQL Developer.
Next Task For You:
You can start learning Oracle Cloud for DBA by registering for our FREE Masterclass. By Clicking the image below.
Muhammad Imran says
Sir, Very good knowledge. in screenshots it is easy to learn and understand.
Surbhi Sharma says
Hi Muhammad,
Glad you find our blog useful.
Stay tuned for the further blogs.
Regards,
Surbhi
(Team K21)
Muhammad says
Can you explain in detail plz
Rohit Pathak says
Hi Muhammad,
Everything is already covered in videos, however, if you any doubts at a specific section, please post here, so that we can help you out.
Thanks & Regards,
Rohit(TeamK21)
Karthik says
I am not able to connect to database. I am getting the below error “The network adapter could not establish the connection.”
Any suggestions?
Varsha Sharma says
Hi Karthik,
1. Make sure your entries are correct
2. Make sure you have selected the client Wallet location under the configuration file
3. Sometimes you select incorrect Service from the drop-down list in the SQL Developer connection setup, so check that please.
4. Also check the version of your SQL developer, it should be the latest one
If you double-check and everything looks fine .. then try downloading a new wallet and creating a connection with the new one.
Regards
Varsha Sharma
(Team K21)
Abdul says
HI Team,
Could you please explain about connecting the cloud ADW using putty session by adding entry in TNS .
Thanks
Abdul
Surbhi Sharma says
Hi Abdul,
You can add the entry of tnsnames.ora to the on-prem DB under sqlnet.ora
Also, if you want to know more in details, we cover this in our DBA to Cloud DBA training, check here for free masterclass: https://k21academy.com/clouddba02
Regards,
Surbhi
Team K21
Gokul says
When I try to connect Oracle ATP or Oracle Autonomous Database. I am getting the below error “The network adapter could not establish the connection.”
While creating DB am I missing anything? I am using the JDBC details from DB connection or from Wallet tns file.
Surbhi Sharma says
Hi Gokul,
1. Make sure your entries are correct
2. Make sure you have selected the client Wallet location under the configuration file
3. Sometimes you select incorrect Service from the drop-down list in the SQL Developer connection setup, so check that, please.
4. Also, check the version of your SQL developer, it should be the latest one
If you double-check and everything looks fine .. then try downloading a new wallet and creating a connection with the new one.
Regards
Surbhi
(Team K21)
ameet says
Go through the Surbhi suggestion and also check if you have the network connectivity from your local machine to ADB. you can use the tnsping to confirm .
Mahesh says
Can we SSH to the sever where ATP / ADW instances are running ?
Piyush Jain says
Hi Mahesh,
There are Two Types of Autonomous Databases Serverless and dedicated to know more about serverless and dedicated check here https://k21academy.com/1z093112.
In serverless you don’t get access to the servers so you can’t ssh to the server but if you have dedicated autonomous then you can ssh to the server.
Regards
Piyush
(Team K21)
Krishna says
I am able to connect to Serverless ATP using wallet etc. How to connect to Dedicated ATP from SQL Developer? It always says “The Network Adapter could not establish the connection”.
Piyush Jain says
Hi Krishna,
1. Make sure your entries are correct
2. Make sure you have selected the client Wallet location under the configuration file
3. Sometimes you select incorrect Service from the drop-down list in the SQL Developer connection setup, so check that please.
4. Also, check the version of your SQL developer, it should be the latest one
5. Appropriate ports are open or not.
https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/adbconnecting.htm
If you double-check and everything looks fine .. then try downloading a new wallet and creating a connection with the new one.
Regards
Piyush
(Team K21)
AnyaCH says
Hi. I am trying to connect to Oracle autonomous DB.
I do everything like in the video, but when pinging the host I get “Request timed out.” message. I also allowed traffic through 1522 port on my computer, but that does not help either. Please suggest any possible solutions, I would be very grateful.
Thanks!
PRateek says
Hi,
Is there any way I can connect Oracle ADW using AWS lambda function or using AWS glue? I am not able to find any supporting document.
Thanks,
PS