0 Replies Latest reply on Nov 8, 2016 4:29 PM by Roman Vogt

    sqldeveloper use a different port for debugging - has anybody the same problem?

    Roman Vogt

      I use the sqldeveloper on a Windows 7 workstation with an Oracle 11 datatabase.

       

      Since a few days my debugging sessions could not establish a connection:

      Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE

      Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'myWorkstation', '50025' )

      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.

       

      The strange is, that a network connection will be opened, but on a port number minus one. For the example above, a netstat -na at the Windows command line shows me the following:

       

        TCP    myWorkstation:50024     myDatabase:4711        ESTABLISHED

       

      This behavior is reproducible only on my workstation. Debugging from other workstations works well.

       

      First I assume a firewall issue on my workstation - so I disable the firewall. I restarted the workstation, install different sqldeveloper etc.

       

      Has anybody been faced with the same problem?