Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB jobs wont run for longer periods
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