Re: ORA-03113 End of communication channel

I also had this problem on SCO unix. It goes as follows: In a unix session, as oracle, the sqlnet 2 listener is started, and people can connect.
As soon as the session that started the listener is closed, the 3113 errors begin.
Sounds weird, but test it to see if this is the same problem. My solution was to use the following command: nohup lsnrctl start

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
Received on Tue Oct 28 1997 - 00:00:00 CST