warring :not enough physical memory for SHM_SHARE_MMU

[joyloce]

hello all:
ultra 2 ORACLE 8.1.7.4
when I start the database, the warring in the alert.log
WARNING: Not enough physical memory for SHM_SHARE_MMU segment of size 0x00000000
0ae44000

the /etc/system
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=1000
set semsys:seminfo_semmns=5000
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100

set shmsys:shminfo_shmmax=209715200set
shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=200
set shmsys:shminfo_shmmin=1
set msgsys:msginfo_msgmni=50
set msgsys:msginfo_msgmnb=16384

the initial.ora
DB_BLOCK_SIZE=8192
DB_BUFFERS=12800
LOG_BUFFER=32768
SHARED_POOL_SIZE =50MB

please help me analyse the problem and present the solution!
Thanks in advance

[shandj]

Oracle recommended values for Unix Kernal parameters are:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

I hope this will help you...

Thanks,

[rotem_fo]

Hi,
shandj is correct, Oracle recommends these parameters, but the parameters need to reflect your database and machine characteristics.

UNIX Kernel Parameters:
SHMMAX = 4294967295 (This setting indicates the maximum allowable size)
SHMMIN = 1
SHMMNI = 100
SHMSEG = 10

Semaphores:
SEMMNI = 100
SEMMNS = [(largest PROCESSES parameter of any database) * 2 + (other instance processes)] + [(# of instances) * 10]
SEMMSL = 10 + largest PROCESSES parameter.
SEMOPM = 10
SEMVMX = 32767


Cheers,
R.

[agasimani]

Alternatively you can reduce the SGA settings in init.ora.