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
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?