Troubleshooting ORA-609

Tags

609, ORA-609

ORA-609 process unknown, its broken connections.

Follow below process to troubleshoot the issue:

— Identify the error in the alert log, and review listerner log. Gather connection info during the time line.

— Enable tracing to monitor client connections.

TRACE_LEVEL_CLIENT=16
TRACE_TIMESTAMP_CLIENT=ON
TRACE_DIRECTORY_CLIENT = <PATH>

Add above parameters with trace location in client’s sqlnet.ora

— Server level tracing.

TRACE_LEVEL_CLIENT=16
TRACE_TIMESTAMP_CLIENT=ON
TRACE_DIRECTORY_CLIENT = <PATH>

Add above parameters with trace location in server’s sqlnet.ora

You can review the sqlnet.log, alert.log, listener.log for connection drops. Once you identify the connections that are being dropped. You can pin point why the time outs were happening that resulting in connection drops.

If it’s due to internal calls, you can gather errorstack for 609 and identify the time out calls.

Enable error stack:

alter session set events ‘609 errorstack(3)’;

 

Hope this help in troublehooting ORA-609