OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » spfile error (oracle 10g)

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

spfile error [message #616321]

Sun, 15 June 2014 21:36

m.abdulhaq
Messages: 243
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.

Report message to a moderator

Re: spfile error [message #616323 is a reply to message #616321]

Sun, 15 June 2014 21:49

BlackSwan
Messages: 26204
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/

Report message to a moderator

Re: spfile error [message #616329 is a reply to message #616323]

Sun, 15 June 2014 22:47

m.abdulhaq
Messages: 243
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.

Report message to a moderator

Re: spfile error [message #616330 is a reply to message #616329]

Sun, 15 June 2014 22:49

BlackSwan
Messages: 26204
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

Report message to a moderator

Re: spfile error [message #616335 is a reply to message #616321]

Mon, 16 June 2014 00:11

Michel Cadot
Messages: 65848
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.

Report message to a moderator