Re: Help!!! End of file!!!!!!!!! communication!!!!!!!!

It should be noted that ORA-3113 is a generic error. It basically means that the server went away. So, the problem described by Terrence may not be the same as that described by Rajs.

                        Rick
                        Rick Wessman
                        Network Security Products
                        Oracle Corporation
                        rwessman_at_us.oracle.com

Terrence Wong <mingjun_at_singnet.com.sg> writes:

>
> Hello.
> I have this problem recently.
> While compiling the lastest program to be run onto the production
> machine. CRASH. Finally, came to realised that the core of the problem
> may be the sql statements used are not optimised. This is particularly
> so when indexes are created and the joining tables seems to favour one
> index over the other. Solution was to re-investigate the query and
> in-active (using nvl ..) the second-prefered index.
>
> The core dumps seems to be no more.
> The systems you have described is the likely cause for the solution I am
> having. Then again, if both hands are tied, no harm shouting aloud.
>
> ps. We are using a web server at time.
> Cheers.
> Terrence
> Systems Developer
>
> rajs_at_meghdoot.mastek.com wrote:
> >
> > Hi everybody,
> > Our Oracle server configuration is Oracle 7.3.2 Workgroup Server for Unix
> > ScoOpenServer5.x. SQL*Net is Release 2.3.
> > 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.Any clues??? Looking for a right direction to analyze the situation
> > Thanks in advance.
> > Regards
> > Rajs
  Received on Thu Oct 16 1997 - 00:00:00 CDT