Oracle Jobs not restarting after upgrade

2003-03-28 Thread Ball, Terry
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

RE: Oracle Jobs not restarting after upgrade

2003-03-28 Thread Jamadagni, Rajendra
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

RE: Oracle Jobs not restarting after upgrade

2003-03-28 Thread Nicoll, Iain
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

RE: Oracle Jobs not restarting after upgrade

2003-03-28 Thread Spears, Brian
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