Hi all, In second run almost every thing goes OK except the PL/SQL part but I could open the database, but still looking for a link to download the patch2 for oracle 8.1.7 sun solaris. Tanks all for helping with this issue. BTW: Nobody answer how can I remove the SID name from oracle.
-----Original Message----- Sent: Thursday, May 02, 2002 7:53 PM To: Multiple recipients of list ORACLE-L 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). ======================= 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).
