Moving SPfile From ASM to File System

its Easy Steps

1-

SQL>Show parameter Spfile ;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/orcl/spfileorcl.ora
2-

Create pfile='/u01/new.pfile' from spfile ;

3-

Create spfile='/u01/app/oracle/product/10.2.0/db_1/dbs/newspfile.ora' from
pfile='/u01/new.pfile';


4-

Shutdown immediate ;
startup ;

5-
Check new Location For Spfile ;


Thank you
Osama Mustafa

Comments

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET