Re: ORA-03113 End of communication channel

rajs_at_meghdoot.mastek.com wrote in article <61hmtq$g0r_at_drn.zippo.com>...
> Our protocol is TCP/IP. The installation went smoothly and work
 progressed also
> smoothly. But the we found that the listener process is fine and up.But
 after
> sometime, intermittently new clients are unable to connect to the
 database.The
> error is ORA-03113 end-of-file communication channel. This happens very
 often
> and we have stop and start the listener process again to allow the new
> connections.

I've had the exact same problem on a number of occasions and everytime there was a different solution. The weirdest was running local sqlplus on the server doing a huge extract (spool). After about 100MB it bombed with ora-3113 everytime. Finally I changed the connection string to use a loopback connection (instead of a local connection) and the job went thru first time. <aargghh!>

I suggest you make sure that you have the latest SQL*Net patches for the server and use the latest SQL*Net client software. A shot in the dark - why not look at the tcp/ip stack settings, limits and stats in Unix too? You just may find something interesting that may explain your specific problem, such as a time-out TCP connection due to high number of collisions.

regards,
Billy Received on Wed Oct 15 1997 - 00:00:00 CDT