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
Title: RE: Oracle Jobs not restarting after upgrade
Run them manually for the first time, or try dropping and recreating them.
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any
dbms_job.run ?
-Original Message-
Sent: 28 March 2003 17:09
To: Multiple recipients of list ORACLE-L
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
Check you have the init.ora parameters set up in your new DB
Brian
-Original Message-
Sent: Friday, March 28, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
dbms_job.run ?
-Original Message-
Sent: 28 March 2003 17:09
To: Multiple recipients of list ORACLE-L
Solaris