From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Subject: Re: Queries don'twork any more - urgent!
Date: 2000/06/06
Message-ID: <960268547.23657.0.pluto.d4ee154e@news.demon.nl>#1/1
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
References: <393B01EE.140F053B@markandlard.com> <960204507.21432.0.pluto.d4ee154e@news.demon.nl> <393C5519.81647B7C@markandlard.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Complaints-To: abuse@nl.demon.net
X-Trace: news.demon.nl 960268547 pluto:23657 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-MSMail-Priority: Normal
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server


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@markandlard.com> schreef in berichtnieuws
393C5519.81647B7C@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@markandlard.com> schreef in berichtnieuws
> > 393B01EE.140F053B@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
> > >
>