Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03113: end-of-file on communication channel
On 20 Mar 2003 21:59:49 -0800, chuaby_at_hotmail.com (chuaby) wrote:
>or could a
>router automatically drop a session if it detects that there is no
>activity for the session ?
Definitely possible. There are various registry settings like TCPkeepalive, which determine when the connection is considered 'dead'.
ORA-3113 has also literally 1000s of course.
You would need to conduct a sqlnet trace from both client and server
side to check what is really going on.
trace_level_client = 16
in sqlnet.ora on the client
trace_level_server = 16
on the sqlnet.ora on the server
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Fri Mar 21 2003 - 12:30:33 CST