Re: ORA-03113: end-of-file ... during Oracle Streams setup
Well, it's easy. You're doing shutdown immediate during the procedure execution. do shutdown abort and you'll get rid of the error message. On 2003.10.26 16:14, [EMAIL PROTECTED] wrote: Hi List I am in the process of setting up Oracle Streams and getting the following error *** 2003-10-26 17:01:38.417 *** SESSION ID:(11.18) 2003-10-26 17:01:37.836 OPIRIP: Uncaught error 1089. Error stack: ORA-01089: immediate shutdown in progress - no operations are permitted ORA-00448: normal completion of background process while running (OEM generated script to setup Oracle Streams) BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); END; / Any help would be really appreciated. -tamizh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 ... during Oracle Streams setup
No. I did not shutdown the oracle DB. It is an oracle bug. Problem:- BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_RULE_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); END; / Solution:- could ask the customer to re-load as SYS $OH/rdbms/admin/dbmsread.sql $OH/rdbms/admin/prvtread.plb . then try the testcase. -tamizh - Original Message - Date: Sunday, October 26, 2003 4:44 pm Well, it's easy. You're doing shutdown immediate during the procedureexecution. do shutdown abort and you'll get rid of the error message. On 2003.10.26 16:14, [EMAIL PROTECTED] wrote: Hi List I am in the process of setting up Oracle Streams and getting the following error *** 2003-10-26 17:01:38.417 *** SESSION ID:(11.18) 2003-10-26 17:01:37.836 OPIRIP: Uncaught error 1089. Error stack: ORA-01089: immediate shutdown in progress - no operations are permitted ORA-00448: normal completion of background process while running (OEM generated script to setup Oracle Streams) BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); END; / Any help would be really appreciated. -tamizh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --- -- 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 ... during Oracle Streams setup
This is the error message: ORA-01089: immediate shutdown in progress - no operations are permitted. Either you shut the database down or somebody else did. You didn't buy a Halloween edition of oracle, did you? If you think it's a bug, you'll have to show the trace file of the failed background process. At any rate, the text of your PL/SQL procedure is probably less relevant then the version, platform, OS version and alike. You should really be opening an iTar, not writing to the oracle list. The basic motto of this list is Dante's All thy hopes abandon. On 2003.10.26 17:04, [EMAIL PROTECTED] wrote: No. I did not shutdown the oracle DB. It is an oracle bug. Problem:- BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_RULE_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); END; / Solution:- could ask the customer to re-load as SYS $OH/rdbms/admin/dbmsread.sql $OH/rdbms/admin/prvtread.plb . then try the testcase. -tamizh - Original Message - Date: Sunday, October 26, 2003 4:44 pm Well, it's easy. You're doing shutdown immediate during the procedureexecution. do shutdown abort and you'll get rid of the error message. On 2003.10.26 16:14, [EMAIL PROTECTED] wrote: Hi List I am in the process of setting up Oracle Streams and getting the following error *** 2003-10-26 17:01:38.417 *** SESSION ID:(11.18) 2003-10-26 17:01:37.836 OPIRIP: Uncaught error 1089. Error stack: ORA-01089: immediate shutdown in progress - no operations are permitted ORA-00448: normal completion of background process while running (OEM generated script to setup Oracle Streams) BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); END; / Any help would be really appreciated. -tamizh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --- -- 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 After Pathc 8.1.7.4
That's it. I ran it again and everything ok. Tks Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Richard Ji Sent: Friday, June 06, 2003 8:54 PM To: Multiple recipients of list ORACLE-L Did you re-run the glibc stub patch after applying 8.1.7.4? Richard -Original Message- Sent: Friday, June 06, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Platform suse linux professional 7.2 Sorry :-( Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Friday, June 06, 2003 7:14 PM To: 'DBA List ([EMAIL PROTECTED])' Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113 after like 1 minute. I followed the steps in the readme file of the patch. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 After Pathc 8.1.7.4
Did you re-run the glibc stub patch after applying 8.1.7.4? Richard -Original Message- Sent: Friday, June 06, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Platform suse linux professional 7.2 Sorry :-( Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Friday, June 06, 2003 7:14 PM To: 'DBA List ([EMAIL PROTECTED])' Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113 after like 1 minute. I followed the steps in the readme file of the patch. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 with dbms_output and sysdate
Your current session's DB has been gone out. Here is the scanario, Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL SET SERVEROUT ON SQL BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3 END; 4 / WED, SEP 25 15:32:28002 PL/SQL procedure successfully completed. SQL ; 1 BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3* END; SQL / ERROR: ORA-03114: not connected to ORACLE BEGIN * ERROR at line 1: ORA-12571: TNS:packet writer failure SQL hth, Nirmal. -Original Message- Sent: Tuesday, September 24, 2002 8:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 with dbms_output and sysdate
Seems like not a network then. Have you read a note 1020463.6 (mind you, it is a bit dated)? inka -Original Message- Sent: Tuesday, September 24, 2002 11:08 PM To: Multiple recipients of list ORACLE-L I will try that. The confusing part is I can run : select TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') into datevar from dual; dbms_output.put_line( datevar); and it works fine. I can run all my other sql scripts without error. I'd be surprised if it was a network error, but I'm willing to look at anything. steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 1:23 PM It is neither dbms_output nor sysdate. Try a loopback. This error is related to the network and I am sure that there is a lot on MetaLink. inka -Original Message- Sent: Tuesday, September 24, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Steve works fine for me on 8171 on WinNT Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set serveroutput on SQL DECLARE 2 3BEGIN 4 5dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') ); 6 7END; 8 9 / TUE, SEP 24 12:59:21002 PL/SQL procedure successfully completed. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 with dbms_output and sysdate
SET SERVEROUTPUT ON BEGIN dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); END; / WED, SEP 25 10:20:10002 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:38 AM Your current session's DB has been gone out. Here is the scanario, Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL SET SERVEROUT ON SQL BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3 END; 4 / WED, SEP 25 15:32:28002 PL/SQL procedure successfully completed. SQL ; 1 BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3* END; SQL / ERROR: ORA-03114: not connected to ORACLE BEGIN * ERROR at line 1: ORA-12571: TNS:packet writer failure SQL hth, Nirmal. -Original Message- Sent: Tuesday, September 24, 2002 8:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 with dbms_output and sysdate
Steve works fine for me on 8171 on WinNT Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set serveroutput on SQL DECLARE 2 3BEGIN 4 5dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') ); 6 7END; 8 9 / TUE, SEP 24 12:59:21002 PL/SQL procedure successfully completed. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 with dbms_output and sysdate
It is neither dbms_output nor sysdate. Try a loopback. This error is related to the network and I am sure that there is a lot on MetaLink. inka -Original Message- Sent: Tuesday, September 24, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Steve works fine for me on 8171 on WinNT Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set serveroutput on SQL DECLARE 2 3BEGIN 4 5dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') ); 6 7END; 8 9 / TUE, SEP 24 12:59:21002 PL/SQL procedure successfully completed. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 with dbms_output and sysdate
Check your ORA_NLS_33 parameter and make sure it is valid... Steve Perry [EMAIL PROTECTED] on 09/24/2002 01:48:25 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 with dbms_output and sysdate
I will try that. The confusing part is I can run : select TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') into datevar from dual; dbms_output.put_line( datevar); and it works fine. I can run all my other sql scripts without error. I'd be surprised if it was a network error, but I'm willing to look at anything. steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 1:23 PM It is neither dbms_output nor sysdate. Try a loopback. This error is related to the network and I am sure that there is a lot on MetaLink. inka -Original Message- Sent: Tuesday, September 24, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Steve works fine for me on 8171 on WinNT Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set serveroutput on SQL DECLARE 2 3BEGIN 4 5dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') ); 6 7END; 8 9 / TUE, SEP 24 12:59:21002 PL/SQL procedure successfully completed. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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. 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).
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).
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
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 john.weatherman@replace To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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
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
[EMAIL PROTECTED] schrieb: are you sure that you set ORACLE_SID appropriately? sqlplus /nolog connect sys/change_on_install@XXX as sysdba startup (nomount) replace XXX with your SID, typically ORCL. if this doesn't help, try: sorry - this was misleading: meant use O9i on RH7.2 - i/we use O9i twice .. on RH7.2 , twice .. on SunOS 5.8, thrice .. on W2k and they all work fine - so far. use O9i on RH7.2 twice, SunOS 5.8 twice, W2k twice- they all run fine. you need a workaround to get it started, esp the binutils must be downgraded for installation. (rpm -Uhv --nodeps --force binutils-2.10.0.18-1.i386.rpm from release RH7.0). after installation of oracle you can upgrade again. (rpm -Uhv binutils-2.11.90.0.8-9.i386.rpm) after upgrading again edit the file $ORACLE_HOME/bin/genclntsh find the line LD_SELF_CONTAINED=-z defs and edit so, that it reads LD_SELF_CONTAINED= then cd $ORQACLE_HOME relink all the latter builds all binaries newly. this worked for me - on both RH7.2 dual-piii-machines with O9i - will change to glibc-2.2.4-24.i686.rpm kernel-smp-2.4.9-31.i686.rpm shortly - and - on request - report after that. . I happened to install it this weekend twice and had no problems- but I used kernel 2.4.7-10smp. br marc ltiu schrieb: Hello Guys, Linux 2.4.18 Pentium III both Oracle 9i and 8i used netca and netmgr to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem. Even better if someone here has encountered this same problem and was able to fix it, could you email me the solution? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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).
RE: ORA-03113
3113 is a tough beast to resolve. We have some java processes that feed out spores to our clients. Recently at about 5:30pm and 6pm they all started throwing 3113 errors (with corresponding Exception 11 dump files on the server bdumps and cores too). Mind it well, the server trace file just tells me that it is Exception 11 , no other error is mentioned in the trace file. What we found that flushing the shared pool helped, and it isn't that the shared pool is insufficient, it is about 700M, and usually the system never exceeds 60%. We have plans to scale it down though ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: ORA-03113
are you sure that you set ORACLE_SID appropriately? sqlplus /nolog connect sys/change_on_install@XXX as sysdba startup (nomount) replace XXX with your SID, typically ORCL. if this doesn't help, try: use O9i on RH7.2 twice, SunOS 5.8 twice, W2k twice- they all run fine. you need a workaround to get it started, esp the binutils must be downgraded for installation. (rpm -Uhv --nodeps --force binutils-2.10.0.18-1.i386.rpm from release RH7.0). after installation of oracle you can upgrade again. (rpm -Uhv binutils-2.11.90.0.8-9.i386.rpm) reinstall it. I happened to install it this weekend twice and had no problems- but I used kernel 2.4.7-10smp. br marc ltiu schrieb: Hello Guys, Linux 2.4.18 Pentium III both Oracle 9i and 8i used netca and netmgr to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem. Even better if someone here has encountered this same problem and was able to fix it, could you email me the solution? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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).
Re: ORA-03113
Rajendra, The coredumping is ofcourse a bug in Oracle. However, not producing a stack trace and error stack also sounds like an bug to me. What is the response from Oracle Support on this ? You are using AIX and what version of Oracle ? Thanks, Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 22, 2002 1:28 PM 3113 is a tough beast to resolve. We have some java processes that feed out spores to our clients. Recently at about 5:30pm and 6pm they all started throwing 3113 errors (with corresponding Exception 11 dump files on the server bdumps and cores too). Mind it well, the server trace file just tells me that it is Exception 11 , no other error is mentioned in the trace file. What we found that flushing the shared pool helped, and it isn't that the shared pool is insufficient, it is about 700M, and usually the system never exceeds 60%. We have plans to scale it down though ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk 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
Anjo, me think it is something related to bind values and we use cursor_sharing=force. There is a bug already logged in and colleague of mine is working on it. In the mean time, I noted it here, because a shared_pool flush worked. I am on 9012 on AIX 4.3 64 bit. I think this is where I was told that the bug is fixed in main line 10 and a backport for 9013 would be available. But 9013 doesn't even compile (at-least we have had problems, I don't know the exact details though) and IBM+Oracle are still trying to resolve it. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: ORA-03113
I *hope* you have MetaLink access, cuz your gonna need it. You gave the Kernel version, but not the OS. I'm going to assume you are RedHat 7.1 or 7.2 due to the late version of your kernel. Oracle is not certified on these. There is a workaround. You can go technet.oracle.com, go to the download section and grab the patch for glibc on Linux. Neither 8i nor 9i will work without it on 2.4 kernels as they are using a later version of glibc than what Oracle was compiled with. Can't remember the version #'s, maybe someone else can help out here. I still haven't got 9i to work right on RH 7.2. 8i works though. I'll fix 9i when I get time, or just wait for Release 2. Jared On Sunday 21 April 2002 14:58, ltiu wrote: Hello Guys, Linux 2.4.18 Pentium III both Oracle 9i and 8i used netca and netmgr to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem. Even better if someone here has encountered this same problem and was able to fix it, could you email me the solution? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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
On Sun, Apr 21, 2002 at 04:18:27PM -0800, Jared Still wrote: I *hope* you have MetaLink access, cuz your gonna need it. You gave the Kernel version, but not the OS. I'm going to assume you are RedHat 7.1 or 7.2 due to the late version of your kernel. Oracle is not certified on these. This does not seem to be true according to metal ink: OS Product Certified With Version Status Addtl. Info. Components Other Install Issue SuSE 7.2 9.0.1 (9i) N/A N/A Certified Yes None None None SuSE 7.2 8.1.7 (8i) N/A N/A Certified Yes None None Yes Red Hat 7.1 9.0.1 (9i) N/A N/A Certified Yes None None None Red Hat 7.1 8.1.7 (8i) N/A N/A Certified Yes None None None RH 7.2 is still a glaring hole in the matrix, probably nothing to do with Red Hat Database. There is a workaround. You can go technet.oracle.com, go to the download section and grab the patch for glibc on Linux. Neither 8i nor 9i will work without it on 2.4 kernels as they are using a later version of glibc than what Oracle was compiled with. Can't remember the version #'s, maybe someone else can help out here. I still haven't got 9i to work right on RH 7.2. 8i works though. I'll fix 9i when I get time, or just wait for Release 2. Jared On Sunday 21 April 2002 14:58, ltiu wrote: Hello Guys, Linux 2.4.18 Pentium III both Oracle 9i and 8i used netca and netmgr to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem. Even better if someone here has encountered this same problem and was able to fix it, could you email me the solution? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). -- === 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).
Re: ORA-03113
9i is certified on rh 7.1 but not rh 7.2 a/o last week when i checked. it will work though on either, i've successfully got it running on rh 7.2 and used that for the logminer and data guard presentations last week at ioug conference. joe Jared Still wrote: I *hope* you have MetaLink access, cuz your gonna need it. You gave the Kernel version, but not the OS. I'm going to assume you are RedHat 7.1 or 7.2 due to the late version of your kernel. Oracle is not certified on these. There is a workaround. You can go technet.oracle.com, go to the download section and grab the patch for glibc on Linux. Neither 8i nor 9i will work without it on 2.4 kernels as they are using a later version of glibc than what Oracle was compiled with. Can't remember the version #'s, maybe someone else can help out here. I still haven't got 9i to work right on RH 7.2. 8i works though. I'll fix 9i when I get time, or just wait for Release 2. Jared On Sunday 21 April 2002 14:58, ltiu wrote: Hello Guys, Linux 2.4.18 Pentium III both Oracle 9i and 8i used netca and netmgr to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem. Even better if someone here has encountered this same problem and was able to fix it, could you email me the solution? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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
Assuming all your OS, patches, etc.. are certified, this error is very generic. Check your ORACLE_HOME again. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/21/02 2:58 PM Hello Guys, Linux 2.4.18 Pentium III both Oracle 9i and 8i used netca and netmgr to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem. Even better if someone here has encountered this same problem and was able to fix it, could you email me the solution? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: Wong, Bing 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
Title: RE: ORA-03113
Why don't you want to want to take all the oracle processes down? I thought that's what you wanted to accomplish with shutdown immediate?
Go ahead and issue Mladen's command and restart the database. It's the only way you can bring it down if you can't connect with svrmgrl or sqlplus.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-03113
Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP box 10 different databases.
This command was posted some time back by Mladen:
ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9
It's will take all oracle processes and listeners down
which I don't want to do. I'm on Oracle 8.1.6.
Thanks.
Greg.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
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
You could always start a bit nicer and kill pmon, wait a couple of minutes
to see if the others are brought down. They usually will as Oracle
recognizes the instance failure.
-Original Message-
Sent: Thursday, November 29, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L
Why don't you want to want to take all the oracle processes down? I thought
that's what you wanted to accomplish with shutdown immediate?
Go ahead and issue Mladen's command and restart the database. It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
Sent: Thursday, November 29, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP
box 10 different databases.
This command was posted some time back by Mladen:
ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9
It's will take all oracle processes and listeners down
which I don't want to do. I'm on Oracle 8.1.6.
Thanks.
Greg.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com
--
Author: Greg Faktor
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: Troiano, Paul (CAP, GEFA)
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
grep, then, for the instance you DO want to take down.
or, ask Mladen again. I understand he likes taking things down!
;-)
-Original Message-
Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP
box 10 different databases.
This command was posted some time back by Mladen:
ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
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: RE: ORA-03113
If I'll apply this command it's will take all oracle processes down for every
instance in this box?
Thanks.
[EMAIL PROTECTED] 11/29 10:35 AM
Why don't you want to want to take all the oracle processes down? I thought
that's what you wanted to accomplish with shutdown immediate?
Go ahead and issue Mladen's command and restart the database. It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-03113
Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP
box 10 different databases.
This command was posted some time back by Mladen:
ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9
It's will take all oracle processes and listeners down
which I don't want to do. I'm on Oracle 8.1.6.
Thanks.
Greg.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
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: Greg Faktor
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: RE: ORA-03113
Title: RE: RE: ORA-03113
Yes, you are right. If you have multiple instances change the command to something like this, assuming your sid name is SID
ps -fu oracleSID|grep -v PPID|awk '{ print $2; }'|xargs kill -9
Try it without the xargs kill -9 to verify it's choosing what you need. Otherwise just kill smon, pmon and the database will come down. I have done this many times and only once did I end up in a recovery.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: ORA-03113
If I'll apply this command it's will take all oracle processes down for every instance in this box?
Thanks.
[EMAIL PROTECTED] 11/29 10:35 AM
Why don't you want to want to take all the oracle processes down? I thought
that's what you wanted to accomplish with shutdown immediate?
Go ahead and issue Mladen's command and restart the database. It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-03113
Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP
box 10 different databases.
This command was posted some time back by Mladen:
ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9
It's will take all oracle processes and listeners down
which I don't want to do. I'm on Oracle 8.1.6.
Thanks.
Greg.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
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: Greg Faktor
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: RE: ORA-03113
Title: RE: RE: ORA-03113
Lisa,
ps -fu
oracleSID - command would not work. The reason is when you -u option
with ps, it looks for the user by name mentioned. In this case, there would not
be any user by name oracleSID (most likely). All the oracle processes
would be owned by the user oracle.
Now, the following modification for the command
might work. I did not test this completely.
ps -fu
oracle | grep -v SID | grep -v PPID | awk '{ print $2; }' | xargs kill
-9
Rao
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001
1:27 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: RE: ORA-03113
Yes, you are right. If you have
multiple instances change the command to something like this, assuming your
sid name is SID
ps -fu oracleSID|grep -v PPID|awk '{ print $2;
}'|xargs kill -9
Try it without the xargs kill -9 to verify
it's choosing what you need. Otherwise just kill smon, pmon and the
database will come down. I have done this many times and only once did I
end up in a recovery.
Lisa Koivu Oracle Database
Administrator Fairfield Resorts, Inc.
954-935-4117
-Original Message- From: Greg
Faktor [SMTP:[EMAIL PROTECTED]] Sent: Thursday,
November 29, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: ORA-03113
If I'll apply this command it's will take all
oracle processes down for every instance in this box?
Thanks.
[EMAIL PROTECTED] 11/29
10:35 AM Why don't you want
to want to take all the oracle processes down? I thought
that's what you wanted to accomplish with
shutdown immediate?
Go ahead and issue Mladen's command and restart
the database. It's the only way you
can bring it down if you can't connect with svrmgrl or sqlplus.
Lisa Koivu Oracle Database Monkey Fairfield
Resorts, Inc. 954-935-4117
-Original Message- From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001
10:05 AM To: Multiple
recipients of list ORACLE-L
Subject: ORA-03113 Hi All! I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can
take instance down? On this HP box
10 different databases. This command
was posted some time back by Mladen:
ps -fu oracle|grep -v PPID|awk '{
print $2; }'|xargs kill -9 It's will
take all oracle processes and listeners down which I don't want to do. I'm on Oracle 8.1.6.
Thanks. Greg. -- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg
Faktor 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: Greg Faktor
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: RE: ORA-03113
Try doing:
ps -ef|grep pmon|grep SID
It will look something like
oracle 20065 1 0 Nov 11 ?0:07 ora_pmon_BI
Issue the kill against the PPID that is returned, in this case 20065.
The kill command would look like:
kill -9 20065
Terry
-Original Message-
Sent: Thursday, November 29, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L
If I'll apply this command it's will take all oracle processes down for
every instance in this box?
Thanks.
[EMAIL PROTECTED] 11/29 10:35 AM
Why don't you want to want to take all the oracle processes down? I thought
that's what you wanted to accomplish with shutdown immediate?
Go ahead and issue Mladen's command and restart the database. It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-03113
Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP
box 10 different databases.
This command was posted some time back by Mladen:
ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9
It's will take all oracle processes and listeners down
which I don't want to do. I'm on Oracle 8.1.6.
Thanks.
Greg.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
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: Greg Faktor
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: Ball, Terry
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: RE: ORA-03113
Title: RE: RE: ORA-03113
Thanks Rao for correcting me. Like I confessed earlier, I am unix savvy, not an expert :)
-Original Message-
From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: ORA-03113
Lisa,
ps -fu oracleSID - command would not work. The reason is when you -u option with ps, it looks for the user by name mentioned. In this case, there would not be any user by name oracleSID (most likely). All the oracle processes would be owned by the user oracle.
Now, the following modification for the command might work. I did not test this completely.
ps -fu oracle | grep -v SID | grep -v PPID | awk '{ print $2; }' | xargs kill -9
Rao
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: ORA-03113
Yes, you are right. If you have multiple instances change the command to something like this, assuming your sid name is SID
ps -fu oracleSID|grep -v PPID|awk '{ print $2; }'|xargs kill -9
Try it without the xargs kill -9 to verify it's choosing what you need. Otherwise just kill smon, pmon and the database will come down. I have done this many times and only once did I end up in a recovery.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: ORA-03113
If I'll apply this command it's will take all oracle processes down for every instance in this box?
Thanks.
[EMAIL PROTECTED] 11/29 10:35 AM
Why don't you want to want to take all the oracle processes down? I thought
that's what you wanted to accomplish with shutdown immediate?
Go ahead and issue Mladen's command and restart the database. It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-03113
Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP
box 10 different databases.
This command was posted some time back by Mladen:
ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9
It's will take all oracle processes and listeners down
which I don't want to do. I'm on Oracle 8.1.6.
Thanks.
Greg.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
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: Greg Faktor
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 ora-03114
Donnie, Core dumps on NT don't record any errors in the alert.log the way they do on Unix platforms. They will typically create a sidCORE.LOG file in either bdump, udump or the default %ORACLE_HOME%\RDBMS73\TRACE directory. If you're lucky it will contain a stack trace that might be useful to help narrow down the common denominator. Have you checked the event viewer for any errors? When was the last time the server was rebooted? Given that this is a 7.3.3 db, however, there's not much advice I can give. HTH, -- Anita --- Shaw, Donnie [EMAIL PROTECTED] wrote: I recently rebuild several tables/indexes on a v7.3.3 database on nt 4.0 sp4. Most to all of the table rebuilds included changing the initial extent. A fews days later we started experiencing ora-03113/03114 errors on the client side. This is a small database/applications which serves a small user base, 10 - 15 users. There is no relevant information in the alter log, nor am I generating any trace files. This listener is up and from a network stand point we are not receiving any packet errors or collisions. The database starts up fine and everyone can connect with no problems. After being logged in and working for a certain amount time the users loose their connection. This problem isn't isolated to certain users or machines. For that matter nor the views or tables they are accessing either. Has anyone ran into this situation and if so how did you identify and resolve the issue. thanks, Donnie Shaw __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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 DURING DATABASE STARTUP
Did u check shared memory and unix parameter?If UNIX parameters are ok then please try to start with mount options. -Seema From: Harvinder Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORA-03113 DURING DATABASE STARTUP Date: Fri, 02 Nov 2001 10:15:19 -0800 Hi, We have just created the database on solaris unix box and we are able ro run all applications. But when we reboot the sun box and try to start database we are getting error ORA-03113. I tried all the points which are specified in metalink articles.. Following one of the articles i tried following steps: startup nomount pfile=inittest.ora our init.ora file it gives error ora-03113 then i tried startup nomount pfile=init.ora sample file and it succedded. I didn't change anything in inittest.ora file before reboot What can be the possible cause for problem? any OS level setting or where to check Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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 DURING DATABASE STARTUP
Hi! Happened to me once. Somehow the init ora file had gotten corrupted with unprintable control characters. Solved the problem by recreating a new init ora by retyping. If you have ftp'ed the init ora file from another system, make sure that it was in ASCII format. pramo chepuri -Original Message- Sent: Friday, November 02, 2001 1:15 PM To: Multiple recipients of list ORACLE-L Hi, We have just created the database on solaris unix box and we are able ro run all applications. But when we reboot the sun box and try to start database we are getting error ORA-03113. I tried all the points which are specified in metalink articles.. Following one of the articles i tried following steps: startup nomount pfile=inittest.ora our init.ora file it gives error ora-03113 then i tried startup nomount pfile=init.ora sample file and it succedded. I didn't change anything in inittest.ora file before reboot What can be the possible cause for problem? any OS level setting or where to check Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: Chepuri Pramo (AP/QSW3, AB/QSW3) 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 when executing the initjvm script
Thanks, christoffer, finally I have solved this and it works. The parameters set I have now, is the following: shared_pool_size 68157440 (size in bytes ) shared_pool_reserved_size 3407872 large_pool_size 614400 java_pool_size 5250 java_soft_sessionspace_limit 0 java_max_sessionspace_size 0 50 mb free in the system tablespace XXX in the rollback segment. I suppose that the rollback segment space is the following: SQL select sum(rssize-writes) from v$rollstat; SUM(RSSIZE-WRITES) -- 29326204 A lot of thanks all, Christopher Spence wrote: I notice this happens when you don't have enough rollback space. You may want to go through and check back and see what the original error was. You may want to increase your SP a little and decrease your JP a little. Although it is recommended to have SP: 20M JP: 30M for the install, 90M of rollback, and if I remember 130M of System Tablespace. Also, there is a bug on metadink regarding changing call to execute, seems to cause this problem as well. Forget the bug number. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1: ORA-03113: end-of-file on communication channel * The script is composed of several calls to another scripts, and is in the second one, the initjvm2.sql where the error appears. I have checked the trace and log files, but there isn´t any one that give me a clue on the problem. I have read something about checking some parameters, here is the output showing them: ** SQL select * from v$parameter 2 where name like '%pool_size%'; NUM NAME TYPE -- -- VALUE ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ - - - -- - DESCRIPTION 23 shared_pool_size 2 19643392 FALSE FALSE FALSE FALSE FALSE size in bytes of shared pool 28 large_pool_size 2 614400 FALSE FALSE FALSE FALSE FALSE size in bytes of the large allocation pool 30 java_pool_size 2 5250 FALSE FALSE FALSE FALSE FALSE size in bytes of the Java pool * I think they are setting correctly... Has anyone faced this problem? TIA, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard
Re: ORA-03113 when executing the initjvm script
Look in trace files. Probably you are hitting a 4030 error. If this the case, not only shared_pool_size or java_pool_size are the parameters to be increased. Also increase java_soft_sessionspace_limit or java_max_sessionspace_size. If it isn't a 4030 case, put the event to get the errorstack of the 3113 in the init.ora: event=3113 trace name errorstack level 10 REGARDS. --- Beatriz Martínez Jiménez [EMAIL PROTECTED] wrote: Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1: ORA-03113: end-of-file on communication channel * The script is composed of several calls to another scripts, and is in the second one, the initjvm2.sql where the error appears. I have checked the trace and log files, but there isn´t any one that give me a clue on the problem. I have read something about checking some parameters, here is the output showing them: ** SQL select * from v$parameter 2 where name like '%pool_size%'; NUM NAME TYPE -- -- VALUE ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ - - - -- - DESCRIPTION 23 shared_pool_size 2 19643392 FALSE FALSE FALSE FALSE FALSE size in bytes of shared pool 28 large_pool_size 2 614400 FALSE FALSE FALSE FALSE FALSE size in bytes of the large allocation pool 30 java_pool_size 2 5250 FALSE FALSE FALSE FALSE FALSE size in bytes of the Java pool * I think they are setting correctly... Has anyone faced this problem? TIA, begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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 when executing the initjvm script
I notice this happens when you don't have enough rollback space. You may want to go through and check back and see what the original error was. You may want to increase your SP a little and decrease your JP a little. Although it is recommended to have SP: 20M JP: 30M for the install, 90M of rollback, and if I remember 130M of System Tablespace. Also, there is a bug on metadink regarding changing call to execute, seems to cause this problem as well. Forget the bug number. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1: ORA-03113: end-of-file on communication channel * The script is composed of several calls to another scripts, and is in the second one, the initjvm2.sql where the error appears. I have checked the trace and log files, but there isn´t any one that give me a clue on the problem. I have read something about checking some parameters, here is the output showing them: ** SQL select * from v$parameter 2 where name like '%pool_size%'; NUM NAME TYPE -- -- VALUE ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ - - - -- - DESCRIPTION 23 shared_pool_size 2 19643392 FALSE FALSE FALSE FALSE FALSE size in bytes of shared pool 28 large_pool_size 2 614400 FALSE FALSE FALSE FALSE FALSE size in bytes of the large allocation pool 30 java_pool_size 2 5250 FALSE FALSE FALSE FALSE FALSE size in bytes of the Java pool * I think they are setting correctly... Has anyone faced this problem? TIA, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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 when executing the initjvm script
Chris, Basically the error 3113 is bit different from the other errors. Most of the errors (if not all ORA errors other than 3113 and 1041 I think) are generated from rdbms kernel where as 3113 is generated from the client side, You won't be able to get an error stack trace or systemstate/processtate dumps by setting an event 3113. I don't think this is possible. Have you ever trued setting event 3113 and got an errorstack ? Just Curious. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Trassens Sent: Monday, October 01, 2001 3:40 AM To: Multiple recipients of list ORACLE-L Look in trace files. Probably you are hitting a 4030 error. If this the case, not only shared_pool_size or java_pool_size are the parameters to be increased. Also increase java_soft_sessionspace_limit or java_max_sessionspace_size. If it isn't a 4030 case, put the event to get the errorstack of the 3113 in the init.ora: event=3113 trace name errorstack level 10 REGARDS. also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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 when executing the initjvm script
Gopal, I have tried it many times (dumping errorstack at level 3 on 3113) but somehow it didn't give the analyst any clue. I don't know why ... and neither did he (the analyst). Of course none of my errors are related to JVM, we haven't started putting JAVA in our DB, that's for 9i implementation. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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 comm. error - Why???
The Ora-3113 is because the database crashed; your client machine no longer had a database to communicate with. You should find errors in the databases alert log; a trace file and a core dump should have been produced. It could be an OS software problem, an Oracle software problem or possibly a hardware problem.The trace files are instrumental in determining what went wrong. Were there any OS system events captured at the same time? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 16, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Hi, I have a program that converts records from d-base to Oracle 8.1.7. I works perfectly but about once a week it gives the Ora-03113 error and the whole Oracle freezes, we have to restart the whole server. There is no logic in it since if I repeat the converting procedure 100 times with the same data, maybe all 100 will be good, but there is a chance that e.g. the 97-th will give this error. Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: MacGregor, Ian A. 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).
