Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump (never remember where it goes).
HTH
SF
>----- ------- Original Message ------- -----
>From: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Fri, 14 Nov 2003 05:29:30
>
>Dear Gurus,
>
>I have dbms_job in replication environment to push
>deffered transactions from site "A" to "B" and "B"
>to "A".
>
>The job which is running at site "A" is working
>fine but job which is running at site "B" is not
>pushing the transactions automatically. But if I do
>it manually (either dbms_job.run(job_number) or
>using OEM UI) it is working fine. Otherwise
>dbms_job failed count keep increases every minute
>and finally it becomes broken.
>
>The owner of the DBMS_JOB is REPADMIN at both
>sites.
>
>Is there a way to check the root cause for the
>failed DBMS_JOB?. I need to check the reason why
>the particular DBMS_JOB is failing. I don't want
>DBA_JOBs view because DBA_JOBS gives the number of
>failed count.
>
>
>Note:-
>
>Number of Job_queue_processes is configured as 20
>in both sites("A" and "B").
>Also iI confirmed that 20 # of snp unix process is
>running at each node.
>job_queue_interval is 60 secs.
>
>thanks
>Jay
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
