Re: ORA-27123

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Sat, 13 Mar 1999 19:38:44 -0800
Message-ID: <36EB2F44.791F@oriolecorp.com>

Ying-fen Hu wrote:
>
> VIEL wrote:
>
> > I am on HP/UX (V2250) with Oracle 8.04
> > I have increase the SGA parameters
> > db_block_buffers 7150 ==> 14300 (x 2)
> > log_buffer = 3465216 ==> 6930432 (x2)
> >
> > and after i have the oracle message :
> > ORA-27123: unable to attach to shared memory segment
> > HP-UX Error: 22: Invalid argument
> >
>
> Try increase the shmmax by at least the following amount:
>
> (7150 * db_block_size) + 3465216
>
> Bounce the server and see whether that works.
>
> Hope this helps.
>
> Ying-fen Hu

There is a not-too-widely known utilility named tstshm which allows you to test whether you can allocate a given size of shared memory (tstshm -t <size> if I remember well). There are options to make it more or less talkative, just type

tstshm
to have the possible options. It can be a useful additional diagnosis tool (it is located under $ORACLE_HOME/bin, so you should normally have it in your path).
--
Regards,

Stéphane Faroult
Oriole Corporation

www.oriolecorp.com, the site created by Oracle DBAs for Oracle DBAs

Received on Sat Mar 13 1999 - 21:38:44 CST