Re: linux/shared

"stef" <Stephane.Pellegrino_at_wanadoo.fr> wrote in message news:<b1ujaf$pcj$1_at_news-reader10.wanadoo.fr>...
> Hi guys, just a little problem :
>
> On server side I run linux red-hat 7 box with Oracle 8.1.7...
> From client-side, I'm under Citrix-metaframeXP and -of course- I can connect
> to the red-hat/oracle...
>
> Cool.. not really :(
>
> 1 )Under Citrix, sometimes, I run sql*plus (or something like this ) and
> after some querys,
> I get the message
> "ORA-04031: unable to allocate xxxx bytes of shared memory..."
> even after a little query which return 100/300 tuples.
>
> 2) Strange behavior : I've NEVER met the error message when I run under
> a "normal" client (no citrix) !??
>
> So :
> The SHARED_POOL_SIZE is very large (128 MO I think, and my db is "small"
> just 400/600 mo)
> I've seen there's a bug (n° 1397603), I patched.... same error !!!!!!
>
> I think it must be a problem WITH Linux shared memory (you know
> theshmsys:shmino...etc...)
> because a client of mine has the same config but his Oracle is under Solaris
> 6.xx and
> he doesn't have the problem at all...
>
> Could you help me ????? (please :( )
>
> thanx Anyway....
>
> steph

If increasing the shared_pool_size does not help then most likely it is the size of your shared memory segment.

shmmax is the maximum allowable size of a shared memory segment $ cat /proc/sys/kernel/shmmax
If it is less then atleast half the size of RAM then increase it e.g. if RAM is 2GB then,
$ echo 1073741824 > /proc/sys/kernel/shmmax

Regards
/Rauf Sarwar Received on Fri Feb 07 2003 - 00:38:28 CST