Re: ora_snp locks offline datafile

why don't you try in a nice way;
alter system set job_queue_processes=0;
alter system set job_queue_processes=x;

and it is done.

sometimes datafile can be openned by process, even if they have been offlined, or even dropped.

On 4/1/06, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
> The SNP processes do get restarted automatically.
>
> Whenever I do a "kill -9" for the snp process, I check and double check the
> PID -- I don't want to kill the pmon
> or smon or lgwr or dbwr process. Those don't restart automatically.
>
> Hemant
> At 12:50 AM Saturday, Alessandro Vercelli wrote:
> >....I got late in taking that step, as the three ora_snp instances
> >released by themselves the locked filesystem....just for curiosity: if I
> >had killed the snp processes, whould they restarted automatically or
> >should I have restarted them?
> >
> >Thanks,
> >
> >Alessandro
> >
> > >
> > > If there are no jobs currently running in DBA_JOBS_RUNNING, you can "kill
> > > -9" the snp processes.
> > >
> > > Hemant
>
>
> Hemant K Chitale
> http://web.singnet.com.sg/~hkchital
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l