Hamid, Generally, finding an "alert*.log" file in the default "$ORACLE_HOME/rdbms/log" directory, even when BACKGROUND_DUMP_DEST has been set, indicates that someone issued the SHUTDOWN ABORT command when the instance wasn't already running. Alternatively, issuing the STARTUP FORCE command (which first performs a SHUTDOWN ABORT then a STARTUP) when the instance isn't already running could get the same effect.
In other words, I think it's a red herring -- you probably shouldn't worry about it. Set your BACKGROUND_DUMP_DEST, USER_DUMP_DEST, CORE_DUMP_DEST, and AUDIT_FILE_DEST parameters to "$ORACLE_BASE/admin/$ORACLE_SID/bdump", ".../udump", ".../cdump", and ".../adump" respectively and start over. If the ORA-03113 occurs again, look for "core" or ".trc" files in those directories and log a TAR with Oracle Support... Hope this helps... -Tim ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:37 PM > Tim, > This is me again, this is all in $ORACLE_HOME/rdbms/log > Thu May 2 10:15:06 2002 > Shutting down instance (abort) > That's it which I found as a log. > Thanks for your HELP > > -----Original Message----- > Sent: Thursday, May 02, 2002 1:54 PM > To: Multiple recipients of list ORACLE-L > > > 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). > > > > > > ======================= 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). -- 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).