Re: ORA-04031 Unable to allocate shared memory

From: Anil Kamath <akk_16_at_yahoo.com>
Date: Wed, 29 Sep 1999 18:21:54 GMT
Message-ID: <7stlbj$fb8$1@nnrp1.deja.com>

First make sure that the init.ora parameters that control the size of the SGA are set such that the size of the SGA is less than
the size of ur RAM (also take into account shared memory needed for the OS resources).

Also, if u are on the Solaris box, then u need to up the shared memory parameter in the /etc/system configuration file such that the OS will then allow oracle to use the large SGA u are asking for.

-anil

In article <37F1333E.4BC489D9_at_mantech-wva.com>, Brian Abraham <abrahamb_at_mantech-wva.com> wrote:
> One of my colleagues is trying to install Oracle 8i on a Windows
> NT 4.0 server. He gets the following message after several
> minutes into the Oracle installation:
>
> ORA-04031 Unable to allocate nnn bytes of shared memory ("shared
> pool","unknown object","sga heap","db_block_buffers")
>
> The server has multiple CPU's, 4 GB RAM, and RAID5 drive
> subsystem. He has reinstalled the OS, but stills gets the same error
> message during the Oracle 8i installation.
>
> Any help is appreciated.
> Thanks.
>
> Brian Abraham
>
>

--
Anil Kamath
SmartOnline Inc. (www.smartonline.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 29 1999 - 13:21:54 CDT