That was it. Thanks.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
-----Original Message-----
Sent: Friday, March 28, 2003 12:24 PM
To: Ball, Terry
Terry:
Any chance the job_queue_processes parameter got set
to 0 on the new database??
Barb
- "Ball, Terry" <TBall_at_birch.com> wrote:
> Date: Fri, 28 Mar 2003 09:08:40 -0800
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> From: "Ball, Terry" <TBall_at_birch.com>
> Subject: Oracle Jobs not restarting after upgrade
>
> Solaris 5.8 Oracle 8.1.6 upgrade to 9.2
>
> We are testing an upgrade of Oracle from 8.1.6 to
> 9.2. There are several oracle jobs scheduled on
> this DB. Before we started the upgrade, all the
> jobs were broken (execute dbms_job.broken(201,
> true). The upgrade to 8.1.7 was done and then the
> migrate/upgrade to 9.2.0 was done. The jobs were
> then unbroken execute dbms_job.broken(201, false).
> But the jobs are not running. A select shows that
> the jobs are no longer broken, but is also shows
> that the last date they ran was just before the
> upgrade, with the next_date showing as the time it
> would have been scheduled before the upgrade. (I.e,
> if it ran on the first and was a daily job, it's
> next_date would be the second). We have tried
> issuing a change for the next date, but all that
> does is show a new next_date, it does not make the
> jobs run.
>
> Is there a way to make these jobs start running
> again. I have looked in the manuals, but either I
> am missing something obvious, or am not looking in
> the right place. Any help or suggestions are
> appreciated. TIA.
>
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX: 816-300-1800
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Ball, Terry
> INET: TBall_at_birch.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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).
>
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ball, Terry
INET: TBall_at_birch.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Fri Mar 28 2003 - 12:38:54 CST
