RE: Create a new database

Thanks Tim,
Would you please let me know where can I download the Patch2 or 3 for 8.1.7 for OSsun5.7, Appreciate
Thanks

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





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