Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DB jobs wont run for longer periods

Re: DB jobs wont run for longer periods

From: <nicklas.lundgren_at_triacon.se>
Date: 22 Aug 2006 00:51:38 -0700
Message-ID: <1156233098.774194.83630@m79g2000cwm.googlegroups.com>


Yes I know it should have been patched. The problem is that the new DBA at the site installed this, not me. Then it will require downtime to patch and the customer won't accept that. This is a big problem for me that is asked to fix problems with my hands tied :(

DA Morgan wrote:
> nicklas.lundgren_at_triacon.se wrote:
> > Hi
> >
> > I have a job that should run every minute, this works fine for a while
> > but then all of a sudden it stops to be executed. The parameter:
> > job_queue_processes is set to 10 and I have only six jobs. If I run
> > this job manually it then runs for one or two days but then it just
> > stops to be executed again.
> > This is a Oracle 9.2.0.1 database.
> >
> > Can anybody help me, that would really be appriciated.
>
> Just a thought ... why in 9.2.0.1? Oracle has released a rather
> substantial number of meaningful patches in the last 5 years. I would
> suggest patching up to at least 9.2.0.6 at a minimum.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Tue Aug 22 2006 - 02:51:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US