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!!
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.