Re: ORA-03113 End of communication channel

Billy Verreynne wrote:
>
> 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

Unfortunately too that this similar message is also given when the privileges on the datafiles and other oracle files were changed ! Received on Thu Oct 23 1997 - 00:00:00 CDT