Re: Oracle error log
From: michael ngong <mngong_at_yahoo.com>
Date: 10 Jul 2003 06:05:38 -0700
Message-ID: <ecf365d5.0307100505.46aab4de_at_posting.google.com>
Date: 10 Jul 2003 06:05:38 -0700
Message-ID: <ecf365d5.0307100505.46aab4de_at_posting.google.com>
aprinsloo_at_websoft.co.za (Allen) wrote in message news:<236c75fa.0307090540.437c0b11_at_posting.google.com>...
> I'm from a Sybase and Ms SQL server background and a bit new to
> Oracle.
> Does Oracle have a databse error log where all database errors are
> logged to?
> I've searched(maybe not hard enough) for either an overall oracle log
> and for an instance specific log, but have not found anything.
>
> Thx in advance
It is assumed here that your database is up and running and you can get in.
select value from v$parameter where name like '%background_dump_dest%'; OR show parameter background_dump_dest
should give the location of the alert log file
HTH Michael Tubuo Ngong Received on Thu Jul 10 2003 - 15:05:38 CEST