ORA-27102: out of memory in oracle

[andysys]

Hi
I am facing out of memory problem as shown below in oracle.
$ sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jun 17 19:13:10 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

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

I have 2GB memory in my system.System parameters are as
follows

set shmsys:shminfo_shmmax=1932735283
set semsys:seminfo_semmni=1024
set semsys:seminfo_semmns=2048
set shmsys:shminfo_shmmni=300
set shmsys:shminfo_shmseg=50
set shmsys:shminfo_shmmin=1
set pt_cnt = 256
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgmap=258
set msgsys:msginfo_msgmni=256
set msgsys:msginfo_msgssz=16
set msgsys:msginfo_msgtql=1024
set msgsys:msginfo_msgseg=32767
set semsys:seminfo_semmap=1026
set semsys:seminfo_semmnu=2048
set semsys:seminfo_semume=50

Can anyone help me on this ?

Thks

Andy

 

[KenCunningham]

Your shmmax value seems a little low. Ours is:

set shmsys:shminfo_shmmax=4294967295

on a 1Gb system. You could try changing it, rebooting and trying again? HTH.

 

[pmurray99]

set shmmax to physical memory. it will only use what it needs.

and maybe the SGA is too big?