How to create spfile in asm diskgroup from pfile
Hello Team,
we have prod instance with standalone asm ( Means database and ASM (grid) both are installed on same server with the single os user oracle). Now when I tried to create the spfile under the diskgroup f from pfile it returns the error.
SQL> create spfile '+ORADATA' from pfile;
create spfile '+ORADATA' from pfile
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
Kindly suggest how I can create the spfile from the pfile in asm diskgroup.
Regards,
Pritesh Ranjan