Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

share|improve this question
no listener means that you are trying to connect to a port of a server where no oracle listener is listening. Is this package using a database link? – miracle173 Aug 26 '13 at 11:57

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.

share|improve this answer
No, I have no firewall. I'm using mac os, sql developer Version – Igor Konoplyanko Dec 12 '12 at 14:00
+1 to REW, I get reports of this all the time. Developer can work fine when database is on their subnet, but working from different network segment or VPN the debugging connection from the server back to SQLDeveloper (or other tool) does not make it. Local firewall may be one issue, but as REW said, if it can't connect back to you that is the root issue. Can you ping from the server to your local workstation? – David Mann Jan 12 '14 at 3:10

I haven't tested it again, but as far as I remember you need DEBUG privileges to use the debugger in SQL Developer:

share|improve this answer
also: GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP TO YOUR_USER; – Franek Jan 29 '15 at 14:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.