ORA-03113 (and ORA-03114) are error messages issued by the client process, not generated on the server (like most "ORA-" messages). Both essentially are complaints by the client process (i.e. SQL*Plus) that there is no longer a connection to the database server process. The usual way this occurs is if the database server process has "core-dumped" or "aborted" from experiencing a "bus error", "segmentation fault", "segmentation violation", etc. Something dramatic and instantly fatal, kind of like a brain aneurism for computer processes...
You should be able to find a large, cryptic ASCII-text trace file (i.e. "*.trc") in whatever directory the parameter USER_DUMP_DEST is pointing to. The "alert_<ora-sid>.log" file (located in whatever directory the BACKGROUND_DUMP_DEST parameter is pointing to) should also have something logged in it. Unless the process was killed with the "KILL" or "-9" signal, Oracle executables generally try to produce a "core" file before it dies. This trace file would represent a good starting point for a search of MetaLink or for logging a TAR... If you haven't set these two "_DEST" parameters yet, then these files can probably be found in "$ORACLE_HOME/rdbms/log" or "$ORACLE_HOME/dbs" or some such... And the advice to upgrade to 8.1.7.2 still holds....... :-) ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:48 PM > I don't know why you are getting the ORA-3113 > > I was merely trying to offer some advice based on limited information. > > ORA-3113 is a 'catch all' error; any number of things can cause that > error. > > Are there other errors associated with it? > > Please include the list in your replies so as not to limit responses to > one individual. > > And the advice to move to 8.1.7.2 still holds. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > 05/02/2002 11:40 AM > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > cc: > Subject: RE: Create a new database > > > yes I am 0n 8.1.7.0, so you mean 8.1.7.0 can not create a new database. > But during the installation 8.1.7.0 I create a database, How come now I > can > not create another one?? > > > -----Original Message----- > Sent: Thursday, May 02, 2002 11:22 AM > To: [EMAIL PROTECTED] > Cc: Hamid Alavi > > > Which version exactly? > > If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any > databases. 8.1.7.3 is available, but rife with bugs. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 11:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: Create a new database > > > Hi List, > > When I try to create a new database (8.1.7) under sun solaris I got the > following error: > ORA-03113: end-of-file on communication channel > > Any Idea? Any help realy appreciated. > > This is the contenet of log file which created: > > Connected. > ORA-03113: end-of-file on communication channel > CREATE DATABASE "CMSREPT" > * > ORA-03114: not connected to ORACLE > Disconnected. > > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell 818 402-1987 > > > > > > > ======================= Confidentiality Statement ======================= > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > ===================== End Confidentiality Statement ===================== > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > > > > > > > > ======================= Confidentiality Statement ======================= > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > ===================== End Confidentiality Statement ===================== > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
