Re: Create a new database

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" <ORACLE-L_at_fatcity.com> 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 <hamid.alavi_at_quovadx.com>
> 05/02/2002 11:40 AM
>
>
> To: "'Jared.Still_at_radisys.com'" <Jared.Still_at_radisys.com>
> 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: ORACLE-L_at_fatcity.com
> 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 <hamid.alavi_at_quovadx.com>
> Sent by: root_at_fatcity.com
> 05/02/2002 11:28 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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: hamid.alavi_at_quovadx.com
>
> 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).
>
>
>
>
>
>
>
> ======================= 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: Jared.Still_at_radisys.com
>
> 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: Tim Gorman
  INET: Tim_at_SageLogix.com

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