Re: init.ora - changs not recognised

Terry Dykstra wrote:

> If you used that actual spelling (LOG_ARHIVE_START), the database would not
> even startup. Most likely your database is starting of the spfile, not the
> pfile.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> "Vasu Shroff" <vasu.shroff_at_genisys-group.com> wrote in message
> news:b028df6c.0301241006.66be2d57_at_posting.google.com...
> > Dear Oracles,
> >
> > I am facing a strange problem. I need to set the parameter
> > LOG_ARHIVE_START=TRUE. I have specified it in the init.ora file
> > (Oracle 9i, win2k) in the folder $ORACLE_BASE/admin/$ORACLE_SID/pfile
> > directory. I restarted the DB. But it is not recognising the changed
> > value.
> >
> > I have just installed the DB and I have not changed the init.ora for
> > this instance.
> >
> > Any help is appreciated.
> >
> > Regards,
> > Vasu Shroff

Which means, after you correct the spelling, you need to issue the following:

SQL> create spfile from pfile='<init.ora name>';

Daniel Morgan Received on Fri Jan 24 2003 - 14:56:40 CST