Re: ora_snp locks offline datafile
- From: "zhu chao" <zhuchao@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Sat, 1 Apr 2006 18:50:42 -0800
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@xxxxxxxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Regards
Zhu Chao
www.cnoug.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
