Re: Queries don'twork any more - urgent!

In the directory pointed to by the background_dump_dest init<sid>.ora parameter (in svrmgrl do show parameter dump). By default if you didn't change it in $ORACLE_HOME/rdbms/log

Hth,

Sybrand Bakker, Oracle DBA

kev <kev_at_markandlard.com> schreef in berichtnieuws 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 Tue Jun 06 2000 - 00:00:00 CDT