ORA-03113: end-of-file on communication channel - client connection lost after several minutes
Posted on 2003-12-01
I have a strange problem with my client connection to an oracle database. I can connect to the database fine and work with the database ok, but if I leave the connection alone then after a couple of minutes I get an "ORA-03113: end-of-file on communication channel" error.
If I open a sqlplus session on the server where the database resides I do not lose my connection when I leave it open for over 10 minutes.
There are several databases on the server and I seem to be having the same problem with all of them.
I suspect that because I can connect ok initially, but then lose my connection, that I have a network issue, but I am not sure what would cause this problem to happen. It is occurring with all my colleagues as well.
Unfortunately I do not have a metalink account as we do not hold the oracle licenses ourselves so I cannot check this problem out there. The database is oracle 8.1.7 and resides on a Windows 2000 server. If any one has any suggestions then I'd appreciate your input?