Re: init.ora - changs not recognised

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 24 Jan 2003 15:58:09 -0800
Message-ID: <92eeeff0.0301241558.24c0b18b@posting.google.com>

vasu.shroff_at_genisys-group.com (Vasu Shroff) 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

First change your spelling from ARHIVE to ARCHIVE. Secondly, you need to resync your spfile from your pfile.

C:\> set oracle_sid=<SID> 
C:\> sqlplus /nolog
SQL> connect sys/password as sysdba
SQL> shutdown immediate (If database already started)
SQL> create spfile='ORACLE_HOME\database\spfile<SID>.ora' from

pfile='path and pfile name';
SQL> startup

Regards
/Rauf Sarwar Received on Fri Jan 24 2003 - 17:58:09 CST