Let’s turn off the 1521 port if we can already open so that to make sure our connection using SSH works. It will confirm us that SSH is enabled.
Moreover SSH connection is more secure.
In SQL Developer menu, click on View –> SSH. Then right click and choose “Create New SSH Host”.
Provide the Cloud Database Service Public IP address and the SSH key file. Enable port forwarding on port 1521.
Now choose “New Connection” in SQL Developer, and configure a connection using connection type as “SSH”. Now enter the service name of the cloud database and test your connection.
So now you know that it is very easy to access a database with SSH.
Can we connect it from Oracle Fusion Instance ?? or Only with Onpremis this wil work out ?
We can with fusion instance by making ssh data sources connection
Can you please tell me the navigation to add the ssh data sources. Thank you