unable to create large sga for oracle on linux

From: chao_ping <chao_ping_at_163.com>
Date: 10 Jul 2002 06:17:10 GMT
Message-ID: <3d2bd166$1@usenetgateway.com>

RedHat Linux 7.2 with 4G memory according to document on otn: we can configure large sga for oracle on linux. http://otn.oracle.com/tech/linux/pdf/1_linuxVM_v2_accepted.pdf

I hope to do as document 5.3 said: [oracle_at_database 8.1.7]$ su - Password: [root_at_database root]#echo 3000000000 >/proc/sys/kernel/shmmax
[root_at_database root]# umount /dev/shm [root_at_database root]# mount -t shm
shmfs -o nr_blocks=8388608 /dev/shm [root_at_database root]# su - oracle

[oracle_at_database 8.1.7]$ sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 9 22:28:16 2002

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1837166752 bytes Fixed Size 73888 bytes Variable Size 360886272 bytes Database Buffers 1474560000 bytes Redo Buffers 1646592 bytes Database mounted. Database opened.

SQL> show parameter db_block_size

NAME TYPE VALUE ------------------------------------ -------
------------------------------ db_block_size integer 16384

SQL> show parameter db_block_buffers

NAME TYPE VALUE ------------------------------------ -------
------------------------------ db_block_buffers integer 90000

But if i enlarge the db_block_buffers a little larger, oracle fail to startup: db_block_buffers = 94000
#94000*16K=1468.75M

SQL> startup
ORA-27123: unable to attach to shared memory segment Linux Error: 22: Invalid argument Additional information: 1 Additional information: 983040 Anyone ever tested it?

--
an oracle fan, 
an oracle beginner

Posted via dBforums
http://dbforums.com

Received on Wed Jul 10 2002 - 01:17:10 CDT