Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Create a new database

RE: Create a new database

From: Hamid Alavi <hamid.alavi_at_quovadx.com>
Date: Fri, 03 May 2002 07:23:23 -0800
Message-ID: <F001.004574A8.20020503072323@fatcity.com>


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

> 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" <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).
-- 
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).
Received on Fri May 03 2002 - 10:23:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US