Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

moving spfile from non-asm to asm file system

hariharan.thyagarajanJul 1 2009 — edited Jul 13 2009
Hi All

We are migrating non-asm file system to asm file system, we are held up in moving the spfile from non-asm file system to asm file system ...

we tried the below method

Recreate SPFILE on ASM diskgroup

SQL> create pfile='c:\initTEST.ora' from spfile;
File created.
SQL> create spfile='+DGRP2/spfileTEST.ora' from pfile='c:\initTEST.ora';
File created.

after this we started both the running instance and asm instance

but after starting the instance TEST we saw the instance still using spfile of non-asm file system

what is the correct way of moving the spfile from non-asm to asm file system..

Regards
Hariharan.T
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2009
Added on Jul 1 2009
9 comments
2,642 views