SOLARIS: How to Relocate the SGA 大于2G(转)

zflying2000

应该是metalink上面的文档,Note:1028623.6
PURPOSE:  
  This note describes how to relocate the SGA on the Solaris operating  
system (SPARC) in a 32-bit environment.  This note only applies to 32bit  
architecture.  SGA can be >; 4GB in 64bit.  
SCOPE & APPLICATION:
  This applies to 32-bit database versions 7.x through 9.x on the
  Solaris operating system (SPARC).  
  The Solutions described below are:
      A. For RDBMS version 9.x - How to Change your Attach Address
      B. For RDBMS version 8.1.x - How to Change your Attach Address
      C. For RDBMS version 8.0.x - How to Change Your Attach Address
      D. For RDBMS version 7.3.2.x - How to Change Your Attach Address
      E. For RDBMS versions 7.3.3 or 7.3.4 - How to Change Your Attach Address
      F. For RDBMS version 7.2.3 or older - How to Change Your Attach Address  
  If you experience difficulties during the attempt to change the attach
  address, simply restore the file backed up as part of the procedure, and
  use it to relink.  You will then revert to your original attach address.  
SUN SOLARIS: How to Relocate the SGA:
=====================================  
You need to configure the SGA to a value greater than 256 Mbytes on your   
Sun system. You are referring to the following sgabeg parameter chart:  
   sgabeg = 0xe0000000  |  256Mb   SGA
   sgabeg = 0xd0000000  |  512Mb   SGA  
   sgabeg = 0xc0000000  |  768Mb   SGA  
   sgabeg = 0xb0000000  |    1Gb   SGA  
   sgabeg = 0xa0000000  | 1.25Gb   SGA  
   sgabeg = 0x90000000  |  1.5Gb   SGA  
   sgabeg = 0x80000000  | 1.75Gb   SGA  
   sgabeg = 0x77000000  |  just less than 2Gb SGA  
   sgabeg = 0x70000000  |    2Gb   SGA  
   sgabeg = 0x60000000  | 2.25Gb   SGA  
   sgabeg = 0x50000000  |  2.5Gb   SGA  
   sgabeg = 0x40000000  | 2.75Gb   SGA  
   sgabeg = 0x30000000  |    3Gb   SGA  
   sgabeg = 0x20000000  | 3.25Gb   SGA  
   sgabeg = 0x10000000  |  3.5Gb   SGA  
   sgabeg = 0x01000000  |  16Mb less than 3.75Gb SGA   
A. For RDBMS version 9.x - How to Change your Attach Address:
===============================================================  
For RDBMS version 9.x, change your attach address by doing the following  
steps to relocate the SGA:   
1. Shutdown any databases using the current "ORACLE_HOME".  
2. Change your location to the "/lib" directory   
     % cd $ORACLE_HOME/lib   
3. Make a backup copy of 'libserver9.a'.   
     % cp libserver9.a libserver9.a.orig   
4. Change your location to the "rdbms/lib" directory     
     % cd $ORACLE_HOME/rdbms/lib   
5. Generate the "ksms.s" file     
     % $ORACLE_HOME/bin/genksms -b <new_location>; >; ksms.s     
   For example, changing the attached address starting at  
   0x80000000 to 0x60000000 would be:     
     % $ORACLE_HOME/bin/genksms -b 0x60000000 >;ksms.s   
6. Regenerate the 'ksms.o' object:   
     % make -f ins_rdbms.mk ksms.o   
7. Archive 'ksms.o' into 'libserver9.a'   
     %ar r $ORACLE_HOME/lib/libserver9.a ksms.o  
8. Relink     
     % make -f ins_rdbms.mk ioracle   
B. For RDBMS version 8.1.x - How to Change Your Attach Address:
===============================================================  
For RDBMS version 8.1.X , change your attach address by doing the following  
steps to relocate the SGA:   
1. Shutdown any databases using the current "ORACLE_HOME".  
2. Change your location to the "/lib" directory   
     % cd $ORACLE_HOME/lib   
3. Make a backup copy of 'libserver8.a'.   
     % cp libserver8.a libserver8.a.orig   
4. Change your location to the "rdbms/lib" directory     
     % cd $ORACLE_HOME/rdbms/lib   
5. Generate the "ksms.s" file     
     % $ORACLE_HOME/bin/genksms -b <new_location>; >; ksms.s     
   For example, changing the attached address starting at  
   0x80000000 to 0x60000000 would be:     
     % $ORACLE_HOME/bin/genksms -b 0x60000000 >;ksms.s     
6. Regenerate the 'ksms.o' object:  
     % make -f ins_rdbms.mk ksms.o   
7. Archive 'ksms.o' into 'libserver8.a'   
     %ar r $ORACLE_HOME/lib/libserver8.a ksms.o   
8. Relink     
     % make -f ins_rdbms.mk ioracle   
Explanation:  
============   
Changing the 'sgabeg' in 'ksms.o' will allow you to increase SGA size and  
allocate the memory in a contiguous segment.   
NOTE:  If the above process does not resolve the problem, you may be   
       using an older version of the Sun Solaris architecture (Sun4c).   
       If this is the case, repeat all the steps shown above and change   
       the value for Step 5 to be the same as the old value less one   
       zero.      
       For example:        
           Old Value for Step 5:  0x80000000                 
           New Value for Step 5:  0x8000000
C. For RDBMS version 8.0.x - How to Change Your Attach Address:
===============================================================
For RDBMS version 8.0.x, change your attach address by doing the following  
steps to relocate the SGA:   
1. Shutdown the database.   
2. Change your location to the "rdbms/lib" directory   
     % cd $ORACLE_HOME/rdbms/lib   
3. Modify the "ksms.s" file     
     % $ORACLE_HOME/bin/genksms -b <new_location>; >;ksms.s   
   For example, changing the attached address starting at   
   0x80000000 to 0x60000000 would be:   
     % $ORACLE_HOME/bin/genksms -b 0x60000000 >;ksms.s   
4. Make a backup copy of the "ins_rdbms.mk" file   
     % cp ins_rdbms.mk ins_rdbms.mk.ksms   
5. Modify the "ins_rdbms.mk" file   
     Change:  ksms.s $(RDBMSLIB)ksms.s:
              $(GENKSMS) >; ksms.s
   
     To:      ksms.s $(RDBMSLIB)ksms.s:
              $(GENKSMS) >; ksms.s.default_sgabeg
6. Regenerate the 'ksms.o' object:            
     % make -f ins_rdbms.mk ksms.o  
7. Relink   
     % make -f ins_rdbms.mk ioracle   
NOTE:  If the above process does not resolve the problem, you may be   
       using an older version of the Sun Solaris architecture (Sun4c).   
       If this is the case, repeat all the steps shown above and change   
       the value for Step 3 to be the same as the old value less one   
       zero.   
       For example:     
           Old Value for Step 3:  0x80000000   
           New Value for Step 3:  0x8000000  
NOTE: If the above process does not resolve the problem, you may have to apply
      the fix for [BUG], fixed in 8.0.4.4.
D. For RDBMS version 7.3.2.x - How to Change Your Attach Address:
=================================================================
For RDBMS version 7.3.2.x, change your attach address by doing the following  
steps to relocate the SGA:  
1. Shutdown the database.  
2. Change your location to the "rdbms/lib" directory  
      % cd $ORACLE_HOME/rdbms/lib
3. Modify the "ksms.s" file   
   Change this line:  
        sgabeg = 0xe0000000  
   To the new value:  
        sgabeg = 0x80000000  
   NOTE: This example moves the attached address from  
         "0xe0000000" to "0x80000000".  
4. Make a backup copy of the "env_rdbms.mk" file
      % cp env_rdbms.mk env_rdbms.mk.ksms  
5. Modify the "env_rdbms.mk" file  
   Change:  $(ORACLE_HOME)/bin/genksms >; $(KSMSS)  
   To:      $(ORACLE_HOME)/bin/genksms >; $(KSMSS).sga
6. Regenerate the 'ksms.o' object:   
      % make -f ins_rdbms.mk ksms.o
7. Relink  
      % make -f ins_rdbms.mk ioracle  
NOTE:  If the above process does not resolve the problem, you may be  
       using an older version of the Sun Solaris architecture (Sun4c) .   
       If this is the case, repeat all the steps shown above and change  
       the value for Step 3 to be the same as the old value less one   
       zero.   
       For example:      
           Old Value for Step 3:  0x80000000               
           New Value for Step 3:  0x8000000
E. For RDBMS versions 7.3.3 or 7.3.4 - How to Change Your Attach Address:
=========================================================================
For RDBMS version 7.3.3 or newer, change your attach address by doing   
the following steps to relocate the SGA:  
1. Shutdown the database.  
2. Change your location to the "rdbms/lib" directory   
     % cd $ORACLE_HOME/rdbms/lib   
3. Modify the "ksms.s" file   
     % $ORACLE_HOME/bin/genksms -b <new_location>; >;ksms.s  
     For example, changing the attached address starting at   
     0x80000000 to 0x60000000 would be:
     % $ORACLE_HOME/bin/genksms -b 0x60000000 >;ksms.s
4. Make a backup copy of the "env_rdbms.mk" file   
     % cp env_rdbms.mk env_rdbms.mk.ksms   
5. Modify the "env_rdbms.mk" file   
     Change:  $(ORACLE_HOME)/bin/genksms >; $(KSMSS)   
     To:      $(ORACLE_HOME)/bin/genksms >; $(KSMSS).sga   
6. Make a backup copy of the "ins_rdbms.mk" file
     % cp ins_rdbms.mk ins_rdbms.mk.ksms
7. Regenerate the 'ksms.o' object:   
     % make -f ins_rdbms.mk ksms.o
8. Modify the "ins_rdbms.mk" file
     Change:  -rm -f ksms.s ksms.o
     To:      -rm -f ksms.o
9. Relink   
     % make -f ins_rdbms.mk ioracle
NOTE:  If the above process does not resolve the problem, you may be using an older version of the Sun Solaris architecture (Sun4c). If this is the case, repeat all the steps shown above and change  the value for Step 3 to be the same as the old value less one  zero.  
       For example:  
Old Value for Step 3:  0x80000000
New Value for Step 3:  0x8000000
F. For RDBMS version 7.2.3 or older - How to Change Your Attach Address:
========================================================================
For RDBMS version 7.2.3 or older, change the attach address by doing  
the following steps to relocate the SGA:
1. Shutdown the database.  
2. Change location to the "rdbms/lib" directory
      % cd $ORACLE_HOME/rdbms/lib  
3. Modify the "ksms.s" file   
   Change this line:  
        sgabeg = 0xe0000000  
   To the new value:
        sgabeg = 0x80000000
   NOTE:  This example moves the attached address from   
          "0xe0000000" to "0x80000000".
4. Edit the "oracle.mk" file by commenting out the following line:
     FROM:  ksms.s: $(ORACLE_HOME)/bin/genksms  
                    $(ORACLE_HOME)/bin/genksms >; ksms.s
     TO:    #ksms.s: $(ORACLE_HOME)/bin/genksms  
            #        $(ORACLE_HOME)/bin/genksms >; ksms.s
5. Relink  
      % make -f oracle.mk ioracle
6. Regenerate the 'ksms.o' object:  
      % make -f oracle.mk ksms.o
NOTE:  If the above process does not resolve the problem, you may be  
       using an older version of the Solaris architecture (Sun4c).   
       If this is the case, repeat all the steps shown above and change  
       the value for Step 3 to be the same as the old value less one   
       zero.
       For example:  
           Old Value for Step 3:  0x80000000
           New Value for Step 3:  0x80000
Search Words:
ORA-27123 ORA-07307  ORA-7307  ORA-07308  ORA-7308  ORA-07310  ORA-7310 increase shared memory SPARC ksms attach address

chaoping

why don't you use 64bit oracle? much more stable than you do relink, and support much larger sga.