Re: Managing Job Queues

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 12 Jul 1998 17:02:22 GMT
Message-ID: <35a8eb3b.676112@192.86.155.100>

A copy of this was sent to amattioli_at_gedy.it (Andrea Mattioli) (if that email address didn't require changing) On Sat, 11 Jul 1998 20:02:21 GMT, you wrote:

>On "Oracle 7 Server Administrator Guide" there's a chapter about Job
>Queues.
>In it, when it talks about Job Execution Errors I found:
>
>" When a job fails, information about the failure is recorded in a
>trace file"
>
>How can I know the name and location of this file.
>
>Thank you very much.
>
>Andrea Mattioli

It goes to the background dump destination:

SVRMGR> select value from v$parameter where name like 'background_dump%'; VALUE

/usr/oracle/oracle8/admin/oracle8/bdump 1 row selected.
SVRMGR> So, my background trace files go into that directory. for a job that failed via the job queue, the trace file will be named $(ORACLE_SID)_snp<N>_<M>.trc (n and m are numbers)

You will also see mentions of it in your alert file as well, for example, you'll see entries like:

Thread 1 advanced to log sequence 6186
Current log# 1 seq# 6186 mem# 0: /d02/dbs/redo01.log Current log# 1 seq# 6186 mem# 1: /d04/dbs/redo01.log Sun Jul 12 01:12:28 1998
Errors in file /usr/oracle/oracle8/admin/oracle8/bdump/oracle8_snp0_5460.trc:

ORA-12012: error on auto execute of job 51151
ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "INTRANET.COUNTER", line 10
ORA-06512: at line 1

Sun Jul 12 03:05:07 1998

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Jul 12 1998 - 12:02:22 CDT