ORA-03113: End of File on Communication Channel
Hello guys, I have an unexpected problem with this error. It appears when I execute and select statement showing bellow. The strange things is until now I don't catch it nevermore. I use two RDBMS: Oracle 8.1.7 EE for Windows NT4 and Oracle 8.1.7 EE for HPUX. The select statemen is: select tgr_error_id, count(tgr_error_id) from tim_logger where (TGR_CODICE_ID, TGR_DATETIME) not in (select tgr_codice_id, max(tgr_datetime) from tim_logger group by tgr_codice_id) and tgr_error_id<>'000' group by tgr_error_id order by tgr_error_id The table is: TABLE TIM_LOGGER ( TGR_ID NUMBER, TGR_CODICE_ID VARCHAR2 (14), TGR_DATETIME DATE, TGR_ERROR_ID CHAR (3)) Thanks
RE: ORA-03113: end-of-file on communication channel. HELP !
I'm not sure what operating system you are working on and I'm not precisely sure why you get your particular symptom, but I do know what you are missing. When you use "su - user", "the environment will be changed to what would be expected if the user actually logged in as the specified user" (from Solaris8 man page). If you omit the - argument, the new shell uses the current environment -- which, in your case, probably is not exactly the right environment for starting Oracle. To see the differences, save the output from env|sort after "su - oracle" then again after "su oracle" and use diff to compare them. I recommend that you always use the "su - oracle" login when starting oracle -- working under ksh while starting the database shouldn't be too painful even for a csh type person 8-) Note, on Solaris, "su -u user" seems to work the same as "su - user". The u is not a documented parameter but it may have some relevance on your version of unix. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, July 25, 2002 5:23 AM To: Multiple recipients of list ORACLE-L Hi, We have a Unix user dcclive ( oracle database user ops$dcclive - os authentication ). I am able to connect my database using TNS Alias but not directly. when i start the database in the following way : After logging in as dcclive ( C Shell ), su -u oracle ( Korn Shell ) and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it connects to the database. But when i logging in as dcclive ( C Shell ), su oracle and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it DOES NOT connects to the database. To connect now, i have to use TNS Alias as seen below. uid=1037(dcclive) gid=101(dba) kitchen% sqlplus / SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 25 12:07:36 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-03113: end-of-file on communication channel Enter user-name: / @dcclive Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Why ? Please note that Oracle login has Korn shell. Does the change of shell matters ? or am i missing something ? I have checked all the necessary env. variables. All r set properly. How exactly su -u and su matters to oracle ? Thanks in advance. Arul. -- 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: kkennedy 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).
ORA-03113: end-of-file on communication channel. HELP !
Hi, We have a Unix user dcclive ( oracle database user ops$dcclive - os authentication ). I am able to connect my database using TNS Alias but not directly. when i start the database in the following way : After logging in as dcclive ( C Shell ), su -u oracle ( Korn Shell ) and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it connects to the database. But when i logging in as dcclive ( C Shell ), su oracle and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it DOES NOT connects to the database. To connect now, i have to use TNS Alias as seen below. uid=1037(dcclive) gid=101(dba) kitchen% sqlplus / SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 25 12:07:36 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-03113: end-of-file on communication channel Enter user-name: / @dcclive Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Why ? Please note that Oracle login has Korn shell. Does the change of shell matters ? or am i missing something ? I have checked all the necessary env. variables. All r set properly. How exactly su -u and su matters to oracle ? Thanks in advance. Arul. -- 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: ORA-03113: end-of-file on communication channel
Hi, Kill -9 PID of pmon process and wait for 10 seconds, everything will be cleaned for you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manh Tran 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: ORA-03113: end-of-file on communication channel
Check and see if you still have a lock file in $ORACLE_HOME/dbs David A. Barbour Oracle DBA, OCP AISD 512-414-1002 John Weatherman ments.com> cc: Sent by: Subject: ORA-03113: end-of-file on communication channel [EMAIL PROTECTED] 05/06/2002 03:18 PM Please respond to ORACLE-L All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now done (fortunately this is on a development server). I'm still getting the ORA-3113. Anybody seen anything like this and/or have any suggestions for getting the database to open? TIA, John -- 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: ORA-03113: end-of-file on communication channel
I had this problem before in our Unix box. I have to use "ipcrm -m id" to remove the oracle process. You must use ipcs to find out the process first. Brian Chen -Original Message-From: John Weatherman [mailto:[EMAIL PROTECTED]]Sent: Monday, May 06, 2002 4:18 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-03113: end-of-file on communication channel All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now done (fortunately this is on a development server). I'm still getting the ORA-3113. Anybody seen anything like this and/or have any suggestions for getting the database to open? TIA, John
Re: ORA-03113: end-of-file on communication channel
Doc ID: 17613.1 On Mon, May 06, 2002 at 12:18:18PM -0800, John Weatherman wrote: > All, > > I had an instance crash this morning and sence then have been getting an > ORA-3113 whenever I try to open it. It will startup nomount and mount, > the error occurs on the open. A search on metalink showed this was likely > a shared memory error and recommended a reboot, which I have now done > (fortunately this is on a development server). I'm still getting the > ORA-3113. > > Anybody seen anything like this and/or have any suggestions for getting the > database to open? > > TIA, > John -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
ORA-03113: end-of-file on communication channel
All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now done (fortunately this is on a development server). I'm still getting the ORA-3113. Anybody seen anything like this and/or have any suggestions for getting the database to open? TIA, John
