Configuring SGA greater that 2GB on Red Hat Linux 7.3 / Oracle 9i Rel 2

From: Adnan <adnanans_at_cyber.net.pk>
Date: 20 Nov 2002 15:19:30 -0800
Message-ID: <d29dbd53.0211201519.7b314688@posting.google.com>

i m trying to configure SGA size around 2.3 GB for my database on 2 processors / 3 GB Ram machine running RedHat linux 7.3 and Oracle 9i R2.

i have tried all the possibilities mentioned in the manuals but failed to configure.

the following error comes whenever i tried to start the db with sqlplus:

ORA-27102 out of memory
Linux Error 28 : No space left on device.

the following r the kernel parameter settings:

sem # 200 1500 100 1500

shmmax # 2 GB
shmmin # 1
shmseg # 4096
shmvmx # 32767

(mount point for shared mem)

mount -t shm shmfs -o nr_blocks=8g /dev/shm

(initora parameter)

use_indirect_data_buffers=true

Regards
Adnan... Received on Wed Nov 20 2002 - 17:19:30 CST