Ang: RE: How to find out what caused job to fail?

From: <Roland.Skoldblom_at_ica.se>
Date: Mon, 04 Feb 2002 01:46:39 -0800
Message-ID: <F001.0040487C.20020204013533@fatcity.com>

But how do I use the alert log and where canI find the trace file?

Roland

yen-wee.tan_at_amd.com_at_fatcity.com den 2002-02-04 01:05 PST

Sänd svar till ORACLE-L_at_fatcity.com

Sänt av: root_at_fatcity.com

Till: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Kopia:

Hi, you can find the reason in alert log or trace files.

     -----Original Message-----
     From: Daiminger, Helmut [mailto:Helmut.Daiminger_at_KirchGruppe.de]
     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: Roland.Skoldblom_at_ica.se

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: ListGuru_at_fatcity.com (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). Received on Mon Feb 04 2002 - 03:46:39 CST