core dump [ttci2u()+2356] and ORA-03113 at clientend
Hi, I have Oracle8163 on Sun and Sun 8160 clients.Applications are running fine.We are planning to migrate to app box on Linux 7.1.We Installed Oracle client 9.2.0.1 on linux box.When we are running couple of applications which are having CLOB column,We are getting some error on DB box(Sun Box) and some error on client box(Linux). Sun box (DB error) ORA-07445: exception encountered: core dump [ttci2u()+2356] [SIGSEGV] [Address not mapped to object] [0] [] [] On Linux box(Client box) exception 3113, ora8.c:2161:ora_get_row: error in `OCILobRead ()': ORA-03113: end-of-file on communication channel Meta link say its due to platform diffrent and OCI layer which is fixed in Oracle 9.2. Any one had such problem if yes how did fix ? thx -Seema _ Compare high-speed Internet plans, starting at $26.95. https://broadband.msn.com (Prices may vary by service area.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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
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).
ORA-03113: end-of-file ... during Oracle Streams setup
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).
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).
ORA-03113 on using create_stored_outlines
Hello list I need your help with a problem I am having whenever I start using outlines. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Suppose two users scott and hr have select any table, create any outline privileges and select_catalog_role. SQL conn scott/[EMAIL PROTECTED] Connected. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=hr; Session altered. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL create table test as select * from scott.emp ; create table test as select * from scott.emp * ERROR at line 1: ORA-03113: end-of-file on communication channel (And I get a core dump file ) The same thing happens irrespective of the category name I use in alter session set create_stored_outlines , even when i specify alter session set create_stored_outlines=default;, and even when I use random values. But when I do the following then no problems : SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=false; Session altered. SQL create table test as select * from scott.emp ; Table created. Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Dedicated Server problem ORA-03113
That is the whole problem, there is no logged errors, or trace files. Everyone can connect via the MTS servers, no problem, however no one can connect via dedicated server. Go figure. Regards Denham -Original Message- Sent: Saturday, June 28, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Hi! What does your alert log say? Or event log then? Maybe, for some reason, Oracle is unable to start new processes on your system. For MTS connection, no new processes are needed, but for dedicated, there are. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 28, 2003 12:24 PM Hello Gurus, I am at wits end. The enviroment is Windows 2000 SP3. Oracle 817, MTS is also set up. The server has been up for 32 days. Everything fine and then suddenly all the power users using dedicated server because of their resource intensive sql etc just cann't connect. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections, and I have seen up to nine dedicated server connections before. Anyone experience this before? Regards Denham Eva Oracle DBA _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva 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: Tanel Poder 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). _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those
RE: Dedicated Server problem ORA-03113
ORA-3113 error is not very easy to track down. It's like ORA-600, but relates to issues in N/W communication with Oracle datbases. There are a number of notes/articles on Metalink discussing this error. Hopefully some of that information helps you. - Kirti --- Denham Eva [EMAIL PROTECTED] wrote: That is the whole problem, there is no logged errors, or trace files. Everyone can connect via the MTS servers, no problem, however no one can connect via dedicated server. Go figure. Regards Denham -Original Message- Sent: Saturday, June 28, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Hi! What does your alert log say? Or event log then? Maybe, for some reason, Oracle is unable to start new processes on your system. For MTS connection, no new processes are needed, but for dedicated, there are. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 28, 2003 12:24 PM Hello Gurus, I am at wits end. The enviroment is Windows 2000 SP3. Oracle 817, MTS is also set up. The server has been up for 32 days. Everything fine and then suddenly all the power users using dedicated server because of their resource intensive sql etc just cann't connect. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections, and I have seen up to nine dedicated server connections before. Anyone experience this before? Regards Denham Eva Oracle DBA __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Dedicated Server problem ORA-03113
Yeah, so I have discovered when looking on metalink :-) Nice of you to answer anyway, appreciate it. Denham -Original Message- Sent: Monday, June 30, 2003 4:10 PM To: Multiple recipients of list ORACLE-L ORA-3113 error is not very easy to track down. It's like ORA-600, but relates to issues in N/W communication with Oracle datbases. There are a number of notes/articles on Metalink discussing this error. Hopefully some of that information helps you. - Kirti --- Denham Eva [EMAIL PROTECTED] wrote: That is the whole problem, there is no logged errors, or trace files. Everyone can connect via the MTS servers, no problem, however no one can connect via dedicated server. Go figure. Regards Denham -Original Message- Sent: Saturday, June 28, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Hi! What does your alert log say? Or event log then? Maybe, for some reason, Oracle is unable to start new processes on your system. For MTS connection, no new processes are needed, but for dedicated, there are. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 28, 2003 12:24 PM Hello Gurus, I am at wits end. The enviroment is Windows 2000 SP3. Oracle 817, MTS is also set up. The server has been up for 32 days. Everything fine and then suddenly all the power users using dedicated server because of their resource intensive sql etc just cann't connect. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections, and I have seen up to nine dedicated server connections before. Anyone experience this before? Regards Denham Eva Oracle DBA __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva 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).
Dedicated Server problem ORA-03113
Hello Gurus, I am at wits end. The enviroment is Windows 2000 SP3. Oracle 817, MTS is also set up. The server has been up for 32 days. Everything fine and then suddenly all the power users using dedicated server because of their resource intensive sql etc just cann't connect. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections, and I have seen up to nine dedicated server connections before. Anyone experience this before? Regards Denham Eva Oracle DBA _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva 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: Dedicated Server problem ORA-03113
Hi! What does your alert log say? Or event log then? Maybe, for some reason, Oracle is unable to start new processes on your system. For MTS connection, no new processes are needed, but for dedicated, there are. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 28, 2003 12:24 PM Hello Gurus, I am at wits end. The enviroment is Windows 2000 SP3. Oracle 817, MTS is also set up. The server has been up for 32 days. Everything fine and then suddenly all the power users using dedicated server because of their resource intensive sql etc just cann't connect. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections, and I have seen up to nine dedicated server connections before. Anyone experience this before? Regards Denham Eva Oracle DBA _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva 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: Tanel Poder 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).
ORA-03113 After Pathc 8.1.7.4
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).
FW: ORA-03113 After Pathc 8.1.7.4
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).
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).
ORA-03113: End of File on Communication Channel
Hello guys, I have an unexpected problem with this error. It appears when I executeand select statement showing bellow. The strange things isuntil nowI don't catch itnevermore. I use two RDBMS: Oracle 8.1.7 EE for Windows NT4 andOracle 8.1.7 EE for HPUX. The select statemen is: select tgr_error_id, count(tgr_error_id) from tim_logger where (TGR_CODICE_ID, TGR_DATETIME) not in (select tgr_codice_id, max(tgr_datetime) from tim_logger group by tgr_codice_id) and tgr_error_id'000' group by tgr_error_id order by tgr_error_id The table is: TABLE TIM_LOGGER ( TGR_ID NUMBER, TGR_CODICE_ID VARCHAR2 (14), TGR_DATETIME DATE, TGR_ERROR_ID CHAR (3)) Thanks
ORA-03113 solved .....
After several tests on different machines we found that it was not a version problem, but a environment problem. What happened is that one of our DBAs had created a Unix alias to bring the instance up in her profile and that did not set up the environment properly even though the database came up the last time she bounced the database. Specifically, the LD_LIBRARY_PATH was environment variable was SYS$HOSED as we used to say in the VAX world. The fix is to make sure you bring up the Oracle Instance under the Oracle account. We bounced the instance in the middle of the night and everything is fine now. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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).
Drop snapshot ORA-03113
Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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).
Drop snapshot ORA-03113 - part 2
DBA_JOBS shows that there is job associated with phantom refresh group. Can't remove job because user that owns it does not exist (remember fromuser/touser). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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).
AW: Drop snapshot ORA-03113
Create user x, drop objects, drop user x Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Vladimir Barac [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 16. Oktober 2002 17:49 An: Multiple recipients of list ORACLE-L Betreff: Drop snapshot ORA-03113 Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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: Drop snapshot ORA-03113 - part 2
Have you tried execute sys.dbms_ijob.remove(xx); An undocumented provedure that I picked up on from this list a few weeks ago John -Original Message- Sent: 16 October 2002 17:04 To: Multiple recipients of list ORACLE-L DBA_JOBS shows that there is job associated with phantom refresh group. Can't remove job because user that owns it does not exist (remember fromuser/touser). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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: Drop snapshot ORA-03113 - part 2
See if SYS.DBMS_IJOB.REMOVE(job_id) or SYS.DBMS_IJOB.DROP_USER_JOBS('USERNAME') works Regards Naveen -Original Message- Sent: Wednesday, October 16, 2002 9:34 PM To: Multiple recipients of list ORACLE-L DBA_JOBS shows that there is job associated with phantom refresh group. Can't remove job because user that owns it does not exist (remember fromuser/touser). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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: Naveen Nahata 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: Drop snapshot ORA-03113
We have logged a TAR with Oracle regarding this type of scenario except the client in NT and the server is Sun. They are in the process of reviewing the trace file we sent. Everyones hunch is that its a network issue. You should be able to reproduce it at with with various type of DDL. (eg. DROP USER blah;) -Original Message- Sent: Wednesday, October 16, 2002 8:49 AM To: Multiple recipients of list ORACLE-L Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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: Johnson, Michael 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: How to fix ORA-03113 error
I have oracle8.0.5 running on Solaris8. Here's trace file. I don't think there is problem with I/O. How do I recover this error? $more ssdb_lgwr_272.trc Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /export/home/oracle/product/8.0.5 System name:SunOS Node name: plab1 Release:5.8 Version:Generic_108528-03 Machine:sun4u Instance name: SSDB Redo thread mounted by this instance: 1 Oracle process number: 4 Unix process pid: 272, image: ora_lgwr_SSDB *** SESSION ID:(3.1) 2002.10.13.02.19.02.000 error 204 detected in background process -Original Message- Sent: Monday, October 14, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Your instance crashed because the lgwr died... There should be a trace file for lgwr in the bdump directory... What does it say in the trace file? Are you having any filesystem issues? The LGWR: terminating instance due to error 204 means that there is an I/O error when accessing the controlfile... What version is your database... What O/S are you on... etc... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink... Tim -Original Message- Sent: Monday, October 14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Johnston, Tim 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: Nguyen, David M 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: How to fix ORA-03113 error
Did you read Note:1069812.6 on Metalink yet? Tim -Original Message- Sent: Tuesday, October 15, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I have oracle8.0.5 running on Solaris8. Here's trace file. I don't think there is problem with I/O. How do I recover this error? $more ssdb_lgwr_272.trc Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /export/home/oracle/product/8.0.5 System name:SunOS Node name: plab1 Release:5.8 Version:Generic_108528-03 Machine:sun4u Instance name: SSDB Redo thread mounted by this instance: 1 Oracle process number: 4 Unix process pid: 272, image: ora_lgwr_SSDB *** SESSION ID:(3.1) 2002.10.13.02.19.02.000 error 204 detected in background process -Original Message- Sent: Monday, October 14, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Your instance crashed because the lgwr died... There should be a trace file for lgwr in the bdump directory... What does it say in the trace file? Are you having any filesystem issues? The LGWR: terminating instance due to error 204 means that there is an I/O error when accessing the controlfile... What version is your database... What O/S are you on... etc... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink... Tim -Original Message- Sent: Monday, October 14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Johnston, Tim 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: Nguyen, David M 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
Re: How to fix ORA-03113 error
Please don't "think" about whether there is I/O trouble -- test it. There is no sense in eliminating possible clues based on hoping. To paraphrase Thomas Edison, troubleshooting is 98% perspiration and 2% inspiration... Please chase down*all* ofthe clues you've been provided: Have you attempted to read your control files? Just use the UNIX "dd" or "od" commands to make sure that a read can be performed without an error... Have you performed the "cksum" (checksum) command against all of the control filesto verify that they are exactly identical? Are there any other ".trc" files in the BDUMP directory created around the same time? What does it say? Are there any other ".trc" files in the UDUMP directory created around the same time? Are there any "core" files in the CDUMP directory created around the same time? Hopefully, the first thing you did was log a TAR on MetaLink, right? - Original Message - From: "Nguyen, David M" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 9:54 AM Subject: RE: How to fix ORA-03113 error I have oracle8.0.5 running on Solaris8. Here's trace file. I don't think there is problem with I/O. How do I recover this error? $more ssdb_lgwr_272.trc Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /export/home/oracle/product/8.0.5 System name: SunOS Node name: plab1 Release: 5.8 Version: Generic_108528-03 Machine: sun4u Instance name: SSDB Redo thread mounted by this instance: 1 Oracle process number: 4 Unix process pid: 272, image: ora_lgwr_SSDB *** SESSION ID:(3.1) 2002.10.13.02.19.02.000 error 204 detected in background process-Original Message- Sent: Monday, October 14, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Your instance crashed because the lgwr died... There should be a trace file for lgwr in the bdump directory... What does it say in the trace file? Are you having any filesystem issues? The "LGWR: terminating instance due to error 204" means that there is an I/O error when accessing the controlfile... What version is your database... What O/S are you on... etc... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink... Tim -Original Message- Sent: Monday, October 14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, DavidSVRMGR startup ORACLE instance started. Total System Global Area 285236752 bytes Fixed Size 48656 bytes Variable Size 75390976 bytes Database Buffers 209715200 bytes Redo Buffers 81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Johnston, Tim 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services --
RE: How to fix ORA-03113 error
I am working with Oracle right now on a similar problem which looks to be like a network problem depending on the versions of what you are running. There is a bug that was fixed in 8.1.7.3 dealing with 3113 errors. Dont know what version you are running, but that could have something to do with it. fwiw. Mike -Original Message- Sent: Monday, October 14, 2002 5:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Johnson, Michael 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).
How to fix ORA-03113 error
I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: How to fix ORA-03113 error
At least one of your control files is corrupted, or the disk it is on is bad: 00204, 0, error in reading (block %s, # blocks %s) of controlfile // *Cause: A disk I/O failure was detected on reading the controlfile. // *Action: Check if the disk is online, if it is not, bring it online and try // a warm start again. If it is online, then you need to recover // the disk. Jared Nguyen, David M [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2002 05:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to fix ORA-03113 error I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: How to fix ORA-03113 error
Your instance crashed because the lgwr died... There should be a trace file for lgwr in the bdump directory... What does it say in the trace file? Are you having any filesystem issues? The LGWR: terminating instance due to error 204 means that there is an I/O error when accessing the controlfile... What version is your database... What O/S are you on... etc... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink... Tim -Original Message- Sent: Monday, October 14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Johnston, Tim 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: Help on ORA-03113 error and 7445 in the trace file.
Title: RE: Win2000/8.1.7.3.0/SQL Update ... we dont see this problem if we rlogin to the server via a Sun Solaris client box. -Original Message-From: Johnson, Michael Sent: Friday, October 11, 2002 10:38 AMTo: '[EMAIL PROTECTED]'Subject: Help on ORA-03113 error and 7445 in the trace file. We are getting a intermittent problem that happens both from a SQL prompt or if we execute off of a package. We can telnet in or go through the TNS side of things. It doesnt seem to matter. Sun Solaris 2.8 Oracle 8.1.7.4 Here is the scenario ... SQL Create user blah identified by blah default ts blah temporary ts blah; SQL Drop user blah; ORA-03113 end of file blah blah blah The server thread process is disconnected and we have to reconnect. ORA-07445 shows up in the trace file. After reconnecting we do indeed see that the BLAH user was dropped before we disconnected. Note that all DML seems to work on this connection , only DDL type stuff causes a problem. The only thing we can figure is some type of network issue, but what ?? Thanks for your time in advance. Mike
Help on ORA-03113 error and 7445 in the trace file.
Title: RE: Win2000/8.1.7.3.0/SQL We are getting a intermittent problem that happens both from a SQL prompt or if we execute off of a package. We can telnet in or go through the TNS side of things. It doesnt seem to matter. Sun Solaris 2.8 Oracle 8.1.7.4 Here is the scenario ... SQL Create user blah identified by blah default ts blah temporary ts blah; SQL Drop user blah; ORA-03113 end of file blah blah blah The server thread process is disconnected and we have to reconnect. ORA-07445 shows up in the trace file. After reconnecting we do indeed see that the BLAH user was dropped before we disconnected. Note that all DML seems to work on this connection , only DDL type stuff causes a problem. The only thing we can figure is some type of network issue, but what ?? Thanks for your time in advance. Mike
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).
ORA-03113 with dbms_output and sysdate
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).
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).
ORA-03113 will creating db
Hi All, I am Installed Oracle 8.1.7 on Solaris 8 on sun sparc machine(1 gb Ram) . Installation went off sucessfully without any Problem. But at time of creation of database through DB Assist it is giving ORA-03113 end-of-file on communication channel.I have even tried to create database manually but i am getting same error i am when i saying startup nomount pfile=... my oracle_home and oracle_sid are set properly Is the setting of kernel parameter to do with this error . follwoing are the parameter set by me in /etc/suystem file set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=210 set semsys:seminfo_semmns=205 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03113: end-of-file on communication channel. HELP !
Hi, We have a Unix user dcclive ( oracle database user ops$dcclive - os authentication ). I am able to connect my database using TNS Alias but not directly. when i start the database in the following way : After logging in as dcclive ( C Shell ), su -u oracle ( Korn Shell ) and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it connects to the database. But when i logging in as dcclive ( C Shell ), su oracle and started the database, exit from oracle login , connect from dcclive login using os authentication ( using / in sqlplus ), it DOES NOT connects to the database. To connect now, i have to use TNS Alias as seen below. uid=1037(dcclive) gid=101(dba) kitchen% sqlplus / SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 25 12:07:36 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-03113: end-of-file on communication channel Enter user-name: / @dcclive Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Why ? Please note that Oracle login has Korn shell. Does the change of shell matters ? or am i missing something ? I have checked all the necessary env. variables. All r set properly. How exactly su -u and su matters to oracle ? Thanks in advance. Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03113: end-of-file on communication channel. 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).
More info About RAC, LINUX and ORA-03113
Oracle version 9i release 2 LINUX RH7.3 === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03113: end-of-file on communication channel
All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now done (fortunately this is on a development server). I'm still getting the ORA-3113. Anybody seen anything like this and/or have any suggestions for getting the database to open? TIA, John
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
ORA-03113
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).
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).
LogMiner and ORA-03113
I'm trying to analyze some archive logs via LogMiner and I keep getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I did a new and start prior to running the query. This process that I am going through works on some log files but not on others. The log files aren't corrupted because I can restore/recover the database and apply the logs successfully for a roll-forward. I'm just running a 'select count(*)' query at this point. Has anyone else encountered this and come up with a solution? I've checked MetaLink, Google, etc and so far have not come up with anything that describes what may be the cause. I'm running 8.1.7.2 (64bit) on Solaris 8. MANY thanks in advance. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: LogMiner and ORA-03113
whats your blocksize, anything other than 2K has been know to cause all kinds of problems. joe Walter K wrote: I'm trying to analyze some archive logs via LogMiner and I keep getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I did a new and start prior to running the query. This process that I am going through works on some log files but not on others. The log files aren't corrupted because I can restore/recover the database and apply the logs successfully for a roll-forward. I'm just running a 'select count(*)' query at this point. Has anyone else encountered this and come up with a solution? I've checked MetaLink, Google, etc and so far have not come up with anything that describes what may be the cause. I'm running 8.1.7.2 (64bit) on Solaris 8. MANY thanks in advance. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- 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: LogMiner and ORA-03113
Block size is 8k. Interesting, how is the block size related? --- Joe Testa [EMAIL PROTECTED] wrote: whats your blocksize, anything other than 2K has been know to cause all kinds of problems. joe Walter K wrote: I'm trying to analyze some archive logs via LogMiner and I keep getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I did a new and start prior to running the query. This process that I am going through works on some log files but not on others. The log files aren't corrupted because I can restore/recover the database and apply the logs successfully for a roll-forward. I'm just running a 'select count(*)' query at this point. Has anyone else encountered this and come up with a solution? I've checked MetaLink, Google, etc and so far have not come up with anything that describes what may be the cause. I'm running 8.1.7.2 (64bit) on Solaris 8. MANY thanks in advance. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: LogMiner and ORA-03113
Just that there have been numerous bugs in logminer with blocksizes != 2K. joe Walter K wrote: Block size is 8k. Interesting, how is the block size related? --- Joe Testa [EMAIL PROTECTED] wrote: whats your blocksize, anything other than 2K has been know to cause all kinds of problems. joe Walter K wrote: I'm trying to analyze some archive logs via LogMiner and I keep getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I did a new and start prior to running the query. This process that I am going through works on some log files but not on others. The log files aren't corrupted because I can restore/recover the database and apply the logs successfully for a roll-forward. I'm just running a 'select count(*)' query at this point. Has anyone else encountered this and come up with a solution? I've checked MetaLink, Google, etc and so far have not come up with anything that describes what may be the cause. I'm running 8.1.7.2 (64bit) on Solaris 8. MANY thanks in advance. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- 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
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).
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).
ora-03113 ora-03114
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 This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, Donnie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03113 DURING DATABASE STARTUP
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).
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).
ORA-24323 ORA-03113 ORA-01034 ORA-27101 errors
Hello, I get strange errors from my DB server. Here are the outputs; $ sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Thu Oct 5 14:24:07 2000 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: internal Connected to an idle instance. SQL startup force ORA-24323: value not allowed ORA-03113: end-of-file on communication channel When I try to log on as any user I get these messages; SQL connect anyuser Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory I am still connected to the server as a user but when I do ps -ef | grep ora_ , I get nothing. Can someone please tell me what path I shall take? Regards Okan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Okan CIMEN 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-24323 ORA-03113 ORA-01034 ORA-27101 errors
Your LISTENER is up but it's not pointing at a working instance/database. I'm not sure what you're doing to resolve SQLNet or Net 8 but I would look in listener.ora and see what the SID value is. Okan CIMEN okanTo: Multiple recipients of list ORACLE-L @cimen.org [EMAIL PROTECTED] Sent by: rootcc: Subject: ORA-24323 ORA-03113 ORA-01034 ORA-27101 errors 10/05/2001 08:35 AM Please respond to ORACLE-L Hello, I get strange errors from my DB server. Here are the outputs; $ sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Thu Oct 5 14:24:07 2000 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: internal Connected to an idle instance. SQL startup force ORA-24323: value not allowed ORA-03113: end-of-file on communication channel When I try to log on as any user I get these messages; SQL connect anyuser Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory I am still connected to the server as a user but when I do ps -ef | grep ora_ , I get nothing. Can someone please tell me what path I shall take? Regards Okan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Okan CIMEN 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-24323 ORA-03113 ORA-01034 ORA-27101 errors
ORA-24323: value not allowed For this Chk ur init.ora file. there may be some values that are not supported by the version of Oracle u r using. U r connected as internal user. Rectify the first error, then all the errors will go away. HTH Regards Venkat -- On Fri, 05 Oct 2001 04:35:19 Okan CIMEN wrote: Hello, I get strange errors from my DB server. Here are the outputs; $ sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Thu Oct 5 14:24:07 2000 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: internal Connected to an idle instance. SQL startup force ORA-24323: value not allowed ORA-03113: end-of-file on communication channel When I try to log on as any user I get these messages; SQL connect anyuser Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory I am still connected to the server as a user but when I do ps -ef | grep ora_ , I get nothing. Can someone please tell me what path I shall take? Regards Okan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Okan CIMEN 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). Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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
ORA-03113 when executing the initjvm script
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
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).
Urgent: ORA-03113
Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, ORA-03113 EOF on communication channel appears (progress bar shows between 65% and 75%). What might be possible reason? Software installation went without problems. Please help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sadzakovic Slavica 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: Urgent: ORA-03113
You missed some of the parameter or environmental settings. --- Sadzakovic Slavica [EMAIL PROTECTED] wrote: Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, ORA-03113 EOF on communication channel appears (progress bar shows between 65% and 75%). What might be possible reason? Software installation went without problems. Please help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sadzakovic Slavica 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). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03113 end of file comm. error - Why???
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).
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).
RE: URGENT ORA-03113
Mohammad, Also in Hp-Ux 11 32 bits you have that limit. However you can try with memory windows. Regards. --- Mohammad Rafiq [EMAIL PROTECTED] wrote: In some unix flavour(HP-10.20) 32 bit, it should not exceed 1.75GB ...This is as per Oracle Support..I think there was a mail few days back about this problem... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 12 Jul 2001 05:05:27 -0800 Helen: Try reducing your SHMMAX kernel parameter to under 4GB and see if that works. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio --- Original Message --- From: Helen rwulfjeq [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/12/01 6:45:22 AM Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV/pfile/initDEV.ora I checked previous messages. Someone suggested to reduce the size of kernel SHMM (I don't remember). I just follow the recommanded parameters to modify /etc/system. I have no idea how large I should set the sizes of the parameters. How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS URGENT. I really appreciate your help. I have to get it done ASAP. It is 4:45am (US CT). I was almost sleepless. Thank you so much. H.L. - Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.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).
URGENT ORA-03113
Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora" I checked previous messages. Someone suggested to reduce the size of kernel SHMM (I don't remember). I just follow the recommanded parameters to modify /etc/system. I have no idea how large I should set the sizes of the parameters. How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS URGENT. I really appreciate your help. I have to get it done ASAP. It is 4:45am (US CT). I was almost sleepless. Thank you so much. H.L.Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/
Re: URGENT ORA-03113
Why don't you try with relinking all?. Like this: $ORACLE_HOME/bin/relink all And then issue the startup with the svrmgrl. Also check the permission of the background, trace and core dumps directories or file systems. Regards. --- Helen rwulfjeq [EMAIL PROTECTED] wrote: Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV/pfile/initDEV.ora I checked previous messages. Someone suggested to reduce the size of kernel SHMM (I don't remember). I just follow the recommanded parameters to modify /etc/system. I have no idea how large I should set the sizes of the parameters. How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS URGENT. I really appreciate your help. I have to get it done ASAP. It is 4:45am (US CT). I was almost sleepless. Thank you so much. H.L. - Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.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: URGENT ORA-03113
Helen: Try reducing your SHMMAX kernel parameter to under 4GB and see if that works. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio --- Original Message --- From: Helen rwulfjeq [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/12/01 6:45:22 AM Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV/pfile/initDEV.ora I checked previous messages. Someone suggested to reduce the size of kernel SHMM (I don't remember). I just follow the recommanded parameters to modify /etc/system. I have no idea how large I should set the sizes of the parameters. How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS URGENT. I really appreciate your help. I have to get it done ASAP. It is 4:45am (US CT). I was almost sleepless. Thank you so much. H.L. - Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour 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: URGENT ORA-03113
Hi Ray: Thanks. How can I get information about Doc ID: 17613.1 . Also there are banches of semaphore related parameters. Any guidance to do that? Ray Stell [EMAIL PROTECTED] wrote: On Thu, Jul 12, 2001 at 02:45:22AM -0800, Helen rwulfjeq wrote: Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora" I checked previous messages. Someone suggested to reduce the size of kernel SHMM (I don't remember). I just follow the recommanded parameters to modify /etc/system. I have no idea how large I should set the sizes of the parameters. How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS URGENT. I really appreciate your help. I have to get it done ASAP. It is 4:45am (US CT). I was almost sleepless. Thank you so much. H.L.-- Doc ID: 17613.1 seems to have a tria! ! ge for the situation.another comment from metalink:Both times I've had the problem it was semaphore related (i.e. not enough).===Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ray StellINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Y! ! ahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/
RE: URGENT ORA-03113
I tried this but didn't work. Thank you so much. H.L. Jon Walthour [EMAIL PROTECTED] wrote: Helen:Try reducing your SHMMAX kernel parameter to under 4GB and seeif that works.--Jon Walthour, OCDBAOracle DBAComputer HorizonsCincinnati, Ohio--- Original Message ---From: Helen rwulfjeq <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: 7/12/01 6:45:22 AM Hi ALL:Anybody has any luck to install oracle 8.1.7 on Solaris 8. Iinstalled 8.1.5 on same OS without any problem. When I run dbassist, I got ORA-03113 error message. Actually It happened when youexecute the command:startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora"I checked previous messages. Someone suggested to reduce thesize of kernel SHMM (I don't remember). I just follow the recommandedparameters to modify /etc/system. I have no i! ! dea how large Ishould set the sizes of the parameters.How can I check the bits of OS or ORACLE like (64 bits or 32bits). IT IS URGENT. I really appreciate your help. I have toget it done ASAP. It is 4:45am (US CT). I was almost sleepless.Thank you so much.H.L.-Do You Yahoo!?Get personalized email addresses from Yahoo! Mail - only $35a year!http://personal.mail.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jon WalthourINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [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 mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/
RE: URGENT ORA-03113
metalink.oracle.com -Original Message- Sent: Thursday, July 12, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Hi Ray: Thanks. How can I get information about Doc ID: 17613.1 . Also there are banches of semaphore related parameters. Any guidance to do that? Ray Stell [EMAIL PROTECTED] wrote: On Thu, Jul 12, 2001 at 02:45:22AM -0800, Helen rwulfjeq wrote: Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV/pfile/initDEV.ora I checked previous messages. Someone suggested to reduce the size of kernel SHMM (I don't remember). I just follow the recommanded parameters to modify /etc/system. I have no idea how large I should set the sizes of the parameters. How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS URGENT. I really appreciate your help. I have to get it done ASAP. It is 4:45am (US CT). I was almost sleepless. Thank you so much. H.L. -- Doc ID: 17613.1 seems to have a tria! ! ge for the situation. another comment from metalink: Both times I've had the problem it was semaphore related (i.e. not enough). === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^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). _ Do You Y! ! ahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ http://personal.mail.yahoo.com/?.refer=tagline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: URGENT ORA-03113
Hi ALL Thank you for all of your responses. I made it working now. What I did is to change couple of semaphone parameters by modifying /etc/system file. Thank you again. I will take a rest now. L.H. Helen rwulfjeq [EMAIL PROTECTED] wrote: I tried this but didn't work. Thank you so much. H.L. Jon Walthour [EMAIL PROTECTED] wrote: Helen:Try reducing your SHMMAX kernel parameter to under 4GB and seeif that works.--Jon Walthour, OCDBAOracle DBAComputer HorizonsCincinnati, Ohio--- Original Message ---From: Helen rwulfjeq <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: 7/12/01 6:45:22 AM Hi ALL:Anybody has any luck to install oracle 8.1.7 on Solaris 8. Iinstalled 8.1.5 on same OS without any problem. When I run dbassist, I got ORA-03113 error message. Actually It happened when youexecute the command:startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora"I checked previous messages. Someone suggested to reduce thesize of kernel SHMM (I don't remember). I just follow the recommandedparameters to modify /etc/system. I have no i! ! ! ! dea how large Ishould set the sizes of the parameters.How can I check the bits of OS or ORACLE like (64 bits or 32bits). IT IS URGENT. I really appreciate your help. I have toget it done ASAP. It is 4:45am (US CT). I was almost sleepless.Thank you so much.H.L.-Do You Yahoo!?Get personalized email addresses from Yahoo! Mail - only $35a year!http://personal.mail.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jon WalthourINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [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 mayalso send the HELP command for other information (like subscribing). Do You Yahoo!?Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/
RE: URGENT ORA-03113
In some unix flavour(HP-10.20) 32 bit, it should not exceed 1.75GB ...This is as per Oracle Support..I think there was a mail few days back about this problem... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 12 Jul 2001 05:05:27 -0800 Helen: Try reducing your SHMMAX kernel parameter to under 4GB and see if that works. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio --- Original Message --- From: Helen rwulfjeq [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/12/01 6:45:22 AM Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV/pfile/initDEV.ora I checked previous messages. Someone suggested to reduce the size of kernel SHMM (I don't remember). I just follow the recommanded parameters to modify /etc/system. I have no idea how large I should set the sizes of the parameters. How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS URGENT. I really appreciate your help. I have to get it done ASAP. It is 4:45am (US CT). I was almost sleepless. Thank you so much. H.L. - Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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).