Re: Jobs do not run

On Aug 3, 8:30 am, "Martin T." <0xCDCDC..._at_gmx.at> wrote:
> sybrandb wrote:
> > On Aug 3, 3:57 pm, "Martin T." <0xCDCDC..._at_gmx.at> wrote:
> >> Hello.
>
> >> DB = Oracle9i Release 9.2.0.1.0 - Production
> >> OS = Windows XP sp2
>
> >> Our test database refuses to run any jobs. CJQ0 is there, but does not
> >> start up any Jxxx processes.
>
> >> We tried everything (including restarts and reboots) described in
> >> Metalink note 313102.1 which includes checking for
> >> JOB_QUEUE_PROCESSES=0, server uptime, removing and recreating all jobs,
> >> checking some obscure settings, ...
>
> >> We've really no clue what to do now. All the jobs are there in the
> >> dba_jobs (user_jobs) view but only the next_date is set (to time in the
> >> past) last_date and this_date are both (null) and checking active
> >> sessions we can see that CJQ0 is running but no Jxxx processes.
>
> >> We have also checked the alter log etc. and found nothing obvious.
>
> >> Any ideas where else to look?
>
> >> thanks!
> >> Martin
>
> > correct procedure is
> > begin
> > dbms_job.submit
> > end;
> > /
> > --!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
> > commit
> > /
> > or it will hang 4ever.
>
> Thanks for pointing this out.
> Naturally one would assume that after restarting the database and even
> the machine the jobs still being there may still not be committed. :-P
>
> > You do have a CSI, do you? You are using this for production purposes,
> > do you?
> > If so, why did you never upgrade?
> > Follow Daniels advice and go to 9.2.0.8 or Oracle will drop the phone
> > on you.
>
> The problem only exists in our test db instance (at the moment)
>
> I fully expected you and Daniel to tell me that. (Given the fact that
> there are 7 patch sets we haven't even looked at it might even have some
> foundation.)
>
> Let's for a moment assume we were running Oracle 10g2 with the newest
> patch and hit this. What would you propose except calling Oracle?
>
> Best regards, and don't be sad that some people only patch a running
> system when they hit a problem that is solved by patching.
>

See deferred maintenance on the LA freeways all the time. Doesn't make it any less stupid. Makes me mad when my progress is impeded because someone else is stupid. Makes me sad when innocent people are hurt.

jg

--
@home.com is bogus.
http://rides.webshots.com/album/43043142uDOhYs