Problem with spfile 1

[nassrin5]

I changed a parameter in Oracle with scope spfile. I had to shutdown Oracle and when I startup I get startup error. How can I sort out the problem. I need to remove the wrong parameter setting from spfile. My problem is that my pfile makes a reference to spfile as follows:

spfile=$ORACLE_HOME/dbs/spfileCLM.ora

and spfile is a binary file

Please help!!

 

[sybaseguru]

OK do not panic let us sort it out.

First rename your pfile to pfile_old.

Then although spfileCLM.ora is a binary file copy it to pfileCLM.ora and use vi to edit it. Remove the first and last line of entries (just do 'dd' on the line). Then remove the parameter that causing the problem. Once you have done all, then save it and startup oracle with the following command

startup pfile = $ORACLE_HOME/dbs/pfileCLM.ora

It should then start OK (assuming that you removed the offending parameter). Then do the following:

CREATE SPFILE = '$ORACLE_HOME/dbs/spfileCLM.ora'
FROM PFILE = '$ORACLE_HOME/dbs/pfileCLM.ora';

once it is OK, then shutdown and restart Oracle again as follows

startup force spfile = $ORACLE_HOME/dbs/spfileCLM.ora

If all OK then exit and mv pfileCLM.ora_old to pfileCLM.ora.

Good luck

 

[nassrin5]

Thanks Guru, it worked fine.