Wednesday, April 11, 2012

SID='*'

was testing some memory settings and ISM and DISM  on a 11.2.0.3 2-node rac today

changed the sga_max_size on first node to > than swap available .

SQL node1>alter system set sga_max_size=16G sid='SWINGBE1' scope=spfile;

then
          SQLnode1> shutdown abort

as expected  at startup  I get :

SQL node1> startup nomount
ORA-27102: out of memory
SVR4 Error: 12: Not enough space 


on the 2nd  node I execute following :

SQL node2> alter system set sga_max_size=1632M sid='*' scope=spfile;


still on first node :


SQLnode1> startup nomountORA-27102: out of memorySVR4 Error: 12: Not enough space 

nothing yet,


maybe thinks it is still started 
 SQL node1> shutdown abort 
ORACLE instance shut down. 
ok try again

SQL node1> startup nomount
ORA-27102: out of memory
SVR4 Error: 12: Not enough space 


no joy



on the other instance



SQL node2> alter system set sga_max_size=1632M sid='SWINGBE1' scope=spfile;




on the original node 





SQL> startup
ORACLE instance started.

Total System Global Area 1704132608 bytes
Fixed Size                  2159976 bytes
Variable Size             956304024 bytes
Database Buffers          738197504 bytes
Redo Buffers                7471104 bytes
Database mounted.
Database opened.


Apparently you oracle needs to receive the explicit SID in this case and the SID='*' doesn't work..












No comments: