Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

How to create spfile in asm diskgroup from pfile

edited Dec 27, 2017 9:32AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 4 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center