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.

       

      N.B.:

      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.