1 Reply Latest reply on Jul 21, 2013 3:08 PM by thatJeffSmith-Oracle

    Debugging issue

    user458361
    user458361 Jul 20, 2013 9:27 PM

      Hi

      Getting following error while trying to debug a procedure .

       

       

      Connecting to the database VM DBA SYSTEM.

      Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE

      Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '172.24.39.167', '3549' )

      ORA-30683: failure establishing connection to debugger

      ORA-12535: TNS:operation timed out

      ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68

      ORA-06512: at line 1

      Process exited.

       

      Following privileges are give, but still facing the issue.

       

      SQL> grant DEBUG ANY PROCEDURE to xxxxx;

       

       

      Grant succeeded.

       

       

      SQL> grant DEBUG CONNECT SESSION  to xxxxx;

       

       

      Grant succeeded.

       

      note:Accessing the database through VPN .