Oracle-L: RE: ORA-03113: end-of-file on communication channel

From: Janardhana Babu Donga <jbdonga_at_ucdavis.edu>
Date: Wed, 07 Aug 2002 14:16:18 -0800
Message-ID: <F001.004AE1B9.20020807141618@fatcity.com>

Mike,

Try increasing Semaphores on your Unix box and re-boot the box. It is very much connected to Semaphores.

Babu

-----Original Message-----
Sent: Tuesday, August 06, 2002 8:48 PM
To: Multiple recipients of list ORACLE-L

you can also potentially get one of these with incorrect PL/SQL by trying to use bind identifiers (eg. using bind variables improperly) these are a bitch to find and deal with because you think its a O/S , semaphore or Oracle bug.

fwiw.

Mike
-----Original Message-----
Sent: Tuesday, August 06, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Johnson, Michael
INET: Michael.Johnson_at_oln-afmc.af.mil

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------