ORA-27102: out of memory

[ora_inf]

I trying to create the database and I am getting the following error........
======================================================
sun_Unix> svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> @crdb_ORACLE_SID.sql
Connected.
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
create database "ORACLE_SID"
*
ORA-01034: ORACLE not available
Disconnected.
===========================================================

Thanks

[ramk_vv]

Hi,

I suspect some problem with shared memory or semaphore parameters in /etc/System file.Either they are set too high or not set properly.It's just a guess.

[marist89]

That's where I would start looking, /etc/system...

[Halo]

Do not allocate more than 1/2 the RAM available on the server for the instance(s). Check settings in /etc/system also.

[ora_inf]

Hi:

You guys are right

Following parameter was not set in /etc/system file
so I have requested sys. admin to make this change.
After he make the changes then I will try again

Thanks lot.....

=============================
set semsys:seminfo_semmni=5200
set semsys:seminfo_semmns=8000
set semsys:seminfo_semmnu=400
set semsys:seminfo_semmap=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semopm=100
set semsys:seminfo_semume=100

set msgsys:msginfo_msgmap=200
set msgsys:msginfo_msgmax=4096
set msgsys:msginfo_msgmnb=8192
set msgsys:msginfo_msgmni=100
set msgsys:msginfo_msgssz=2048
set msgsys:msginfo_msgtql=1024
set msgsys:msginfo_msgseg=2048

set shmsys:shminfo_shmmax=1468006400
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=3400
set shmsys:shminfo_shmseg=400
==============================

[ramk_vv]

Don't forget to reboot the server for these parameters to take effect.I think your sysadmin needs to give a boot -r for these changes to affect the kernel.

[--Ex--]

Hello, I have the same problem and I resolved it.

<ORACLE>$ export ORACLE_SID= <INSTANCE>
<ORACLE>$ sqlplus /nolog
SQL> connect /as sysdba
SQL> shutdown abort
SQL> exit

2 processes are not stoped and I kill them.
For me, these processes are: "ora_dbw0_xxx" and "ora_pmon_xxx"

and after-, I can start my database without problem:
<ORACLE>$ sqlplus /nolog
SQL> connect /as sysdba
SQL> startup