Oracle Shared Memory Problem (DEC UNIX 4.0)

From: Peter Bruhn <bruhn_at_exai1.wu-wien.ac.at>
Date: 1997/11/19
Message-ID: <64v7b0$nie@cantine.wu-wien.ac.at>#1/1

Hello!

I am having big trouble with shared memory for oracle. It is oracle 7.3.2 on a DEC-Alpha (DU 4.0).

> uname -a

OSF1 miss.wu-wien.ac.at V4.0 564 alpha alpha

When trying to start oracle I get

  ORA-07307: sms1sg: shmat error, unable to attach sga.   DEC OSF/1 (AXP) Error: 12: Not enough space   Additional information: 1

> sysconfig -q ipc

ipc:

msg-max = 8192
msg-mnb = 16384
msg-mni = 64
msg-tql = 40
shm-max = 67108864
shm-min = 1
shm-mni = 128
shm-seg = 32
sem-mni = 2048
sem-msl = 25
sem-opm = 10
sem-ume = 10
sem-vmx = 32767
sem-aem = 16384
num-of-sems = 60
max-kernel-ports = 93911

port-hash-max-num = 4695550
port-reserved-max-num = 93911

set-max-num = 24837
ssm-threshold = 8388608
ssm-enable-core-dump = 1

So the maximum size of a shared memory segment should be 67108864 byte.

> pwd

/usr/oracle/app/oracle/product/7.3.2

> bin/tstshm

Number of segments gotten by shmget() = 50 Number of segments attached by shmat() = 31 Odd-sized segments are rounded up to even size Segments attach at higher addresses

Default shared memory address = 0x10000
Lowest shared memory address  = 0x10000
Highest shared memory address = 0x11fc10000
Total shared memory range     = 4831838208 (0x120000000)
Total shared memory attached  = 134217696 (0x7ffffe0)
Largest single segment size   =  4194304 (0x400000)
Segment boundaries (SHMLBA)   =     8192 (0x2000)

This seems to say that the maximum size of a shared memory segment is 4194304 byte.

I guess the problem is that the maximum size of segment ist too low, but how can I change this, the operating system seem to say it is much larger.

Or is there something else that I am missing?

Thanks for any help is highly appreciated, Peter Received on Wed Nov 19 1997 - 00:00:00 CST