Re: init.ora - changs not recognised

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 25 Jan 2003 11:07:11 +1100
Message-ID: <8qkY9.32459$jM5.82597@newsfeeds.bigpond.com>

Rauf Sarwar wrote:

> 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

Alternatively, since it seems apparent that he is already using an spfile, issue the command:

alter system set log_archive_dest='xxxxx' scope=spfile;

...to edit it directly.

And then shutdown immediate, followed by startup to get the change to take effect.

Regards
HJR Received on Fri Jan 24 2003 - 18:07:11 CST