Re: Oracle jobs not running. Help

Thanks for your comments Herald.
I knew the couse of the problem.

I'll tell in case it helps.
The cold backup took longer than usual and I am not allowed to have the db down past 9 a.m. so I canceled it by killing the process.(We launch the backup by cron). And then tried to start the db but it told me that Oracle was already running. Aparently I killed first the process that was making the tar file and by the time I killed the backup.sh it has started de db. I didn't think much at that moment - I was in a hurry - so I issued shutdown immediate then I realized what was happening and canceled the shutdown. As a result the db stayed up but the ora_snpxx_sid processes where not runnnig.

I was looking for a way to fix the problem without bouncing the database. But I did not find it. Finally I did bounce the db and my jobs are automatically running again!!!!!!!1

Thanks again

Nat

Harald Maier <maierh_at_myself.com> wrote in message news:<m3llso3f9a.fsf_at_ate.maierh>...
> natalia.poggi_at_spm.com.ar (Nat) writes:
>
> > Since our last cold backup something with the dbms_jobs seems to be
> > wrong.
>
> > I cannot figure what. All de jobs are queued in the dba_jobs table
> > with broken = 'N' and failures = null. But for some reason they do
> > not run. They just stay there waiting for the ora_snpXX_sid to picke
> > them up!!!
> >
>
> You might look into the trace files in the directory where the
> 'background_dump_dest' initialization parameter points to. There you
> should find a error message.
>
> Harald
Received on Wed Sep 17 2003 - 13:43:59 CDT