Re: Error 7331 Unable to allocate variable portion of the SGA on SUN OS 5.6

It's one of either 2 things:

1. You simply need to increase the kernel parameter shmmax (look in /etc/system or do a "sysdef | grep -i shmmax" for the current value). This is the parameter that limits the largest size one shared memory segment can be on your system.
2. You may actually need to change the attach address for the shared memory segment. This is a little bit more involved (have to modify the ksms.s config file in oracle and other steps) so I would contact Oracle support and ask for the UNIX group, we'll help you.

Hope this helps some,
Later - Gene...

Mark Membrino wrote in message <7os07i$2a0$1_at_epsilon.biogen.com>...
>I am trying to create a database on a Sun Ultra 5 running Sun OS Release
5.6
>and Version 7.3 of Oracle. I was able to create the database by decreasing
>the shared pool size, but as soon as I increase it to 3500000 the database
>will not open and gives me an error 7331. The oerr utility tells me to
>'Reconfigure the UNIX kernel to have bigger segments'. Can someone give me
>instructions on how to do this on this OS.
>
>Regards
>Mark
>
>
Received on Thu Aug 12 1999 - 20:04:35 CDT