0 Replies Latest reply: Jun 24, 2014 1:33 AM by Ora-aff RSS

    ORA-30683: failure establishing connection to debugger ORA-12541: TNS:no listener

    Ora-aff

      I am connected to a remote Dev database through SQL Developer.

       

      SQL Developer specifications are as follows:

      Version 3.2.20.09

      Java(TM) Platform 1.7.0

      Oracle IDE 3.2.20.09.87

      Versioning Support 3.2.20.09.87

       

      When I try to debug the stored PL/SQL procedure, I get the following exceptions:

      Connecting to the database XXXX.

      Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE

      Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'XX.XX.X.XXX', '49152' )

      ORA-30683: failure establishing connection to debugger

      ORA-12541: TNS:no listener

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

      ORA-06512: at line 1 Process exited.

      Disconnecting from the database XXXX.

       

      I checked using netstat command and found that the PORT 49152 is listening. So it is not blocked. I tried using both the IPs: The IP of my machine and also the IP of the remote database server which is used to establish the connection.

       

      What are the other things I should try?