Re: Resolved ORA-27302 error, but how to fix?

Hi,

I'm pretty sure that these are what we set:

SEMMNI 100
SEMMNS 1024
SEMMSL 256 SHMMAX 4294967295
SHMMIN 1
SHMMNI 100
SHMSEG 10 per this guide:

http://download-east.oracle.com/docs/pdf/A96167_01.pdf

Jim

wfholmes_at_yahoo.com wrote:
>
> Check the /etc/system file on your Sun box.
>
> I have used the following parameter values on all Sun boxes where
> Oracle databases run with problems:
>
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=800
> set shmsys:shminfo_shmseg=64
> *
> set semsys:seminfo_semmns=6000
> set semsys:seminfo_semmni=65535
> set semsys:seminfo_semmap=200
> set semsys:seminfo_semmnu=500
> set semsys:seminfo_semume=100
> set semsys:seminfo_semmsl=500
>
> You might compare your settings with these. I do not recommend
> blithely setting yours to these values without reviewing what apps
> you're running, etc.
> Mary wrote:
> > Hi,
> >
> > Those 'other messages' help narrow down the problem, post them!
> Could
> > be semaphores or processes or ?, but I wouldn't like to make changes
> to
> > my system based on a guess...
> >
> > Mary
Received on Fri Feb 25 2005 - 13:39:36 CST