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..








On By phil

Leave a Reply

Related Post