REPOST: Relocating the SGA

From: Slawomir Cichy <SlawasC_at_netscape.net>
Date: Fri, 25 Jan 2002 12:10:47 +0100
Message-ID: <4$--$%%%%--_%%-_%$@news.noc.cabal.int>

Hi,

I have two machines. I named them M1 and M2.

M1:
OS: Linux 2.2.18 #1 SMP
DB: Oracle EE 8.1.6.2

RAM: 1G

M2:
OS: Linux 2.2.18 #14 SMP
DB: Oracle EE 8.1.6.2

RAM: 2G

I have problem with the alocation of shared memory on M2. I can't alocate more then 700 M (?) of shared memory. Now, I'm having following parameters in init.ora

     shared_pool_size     134217728
     db_block_buffers     32768
     db_block_size        16384
     sort_area_size       20971520

and it is working OK, but not perfectly:

(/d0/oracle/admin/ANDRO)> free

              total       used       free     shared    buffers     cached
Mem:       2009368    1979432      29936    2195168     151864     948020
-/+ buffers/cache:     879548    1129820
Swap:      1052248       1092    1051156

It looks like I use only ~50% memory. I increase db_block_buffers in init.ora

     db_block_buffers     39168
                          ^^^^^

and I receive the following error while instance is starting:

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORA-27123: unable to attach to shared memory segment Linux Error: 22: Invalid argument
SVRMGR>
(?????!)

I done it on M1 and first configuration is evidently OK, and second... too (?!)

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.

Total System Global Area                        817487856 bytes
Fixed Size                                          69616 bytes
Variable Size                                   144224256 bytes
Database Buffers                                641728512 bytes
Redo Buffers                                     31465472 bytes

(?!)

Why? Do You have this problem on Linux?

Configuration of the kernels on M1 and M2, with regard for shared memory, are identical. Command "ipcs -l" returned just the same values of limits. Command "tstshm" returned following information:

M1:
Number of segments gotten by shmget() = 50 Number of segments attached by shmat() = 50 Segments attach at higher addresses

Default shared memory address = 0x406b0000
Lowest shared memory address  = 0x406b0000
Highest shared memory address = 0x46ab0000
Total shared memory range     = 106954752
Total shared memory attached  = 104857600
Largest single segment size   =  2097152
Segment boundaries (SHMLBA)   =     4096 (0x1000)


-------------------------------------------------

M2:
Number of segments gotten by shmget() = 50 Number of segments attached by shmat() = 50 Segments attach at higher addresses

Default shared memory address = 0x2b15d000
Lowest shared memory address  = 0x2b15d000
Highest shared memory address = 0x3155d000
Total shared memory range     = 106954752
Total shared memory attached  = 104857600
Largest single segment size   =  2097152
Segment boundaries (SHMLBA)   =     4096 (0x1000)


-------------------------------------------------

Please, help me :)

	Thanks in advance.
	Slawas

WAS CANCELLED BY =======: From: Slawomir Cichy <SlawasC_at_netscape.net> Control: cancel <3C513D37.2000809_at_netscape.net> Subject: cmsg cancel <3C513D37.2000809_at_netscape.net> Date: Sun, 27 Jan 2002 23:34:05 GMT Message-ID: <cancel.3C513D37.2000809_at_netscape.net> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!news-han1.dfn.de!news-nue1.dfn.de!newsfeed.r-kom.de!netnews.web.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40723406

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 05:10:47 CST