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

From: MCUK <ron.perrie_at_mci.co.uk>
Date: Tue, 06 Aug 2002 12:03:41 -0800
Message-ID: <F001.004AC920.20020806120341@fatcity.com>

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: MCUK
INET: ron.perrie_at_mci.co.uk

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:03:41 CDT