We have an issue on some client PC's here that when attempting to debug a stored procedure in SQL Developer we get the following error…
Connecting to the database UAT.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '1*5.2*4.2*5.202', '2**9' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNSperation timed out
I have done some investigation into the ORA-30683 error and found out that this is linked to the ORA_DEBUG_JDWP parameter. The example syntax given being "SET ORA_DEBUG_JDWP=host=hostname;port=portnum" What I don’t know is how to implement this?
- Are we talking the client level or server level?
- What parameters am I passing in as hostname and port? client or server?
- Where abouts am I setting this parameter, init.ora?
- I have also read some information about the listener but again I am not sure if we are talking client or server?
If someone can help me with a step by step guide on how to "enable" debugging of Oracle stored procedures that would be helpful.
Connecting to the database UAT.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '1*5.2*4.2*5.202', '2**9' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNSperation timed out
I have done some investigation into the ORA-30683 error and found out that this is linked to the ORA_DEBUG_JDWP parameter. The example syntax given being "SET ORA_DEBUG_JDWP=host=hostname;port=portnum" What I don’t know is how to implement this?
- Are we talking the client level or server level?
- What parameters am I passing in as hostname and port? client or server?
- Where abouts am I setting this parameter, init.ora?
- I have also read some information about the listener but again I am not sure if we are talking client or server?
If someone can help me with a step by step guide on how to "enable" debugging of Oracle stored procedures that would be helpful.