how to delete and re-create an SPFILE

[lhugh]

I need to reset some of my parameters. My database is using an SPFILE right now.

I am thinking bout creating a pfile from spfile, edit the pfile and re-create the spfile

I am able to create the pfile but I can't create the spfile. Oracle gives me an error saying that there is an spfile already

How do I do this?

 

[amirak17]

1. shutdown immediate;
2. Delete spfile using OS
3. conn sys/&pwd as sysdba
4. startup nomount;
5. create spfile from pfile;
6. alter database open;



Amir Ali Khan

http://geocities.com/amirkhanthegreat/

 

[lhugh]

thank you Amir