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 23:11:42 -0700
Message-ID: <1156313502.200037.192810@p79g2000cwp.googlegroups.com>


I could not agree more about this. The thing is that I sit on a theird company as a DBA and is hired in when things go wrong. That means that people can mess things up badly and then expect others to fix their mistakes.

DA Morgan wrote:
> nicklas.lundgren_at_triacon.se wrote:
> > 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
> >

>

> 1. Please do not top post. Scroll to the bottom to reply.
>

> 2. So the DBA prefers downtime for problems such as this to downtime
> for applying the appropriate patches? My impression is that
> management needs to re-evaluate this DBAs qualification for the
> job. My instinct would be that they made a bad choice.
> --
> 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 Wed Aug 23 2006 - 01:11:42 CDT

Original text of this message

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