Re: Queries don'twork any more - urgent!

It's written to wherever your background_dump_dest parameter is pointing. So find your init.ora for the relevant instance, and find where that is.

And no, I won't be able to help you in finding your init(SID).ora. By default (and off the top of my head) it's in the ORCLE_HOME/dbs directory somewhere.

And why the hell aren't you reading your alert log every day? Any good DBA would be doing so as a matter of routine.

How do you know if your log files are big enough (check the alert log for log switch information). How do you know if there's been corruption in a file (check the laert log for ORA-600 errors). And on and on. Really: besides knowing how to log on to your netowork in the first place, the location of your alert log should be second nature.

You do realise that unless you keep clearing it out (ie, deleting the old one) it will keep growing and growing?

I should talk. Oracle (NSW) just cleared out a 300Mb alert log dating back to 1997!

Make friends with your alert log. It's important. HJR "kev" <kev_at_markandlard.com> wrote in message news:393C5519.81647B7C_at_markandlard.com...
> OK thanks. Sorry to be so dumb, but where do I find the alert log?
>
> - Kev
>
> Sybrand Bakker wrote:
>
> > Comment embedded.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > kev <kev_at_markandlard.com> schreef in berichtnieuws
> > 393B01EE.140F053B_at_markandlard.com...
> > > Hi,
> > >
> > > I'm using 8.1.5 on Red Hat 6.1.
> > >
> > > Certain (similar) queries have stopped returning any results. They
 were
> > > working fine, and then suddenly stopped. I'm 99% certain I have done
> > > nothing which may have caused this.
> > >
> > > Where the hell do I start to find out what's wrong?
> >
> > As usual in the alert log.
> >
> > > I'm at home and so don't have Oracle Support's 24/7 support phone
 number
> > > (England) with me. If anyone could remind me of it (mail me direct) I
> > > can ring them.
> > >
> > > thanks,
> > >
> > > - Kev
> > >
>
Received on Fri Jun 09 2000 - 00:00:00 CDT