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

Thomas,

You need the Unix system admin to set several Unix kernel parameters that govern shared memory and semaphores. These should be listed in your install guide in the setting the environment chap. Note this requires a reboot of the machine.

You can use the ipcs Unix cmd to see current shared memory.

Basically the entire SGA is in shared memory. How big it is depends on your needs.

Oracle recommends setting the Unix parameter to their max. I believe Oracle will only use the amount needed for your SGA.

Ken F.

Thomas Hilke <Thomas.Hilke_at_dlh.de> wrote in article <34EB3E71.DA5C42CE_at_dlh.de>...
> Hi.
>
> 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.
>
> I'm running the V7.3.3.4 Database on HP-UX 10.20
>
> Who can i get information of the remaining shared memory of the machine
> ?
> What king of memory use Oracle for wich SGA parts ?
>
> Many question, please answer !
>
>
  Received on Wed Feb 18 1998 - 00:00:00 CST