The answer is basically enlarging shm-max. I enlarged it to 256Mb. After
that it worked fine.
The oracle documentation says the following:
Shared Memory SHMMAX 2139095040 (2GB-8MB)
This setting does not affect how much shared
memory is needed or used by Oracle8i or the
operating system. It is used only to indicate the
maximum allowable size. This setting also does
not impact operating system kernel resources.
SHMMIN 1
SHMMNI 100
SHMSEG 32
Regards,
Gert-Jan Hilbrands
-----------------------------------------------------------------------
Original Question:
Hello Managers,
When trying to create an Oracle 8.1.7 db on one of our alpha 1000's with
Tru64 4.0-D (896Mb) we get an "stack overflow" message.
Our oracle support guys tell us we have to increase the shm-max parameter
(ipc subsystem). But we increased this parameter several times to 32Mb in
the end and it still didn't help. I wonder if increasing the shm-max will
solve the problem, or that we have to look at our per-proc-stack and data
sizes. Any thougths ?
Regards,
Gert-Jan Hilbrands
Received on Mon Feb 19 2001 - 12:07:57 NZDT