Re: creation database problem

From: Colin Casalis <colin_at_rewards.co.za>
Date: Fri, 30 Jul 1999 13:38:57 GMT
Message-ID: <37a1a9ef.12806290@news.is.co.za>

Look at your unix kernel parameters for shared memory and semaphores. Following entries in /etc/system:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmap=80
set semsys:seminfo_semmns=1400
set semsys:seminfo_semmni=140
set semsys:seminfo_semmnu=140
set semsys:seminfo_semmsl=10
set semsys:seminfo_semume=100

Make sure these are large enough to support the SGA size as specified in the database init.ora. If not you may have to reduce the init.ora parameters SHARED_POOL, DB_BLOCK_BUFFERS, LOG_BUFFER.

Good luck,
Colin.

On Tue, 27 Jul 1999 13:40:17 +0200, Michel Dupont <mdupont_at_caramail.com> wrote:

>when I execute the creation script I have a message 7331
>I can't allocate SGA
>
>oracle 7.3.4 and Solaris 2.6
>
>thanks
>
>
Received on Fri Jul 30 1999 - 08:38:57 CDT