| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Create a new database
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
-- 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).Received on Thu May 02 2002 - 21:53:21 CDT
 |
 |