5 Replies Latest reply on Mar 19, 2018 3:34 AM by Paul Simmons

    Unable to debug procedure from sqldeveloper


      OS: RHEL

      DB: 12CR1


      Hi all,


      Our App team is trying to debug  their procudure using SQLDEVELOPER but while doing so they are getting the below error:


      Connecting to the database portaluseruat.

      Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '', '52089' )

      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

      Process exited.

      Disconnecting from the database portaluseruat.


      We are able to connect to the database remotely from sqldeveloper only debugging is not happening, we have  implemented all the solutions available from the web as well.

      Please advise if anyone has faced this issue.