Home » RDBMS Server » Server Administration » spfile error (oracle 10g)
spfile error [message #616321] Sun, 15 June 2014 21:36 Go to next message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
i am not able to execute any alter system command , the error i am getting is

ora-32001 : write to SP FILE requested but no spfile specified at startup.

i started the database using

startup pfile='d:\mydb_ks.sql'

since the location of pfile was on d:\ drive of the server.kindly advice.
Re: spfile error [message #616323 is a reply to message #616321] Sun, 15 June 2014 21:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
sqlplus / as sysdba
shutdown immediate
create spfile from pfile='d:\mydb_ks.sql';
startup
alter system .........


COPY the results from above then PASTE all back here


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

Re: spfile error [message #616329 is a reply to message #616323] Sun, 15 June 2014 22:47 Go to previous messageGo to next message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
thanks blackswan for the immediate response and great help.Well two more query, create spfile should be done after shutdown.Shall i go for shutdown abort instead of shutdown immediate as its taking long time to shutdown.
Re: spfile error [message #616330 is a reply to message #616329] Sun, 15 June 2014 22:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Shall i go for shutdown abort instead of shutdown immediate as its taking long time to shutdown.
YES
Re: spfile error [message #616335 is a reply to message #616321] Mon, 16 June 2014 00:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
i am not able to execute any alter system command , the error i am getting is

ora-32001 : write to SP FILE requested but no spfile specified at startup.


If you don't (want to) use a spfile then just modify your pfile, don't use alter system.

ALWAYS copy and paste what you do and get when you post an error.

Re: spfile error [message #616369 is a reply to message #616335] Mon, 16 June 2014 04:20 Go to previous messageGo to next message
ledo60
Messages: 63
Registered: May 2014
Member
If you want to continue with SPFILE
create spfile from pfile;
shutdown immediate
startup
Re: spfile error [message #616370 is a reply to message #616369] Mon, 16 June 2014 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Is this not what BlackSwan said?

icon14.gif  Re: spfile error [message #616452 is a reply to message #616370] Tue, 17 June 2014 02:36 Go to previous message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
Thanks all of you , it worked after i followed Blackswan advice.
Previous Topic: Oracle Database Upgrade from 11.2.0.3 to 11.2.0.4
Next Topic: Undo Tbs is not clearing/Flushing
Goto Forum:
  


Current Time: Thu Mar 28 17:35:54 CDT 2024