patternMinor
SQL developer: Setup debugger for plsql
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 ?
UPD
I'm trying to debug procedure on remote server. On local computer I have only sql developer installed.
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 1UPD
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.