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

In article <34EB3E71.DA5C42CE_at_dlh.de>,
  Thomas Hilke <Thomas.Hilke_at_dlh.de> wrote:
>
> 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 !
>
>

1. First increase the shared memory segments setting at the OS level. In my SCo Unix 5.0, i increase the SHMMAX (maximum shared memory segments) parameter thru' the ScoAdmin utility.(There should be a similar way to adjust the parameter in HP-UX). Then start Oracle.
2. If that does n't work , Try reducing the SHARED_POOL_SIZE parameter setting in your INIT.ORA and INITsid.ORA FILE in the $ORACLE_HOME/dbs/ directory. Then start Oracle.

Good Luck.

kasthuri. kasti_at_hotmail.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Feb 19 1998 - 00:00:00 CST