Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id hAEGPPa03411 for ; Fri, 14 Nov 2003 10:25:25 -0600 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id hAEGPOc03406 for ; Fri, 14 Nov 2003 10:25:24 -0600 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id hAEDU0W7023629 for ; Fri, 14 Nov 2003 05:30:06 -0800 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id hAEDPQg3021447 for oracle-l@orafaq.net; Fri, 14 Nov 2003 05:25:26 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D6ABF; Fri, 14 Nov 2003 05:29:30 -0800 Message-ID: Date: Fri, 14 Nov 2003 05:29:30 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: jaysingh1@optonline.net Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: jaysingh1@optonline.net Subject: Help needed -- Replication and DBMS_JOB Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT 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: INET: jaysingh1@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@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).