Hoping to get some clarification on the use cases for the SQLDev SSH connection type
I have three scenarios (SQLDev v19.2):
MobaXterm has a way to set up a local-host -> jump-box -> remote-host connection for SSH connections and this seemed very similar so I thought I would try it.
Put another way, here is what I would like to work:
SQLDev windows client -> SSH host db_server_2 (port 22) -> SSH host db_server_3 (22) -> db-3 (1521)
So, db_server_2 would be used as a jump box to get to db_server_3.
db_server_3 hosts db_3 but is not reachable from SQLDev client, However db_3 is reachable from db_server_2 via port 1521
What you need is for db_server_ to be reachable by port 22, then you can create an SSH tunnel to server two, and THEN connect to the database on DB_SERVER_2...assuming 1521 is open on db_server_3 from db_server_2