Re: ORA-07306 sms1sg: shmget error, unable to get a shared memory segment.

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: 1998/02/19
Message-ID: <6chafj$r3j$1@sunrise.pg.gda.pl>#1/1

>When I try to startup my database, i've get the following message
>
>============================================================
>SVRMGR> startup
>ORA-07306: sms1sg: shmget error, unable to get a shared memory segment.
>HP-UX Error: 12: Not enough space
>Additional information: 1
>============================================================
>
>What must i do to solve the problem.
>

First, tune and relink HP-UX kernel.
You must set specific shared memory & semaphores as is described in "Oracle 7 Server for HP Installation and Configuration Guide".
If you have done this, it may mean, that you run out of memory space. SGA size may be too large to fit in virtual memory (but it's better, when it fits real memory!). Estimate total SGA size of instance as
shared_pool_size+DB_BLOCK_SIZE*DB_BLOCK_BUFFERS (it's not completly exact, but it's quite good estimation) and compare it with memory space on your HP. Maybe, in that parameters you added one "zero" more than you need.

I hope, it may help
Piotr Received on Thu Feb 19 1998 - 00:00:00 CST