RE: Create a new database
Hi Jared, I was off the listserv for about 2 months and probably missed the discussion on this. Do you have a pointer to where I can get information on what was messed up in the 8.1.7.3 patch? I was intending to schedule the 8.1.7.3 patch installations for some of my databases in the next few days so this was a very timely post! Thanks, Jay -Original Message- Sent: Thursday, May 02, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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 Cell818 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). -- 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: Miller, Jay 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).
RE: Create a new database
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_.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 > >
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 - 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_.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
RE: Create a new database
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_.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 > Cell818 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
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_.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 > Cell818 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 >
RE: Create a new database
ftp://oracle-ftp.oracle.com/server/patchsets/unix/SUN_SOLARIS2/81patchsets/3 2BIT/ -Original Message- Sent: Thursday, May 02, 2002 5:28 PM To: Multiple recipients of list ORACLE-L 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_.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 > Cell818 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 &
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_.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 > Cell818 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 m
RE: Create a new database
Where can I download the Patch2 for Oracle 8.1.7.0 SunOS 5.7 I couldn't find anything like Patch2 or Patch3 Thanks for HELP -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 Cell818 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: 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).
RE: Create a new database
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
Cell818 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).
Re: Create a new database
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 Cell818 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). -- 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).
