Error received while debugging any procedure:
"ORA-03113: end-of-file on communication channel"
Immediately after that, Toad hangs and results with this error:
"PROBE:timeout error"
1) Verify if your user has all the necessary privileges to debug procedures. Here are the list of privileges that Oracle requires for debugging.
GRANT ALTER ANY PROCEDURE TO user_name
GRANT CREATE ANY PROCEDURE TO user_name
GRANT ALTER SESSION TO user_name
GRANT CREATE SESSION TO user_name
GRANT EXECUTE ON DBMS_DEBUG to public
With Oracle 10g, you need these additional privileges:
GRANT DEBUG ANY PROCEDURE TO user_name
GRANT DEBUG CONNECT SESSION TO user_name
2) Make sure that your user has access to the V$SESSION view.
3) Verify that your SYS.DBMS_DEBUG package is valid.
4) Try patching your database server to the latest patch. The newer patches may fix bugs for the Oracle server.
