Job queue in 8.1.7.2.1 on Win2k - dead

From: Gary Weber <gweber_at_charlesjones.com>
Date: Wed, 03 Oct 2001 08:02:27 -0700
Message-ID: <F001.003A0811.20011003075603@fatcity.com>

Hello,

While I'm trying to get this resolved with Support, I wonder if anyone else encountered follow problem.

Oracle EE 8.1.7.2.1 on Windows 2000 Advanced server.

DBMS_JOBs don't run automatically. When executed manually, they are ok, when placed in a queue, they just sit there. SNPs processes are running.

This worked fine up until 8.1.7.1, which had different bugs, and prompted an upgrade to 8.1.7.2.1. I suspect this latest upgrade introduced the stale job queue.

All obvious solutions have been tried and failed (changing queue size, bouncing, submitting jobs as system, check for invalid objects). Alert.log is clean. There are no trace files at all. ORADEBUG attached to SNP indicates the process is not doing anything - idle.

Any thoughts?

Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gary Weber
  INET: gweber_at_charlesjones.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Wed Oct 03 2001 - 10:02:27 CDT