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

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 - 10:48:31 CST