How To Create a Pfile From an Spfile Stored in ASM?
570448May 20 2010 — edited May 21 2010I've got an 11gR2 DB instance. The spfile for that instance is stored in ASM at +DATA/test/spfiletest.ora and my database will not start:
SQL> startup;
ORA-01078: failure in processing system parameters
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
because I inadvertently set the MEMORY_TARGET value to be greater than the MEMORY_MAX_TARGET. Since I can't even get the database instance into the nomount state to change the value of memory_target to be <= MEMORY_MAX_TARGET I believe I will need to create a pfile from the spfile (which is stored in the running ASM instance) in order to fix this issue.
So. . .how can I create a pfile from the +DATA/test/spfiletest.ora spfile that's stored in ASM. I can certainly get access to an asmcmd prompt if that will help me here. My plan would be to change the value of MEMORY_TARGET in the pfile that I crate and start the instance using that pfile, unless someone has another idea.
Thank you for your input / thoughts / advice :-)
Edited by: BDub2 on May 20, 2010 7:42 AM