RAC 10.2 on ASM, windows - How to create pfile from spfile (ASM)

[Pedro Lopes]

Hi all,
how can I create a pfile (on filesystem) from spfile, if spfile is on ASM.

I cannot open my db with startup nomount.

I have an ORA-00371: not enough shared pool memory

I'm trying to fix this but cannot create the pfile.

thanks,
pedro

[gazzag]

SQL> create pfile = '<path>/<filename>' from spfile;

HTH

-g

[Mark D Powell]

pedro, you also have the option of starting the database using an
init.ora that you create. Once started via the init.ora should be
able to access the existing spfile to make the necessary changes and
then restart the instance using the spfile.

It is a pretty good idea to extract an onit.ora backup of the spfile
on a regular basis and direct this file to a backup area. While you
are making text backups also dump the control file to trace on a
regular basis. In the event of a major diaster having these text
backups can prove useful.

HTH -- Mark D Powell --

[Pedro Lopes]

Thanks for the advice :)

I was able to recreate the pfile, edit and replace the spfile using :

SQL> create pfile = '<path>/<filename>' from spfile='DISK_GROUP/../spfile';

btw, the database don't need to be in nomount.

cheers,
pedro