Re: Oracle WG-Server fails install on Ultra running 2.5

Emanuel Soeding wrote:

  Hi,

  I tried to install the Oracle Workgroup Server on a   Sun Ultra System running Solaris 2.5 with the usual   Sun-patches. The install program works fine, and I   can access the base htm-pages via port 8000. The   problem is, that I can't open the sample WG73 database.   If I try to do that as internal, all I get is an error,   which looks like the following:

  ORA-07331: smsnsg: unable to allocate the variable portion of the   SGA.   I recognized, checking the install.log, that the same   error allready occured during the installation. Everything   seems to compile fine, but the SVRMGR couldn't open   the database. So I conclude, it's not an Oracle error,   but maybe a Solaris fault. Can someone tell me, what's   going wrong? I read, there are some Solaris 2.5 patches,   which shouldn't be installed - which ones?

  Thanx for help..... Ciao Manu

 That is a strange error for you to get as WGS is supposed to update the /etc/system file with correct shared memory parameters. Make sure this has been done. Check the date of /etc/system to see if it was modified around the install date. If not you may want to put the correct settings in manually.

Here is an example of the shared memory entry that should be in there:

set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmsl=100
set shmsys: shminfo_shmmax = 209715200
set shmsys: shminfo_shmseg = 50
set semsys: seminfo_semmns = 1750
set semsys: seminfo_semmni = 70

This is a large example but this is certainly valid. The error you got simply states that it can not fit the variable portion of the SGA into one segment. Received on Thu Apr 10 1997 - 00:00:00 CDT