If you stop the instance, remove the corrupt spfile, rename the new spfile,
then start the instance, it might work. If it doesn't, then start the
instance using the pfile.
But, I think it should work ok. Either way, your instance will be back up
and running.
| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Mark Vosteen
[mailto:oracledba-ezmlmshield-x18719475.[Email address protected]
Sent: Wednesday, November 02, 2005 1:25 PM
To: LazyDBA Discussion
Subject: RE: spfile
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