Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

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

2 Answers 2

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 3.2.10.09 –  Igor Konoplyanko Dec 12 '12 at 14:00
1  
+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 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:

  GRANT DEBUG CONNECT SESSION TO YOUR_USER;
  GRANT DEBUG DEBUG ANY PROCEDURE TO YOUR_USER;
share|improve this answer

Your Answer

 
discard

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.