Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'my pc ip', '58201' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
This message appears when I try to debug a procedure from SQL developer. I concluded that the database failed to connect to the debugger on my pc to proceed with the debugging. I have security concerns in our network to open access from database side to my pc.
Did Oracle put this issue in concern when developing the debugger? Is there a way to set the debugging of the procedures and functions to be server side? or any suggestions to bypass this security concerns.
N.B.:
- Toad has both options server side and client side debugging
- It should be known that a lot of access request will be issued to allow the databases connect to the client pcs and this is kind of unreasonable request for the security folks.