Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Roman VogtNov 8 2016

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?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2016
Added on Nov 8 2016
0 comments
499 views