Stephane,
This is what I was exactly looking for. Thank you so much.
- Original Message -----
Date: Friday, November 14, 2003 8:59 am
> 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: jaysingh1_at_optonline.net
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >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: sfaroult_at_oriolecorp.com
>
> 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: 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: jaysingh1_at_optonline.net
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: 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 Fri Nov 14 2003 - 11:14:28 CST
