Oracle-L: Re: SHM

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Tue, 13 May 2003 20:41:38 -0800
Message-ID: <F001.00598523.20030513204138@fatcity.com>

I didn't see the original post, so I'll reply to a reply. You need to increas SHMMAX.
To do that you don't need to relink your kernel. You don't even need to reboot
your machine. Just do following command as root:

echo "<desired maximum size of a segment>">/proc/sys/kernel/shmmax

to set the desired max. size. BTW, I'm also running Red Hat, but 8.0, with kernel 2.4.20 and oracle 9.2.0.3. Works like a charm:

SQL*Plus: Release 9.2.0.3.0 - Production on Tue May 13 23:36:01 2003

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 235999908 bytes

Fixed Size                   451236 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes

Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production

Database "o9i" warm started.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mladen Gogala
INET: mgogala_at_adelphia.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 13 2003 - 23:41:38 CDT