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