Dbms_debug_jdwp.Connect_tcp Unable to Connect to Debugger: Error ORA-30683 (Doc ID 363691.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 1.0.0.14.67 to 4.0 [Release 1 to 4]
Information in this document applies to any platform.
"Checked for relevance on 04-Mar-2008"
***Checked for relevance on 09-APR-2114***


Symptoms

The loss of functionality
Debugging a procedure in a remote database using a TNS connection raises error in the debugging-log tab:


Connecting to the database meyer@devdb.sinius.org.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'XXX.X.X.X', '2920' )
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.

Note: Different behavior with Database Pre 9ir2, it will use DBMS_DEBUG package without error, but SQL Developer is certified with 9ir2 and above.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms