Re: ORA-04031 Unable to allocate shared memory

From: Winnie Liu <winnie_liu_at_infonet.com>
Date: Tue, 28 Sep 1999 21:59:29 -0700
Message-ID: <7ss6c2$qih$1@birch.prod.itd.earthlink.net>

For NT (and NT only!), Oracle will reside the whole SGA in RAM. So, if you try to create an instance which has >4GB SGA. The instance will not start. You can either:

1)decrease the db_block_buffer
2)decrease shared_pool_size
3)decrease log_buffer

To decrease the SGA size.

HTH Winnie Liu
DBA
Infonet Services Corporation
mailto:winnie_liu_at_infonet.com

Brian Abraham wrote in message <37F1333E.4BC489D9_at_mantech-wva.com>...
>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
>
Received on Tue Sep 28 1999 - 23:59:29 CDT