SQL> connect / as sysdba
SQL> show parameter spfile NAME TYPE VALUE ------- ------- ------------------------------ spfile string /u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb11.ora SQL> create pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb11.ora' from spfile='/u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb11.ora'; #Or simply: SQL> create pfile from spfile File created. SQL> create spfile='+RACDB_DATA' from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb11.ora'; File created. SQL> exit
[[email protected] ~]$ asmcmd ASMCMD> ls RACDB_DATA/racdb1/spfile* spfileracdb1.ora ASMCMD> exit
[[email protected] dbs]$ echo "SPFILE='+RACDB_DATA/racdb1/spfileracdb1.ora'" > /u01/app/oracle/product/11.2.0/db_1/dbs/initracdb11.ora [[email protected] dbs]$ ssh rac2 "echo \"SPFILE='+RACDB_DATA/racdb1/spfileracdb1.ora'\" > /u01/app/oracle/product/11.2.0/db_1/dbs/initracdb12.ora"
[[email protected] dbs]$ srvctl modify database -d racdb1 -p +RACDB_DATA/racdb1/spfileracdb1.ora
[[email protected] dbs]$ mv /u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb11.ora /u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb11.ora_bak [[email protected] dbs]$ ssh rac2 "mv /u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb12.ora /u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb12.ora_bak"
[[email protected] dbs]$ srvctl stop database -d racdb1 [[email protected] dbs]$ srvctl start database -d racdb1 [[email protected] dbs]$ srvctl status database -d racdb1 Instance racdb11 is running on node rac1 Instance racdb12 is running on node rac2
[[email protected] dbs]$ <strong>connect / as sysdba</strong> SQL> SHOW parameter spfile NAME TYPE VALUE ------ ----------- ------------------------------ spfile string +RACDB_DATA/racdb1/spfileracdb 1.ora
Cheers!!