Sorry - I should have been more specific with "earlier
versions" - I was referring to 8.0 and (if memory
serves) one of the 8.1.x's. I was pondering whether
this had crept into 9 (although I would doubt it)
Keep us posted on what happens :-)
Cheers
Connor
- "Freeman, Robert" <Robert_Freeman_at_csx.com> wrote:
> See inline...
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
> Author: Oracle9i New Features
> Mastering Oracle8i
>
> Clark Griswold: Eddie, has anyone ever told you that
> you're bad luck?
> Cousin Eddie: Those were my mother's dying words.
> But I guess if your
> body's covered in third degree burns, and your
> foot's caught in a bear
> trap, you tend to start talkin' crazy.
>
>
>
> -----Original Message-----
> Sent: Wednesday, June 12, 2002 8:03 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Some comments...
>
> >> some earlier versions of the db had job bugs
> where
> >> the next date was not correctly calculated and
> thus
> >> stopped running - typically threw an ora-600 or
> at
> >> least a trace file in bdump (as opposed to udump)
>
> Is this true in 9i? If so, can you provide any bug
> numbers
> we can reference with Oracle? I can't seem to come
> up with
> any specific to 9i in Metalink.
>
>
> >> - we're running about 50 jobs at various
> frequencies
> >> on 9013 and not experienced anything you've
> described,
> >> at which point you're probably saying 'gee
> thanks' :-)
>
> Well, that may be one catch, we are currently on
> 9011... we have plans to
> move
> to 9013, but have not yet for some.... *cough*...
> very good reasons. Maybe
> this is an issue with 9011. If I could identify the
> bug then perhaps I can
> get Oracle to backport an existing patch.
>
>
> >> - see if the problem still occurs if you
> explicitly
> >> - set next date within the job itself, ie
> 'procx;'
> >> - becomes 'procx(next_date);' - this is not a
> great
> >> - workaround, but it does confirm if the next
> date value
> >> - is not being derived correctly by the scheduler
> itself
>
> Tried that, no joy. It's really strange, some jobs
> will run all the time,
> others
> run once, twice, three times maybe and then just
> never run again.
>
> >> - is the interval simple ? the most common errors
> for
> >> job timings I've seen are typically dodgey
> interval
> >> strings or passing a date to the parms instead of
> a
> >> varchar2
>
> Interval is something akin to "sysdate + 5/1440"...
> doesn't seem to complex.
> Like I said, this stuff worked fine in 8i, but in 9i
> it runs a while and
> dies.
>
> Thanks for your thoughts!
>
> RF
>
>
>
> hth
> connor
>
> --- "Freeman, Robert" <Robert_Freeman_at_csx.com>
> wrote:
> > I've got a TAR open on it now, but slow movement.
> >
> > RF
> >
> > Robert G. Freeman - Oracle8i OCP
> > Oracle DBA Technical Lead
> > CSX Midtier Database Administration
> > Author: Oracle9i New Features
> > Mastering Oracle8i
> >
> > Clark Griswold: Eddie, has anyone ever told you
> that
> > you're bad luck?
> > Cousin Eddie: Those were my mother's dying words.
> > But I guess if your
> > body's covered in third degree burns, and your
> > foot's caught in a bear
> > trap, you tend to start talkin' crazy.
> >
> >
> >
> > -----Original Message-----
> > Sent: Monday, June 10, 2002 2:39 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > We had the same situation and then we use "cron"
> > that never fails. Now, we
> > don't trust dbms_job ... I had a TAR open on that,
> > but can't access it now.
> >
> > Raj
> >
>
> > Rajendra Jamadagni MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > Any opinion expressed here is personal and doesn't
> > reflect that of ESPN Inc.
> >
> > QOTD: Any clod can have facts, but having an
> opinion
> > is an art!
> >
> >
> > -----Original Message-----
> > Sent: Monday, June 10, 2002 2:13 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Anyone run into any problems with the job
> scheduler
> > in 9iR1 not kicking
> > off jobs when they are scheduled?
> >
> > We have a situation where a given job (runs every
> 4
> > hours or so) will be
> > kicked
> > of successfully 2-3 times, and then on the 4th
> time
> > the scheduler does not
> > kick
> > it off, next_date is not incremented... it's like
> > the job just gets lost in
> > space...This same scheduled job ran fine in 8i.
> > (this is an 8i to 9i
> > migrated
> > database)
> >
> > Any thoughts on this?
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Freeman, Robert
> > INET: Robert_Freeman_at_csx.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).
>
> =====
> Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
>
> "Some days you're the pigeon, some days you're the
> statue"
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
> 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Freeman, Robert
> INET: Robert_Freeman_at_csx.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).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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 Thu Jun 13 2002 - 03:58:36 CDT
