Oracle-L: Re: Update !!! - Re: ORA-03113: end-of-file on communication

From: Suzy Vordos <lvordos_at_qwest.com>
Date: Tue, 06 Aug 2002 12:43:31 -0800
Message-ID: <F001.004AC9F1.20020806124331@fatcity.com>

Running multiple instances might require further tuning of the systen kernel parameters. For example, SEMMNS is the max number of semaphores system-wide, which is calculated as SEMMNI*SEMMSL (max semaphore sets system wide * max semaphores per semaphore set).

Adrian Cockcroft's Sun Performance & Tuning discusses each of the shared memory and semaphore kernel tunes, and how to calculate them. Here's some info about that and live example from a production system with 3 instances.

----------------------------------
Semaphores/Shared Memory for ORACLE
----------------------------------
shmmax = max size per shared memory segment
shmmin = min size per shared memory segment
shmmni = max num shared memory identifiers
shmseg = max num shared memory segments per process
semmns = max num semaphores system wide (=semmni*semmsl)
semmni = max num semaphore sets system wide (=semmnu)
semmsl = max num semaphores per semaphore set (=semopm)
semmnu = max num sempahore undo structures (=semmni)
semmap = max entries per semaphore map (=semmni*semmsl)
semopm = max operations per semop call (=semmsl)
semume = max undo entries per process (=semopm)
semvmx = max value of a semaphore (cannot be > 32767)

forceload: sys/shmsys
forceload: sys/semsys

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

set semsys:seminfo_semmns=4000
set semsys:seminfo_semmni=40
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmnu=40
set semsys:seminfo_semmap=4000
set semsys:seminfo_semopm=100

set semsys:seminfo_semume=100
set semsys:seminfo_semvmx=32767

Hope this helps,
Suzy

Dear List,

I checked a couple of other web sites and found a solution!

It appears that my "processes" for each database (150) added up to more than the Solaris Environment Variable
"SEMMNS" (410) So I changed each database's init<sid>.ora file to have processes = 100 (Don't know if that is sufficient ?)
and restarted all THREE databases!

Thanks if anyone has replied to this before I posted this update.

Ron.

-------Original Message-------

Date: 06 August 2002 19:49:21
To: ORACLE-L_at_fatcity.com

Dear List,
I have just installed 8.1.7 on Solaris 8 on a Sun Sun-Fire 280r. I created three databases, RATREP,CQPROD01,CQTEST01. I can start and login to each database individually but can only start two
databases at any one time. If I try to start the third (perm any two from
three!) I get the "ORA-03113: end-of-file on communication channel" error.
This error only occurs when I try to start a third database. I have checked the tnsnames.ora and the listener.ora (as recommended by an
oracle support web site) but these seem to be fine. We are too cheap to buy oracle support and I'm on my own here. If anyone can
help, I'd really appreciate it.
Thanks in advance,
Ron.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Aug 06 2002 - 15:43:31 CDT