HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SQL developer: Setup debugger for plsql

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlsetupfordeveloperplsqldebugger

Problem

I'm trying to debug remotely pl/sql. But I can't - database returns me an error. What should I do to fix this and start debugging ?

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


UPD

I'm trying to debug procedure on remote server. On local computer I have only sql developer installed.

Solution

Do you have a local firewall running? You will need to add an exception for SQLDeveloper. It starts a listener that listens for the database/session debugging events. If it can't connect back to you, there-in lies the problem.

Context

StackExchange Database Administrators Q#30156, answer score: 3

Revisions (0)

No revisions yet.