Please help me connecting to remote Oracle Server.
Oracle 11g is hosted on a Unix Server, which we access
- Creating a SSH session . See Attachment 'Remote Host Connection.jpg'
- Creating a SSH tunnel.. See attachment 'Tunneling.jpg'
After the tunnel is established (2nd method), I though we should be able to establish connection from DbFit to DB server, but its not working. Connection timeout error is show.
Please help me to get the connection established
- Either directly creating a SSH tunnel from DbFit if possible.
- Or connect to DB server using the SSH tunnel created.
Below is the code used for testing
!path lib/*.jar
!|dbfit.OracleTest|
!|Connect|localhost:5000|<DB user name>|<password>|dbfit|
!|Query|select 'test' as x|
|x |
|test |
Please find attached screenshot with error displayed.
Copyright Notice:Content Author:「user1842137」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/60448044/dbfit-connection-for-remote-oracle-server-via-ssh