Shared memory error with standard.sql

From: <glennbaron_at_my-deja.com>
Date: 2000/05/31
Message-ID: <8h2qvh$5pa$1@nnrp2.deja.com>#1/1

Trying to create a new instance for test purposes, I encounter :

ORA-00604: error occurred at recursive SQL level 2 ORA-04031: unable to allocate 144 bytes of shared memory ("select name,col#,segcol#,........

kernel parameters in /stand/system are:
* Tunable parameters

dbc_max_pct     10
maxfiles        0X80
maxswapchunks   1665
maxuprc         1024
maxusers        600
nfile           (16*(NPROC+16+MAXUSERS)/06+32+2*
(NPTY+NSTRPTY))
npty            200
nstrpty         100
num_clients     200
semmns          1024
shmmax          0X29999999

shared memory usage is:

m       0 0x2f180002 --rw-------      root
sys      root       sys      9 1286144   332
2351 17:05:09 no-entry 17:05:09
m    2601 0x411c02f9 --rw-rw-rw-      root
root      root      root      0    348   930
930 20:42:43 20:42:43 20:42:39
m       2 0x4e0c0002 --rw-rw-rw-      root
root      root      root      1  31008   930
930 20:42:41 20:42:43 20:42:39
m       3 0x41200a62 --rw-rw-rw-      root
root      root      root      1   8192   930
945 20:42:41 20:42:39 20:42:39
m    8204 0x0c6629c9 --rw-r-----      root
sys      root       sys      2 14407248  1988
1986 17:02:18 no-entry 17:02:18
m    1205 0x06347849 --rw-rw-rw-      root
sys      root       sys      1  77384  1988  1992

17:02:20 17:02:18 17:02:18
m 24606 0x5264bdf4 --rw-r----- oracle dba oracle dba 33 269856768 2831 22708 11:26:06 11:31:23 17:12:03
m 8407 0x52673caa --rw-r----- oracle dba oracle dba 10 1396736 29936 1714 11:14:00 11:14:30 10:54:24

There appears to be ample shared memory available and few segments in use.

Help appreciated.

Regards,

Glenn Baron

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 31 2000 - 00:00:00 CDT