Roland,
you can read the alert log file with vi (or notepad if you are on windows). It can be found in background_dump_dest (look in the init.ora for it). The naming convention is alert_<SID>.log. Oracle writes lots of information about what is going on in the database (e.g. tablespace modifications, log switches and tons more) into that file.
Trace files are written to background_dump_dest (for background processes), user_dump_dest (for user processes) or core_dump_dest (Oracle core dumps). All files are plain text files.
hth,
Helmut
> -----Ursprüngliche Nachricht-----
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 4. Februar 2002 10:36
> An: Multiple recipients of list ORACLE-L
> Betreff: Ang: RE: How to find out what caused job to fail?
>
>
>
> But how do I use the alert log and where canI find the trace file?
>
>
> Roland
>
>
>
>
> [EMAIL PROTECTED]@fatcity.com den 2002-02-04 01:05 PST
>
> Sänd svar till [EMAIL PROTECTED]
>
> Sänt av: [EMAIL PROTECTED]
>
>
> Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Kopia:
>
> Hi, you can find the reason in alert log or trace files.
> -----Original Message-----
> From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 04, 2002 4:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: How to find out what caused job to fail?
>
>
>
> Hi!
>
>
> Is there a way to find out, why a database job failed?
> in dba_jobs (or user_jobs), I can only see that it failed,
> but no indication of the reason why it failed. Any ideas?
>
>
> This is 8.1.7 on Solaris.
>
>
> Thanks,
> Helmut
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>