RAC Instances using different spfile
530453Jul 17 2007 — edited Jul 17 2007I have ASM instance is running on both the RAC servers and I am using SPFILE. I made some changes in SPFILE of the
database instances and tried to modify few parameters with scope=both and also with scope =spfile and then bounced both
the database instances.
All the changes can be seen in both the instances but when I fired:
SQL>show parameter spfile;
on one database instance the output is:
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/10.2/d
b_1/dbs/spfileRACDB1.ora
and on other database it is:
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/racdb/spfileracdb.ora
but the changes I made in the spfile can be seen in both the instances.
I want that both the instances should use the same spfile.......
Can someone please tell me the steps to use same spfile on both the instances (i.e. +DATA/racdb/spfileracdb.ora )