[alanna]

No RTFM please, if you have passion, read this:

I have Solaris 8 installed with 1GB of RAM, 3GB of swap space, 4 disc of size 36GB each and mirrored under solsuite disk suite. My /etc/system file has typical sharedMemSegment+semaphore from Oracle manual, which is perfectly working on other m/c with same database configuration but w/o disc mirroring, as listed below.
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=200
set semsys:seminfo_semmns=300
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

During DB creation, oracle fails with
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
messages.

* Trace file does not reveal anything but the fact that it could not claim shared memory of 128MB with following message.

Tue Jun 3 12:11:35 2003
Starting ORACLE instance (normal)
Tue Jun 3 12:11:36 2003
WARNING: EINVAL creating segment of size 0x000000000784e000
fix shm parameters in /etc/system or equivalent

* Some additional checks:

* Total memory installed.
#prtconf | grep size
Memory size: 1024 Megabytes

* Top shows that 914 MB is free!
load averages: 0.04, 0.05, 0.02 13:16:16
32 processes: 31 sleeping, 1 on cpu
CPU states: 97.6% idle, 0.0% user, 2.4% kernel, 0.0% iowait, 0.0% swap
Memory: 1024M real, 914M free, 25M swap in use, 3802M swap free

* ipcs -b shows:
==============
IPC status from <running system> as of Tue Jun 3 13:20:04 EDT 2003
T ID KEY MODE OWNER GROUP QBYTES
Message Queues:
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 0 0x5001ecbf --rw-r--r-- root root 4
T ID KEY MODE OWNER GROUP NSEMS
Semaphores:
=============

So what is wrong?

-Thanks,
DP.

[nicephotog]

I had the same problem with my webserver and MySQL through JDBC.
The "out of memory" error returned from the servlet was because after the query the connection link had not been closed.
I was loading the driver and connecting directly through the class and process not using a connection pool.