In this post, I have discussed how to get the Public IP of Database in Oracle Gen 2 Cloud & Connect to the Database Instance using PUTTY.
As per the latest update [July 2019] in the Oracle Cloud Database console, the navigation of getting the public IP has been changed.
We are getting lots of requests from our trainees, as they are unable to get the Public IP of the Database, so I thought of creating a blog post for the same.
Database Offerings
In Oracle Cloud Infrastructure, Database is divided into two types:
- User-Managed Database
- Autonomous Database
Note: To know more on how to get the Database On Oracle Cloud (OCI): User-Managed and Autonomous Database, Check here
Steps to Get the Public IP of the Database Instance
Note: You will get the public IP only if you have used the Public Subnet. If you have selected the Private Subnet, you can’t change it to the public, and you will have to create a new Instance.
- Login to the OCI Console and navigate to the Database section.
2. Click on the Database name on which you want to connect.
3. On the left side of the Database Instance Details page, click on Nodes under the Resources.
Steps for Connecting to a Database Instance:
There are 3 main ways to network to Oracle Cloud Instance i.e…
- SSH (Secure Shell)
- IPsec VPN (Virtual Private Network)
- FastConnect
Note: Here is a slide from the Connectivity/Security Module of our Cloud Training
Now that you have performed all the Steps for troubleshooting, check whether you can connect to your instance or not.
You can connect to a running Instance using a Secure Shell (SSH) for Linux or Remote Desktop connection for Windows. To connect to a Linux Instance from your Laptop, you can download a FREE SSH client called PuTTY from Here.
Enter the Public IP Address in the Hostname, then add the SSH Private key under SSH & then Auth. Click on Open.
Well, that was all on How to Create & Connect Windows/Linux machine on Oracle Cloud (OCI).
I hope the above-mentioned steps will help you.
Related/Further Readings
- Create Compute (Linux/Windows Machine) On Oracle Cloud (OCI)
- Oracle Cloud: Create VCN, Subnet, Firewall (Security List), IGW, DRG: Step By Step
- [Troubleshooting] Compute/Database Instance Connectivity Issue in Oracle Cloud (OCI)
- Database On Oracle Cloud (OCI): User-Managed and Autonomous Database
- Oracle Database Cloud Service 2019 | 1Z0-998
If you want to take your career to the next level by switching your role from that of DBA To Cloud DBA even if you are a beginner, then I would like to invite you to Join my FREE MasterClass on DBA To Cloud DBA: What, Why & How to Learn.
Click on the image below to Register for the FREE MasterClass NOW.
FREE Community
Click on the image below to join our FREE Community group.
Leo says
Surbhi,
Well explained. I work for Oracle it took few hours to find the IP address till I get to your blog. Thanks for the details. Well explained as well.
Surbhi Sharma says
Hi Leo,
Glad you liked my post, stay tuned for further more informative & troubleshooting blogs.
Regards.
Surbhi
Team K21