Hi,
You create the sp file after connecting to idle instance only.
Then startup the database.
Thanks.
--Sukhamoy.

Mark Vosteen wrote:

>e didn't have a initSID.ora file. I have created one from the sample file
>that was called init.ora. I tried your commands after deleting the bad
>spfile.
>
>create spfile = 'spfileORABALT.ora' from pfile = 'initORABALT.ora';
>and I got this:
>ORA-32002: cannot create SPFILE already being used by the instance
>
>I then changed the command to this and it worked.
>create spfile = 'spfileORABALT1.ora' from pfile = 'initORABALT.ora';
>and it worked. Now I have a spfile with a different SID name than my server.
>Can I move it to the correct name before I restart the server?
>
>-----Original Message-----
>From: Sabina
>[mailto:oracledba-ezmlmshield-x59610371.[Email address protected]
>Sent: Wednesday, November 02, 2005 2:13 PM
>To: LazyDBA Discussion
>Subject: Re: spfile
>
>
>If you have the pfile (initSID.ora) then
>1. delete the corrupted spfile (never edit this file manually. it is a
>server parameter file and it is only the server
> that writes into this file. You can view the contents in your text
>editor, back it up, and that's it.
>2. Recreate the spfile CREATE SPFILE FROM PFILE; The database could be up
>or down, it does not matter
>3. SHUTDOWN IMMEDIATE;
>4. STARTUP (the server will then use the spfileSID.ora to startup the
>database)
>NOTE
>All changes made after the corrupted spfile was created are lost. you must
>now make those changes again.
>example : Alter system set parameter=value scope=both or scope=spfile;
>
>Sabina.
>
>
>
>
>"Mark Vosteen " <oracledba-ezmlmshield-x41713499.[Email address protected]
>11/02/2005 01:51 PM
>
>To
>"LazyDBA Discussion" <[Email address protected]
>cc
>
>Subject
>spfile
>
>
>
>
>
>
>I am new to oracle, spent a lot of time with Sybase.
>In our new server I was having an issue updating the amount of concurrent
>sessions we could have. I edited the spfile manually with vi. I did not
>restart the server because I stumbled upon this sql command to fix it.
>
>alter system set sessions = 512 scope = spfile;
>
>This gets me the following error which I think happens because I edited
>the
>spfile manually.
>
>ERROR at line 1:
>ORA-27046: file size is not a multiple of logical block size
>Additional information: 1
>
>
>How do I fix my spfile, is there a way to copy running configuration from
>memory to the spfile? I can't even log into the Oracle Enterprise Manager
>now that I have corrupted the spfile.
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:
>http://www.lazydba.com/legal.html
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>


Oracle LazyDBA home page