PFILE/SPFILE in RAC for parameter change
DB: 10.2.0.1 2 node RAC on ASM
O/S: RHEL 4
I have to make a parameter change to increase the sga in our RAC db. I noticed that the system was using a pfile for each instance but seems like there is an SPFILE present there as well on the O/S pointing to an spfile in ASM.
I have to increase the sga_target so do i need to (for each instance) :
SQL> select count(*) from v$spparameter where value is not null;
1/ shutdown the instance
2/ modify sga_target in the pfile
The above should work? However I am unsure why the spfile is not working properly (or not being used). If i do:
The above is probably because the spfile is in ASM. There is an spfile on the O/S for each node, when i do:
SQL> create pfile='/home/oracle/init.ora' from spfile;
create pfile='/home/oracle/init.ora' from spfile
ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
I am a bit confused on how the spfile works with RAC, i understand it is placed in the ASM so all instances can access it.
[oracle@mgdb2 dbs]$ strings spfilebof21.ora
Thanks in advance!