RE: Help needed -- Replication and DBMS_JOB

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).