OraFAQ Forum: Server Administration » modify static parameter in spfile

Home » RDBMS Server » Server Administration » modify static parameter in spfile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

modify static parameter in spfile [message #64048]

Wed, 08 December 2004 23:09

shyam_kk
Messages: 9
Registered: August 2004

Junior Member

i am using oralce 9i for windows rel 2.How can i set
paramters at instance level some of the parameters we cannot change dynamically.like log_Archive_format and log_Archive_start.I got error when i am tried with
alter system and scope=both
how to modify this parameter
with regards
shyam

Report message to a moderator

Re: modify static parameter in spfile [message #64050 is a reply to message #64048]

Wed, 08 December 2004 23:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I always prefer to play a safe game.
Do a clean shutdown.
edit your inti< sid >.ora and apply the changes.
set your ORACLE_SID ( in case of mulitple databases in same box).
start instance with this init< sid >.ora.
open the database.
check whether the changes were applied correctly.
If everything is ok, create an spfile from pfile;
sql > create spfile='path' from pfile='path';
do a clean shutdown.
startup normal ( now spfile is already made use of by default).
optionally , create a new pfile for future use ( just for reference).

Report message to a moderator

Re: modify static parameter in spfile [message #64052 is a reply to message #64048]

Thu, 09 December 2004 00:16

Vivek Vijai
Messages: 67
Registered: April 2004

Member

To modify a static parameter like LOG_ARCHIVE_START use:

Alter system LOG_ARCHIVE_START=FALSE scope=SPFILE;

then at next starup u will notice that LOG_ARCHIVE_START is set to FALSE.

Hope this will solve your problem.

Vivek

Report message to a moderator