Re: ORA-03114 - 8.1.7 Install on Solaris

> The values in the /etc/system are as follows:
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set shmsys:shminfo_semmni=100
> set shmsys:shminfo_semmsl=160
> set shmsys:shminfo_semmns=310
> set shmsys:shminfo_semopm=100
> set shmsys:shminfo_semvmx=32767
>
> Does anyone have any idea what the problem (or more importantly, the
> solution) might be?
>
> Any advice/information would be greatly appreciated!!
>
> John.

The problem is your semaphore settings. I've encountered this exact message. A couple of these settings are probably overkill, but if you use them at least initially, the problem should go away. These are taken from an article on installing on Solaris by Roger Schrag at http://www.dbspecialists.com. It's been a while since I first saw this, so the article may or may not be posted. Kernel Parameter Setting To Get You Started SHMMAX 4294967295 Maximum size of a single shared memory segment SHMMIN 1 Minimum size of a single shared memory segment SHMMNI 100 Maximum number of shared memory segments in entire system SHMSEG 10 Maximum number of shared memory segments one process can attach
SEMMNS 2000 Maximum number of semaphores in entire system SEMMSL 1000 Maximum number of semaphores per set SEMMNI 100 Maximum number of semaphore sets in entire system SEMOPM 100 Maximum number of operations per semop call SEMVMX 32767 Maximum value of a semaphore

Byron Received on Mon Jan 07 2002 - 15:05:16 CST