Re: Ora - 03113

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 05 Jul 2002 19:41:50 GMT
Message-ID: <3D25F655.86E2C754@exesolutions.com>

Niall Litchfield wrote:

> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3D25C84D.1921B801_at_exesolutions.com...
> > Niall Litchfield wrote:
> >
> > > I'm stumped (mostly because ths probably comes under the Network
> Magic(tm)
> > > area). We have a new system that runs quite happily for a number of days
> > > (like say 20 or 30) after which time some clients - mostly those who are
> > > heavy users of the system get disconnected with the above error message.
> > >
> > > Does anyone have any suggestions as to where to look. The net8
> > > troubleshooting guide tells me to refer to my os specific documentation
> but
> > > I can't actually find any windows specific net8 documentation.
> > >
> > > Do I actually have to dump admin level client and server level traces
> until
> > > the error recurs - this does not fill me with enthusiasm.
> > >
> > > --
> > > Niall Litchfield
> > > Oracle DBA
> > > Audit Commission UK
> > > *****************************************
> > > Please include version and platform
> > > and SQL where applicable
> > > It makes life easier and increases the
> > > likelihood of a good answer
> > >
> > > ******************************************
> >
> > Dear Niall,
> >
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer.

>

> grrrrrr. windows 2000 sp2 for both clients and server. two of the clients
> are actually servers themselves (an app server and a web server IIS5 ). The
> Oracle version is 8.1.7.3 both client and server. network cards are gbit
> ethernet though running at 100/full duplex in what maybe a vain attempt to
> help matters out.

>

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

>
> <not saying it this time I'm sulking! >

I am truly sorry. It's just that it was right there and ....

Take a look in sqlnet.ora too. Try commenting out any parameters not absolutely necessary.

Daniel Morgan Received on Fri Jul 05 2002 - 14:41:50 CDT