1 2 Previous Next 22 Replies Latest reply: Oct 31, 2007 8:57 AM by -K- RSS

    PL/SQL Debugger and ORA-12541: TNS:no listener

    501448
      I installed SQL Developer on my PC (Windows XP). I have a connection to my devlopment database on server (Solaris, Oracle 9.2.0.6).

      I create a procedure and compile it successfully. Now I want to 'debug' it. I click on the Debugger (ladybug), set my parameter value and click on 'OK' in the Debug PL/SQL window. In the Debugging log I get:

      Connecting to the database Banner devl.
      Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
      Executing PL/SQL: ALTER SESSION SET PLSQL_COMPILER_FLAGS=INTERPRETED
      Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '130.207.xxx.xxx', '4000' )
      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 Banner devl.

      What listener is it looking for on my own machine? I don't have J Developer and I'm using a remote database.

      I found the thread on setting the 'Prompt for Debugger Host for Database Debugging'. Enabled that and tried debugging again. Got the prompt for entering the IP of the Debugger Host. Tried the database server. So I got:

      Connecting to the database Banner devl.
      Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
      Executing PL/SQL: ALTER SESSION SET PLSQL_COMPILER_FLAGS=INTERPRETED
      Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '130.207.xxx.xxx', '4000' )
      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 Banner devl.

      The answer is probably right in front of me, but I just can't see it. Is something mission on the database server?
        1 2 Previous Next