Hello,
please, could anybody kindly explain what has to be set to debug procedures remotely over SSH tunnel? I've find only this thread so far and the explanation is anything but clear (at least to me). I can connect to my remote machine over SSH and I can tunnel other ports without any problems.
I set up the forwarded debugging port like this
I'm even connected, but when the port is connected, it chooses some "unpredictable" port number and the debugger starts on some different port and I'm getting the following error:
Connecting to the database linda_ssh.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '127.0.0.1:4000', '49966' )
ORA-30683: failure establishing connection to debugger
ORA-12545: Connect failed because target host or object does not exist
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process exited.
Disconnecting from the database linda_ssh.
which makes sense as my forwarded port is 34518 instead of 49966. The problem is that DBMS_DEBUG_JDWP.CONNECT_TCP starts everytimes with different port parameter, so I cannot Use specific remote port option.
Any help how to make it working would be highly appreciated.
Regards,
Pavel