2 Replies Latest reply on Jan 20, 2014 8:01 AM by Ahmed Gamal Khamis

    SQL Developer Debugging and Securiy Issue

    Ahmed Gamal Khamis

      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.



      1. Toad has both options server side and client side debugging
      2. 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.