My Oracle Support Banner

Trying to Debug PL/ SQL in SQL Developer Raises the ERROR ORA-30683 and ORA-12560 (Doc ID 605370.1)

Last updated on NOVEMBER 05, 2021

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Using SQL Developer 1.5.1 or above in Production and debugging a procedure in a remote database raises error in the debugging-log tab:

ERROR

Connecting to the database <databasename>.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '<........> '57936' )
ORA-30683: failure establishing connection to debugger
ORA-12560: TNS:proto adapter error
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process exited.
Disconnecting from the database <databasename>.

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.