Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-32001: write to SPFILE requested but no SPFILE specified at startup

DBA2011Feb 6 2006 — edited Feb 7 2006
SQL> alter system set
2 fast_start_mttr_target=300 scope=both;
alter system set
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup

How i can specify SPFILE at startup?

Comments

249425
Try this one:
create spfile from pfile;

shutdown immediate

startup

show parameter spfile

should give you something similar to this:
mob@MOB92.WORLD> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string %ORACLE_HOME%\DATABASE\SPFILE%
ORACLE_SID%.ORA

Best Regards
Krystian Zieja / mob
376714
How i can specify SPFILE at startup?
This sould be explained clearly in the Administrator Handbook, but

1/ put the spfileSID.ora file in the standard directory (%ORACLE_HOME%\database or $ORACLE_HOME/dbs)

2/ create a pfileSID.ora containing a pointer to the spfile (i.e. one line = SPFILE=/path/to/spfile/spfileSID.ora)

3/ create the file from 2 anywhere and use startup pfile=/path/to/the/redirect/pfile/init.ora

4/ IIRC in 10g you can startup spfile=... but I'm not sure, check TFM.

If you don't understand what I wrote, just:
create spfile from pfile;
shutdown immediate;
startup;
show parameter spfile;
Last line will give you the current spfile location if found.

Regards,

Yoann.
DBA2011
what are the advantage of using spfile instead pfile ?
Nicolas Gasparotto
Hi,

The spfile is not updatable manually, but in dynamic with sql command.
So, there is less error due to manual enter.

Nicolas.
487148
The main advantage is that you can edit some parameters dynamically without having to restart Oracle

Vadim Bobrov
Oracle Database Tools
http://www.fourthelephant.com
488408
hai

pfile is manually enter, we can cahange this at any time in your OS mode.

after alter your pfile you must create the spfile.
spfile is system side file,
at initial the server start with default pfile, once you create the pfile, the server is start with your pfile, after create the spfile your system start with spfile.

Ex: if your system start with spfile, and you have to modify something in your pfile, if you dont create the spfile. there is no changes occurs, alter you acreate spfile , change will occurs.

senthil
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 7 2006
Added on Feb 6 2006
6 comments
86,012 views