Re: ORA-27123

From: Ying-fen Hu <yhu_at_generalmicro.com>
Date: Fri, 12 Mar 1999 21:10:35 -0500
Message-ID: <36E9C91B.C4A8A07@generalmicro.com>

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
>
> Is there somebody who know the kernel parameter that i have to change
> today i have
> shmmax : 134217728
> shmmni : 200
> shmseg : 120
>
> Thanks very much for your help
> (i hope that my english is no so bad)

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 Received on Fri Mar 12 1999 - 20:10:35 CST