RE: ora-600 / ora-00604 during migrate
Problem solved thanks to ots Event 1399 solved it, necessary during migrate Regards, Jeroen -Oorspronkelijk bericht- Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Verzonden: Thursday, November 20, 2003 21:46 Aan: 'Jeroen van Sluisdam' Onderwerp: RE: ora-600 / ora-00604 during migrate Jeroen - I think at least for the U.S. that the form says something like critical business impact. I have had a test database treated as a priority 1. At this point you could try calling on the phone and asking to change the priority. Or you could file another TAR and ensure it gets rated a priority 1. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 20, 2003 2:42 PM To: DENNIS WILLIAMS; '[EMAIL PROTECTED]' -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: donderdag 20 november 2003 21:41 Aan: 'DENNIS WILLIAMS'; '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Dennnis, Priority 2. I have tried export but after 3 days of experimenting And not getting results I switched to this scenario How could I persuade them to go to priority 1 if this isn't A production situation? Tnx, Jeroen -Oorspronkelijk bericht- Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Verzonden: donderdag 20 november 2003 21:24 Aan: '[EMAIL PROTECTED]' CC: '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Jeroen - What priority did Oracle assign the TAR? Given the seriousness of your situation, you should get it rated a priority 1. Is there any possibility you can export/import your data instead of performing a migration? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 20, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hi, I'm experiencing an ora-600 during migration of a 7.3.4 to 9.2.0.4 Error occurs during issueing alter database open resetlogs migrate All previous steps (all according to the migrate manual): Migprep Mig Alter database convert Succeeded successfully Details: HP-UX 11.11 Source-DB 7.3.4.5 (HP11 version) Target 9.2.0.4 Error in alert-file: Errors in file /var/opt/oracle/product/admin/VU_2/bdump/vu_2_smon_8589.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET job_queue_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_9760.trc: ORA-00600: internal error code, arguments: [16608], [2], [0], [0xC000234BAB80], [], [], [], [] I could find one similar notice on metalink but it didn't describe what they did to resolve this. I entered a tar, but probably too late for today. I need help urgently because this is causing Major problems in our timeschedule for testing and going live as planned in 2 weeks. Hope you can help soon, Regards, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam 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-600 / ora-00604 during migrate
Jeroen - What priority did Oracle assign the TAR? Given the seriousness of your situation, you should get it rated a priority 1. Is there any possibility you can export/import your data instead of performing a migration? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 20, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hi, I'm experiencing an ora-600 during migration of a 7.3.4 to 9.2.0.4 Error occurs during issueing alter database open resetlogs migrate All previous steps (all according to the migrate manual): Migprep Mig Alter database convert Succeeded successfully Details: HP-UX 11.11 Source-DB 7.3.4.5 (HP11 version) Target 9.2.0.4 Error in alert-file: Errors in file /var/opt/oracle/product/admin/VU_2/bdump/vu_2_smon_8589.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET job_queue_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_9760.trc: ORA-00600: internal error code, arguments: [16608], [2], [0], [0xC000234BAB80], [], [], [], [] I could find one similar notice on metalink but it didn't describe what they did to resolve this. I entered a tar, but probably too late for today. I need help urgently because this is causing Major problems in our timeschedule for testing and going live as planned in 2 weeks. Hope you can help soon, Regards, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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-600 / ora-00604 during migrate
-Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: donderdag 20 november 2003 21:41 Aan: 'DENNIS WILLIAMS'; '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Dennnis, Priority 2. I have tried export but after 3 days of experimenting And not getting results I switched to this scenario How could I persuade them to go to priority 1 if this isn't A production situation? Tnx, Jeroen -Oorspronkelijk bericht- Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Verzonden: donderdag 20 november 2003 21:24 Aan: '[EMAIL PROTECTED]' CC: '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Jeroen - What priority did Oracle assign the TAR? Given the seriousness of your situation, you should get it rated a priority 1. Is there any possibility you can export/import your data instead of performing a migration? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 20, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hi, I'm experiencing an ora-600 during migration of a 7.3.4 to 9.2.0.4 Error occurs during issueing alter database open resetlogs migrate All previous steps (all according to the migrate manual): Migprep Mig Alter database convert Succeeded successfully Details: HP-UX 11.11 Source-DB 7.3.4.5 (HP11 version) Target 9.2.0.4 Error in alert-file: Errors in file /var/opt/oracle/product/admin/VU_2/bdump/vu_2_smon_8589.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET job_queue_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_9760.trc: ORA-00600: internal error code, arguments: [16608], [2], [0], [0xC000234BAB80], [], [], [], [] I could find one similar notice on metalink but it didn't describe what they did to resolve this. I entered a tar, but probably too late for today. I need help urgently because this is causing Major problems in our timeschedule for testing and going live as planned in 2 weeks. Hope you can help soon, Regards, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam 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-600 / ora-00604 during migrate
What was wrong with export? How big the database is? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jeroen van Sluisdam Sent: Thursday, November 20, 2003 3:45 PM To: Multiple recipients of list ORACLE-L -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: donderdag 20 november 2003 21:41 Aan: 'DENNIS WILLIAMS'; '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Dennnis, Priority 2. I have tried export but after 3 days of experimenting And not getting results I switched to this scenario How could I persuade them to go to priority 1 if this isn't A production situation? Tnx, Jeroen -Oorspronkelijk bericht- Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Verzonden: donderdag 20 november 2003 21:24 Aan: '[EMAIL PROTECTED]' CC: '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Jeroen - What priority did Oracle assign the TAR? Given the seriousness of your situation, you should get it rated a priority 1. Is there any possibility you can export/import your data instead of performing a migration? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 20, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hi, I'm experiencing an ora-600 during migration of a 7.3.4 to 9.2.0.4 Error occurs during issueing alter database open resetlogs migrate All previous steps (all according to the migrate manual): Migprep Mig Alter database convert Succeeded successfully Details: HP-UX 11.11 Source-DB 7.3.4.5 (HP11 version) Target 9.2.0.4 Error in alert-file: Errors in file /var/opt/oracle/product/admin/VU_2/bdump/vu_2_smon_8589.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET job_queue_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_9760.trc: ORA-00600: internal error code, arguments: [16608], [2], [0], [0xC000234BAB80], [], [], [], [] I could find one similar notice on metalink but it didn't describe what they did to resolve this. I entered a tar, but probably too late for today. I need help urgently because this is causing Major problems in our timeschedule for testing and going live as planned in 2 weeks. Hope you can help soon, Regards, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam 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: Igor Neyman 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-600 question
TOAD puts a hint in. [EMAIL PROTECTED] 10/28/2003 1:29:25 PM does toad or the oracle instance itself slip in rule hints? We got an ora-600 error off of a data dictionary read. i think it has to do with explain plan. ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [], []Current SQL statement for this session:select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2-- 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.comSan Diego, California -- Mailing list and web hosting services-To 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).
RE: ora-600 question
What version of TOAD, Oracle server and Oracle client? See Metalink article 34779.1 for details on your bug, which may be fixed in releases 8.1.7.3, 9.0.1.2 and 9.2.0.1. BTW, TOAD can put in hints, but more importantly, it can do some conversion/translation of your SQL before sending it. You may want to checkout the official TOAD list at http://groups.yahoo.com/group/toad Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 question does toad or the oracle instance itself slip in rule hints? We got an ora-600 error off of a data dictionary read. i think it has to do with explain plan. ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [], [] Current SQL statement for this session: select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hiva l, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Re: ora-600 question
The data dictionary should not have any statistics on them and thus will use rule as a rule so to speak. If you have run stats on the data dictionary you coul dbe running into some odd bugs. -Original Message- Sent: Tuesday, October 28, 2003 2:49 PM To: Multiple recipients of list ORACLE-L does the data dictionary still use rule by support? any idea why toad would bother slipping it in? From: John Shaw [EMAIL PROTECTED] Date: 2003/10/28 Tue PM 02:59:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ora-600 question TOAD puts a hint in. [EMAIL PROTECTED] 10/28/2003 1:29:25 PM does toad or the oracle instance itself slip in rule hints? We got an ora-600 error off of a data dictionary read. i think it has to do with explain plan. ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [], [] Current SQL statement for this session: select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hiva l, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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: Re: ora-600 question
By default it's set to 'choose' - but if try to use it for looking at locks (or most any ddl) it will take forever to come back -you have to go to the options menu and pick 'rule' for optimzer modeon ddl queries. [EMAIL PROTECTED] 10/28/2003 2:49:29 PM does the data dictionary still use rule by support? any idea why toad would bother slipping it in? From: "John Shaw" [EMAIL PROTECTED] Date: 2003/10/28 Tue PM 02:59:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ora-600 question TOAD puts a hint in.[EMAIL PROTECTED] 10/28/2003 1:29:25 PM does toad or the oracle instance itself slip in rule hints? We got an ora-600 error off of a data dictionary read. i think it has to do with explain plan. ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [], [] Current SQL statement for this session: select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hiva l, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 -- 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: Re: ora-600 question
does the data dictionary still use rule by support? any idea why toad would bother slipping it in? From: John Shaw [EMAIL PROTECTED] Date: 2003/10/28 Tue PM 02:59:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ora-600 question TOAD puts a hint in. [EMAIL PROTECTED] 10/28/2003 1:29:25 PM does toad or the oracle instance itself slip in rule hints? We got an ora-600 error off of a data dictionary read. i think it has to do with explain plan. ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [], [] Current SQL statement for this session: select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hiva l, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 -- 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). TOAD puts a hint in. [EMAIL PROTECTED] 10/28/2003 1:29:25 PM does toad or the oracle instance itself slip in rule hints? We got an ora-600 error off of a data dictionary read. i think it has to do with explain plan. ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [], []Current SQL statement for this session:select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2-- 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.comSan Diego, California -- Mailing list and web hosting services-To 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).
Re: Re: ora-600 question
Hi! Just for the record, in 9.2 some views such dba_extents use ordered and use_nl hints, which force usage of CBO. If you don't have statistics calculated nor optimizer_dynamic_sampling set to at least 2, then you'll be using CBO with default statistics, which usually are quite misleading. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 11:09 PM The data dictionary should not have any statistics on them and thus will use rule as a rule so to speak. If you have run stats on the data dictionary you coul dbe running into some odd bugs. -Original Message- Sent: Tuesday, October 28, 2003 2:49 PM To: Multiple recipients of list ORACLE-L does the data dictionary still use rule by support? any idea why toad would bother slipping it in? From: John Shaw [EMAIL PROTECTED] Date: 2003/10/28 Tue PM 02:59:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ora-600 question TOAD puts a hint in. [EMAIL PROTECTED] 10/28/2003 1:29:25 PM does toad or the oracle instance itself slip in rule hints? We got an ora-600 error off of a data dictionary read. i think it has to do with explain plan. ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [], [] Current SQL statement for this session: select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hiva l, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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: Re: ora-600 question
If there're already hints like ordered and use_nl that tell Oracle how to join, lack of statistics is less of a problem. In fact, you may need to use those two hints in some queries against data dictionary even in pre-9i Oracle. Yong Huang --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! Just for the record, in 9.2 some views such dba_extents use ordered and use_nl hints, which force usage of CBO. If you don't have statistics calculated nor optimizer_dynamic_sampling set to at least 2, then you'll be using CBO with default statistics, which usually are quite misleading. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 11:09 PM The data dictionary should not have any statistics on them and thus will use rule as a rule so to speak. If you have run stats on the data dictionary you coul dbe running into some odd bugs. __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: Re: ora-600 question
Depending on the query, in dba_extents example there are hints only in one part of multi-part union all SQL, but nevertheless, good point :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 1:04 AM If there're already hints like ordered and use_nl that tell Oracle how to join, lack of statistics is less of a problem. In fact, you may need to use those two hints in some queries against data dictionary even in pre-9i Oracle. Yong Huang --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! Just for the record, in 9.2 some views such dba_extents use ordered and use_nl hints, which force usage of CBO. If you don't have statistics calculated nor optimizer_dynamic_sampling set to at least 2, then you'll be using CBO with default statistics, which usually are quite misleading. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 11:09 PM The data dictionary should not have any statistics on them and thus will use rule as a rule so to speak. If you have run stats on the data dictionary you coul dbe running into some odd bugs. __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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-600 Error [Possible Data Loss]
We have found the cause of the problem. If populate the varray for a row with 100
values, copy that data to a temporary table and then perform split and exchange
partition operations everything is fine. However if we populate the varray with 1000
values for a row and then perform the same operations. Selecting from the partition
results in the error.
For those wanting details ...
create or replace type int_values as varray(16384) of number(38);
create table arch_wave_i
(pv_id number(38),
timestamp date,
nanosecs number(9),
stat number(8),
sevr number(8),
ostat number(16),
value int_values)
partition by range (timestamp)
( partition first values less than
(TO_DATE('01/01/2003 00:00:00', 'mm/dd/ hh24:mi:ss')),
partition bin values less than (MAXVALUE) );
create index archive_wave_index on archive_wave_i (timestamp, pv_id) local;
create table arch_wave_i
(pv_id number(38),
timestamp date,
nanosecs number(9),
stat number(8),
sevr number(8),
ostat number(16),
value int_values)
partition by range (timestamp)
( partition first values less than
(TO_DATE('01/01/2003 00:00:00', 'mm/dd/ hh24:mi:ss')),
partition SEP1803 values less than
(TO_DATE('09/19/2003 00:00:00', 'mm/dd/ hh24:mi:ss')),
partition bin values less than (MAXVALUE) );
create index arch_wave_i_index on arch_wave_i (timestamp, pv_id) local;
To create the error
To recreate the problem:
1. Populate arch_wave_i with one or more rows that have the
following characteristics:
a. the timestamp field is = '09/18/2003 00:00:00' and
'09/19/2003 00:00:00'
b. the value field is an array of 1000 or more integer
values (the actual values do not matter)
c. the other fields (pv_id, nanosecs, stat, sevr, ostat)
may be set to 0
2. create table temp_wave_i as select * from arch_wave_i;
3. create index temp_wave_i_index on temp_wave_i (timestamp, pv_id);
4. alter session set nls_date_format = 'mm/dd/ hh24:mi:ss';
5. alter table archive_wave_i split partition bin at
('09/19/2003 00:00:00') into
(partition SEP1803, partition bin);
6. alter table archive_wave_i exchange partition SEP1803 with
table temp_wave_i including indexes with validation;
7. select * from archive_wave_i partition (SEP1803);
This results in one of the following messages:
a. ORA-00600: internal error code, arguments:
[koxsisz1], [1], [], [], [], [], [], []
b. ORA-00600: internal error code, arguments:
[kcbgtcr_4], [2094072], [0], [1], [], [], [], []
Sometimes the second argument is 2094096 or 2094120
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, September 18, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
Ian,
I was going to recommend to try exporting your problematic partition with direct=y,
that way normal SQL query processing layer is bypassed in Oracle kernel all data
belonging to segment is read directly (thus hopefully avoiding the koxsisz1 crash) ...
but I'm not sure whether varrays don't turn exp to conventional as is the case with
objects and LOBs...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 8:29 PM
The error was first discovered when we tried to move a partition. (
alter
table archive_wave_i move partition SEP1103 tablespace
CHANARCH_NLC_2003_09_DATA). The table was renamed to OLD_archive_wave_i
once it was determined that no new varray data was accessible. My theory is that this
is logical corruption of the data dictionary, but I have not worked out the
particulars.
Selecting via an index or FTS does not matter. What type of error do
you
believe koxsisz1 to be?
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, September 18, 2003 4:13 AM
To: Multiple recipients of list ORACLE-L
Hi!
If even Oracle hasn't seen this error, then probably we can't help
much
here either. Just a wild guess, try to move this partition to another location and
select from it then (although koxsisz1 isn't a data layer error as far as I
understand). Try to read using index if available, then using full hint etc..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 3:04 AM
This is not my week ...
Has anyone seen anything like this
select value from chanarch_nlc.old_archive_wave_i partition
(SEP1603)
where pv_id =
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [],
[],
[], [],
[]
I have Oracle support working on the problem.They say they have
never
seen such an error before. Oracle though often tells me that. The
table
looks like
Name Null?Type
-
---
-
PV_ID NUMBER(38)
TIMESTAMP
Re: ORA-600 Error [Possible Data Loss]
Hi! If even Oracle hasn't seen this error, then probably we can't help much here either. Just a wild guess, try to move this partition to another location and select from it then (although koxsisz1 isn't a data layer error as far as I understand). Try to read using index if available, then using full hint etc.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:04 AM This is not my week ... Has anyone seen anything like this select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id = * ERROR at line 1: ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [], [] I have Oracle support working on the problem.They say they have never seen such an error before. Oracle though often tells me that. The table looks like Name Null?Type - --- - PV_ID NUMBER(38) TIMESTAMP DATE NANOSECS NUMBER(9) STAT NUMBER(8) SEVR NUMBER(8) OSTAT NUMBER(16) VALUE CHANARCH_NLC.INT_VALUES The last column is a varray. I can retrieve any of the other columns from that partition. I can also retrieve the value column from any partition before September 11, 2003. Any partition after that fails with the 0ra-600 error when the value column is selected. DBV at first gave errors along the lines of BV-00102: File I/O error on FILE (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op eration (-1) The file is 2018 MB in size. But resizing the files downwards and back up again fixed That problem. The files are allowed to autoextend with 2018 being the maximum size. This is not the same database which had the RAID problem. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. 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-600 Error [Possible Data Loss]
The error was first discovered when we tried to move a partition. ( alter table archive_wave_i move partition SEP1103 tablespace CHANARCH_NLC_2003_09_DATA). The table was renamed to OLD_archive_wave_i once it was determined that no new varray data was accessible. My theory is that this is logical corruption of the data dictionary, but I have not worked out the particulars. Selecting via an index or FTS does not matter. What type of error do you believe koxsisz1 to be? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 4:13 AM To: Multiple recipients of list ORACLE-L Hi! If even Oracle hasn't seen this error, then probably we can't help much here either. Just a wild guess, try to move this partition to another location and select from it then (although koxsisz1 isn't a data layer error as far as I understand). Try to read using index if available, then using full hint etc.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:04 AM This is not my week ... Has anyone seen anything like this select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id = * ERROR at line 1: ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [], [] I have Oracle support working on the problem.They say they have never seen such an error before. Oracle though often tells me that. The table looks like Name Null?Type - --- - PV_ID NUMBER(38) TIMESTAMP DATE NANOSECS NUMBER(9) STAT NUMBER(8) SEVR NUMBER(8) OSTAT NUMBER(16) VALUE CHANARCH_NLC.INT_VALUES The last column is a varray. I can retrieve any of the other columns from that partition. I can also retrieve the value column from any partition before September 11, 2003. Any partition after that fails with the 0ra-600 error when the value column is selected. DBV at first gave errors along the lines of BV-00102: File I/O error on FILE (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op eration (-1) The file is 2018 MB in size. But resizing the files downwards and back up again fixed That problem. The files are allowed to autoextend with 2018 being the maximum size. This is not the same database which had the RAID problem. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. 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-600 Error [Possible Data Loss]
Hi! I'm on thin ice here, but I think KO means some sort of object layer (KOC is Kernel-Object-Cache module as far as I understand), so koxsisz1 has probably something to do with objects as well (thus not caching, x might mean execute or transaction or anything else:). On the other hand, varrays are somewhat related to objects as well, at least in sense that they are data structures, not basic datatypes. (This one probably won't work, but try to temporarily increase OBJECT_CACHE_MAX_SIZE_PERCENT and OBJECT_CACHE_OPTIMAL_SIZE in your session (put first one to 1000 and second one to 1048576 for example). Maybe there are some specific problems with caching your varray in client side, but as I said I doubt it will help (but it's easy to try out).) Otherwise, try to isolate those varrays causing you problem. Are all varrays in SEP1603 partition unusable? Only some of them? Only new ones? Are any other partitions affected? One more way would be to take one working record and insert it to new partition. If now the new record gets unusable again, it's possible to take relevant blockdumps for both these records, to see whether theres any difference in low-level data. For summary, since you had some file IO errors (as shown by DBV), you might have corrupted your data during the move operation. Maybe some disk controller or memory caused this error... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 8:29 PM The error was first discovered when we tried to move a partition. ( alter table archive_wave_i move partition SEP1103 tablespace CHANARCH_NLC_2003_09_DATA). The table was renamed to OLD_archive_wave_i once it was determined that no new varray data was accessible. My theory is that this is logical corruption of the data dictionary, but I have not worked out the particulars. Selecting via an index or FTS does not matter. What type of error do you believe koxsisz1 to be? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 4:13 AM To: Multiple recipients of list ORACLE-L Hi! If even Oracle hasn't seen this error, then probably we can't help much here either. Just a wild guess, try to move this partition to another location and select from it then (although koxsisz1 isn't a data layer error as far as I understand). Try to read using index if available, then using full hint etc.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:04 AM This is not my week ... Has anyone seen anything like this select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id = * ERROR at line 1: ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [], [] I have Oracle support working on the problem.They say they have never seen such an error before. Oracle though often tells me that. The table looks like Name Null?Type - --- - PV_ID NUMBER(38) TIMESTAMP DATE NANOSECS NUMBER(9) STAT NUMBER(8) SEVR NUMBER(8) OSTAT NUMBER(16) VALUE CHANARCH_NLC.INT_VALUES The last column is a varray. I can retrieve any of the other columns from that partition. I can also retrieve the value column from any partition before September 11, 2003. Any partition after that fails with the 0ra-600 error when the value column is selected. DBV at first gave errors along the lines of BV-00102: File I/O error on FILE (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op eration (-1) The file is 2018 MB in size. But resizing the files downwards and back up again fixed That problem. The files are allowed to autoextend with 2018 being the maximum size. This is not the same database which had the RAID problem. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. 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
Re: ORA-600 Error [Possible Data Loss]
Ian, I was going to recommend to try exporting your problematic partition with direct=y, that way normal SQL query processing layer is bypassed in Oracle kernel all data belonging to segment is read directly (thus hopefully avoiding the koxsisz1 crash) ... but I'm not sure whether varrays don't turn exp to conventional as is the case with objects and LOBs... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 8:29 PM The error was first discovered when we tried to move a partition. ( alter table archive_wave_i move partition SEP1103 tablespace CHANARCH_NLC_2003_09_DATA). The table was renamed to OLD_archive_wave_i once it was determined that no new varray data was accessible. My theory is that this is logical corruption of the data dictionary, but I have not worked out the particulars. Selecting via an index or FTS does not matter. What type of error do you believe koxsisz1 to be? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 4:13 AM To: Multiple recipients of list ORACLE-L Hi! If even Oracle hasn't seen this error, then probably we can't help much here either. Just a wild guess, try to move this partition to another location and select from it then (although koxsisz1 isn't a data layer error as far as I understand). Try to read using index if available, then using full hint etc.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:04 AM This is not my week ... Has anyone seen anything like this select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id = * ERROR at line 1: ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [], [] I have Oracle support working on the problem.They say they have never seen such an error before. Oracle though often tells me that. The table looks like Name Null?Type - --- - PV_ID NUMBER(38) TIMESTAMP DATE NANOSECS NUMBER(9) STAT NUMBER(8) SEVR NUMBER(8) OSTAT NUMBER(16) VALUE CHANARCH_NLC.INT_VALUES The last column is a varray. I can retrieve any of the other columns from that partition. I can also retrieve the value column from any partition before September 11, 2003. Any partition after that fails with the 0ra-600 error when the value column is selected. DBV at first gave errors along the lines of BV-00102: File I/O error on FILE (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op eration (-1) The file is 2018 MB in size. But resizing the files downwards and back up again fixed That problem. The files are allowed to autoextend with 2018 being the maximum size. This is not the same database which had the RAID problem. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: ORA-600 Error [Possible Data Loss]
The varray data is stored in a LOB. So I expect direct export will not work. But I'll give it a try. Ian -Original Message- Sent: Thursday, September 18, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Ian, I was going to recommend to try exporting your problematic partition with direct=y, that way normal SQL query processing layer is bypassed in Oracle kernel all data belonging to segment is read directly (thus hopefully avoiding the koxsisz1 crash) ... but I'm not sure whether varrays don't turn exp to conventional as is the case with objects and LOBs... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 8:29 PM The error was first discovered when we tried to move a partition. ( alter table archive_wave_i move partition SEP1103 tablespace CHANARCH_NLC_2003_09_DATA). The table was renamed to OLD_archive_wave_i once it was determined that no new varray data was accessible. My theory is that this is logical corruption of the data dictionary, but I have not worked out the particulars. Selecting via an index or FTS does not matter. What type of error do you believe koxsisz1 to be? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 4:13 AM To: Multiple recipients of list ORACLE-L Hi! If even Oracle hasn't seen this error, then probably we can't help much here either. Just a wild guess, try to move this partition to another location and select from it then (although koxsisz1 isn't a data layer error as far as I understand). Try to read using index if available, then using full hint etc.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:04 AM This is not my week ... Has anyone seen anything like this select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id = * ERROR at line 1: ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [], [] I have Oracle support working on the problem.They say they have never seen such an error before. Oracle though often tells me that. The table looks like Name Null?Type - --- - PV_ID NUMBER(38) TIMESTAMP DATE NANOSECS NUMBER(9) STAT NUMBER(8) SEVR NUMBER(8) OSTAT NUMBER(16) VALUE CHANARCH_NLC.INT_VALUES The last column is a varray. I can retrieve any of the other columns from that partition. I can also retrieve the value column from any partition before September 11, 2003. Any partition after that fails with the 0ra-600 error when the value column is selected. DBV at first gave errors along the lines of BV-00102: File I/O error on FILE (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op eration (-1) The file is 2018 MB in size. But resizing the files downwards and back up again fixed That problem. The files are allowed to autoextend with 2018 being the maximum size. This is not the same database which had the RAID problem. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. 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
Re: ORA-600
Doc ID: Note:34782.1 Subject: ORA-600 [17114] KGH Bad magic number in header Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 29-FEB-1996 Last Revision Date: 29-OCT-2002 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [17114], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [17114][a][b][c][d][e] VERSIONS: versions 7.X to 8.X DESCRIPTION: Oracle has detected that the magic number in a memory chunk header has been overwritten. This is a heap (in memory) corruption and there is no underlying data corruption. The error may occur in the one of the process specific heaps (the Call heap, PGA heap, or session heap) or in the shared heap (SGA). FUNCTIONALITY: HEAP MANAGEMENT IMPACT: PROCESS FAILURE MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE NON DATA CORRUPTIVE - No underlying data corruption. SUGGESTIONS: If you think you are not hitting any of the known issues shown below, then you need to set event 10235 in your init.ora file :- event=10235 trace name context forever, level 1 While the event is set, the next time you get the error a trace file will be generated in your USER_DUMP_DEST directory. Contact Oracle Support Services and supply the trace file. Known Issues: Bug 898074: PRIVATE MEM CORR ON PARTITION TABLE NON-PARTITION-KEY PREDICATE fixed in 8.0.6.1 and 8.1.6.0 releases Bug 573746: -- DBMS_SQL DEFINE_ARRAY / ARRAY FETCH TO LARGE ARRAY MAY CAUSE ORA-600[17114] fixed in 8.0.4.4, 8.0.5.0 and 8.1.5.0 releases Bug 1280983: ORA-600 [17114]/ORA-600 [17112] USING STAR_TRANSFORMATION fixed in 8.1.7.0 Hemant At 08:14 AM 16-09-03 -0800, you wrote: This is on an old 7.3.4 database. I can't find the same error on Metalink. Anybody have any ideas what might be the cause? ORA-00600: internal error code, arguments: [17114], [1074346728], [], [], [], [], [], [] Ron Smith Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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-600
Title: Message http://tinyurl.com/njtq Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 16, 2003 12:15 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-600 This is on an old 7.3.4 database. I can't find the same error on Metalink. Anybody have any ideas what might be the cause? ORA-00600: internal error code, arguments: [17114], [1074346728], [], [], [], [], [], [] Ron Smith 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
RE: ora-600 when analyzing IOT
Does it mean, that if I don't have overflow segment in my IOT, I don't
have to analyze table, just analyze PK?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L
Igor,
When you gather statistics on an IOT with the ANALYZE command, it will
analyze the primary key and overflow segment so I would think
this is all that is required by CBO. Hopefully others have more
insight.
Rick
Igor Neyman
[EMAIL PROTECTED]To:
[EMAIL PROTECTED]
on.com cc:
[EMAIL PROTECTED]
Subject: RE: ora-600
when analyzing IOT
08/07/2003 12:13
PM
Rick,
Thanks for prompt reply.
I tried it (deleting statistics before analyzing table) and it worked.
Any ideas, whether cost-based optimizer need statistics on IOT or having
statistics on PK index of IOT would be enough?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
According to MetaLink you need to delete statistics and re-analyze
I do not know your database version but this is supposely fixed in 8.1.6
execute
dbms_stats.delete_table_stats('owner','IPN_MEASUREMENT');
analyze table ipn_measurement estimate statistics ;
HTH
Rick
Igor Neyman
[EMAIL PROTECTED]To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
on.com cc:
Sent by: Subject: ora-600 when
analyzing IOT
[EMAIL PROTECTED]
.com
08/07/2003 12:44
PM
Please respond to
ORACLE-L
Ok, since my original message still hasn't arrived (sent couple hours
ago), here it goes again (sorry, if you get duplicate).
First, sorry for asking this list before searching Metalink, but I don't
have access to it right now.
So, here it is:
I'm getting:
ORA-00600: internal error code, arguments: [15163], [333], [17424],
[16191], [], [], [], []
when analyzing one of the index-organized tables:
ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS.
Now, similar statement analyzing other IOTs works fine.
Also, on the same table (ipn_measurement) analyze worked fine yesterday,
and the table didn't grew too much since yesterday.
Any ideas?
Another question, do I really have to run analyze table on IOT for
cost-based optimizer, or analyzing index would be enough:
ANALYZE INDEX pk_ipn_measurement ESTIMATE STATISTICS
because analyze index still runs with no errors.
Oracle version is 8.1.5.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
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).
--
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).
--
Please see
RE: ora-600 when analyzing IOT
Rick,
Thanks for prompt reply.
I tried it (deleting statistics before analyzing table) and it worked.
Any ideas, whether cost-based optimizer need statistics on IOT or having
statistics on PK index of IOT would be enough?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
According to MetaLink you need to delete statistics and re-analyze
I do not know your database version but this is supposely fixed in 8.1.6
execute
dbms_stats.delete_table_stats('owner','IPN_MEASUREMENT');
analyze table ipn_measurement estimate statistics ;
HTH
Rick
Igor Neyman
[EMAIL PROTECTED]To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
on.com cc:
Sent by: Subject: ora-600 when
analyzing IOT
[EMAIL PROTECTED]
.com
08/07/2003 12:44
PM
Please respond to
ORACLE-L
Ok, since my original message still hasn't arrived (sent couple hours
ago), here it goes again (sorry, if you get duplicate).
First, sorry for asking this list before searching Metalink, but I don't
have access to it right now.
So, here it is:
I'm getting:
ORA-00600: internal error code, arguments: [15163], [333], [17424],
[16191], [], [], [], []
when analyzing one of the index-organized tables:
ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS.
Now, similar statement analyzing other IOTs works fine.
Also, on the same table (ipn_measurement) analyze worked fine yesterday,
and the table didn't grew too much since yesterday.
Any ideas?
Another question, do I really have to run analyze table on IOT for
cost-based optimizer, or analyzing index would be enough:
ANALYZE INDEX pk_ipn_measurement ESTIMATE STATISTICS
because analyze index still runs with no errors.
Oracle version is 8.1.5.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
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-600 when analyzing IOT
Igor,
When you gather statistics on an IOT with the ANALYZE command, it will
analyze the primary key and overflow segment so I would think
this is all that is required by CBO. Hopefully others have more insight.
Rick
Igor Neyman
[EMAIL PROTECTED]To: [EMAIL PROTECTED]
on.com cc: [EMAIL PROTECTED]
Subject: RE: ora-600 when analyzing
IOT
08/07/2003 12:13
PM
Rick,
Thanks for prompt reply.
I tried it (deleting statistics before analyzing table) and it worked.
Any ideas, whether cost-based optimizer need statistics on IOT or having
statistics on PK index of IOT would be enough?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
According to MetaLink you need to delete statistics and re-analyze
I do not know your database version but this is supposely fixed in 8.1.6
execute
dbms_stats.delete_table_stats('owner','IPN_MEASUREMENT');
analyze table ipn_measurement estimate statistics ;
HTH
Rick
Igor Neyman
[EMAIL PROTECTED]To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
on.com cc:
Sent by: Subject: ora-600 when
analyzing IOT
[EMAIL PROTECTED]
.com
08/07/2003 12:44
PM
Please respond to
ORACLE-L
Ok, since my original message still hasn't arrived (sent couple hours
ago), here it goes again (sorry, if you get duplicate).
First, sorry for asking this list before searching Metalink, but I don't
have access to it right now.
So, here it is:
I'm getting:
ORA-00600: internal error code, arguments: [15163], [333], [17424],
[16191], [], [], [], []
when analyzing one of the index-organized tables:
ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS.
Now, similar statement analyzing other IOTs works fine.
Also, on the same table (ipn_measurement) analyze worked fine yesterday,
and the table didn't grew too much since yesterday.
Any ideas?
Another question, do I really have to run analyze table on IOT for
cost-based optimizer, or analyzing index would be enough:
ANALYZE INDEX pk_ipn_measurement ESTIMATE STATISTICS
because analyze index still runs with no errors.
Oracle version is 8.1.5.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Re: ora-600 when analyzing IOT
According to MetaLink you need to delete statistics and re-analyze
I do not know your database version but this is supposely fixed in 8.1.6
execute
dbms_stats.delete_table_stats('owner','IPN_MEASUREMENT');
analyze table ipn_measurement estimate statistics ;
HTH
Rick
Igor Neyman
[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
on.com cc:
Sent by: Subject: ora-600 when analyzing IOT
[EMAIL PROTECTED]
.com
08/07/2003 12:44
PM
Please respond to
ORACLE-L
Ok, since my original message still hasn't arrived (sent couple hours
ago), here it goes again (sorry, if you get duplicate).
First, sorry for asking this list before searching Metalink, but I don't
have access to it right now.
So, here it is:
I'm getting:
ORA-00600: internal error code, arguments: [15163], [333], [17424],
[16191], [], [], [], []
when analyzing one of the index-organized tables:
ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS.
Now, similar statement analyzing other IOTs works fine.
Also, on the same table (ipn_measurement) analyze worked fine yesterday,
and the table didn't grew too much since yesterday.
Any ideas?
Another question, do I really have to run analyze table on IOT for
cost-based optimizer, or analyzing index would be enough:
ANALYZE INDEX pk_ipn_measurement ESTIMATE STATISTICS
because analyze index still runs with no errors.
Oracle version is 8.1.5.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
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
RE: ora-600 when analyzing IOT
Title: RE: ora-600 when analyzing IOT Only missing data in *_TABLES is avg_row_len which, probably, can be used for estimating hash area for hash join. Also, columns statistics will not be generated, probably more important. Alex. -Original Message- Does it mean, that if I don't have overflow segment in my IOT, I don't have to analyze table, just analyze PK? Igor Neyman, OCP DBA [EMAIL PROTECTED]
RE: ora-600 when analyzing IOT
I am not sure but based on the definition of an IOT I would think you would
have to ANALYZE TABLE since the primary key data is not duplicated in
a separate index.
Rick
Igor Neyman
[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
on.com cc:
Sent by: Subject: RE: ora-600 when analyzing
IOT
[EMAIL PROTECTED]
.com
08/07/2003 02:14
PM
Please respond to
ORACLE-L
Does it mean, that if I don't have overflow segment in my IOT, I don't
have to analyze table, just analyze PK?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L
Igor,
When you gather statistics on an IOT with the ANALYZE command, it will
analyze the primary key and overflow segment so I would think
this is all that is required by CBO. Hopefully others have more
insight.
Rick
Igor Neyman
[EMAIL PROTECTED]To:
[EMAIL PROTECTED]
on.com cc:
[EMAIL PROTECTED]
Subject: RE: ora-600
when analyzing IOT
08/07/2003 12:13
PM
Rick,
Thanks for prompt reply.
I tried it (deleting statistics before analyzing table) and it worked.
Any ideas, whether cost-based optimizer need statistics on IOT or having
statistics on PK index of IOT would be enough?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
According to MetaLink you need to delete statistics and re-analyze
I do not know your database version but this is supposely fixed in 8.1.6
execute
dbms_stats.delete_table_stats('owner','IPN_MEASUREMENT');
analyze table ipn_measurement estimate statistics ;
HTH
Rick
Igor Neyman
[EMAIL PROTECTED]To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
on.com cc:
Sent by: Subject: ora-600 when
analyzing IOT
[EMAIL PROTECTED]
.com
08/07/2003 12:44
PM
Please respond to
ORACLE-L
Ok, since my original message still hasn't arrived (sent couple hours
ago), here it goes again (sorry, if you get duplicate).
First, sorry for asking this list before searching Metalink, but I don't
have access to it right now.
So, here it is:
I'm getting:
ORA-00600: internal error code, arguments: [15163], [333], [17424],
[16191], [], [], [], []
when analyzing one of the index-organized tables:
ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS.
Now, similar statement analyzing other IOTs works fine.
Also, on the same table (ipn_measurement) analyze worked fine yesterday,
and the table didn't grew too much since yesterday.
Any ideas?
Another question, do I really have to run analyze table on IOT for
cost-based optimizer, or analyzing index would be enough:
ANALYZE INDEX
RE: ora-600 errors for X_$KCBCBH x_$kcbrbh
Roy: This is a cut-and-paste from the Oracle TAR. HTH, Mike *** For the x_$ view not able to recompile successfully: - issue the following query and note the object_id: SQL select object_id, object_name from dba_objects where object_name='X$whatever' and owner='SYS'; - issue SQL delete from dependency$ where d_obj# in (obj# from previous select statement); - drop the view using the DROP command - flush the shared pool - bounce the instance with shutdown abort, startup, shutdown immediate and startup. In a test, use the X_$KCBCBH view and apply this process. Report back results before proceeding with other views. Thanks, ~ Stefan. *** -Original Message- Sent: Thursday, July 17, 2003 6:59 PM To: Vergara, Michael (TEM) Hi, I have this problem and would be interested in seeing the solution from the tar. Thank you for your help. Roy Armstrong [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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-600 [12501] Error ??
Title: RE: ORA-600 [12501] Error ?? Couldn't find it on Metalink. Perhaps you should open a TAR for it? Oracle version? Server version? Is there a trace file? Can you show us the DDL for the table including its indexes? -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED]] I came across this error in ALRT log file. ORA-00600 Internal error [12501] It happened during this SELECT statement and it returned no rows, after i dropped an index on FROMPROFNO column. SELECT NAME,AGE,SEX FROM MSGHISTORY WHERE ( MEMNO = 123 AND PROFNO = 456 AND FROMMEMNO = 789 AND FROMPROFNO = 910 AND SEX='MALE' AND POINT=1) OR ( MEMNO = 124 AND PROFNO = 457 AND FROMMEMNO = 789 AND FROMPROFNO = 910 AND SEX='MALE' AND POINT=1) this statement was working fine and was returning rows b4 i dropped the index. as soon as i created an index on FROMPROFNO , it returned rows. why is it behaving so ? whether is there or not , i should be getting the rows. but it is not so ? if there is index , i get the data and if it is not there i dont get data. and what may be reason of ORA 600 [12501] error ? when is this error expected ?
Re: ORA-600 error(solution for all of them).
Jeremy, you've been left out of the camel joke, evidently. It will come around again. I guess pointless is better than useless :) joe Jeremy Pulcifer wrote: So, Joe, are you pointless for a reason, or is there a joke I'm not aware of. -Original Message- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 7:29 AM To: Multiple recipients of list ORACLE-L Subject: ORA-600 error(solution for all of them). go to sql-server, bwahahahaha. Ok as its been said numerous time(at least by me). Yes I'll SHOUT NOW: YOU CAN'T FIX AN ORA-600 ERROR. ITS 98% OF THE TIME A BUG. CALL SUPPORT, THE OTHER 2% OF THE TIME ITS A LARGE CAMEL NOT A BUG. :) thats is all. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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-600 error(solution for all of them).
There is a utility called "ORA-600 Lookup Utility" which is on Metalink which prompts you for the first argument listed in the ORA-600 error that will give you an idea where the problem lies. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 12, 2002 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-600 error(solution for all of them). go to sql-server, bwahahahaha. Ok as its been said numerous time(at least by me). Yes I'll SHOUT NOW: YOU CAN'T FIX AN ORA-600 ERROR. ITS 98% OF THE TIME A BUG. CALL SUPPORT, THE OTHER 2% OF THE TIME ITS A LARGE CAMEL NOT A BUG. :) thats is all. joe
RE: ORA-600 error(solution for all of them).
Title: RE: ORA-600 error(solution for all of them). So, Joe, are you pointless for a reason, or is there a joke I'm not aware of. -Original Message- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 7:29 AM To: Multiple recipients of list ORACLE-L Subject: ORA-600 error(solution for all of them). go to sql-server, bwahahahaha. Ok as its been said numerous time(at least by me). Yes I'll SHOUT NOW: YOU CAN'T FIX AN ORA-600 ERROR. ITS 98% OF THE TIME A BUG. CALL SUPPORT, THE OTHER 2% OF THE TIME ITS A LARGE CAMEL NOT A BUG. :) thats is all. joe
Re: ORA-600
Weeny. Try using a very small magnet on your hard drive. On Wednesday 23 October 2002 14:49, Stephane Faroult wrote: Joe Testa wrote: Hack the oracle kernel to fix those errors. Use your favorite binary editor. joe Binary editors are for sissies. You probably can do it with cat and sed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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-600
Seema - I used the ORA-600 lookup function on metalink, but it said nothing had yet been published on this error. Your best choice may be to file a TAR. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Hi I am having following error message in alert log on standby database at time of recovery. ORA-00600: internal error code, arguments: [3020], [46191421], [1], [8439], [18903], [16], [], [] Metalink say its BUG.Does any one faced such error? If yes how to fix that. Thx -Seema _ Choose an Internet access plan right for you -- try MSN! http://resourcecenter.msn.com/access/plans/default.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 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: DENNIS WILLIAMS 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-600
Check the trace file or can u send the trace file -Original Message- Sent: Wednesday, October 23, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Hi I am having following error message in alert log on standby database at time of recovery. ORA-00600: internal error code, arguments: [3020], [46191421], [1], [8439], [18903], [16], [], [] Metalink say its BUG.Does any one faced such error? If yes how to fix that. Thx -Seema _ Choose an Internet access plan right for you -- try MSN! http://resourcecenter.msn.com/access/plans/default.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 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: Arun Chakrapanirao 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-600
Hack the oracle kernel to fix those errors. Use your favorite binary editor. joe Seema Singh wrote: Hi I am having following error message in alert log on standby database at time of recovery. ORA-00600: internal error code, arguments: [3020], [46191421], [1], [8439], [18903], [16], [], [] Metalink say its BUG.Does any one faced such error? If yes how to fix that. Thx -Seema _ Choose an Internet access plan right for you -- try MSN! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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-600
Joe Testa wrote: Hack the oracle kernel to fix those errors. Use your favorite binary editor. joe Binary editors are for sissies. You probably can do it with cat and sed. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-600 on insert over dblink to RDB
Beth - Interesting. I pasted your argument into the ORA-600 lookup function on MetaLink and received the message: Description for this argument is not yet published. Your request is recorded and will be used for publishing prioritization. Looks like you're right out there on the bleeding edge. I'd file a TAR were I you. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 16, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Hi everyone, I just upgraded out development database from 8.1.7 to 9.2 and I'm getting an ORA-600 error when trying to do insert into table1 (select * from table1@dblink) The error is - ORA-00600: internal error code, arguments: [qerrmOFBu1], [9100], [], [], [], [], [], [] The database on the other end of the dblink is an RDB 7.0.63 database. I can select * from table1@dblink with any probem. I can also insert over a dblink from an Oracle 8.1.7 or 9.2 database without a problem. I checked Metalink and this ORA-600 error isn't documented yet. Has anyone seen this error before or have any suggestions for going about debugging it? Thanks, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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: DENNIS WILLIAMS 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-600 on insert over dblink to RDB
Hi, Upload your trace file to iOraBugFinder at http://www.ubTools.com/products/iorahanganalyzer/iorahanganalyzer.html regards... DENNIS WILLIAMS wrote: Beth - Interesting. I pasted your argument into the ORA-600 lookup function on MetaLink and received the message: Description for this argument is not yet published. Your request is recorded and will be used for publishing prioritization. Looks like you're right out there on the bleeding edge. I'd file a TAR were I you. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 16, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Hi everyone, I just upgraded out development database from 8.1.7 to 9.2 and I'm getting an ORA-600 error when trying to do insert into table1 (select * from table1@dblink) The error is - ORA-00600: internal error code, arguments: [qerrmOFBu1], [9100], [], [], [], [], [], [] The database on the other end of the dblink is an RDB 7.0.63 database. I can select * from table1@dblink with any probem. I can also insert over a dblink from an Oracle 8.1.7 or 9.2 database without a problem. I checked Metalink and this ORA-600 error isn't documented yet. Has anyone seen this error before or have any suggestions for going about debugging it? Thanks, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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: DENNIS WILLIAMS 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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dunal (ubTools) 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-600 during replication
Vladimir Barac - posao wrote: Good morning / afternoon/ evening (depending on your position)... Alert log has following lines... Tue Jun 25 10:07:30 2002 Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: ORA-12012: error on auto execute of job 123 ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [] ORA-06512: at SYS.DBMS_SNAPSHOT, line 617 ORA-06512: at SYS.DBMS_SNAPSHOT, line 674 ORA-06512: at SYS.DBMS_IREFRESH, line 577 ORA-06512: at SYS.DBMS_REFRESH, line 211 ORA-06512: at line 1 What the hell is going on? I tried to do some search on metalink, but to no avail. Hate to say this, but it is kind of urgernt! Regards, Vladimir Barac Anything more explicit in the .trc file ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-600 during replication
Hi, Upload your trace file to iOraBugFinder at http://www.ubtools.com/products/iorabugfinder/iorabugfinder.html . regards... Vladimir Barac - posao wrote: Good morning / afternoon/ evening (depending on your position)... Alert log has following lines... Tue Jun 25 10:07:30 2002 Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: ORA-12012: error on auto execute of job 123 ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [] ORA-06512: at SYS.DBMS_SNAPSHOT, line 617 ORA-06512: at SYS.DBMS_SNAPSHOT, line 674 ORA-06512: at SYS.DBMS_IREFRESH, line 577 ORA-06512: at SYS.DBMS_REFRESH, line 211 ORA-06512: at line 1 What the hell is going on? I tried to do some search on metalink, but to no avail. Hate to say this, but it is kind of urgernt! Regards, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) 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-600 during replication
Hi. This error signals a potential data corruption, but, examine the other messages for a more complete description of the problem. about the ora-12008 A number of events could cause this problem, among them the following: The master table no longer exists. A column was added to the master table, and the view was not altered. The master is at a remote site and inaccessible. Also suggest you try changing the refresh of the snapshot for FAST or you may need to generate an event 10046 trace so youcan see exactly which statement is failing. Alessandro Guimarães P.S. Brazil is five times world championship (Futebol) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 4:38 AM Hi, Upload your trace file to iOraBugFinder at http://www.ubtools.com/products/iorabugfinder/iorabugfinder.html . regards... Vladimir Barac - posao wrote: Good morning / afternoon/ evening (depending on your position)... Alert log has following lines... Tue Jun 25 10:07:30 2002 Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: ORA-12012: error on auto execute of job 123 ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [] ORA-06512: at SYS.DBMS_SNAPSHOT, line 617 ORA-06512: at SYS.DBMS_SNAPSHOT, line 674 ORA-06512: at SYS.DBMS_IREFRESH, line 577 ORA-06512: at SYS.DBMS_REFRESH, line 211 ORA-06512: at line 1 What the hell is going on? I tried to do some search on metalink, but to no avail. Hate to say this, but it is kind of urgernt! Regards, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) 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: Alessandro Guimaraes 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-600 during replication
Better look again. I got 4 hits on 'ora-600 ktbdchk1' Jared Vladimir Barac - posao [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/01/2002 02:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ORA-600 during replication Good morning / afternoon/ evening (depending on your position)... Alert log has following lines... Tue Jun 25 10:07:30 2002 Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: ORA-12012: error on auto execute of job 123 ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [] ORA-06512: at SYS.DBMS_SNAPSHOT, line 617 ORA-06512: at SYS.DBMS_SNAPSHOT, line 674 ORA-06512: at SYS.DBMS_IREFRESH, line 577 ORA-06512: at SYS.DBMS_REFRESH, line 211 ORA-06512: at line 1 What the hell is going on? I tried to do some search on metalink, but to no avail. Hate to say this, but it is kind of urgernt! Regards, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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-600
This is an error that occurred while recovering from a rolled back transaction. Not a database recovery. This could be caused by doing a control-c while trying to truncate a large table (Bug 1400739 fixed in 8.1.7.1). Could also be from an undo operation on a leaf key of a bitmap index. You should be able to tell this from the trace file. Either way I would open a TAR with Oracle Support to get a proper diagnosis from the trace files. Ultimately, it looks like you have some form of rollback segment corruption, likely block corruption in your rollback tablespace. I would strongly suggest that you open a tar with Oracle Support. Check your alert log for related trace files, in particular SMON trace files. In the mean time check out Metalink note 28814.1 regarding dealing with block corruptions just to get an idea of the possible implications (e.g. logical data corruption). Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Sent: Friday, May 31, 2002 6:18 AM To: Multiple recipients of list ORACLE-L Dear All, I am gettying the follwoing error on our alert_log file,though no porblem in the activity of database. Has any one faced this problem, It is AIX, Oracle 8.1.7 Database and non archived mode. We never gave like recover any thing, why it is trying to recover from error message as follows? ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], [] Mon May 13 16:10:59 2002 ORACLE Instance PAR_D1 (pid = 6) - Error 600 encountered while recovering transaction (7, 43) on object 1. Mon May 13 16:10:59 2002 Thanks for your help. Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= 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: Michael P Sale 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-600
Hi Micheal, Thanks, I would do that cheers, Ravi --- Michael P Sale [EMAIL PROTECTED] wrote: This is an error that occurred while recovering from a rolled back transaction. Not a database recovery. This could be caused by doing a control-c while trying to truncate a large table (Bug 1400739 fixed in 8.1.7.1). Could also be from an undo operation on a leaf key of a bitmap index. You should be able to tell this from the trace file. Either way I would open a TAR with Oracle Support to get a proper diagnosis from the trace files. Ultimately, it looks like you have some form of rollback segment corruption, likely block corruption in your rollback tablespace. I would strongly suggest that you open a tar with Oracle Support. Check your alert log for related trace files, in particular SMON trace files. In the mean time check out Metalink note 28814.1 regarding dealing with block corruptions just to get an idea of the possible implications (e.g. logical data corruption). Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Sent: Friday, May 31, 2002 6:18 AM To: Multiple recipients of list ORACLE-L Dear All, I am gettying the follwoing error on our alert_log file,though no porblem in the activity of database. Has any one faced this problem, It is AIX, Oracle 8.1.7 Database and non archived mode. We never gave like recover any thing, why it is trying to recover from error message as follows? ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], [] Mon May 13 16:10:59 2002 ORACLE Instance PAR_D1 (pid = 6) - Error 600 encountered while recovering transaction (7, 43) on object 1. Mon May 13 16:10:59 2002 Thanks for your help. Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= 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: Michael P Sale 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!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= 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-600
Hi, Add event=10015 trace name context forever, level 10 to init.ora and restart db. A trace will be dumped which shows some rbs headers before and after recovery. can you email it ? Nalla Ravi wrote: Dear All, I am gettying the follwoing error on our alert_log file,though no porblem in the activity of database. Has any one faced this problem, It is AIX, Oracle 8.1.7 Database and non archived mode. We never gave like recover any thing, why it is trying to recover from error message as follows? ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], [] Mon May 13 16:10:59 2002 ORACLE Instance PAR_D1 (pid = 6) - Error 600 encountered while recovering transaction (7, 43) on object 1. Mon May 13 16:10:59 2002 Thanks for your help. Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= 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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) 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-600
When I found the ORA 600 form, I opened the frame in its own window and bookmarked the URL. No need to look up the associated note first. http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=153788.1blackframe=0 -Chris From: Nalla Ravi [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORA-600 Date: Sun, 26 May 2002 12:28:19 -0800 Hi All, Can any one please point me to right URL for ORA-600 error search in Metalink. Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris McGrail 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-600
Ravi - I'm assuming you want the ORA-600 Argument Lookup feature. It appears to be associated with Note:153788.1. I can click on the link and get the screen to appear, but it doesn't update the address part of the browser, so I don't know how to give you specific directions. If you search for ORA-600, you can select Note 146580.1, and it has a link to the Argument Lookup (Note 153788.1). If none of this works, file a TAR with ORA-600 in it. Before Metalink accepts your TAR, it will force you to the page you want. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, May 26, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Can any one please point me to right search URL in metalink for ORA-600 error. Thans for your help Cheers, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= 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: DENNIS WILLIAMS 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-600
Hi Dennis, Thanks you so much I got that. Cheers, Ravi --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ravi - I'm assuming you want the ORA-600 Argument Lookup feature. It appears to be associated with Note:153788.1. I can click on the link and get the screen to appear, but it doesn't update the address part of the browser, so I don't know how to give you specific directions. If you search for ORA-600, you can select Note 146580.1, and it has a link to the Argument Lookup (Note 153788.1). If none of this works, file a TAR with ORA-600 in it. Before Metalink accepts your TAR, it will force you to the page you want. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- From: Nalla Ravi [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Subject: Ora-600 Can any one please point me to right search URL in metalink for ORA-600 error. Thans for your help Cheers, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= 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!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= 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-600 [3708] During Database SHUTDOWN
Vivek: Oracle Support is right. THis is a typical LGWR problem. The first thing you should do is.. You need to reduce the size of Log Buffer (it should be in KBs.. NEVER configure log buffer in MBs) Try setting log buffer in KBs. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- VIVEK_SHARMA Sent: Wednesday, May 22, 2002 2:04 PM To: Multiple recipients of list ORACLE-L O.S. Solaris 8 Oracle 8.1.7.2 + 3 Stand Alone Patches CASE - On Database SHUTDOWN Got the Error ora-600 [3708 ] Messages ALTER DATABASE CLOSE NORMAL Tue May 21 01:30:36 2002 SMON: disabling tx recovery SMON: disabling cache recovery Tue May 21 01:46:23 2002 Errors in file /oracle734/ver817/rdbms/userlog/bby01_ora_19332.trc: ORA-00600:internal error code,arguments:[3708], [910], [], [], [], [], [], [] Tue May 21 01:46:39 2002 SMON: enabling cache recovery SMON: enabling tx recovery NOTE Shutdown process took about 15 Minutes to Complete gave this Error EXPLANATION By Oracle Corp. :- Basically this error is raised because LGWR timmed out. While shutdown, Oracle routine (kcttsc()) sends a message to LGWR to change the state of a redo thread and waits for confirmation. If the return message never comes, then LGWR times out after 15 minutes which is the second argument in the ora-600 (910 secs ie. 15mins.) In the situation we faced , lgwr had RT enqueue and waiting for 'direct path read' on file 197. Becuase of some OS issues the read took more than 15 minutes and lgwr gave a timeout. There is a workaround to keep a underscore init parameter to overcome any OS issues and tell lgwr to wait for more time. But this is suggested only after checking OS for any performance issues. SOLUTION / Suggestion by Oracle Corp :- - Remove the REDO log files from RAID5 - Check OS H/W, RAID for any performance issues specifically during that time. GENERAL INFO :- log_buffer = 4M (High Volume OLTP / Batch Transactions 3 Million in a 5 Hours Window Exist) Size of online Redo Logfile = 500M ( Is This Excessive ?) Logfiles are Multiplexed . All Datafiles Online Redo logfiles Exist on a SINGLE RAID 5 Volume All Hard Disks Clubbed into a Single RAID 5 Volume Storage Box = HP having VXFS Filesystems mounted thereon even though O.S. = Solaris 8 Any Advice for approach / resolution ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: 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-600 Error
Hi John, Oracle has solved the problem. Change the connect strings in the form server from http to socket. Thanks. Regds, New Bee -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Subject:RE: ORA-600 Error Hi Catherine, Depending on your version, and whether you have set the system profile 'Sign-On:Audit Level' to FORMS, you should be able to view current online forms users using SELECT USER_NAME, USER_FORM_NAME, RESPONSIBILITY_NAME, TIME, PID FROM APPS.FND_SIGNON_AUDIT_VIEW order by user_name / Past history, again depending on whether the above System profile was set or not, can be determined by querying the FND_LOGINS, FND_LOGIN_RESP_FORMS and FND_USERS. Apologies - I don't have a query on-hand to do this. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] I am trying to gather the events that will led up to the error : who is accessing the form and the operations that were attempted that led to the error. Does anyone know the query to list all the user who is accessing the form ? I tried to use SELECT OSUSER,USERNAME, TERMINAL, COMMAND, SQL_ADDRESS, PREV_SQL_ADDR , MODULE FROM V$SESSION WHERE PROGRAM='f60runm@orion (TNS V1-V3)' OSUSER USERNAME TERMINAL COMMAND SQL_ADDR PREV_SQL MODULE -- -- -- - - orahrmsAPPS 0 8D0F3EB4 8D0F3EB4 orahrmsAPPS 0 8D0F3EB4 8D0F3EB4 FNDSCAUS orahrmsAPPS 0 8D162568 8D162568 orahrmsAPPS 0 8D162568 8D162568 orahrmsAPPS 0 8D06ECB8 8D06ECB8 PERWSHRG It does not work 'cause there are 5 different users with different login accessing the form and all I get from the v$session.username is 'APPS'. Any advice ? How do U gurus solve the ORA-600 error ? Please help. Thanks. Regds, New Bee Contents of form server log file : port=9000 mode=http exe=f60webmx Choosing default pool 1 for this process... 1 Forms environment: ORACLE_HOME = /dg2/oracle/nieora/8.0.6 PATH = /dg2/oracle/nieora/8.0.6/bin:/dg2/oracle/nieora/8.0.6/bin:/dg2 /oracle/nieapp l/fnd/11.5.0/bin:/dg2/oracle/nieappl/ad/11.5.0/bin::/dg2/oracl e/nieora/8.0.6 /bin:/usr/ccs/bin:/usr/sbin:/dg2/oracle/niecomn/util/jre/1.1.8 /bin:/usr/bin LD_LIBRARY_PATH = /dg2/oracle/nieora/8.0.6/lib:/dg2/oracle/niecomn/util/jre/1.1. 8/lib:/dg2/ora cle/nieora/8.0.6/lib:/dg2/oracle/nieora/8.0.6/lib:/usr/dt/lib: /usr/openwin/l ib Forms listener started on port 9000. **START PLSQL RUNTIME DUMP ***Got ORA-600 while running PLSQL*** PACKAGE BODY .FORMS40: library unit=d40d60 line=453 opcode=37 static link=0 scope=1 FP=da971c PC=ef7596cc Page=0 AP=da882c ST=da9724 DL0=d95da0 GF=d95dd4 DL1=d95db4 DPF=d95dcc DS=d41c8c DON library unit variable list instantiation -- - - 0 d40d60
RE: ORA-600 Error
Hi Catherine, Depending on your version, and whether you have set the system profile 'Sign-On:Audit Level' to FORMS, you should be able to view current online forms users using SELECT USER_NAME, USER_FORM_NAME, RESPONSIBILITY_NAME, TIME, PID FROM APPS.FND_SIGNON_AUDIT_VIEW order by user_name / Past history, again depending on whether the above System profile was set or not, can be determined by querying the FND_LOGINS, FND_LOGIN_RESP_FORMS and FND_USERS. Apologies - I don't have a query on-hand to do this. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] I am trying to gather the events that will led up to the error : who is accessing the form and the operations that were attempted that led to the error. Does anyone know the query to list all the user who is accessing the form ? I tried to use SELECT OSUSER,USERNAME, TERMINAL, COMMAND, SQL_ADDRESS, PREV_SQL_ADDR , MODULE FROM V$SESSION WHERE PROGRAM='f60runm@orion (TNS V1-V3)' OSUSER USERNAME TERMINAL COMMAND SQL_ADDR PREV_SQL MODULE -- -- -- - - orahrmsAPPS 0 8D0F3EB4 8D0F3EB4 orahrmsAPPS 0 8D0F3EB4 8D0F3EB4 FNDSCAUS orahrmsAPPS 0 8D162568 8D162568 orahrmsAPPS 0 8D162568 8D162568 orahrmsAPPS 0 8D06ECB8 8D06ECB8 PERWSHRG It does not work 'cause there are 5 different users with different login accessing the form and all I get from the v$session.username is 'APPS'. Any advice ? How do U gurus solve the ORA-600 error ? Please help. Thanks. Regds, New Bee Contents of form server log file : port=9000 mode=http exe=f60webmx Choosing default pool 1 for this process... 1 Forms environment: ORACLE_HOME = /dg2/oracle/nieora/8.0.6 PATH = /dg2/oracle/nieora/8.0.6/bin:/dg2/oracle/nieora/8.0.6/bin:/dg2 /oracle/nieapp l/fnd/11.5.0/bin:/dg2/oracle/nieappl/ad/11.5.0/bin::/dg2/oracl e/nieora/8.0.6 /bin:/usr/ccs/bin:/usr/sbin:/dg2/oracle/niecomn/util/jre/1.1.8 /bin:/usr/bin LD_LIBRARY_PATH = /dg2/oracle/nieora/8.0.6/lib:/dg2/oracle/niecomn/util/jre/1.1. 8/lib:/dg2/ora cle/nieora/8.0.6/lib:/dg2/oracle/nieora/8.0.6/lib:/usr/dt/lib: /usr/openwin/l ib Forms listener started on port 9000. **START PLSQL RUNTIME DUMP ***Got ORA-600 while running PLSQL*** PACKAGE BODY .FORMS40: library unit=d40d60 line=453 opcode=37 static link=0 scope=1 FP=da971c PC=ef7596cc Page=0 AP=da882c ST=da9724 DL0=d95da0 GF=d95dd4 DL1=d95db4 DPF=d95dcc DS=d41c8c DON library unit variable list instantiation -- - - 0 d40d60d95dd4d95e04 1 2 3 4 scopeframe 2 da971c 10 version=43123476 instantiation size=48 line pcode offset 3699 370 18 376 41 377 71 379 99 381 99 382 134 383 176 385 206 386 217 390 231 391 240 395 249 396 258 400 276 401 290 404 313 406 313 407 348 408 362 412 371 413 380 417 398 418 412 420 435 422 435 423 470 424 512 426 526 432 535 433 544 439 567 441 567 442 596 443 615 448 629 449 649 453 663 454 683 458 706 459 720 461 743 463 743 464 778 465 792 468 815 470 815 471 850 472 892 474 911 478 929 479 948 484 957 485 957 489 966 490 966 494 975 495 975 500 984 501 993 507 1002 508 1011 514 1025 515 1064 521 1073 522 1102 527 528 1120 532 1129 533 1138 538 1161 540
RE: ORA-600 [1158] on 8.1.7
Hi, I'm working on Oracle 8.1.7.2 , AIX 4.3.3 and haven't got any problems... had a lot before the patch, but not ORA-600. I suggest you apply the patch and monitor the instance. Hope this helps! Saludos, Verónica Levin Enríquez. Compañía Cervecera de Nicaragua. -Mensaje original- De: Mohammad Rafiq [mailto:[EMAIL PROTECTED]] Enviado el: Thursday, February 14, 2002 11:54 AM Para: Multiple recipients of list ORACLE-L Asunto: Re: ORA-600 [1158] on 8.1.7 With every parchset they provide list of fixes in readme file. You can check it before downloading or applying patches...However, it is better to go to 8.1.7.2 which has lot of fixes... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 14 Feb 2002 08:23:34 -0800 Hi, We have a database running version 8.1.7.0 on AIX 4.3.3 that intermittently crashes with an ORA-600 [1158] error. Oracle's ORA-600 lookup tool did not have any hits. There was no specific resolution from Oracle support for this error - just a general suggestion to upgrade to the latest patch levels. This is something we are reluctant to do without specific patch information addressing our problem. Has anyone seen this error on 8.1.7 before? Regards, Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Vasas 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). MOHAMMAD RAFIQ _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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-600 [1158] on 8.1.7
With every parchset they provide list of fixes in readme file. You can check it before downloading or applying patches...However, it is better to go to 8.1.7.2 which has lot of fixes... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 14 Feb 2002 08:23:34 -0800 Hi, We have a database running version 8.1.7.0 on AIX 4.3.3 that intermittently crashes with an ORA-600 [1158] error. Oracle's ORA-600 lookup tool did not have any hits. There was no specific resolution from Oracle support for this error - just a general suggestion to upgrade to the latest patch levels. This is something we are reluctant to do without specific patch information addressing our problem. Has anyone seen this error on 8.1.7 before? Regards, Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Vasas 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). MOHAMMAD RAFIQ _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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).
RE: ORA-600 Parser...
Yup ... for me most of the time it doesn't look-up anything 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! -Original Message- Sent: Wednesday, January 09, 2002 10:25 AM To: Multiple recipients of list ORACLE-L I ran across something that I have not seen before when logging a TAR via MetaLink. Oracle now has an ORA-600 parser and lookup. Thought you might all be interested if you have access to MetaLink: http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=153788.1blackfr ame=0 Jim *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
Re: ORA-600 Parser...
Interesting, thanks for the link. Jared HAWKINS, JAMES W [IT/1000] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] james.w.hawkins@phar cc: macia.com Subject: ORA-600 Parser... Sent by: [EMAIL PROTECTED] 01/09/02 07:25 AM Please respond to ORACLE-L I ran across something that I have not seen before when logging a TAR via MetaLink. Oracle now has an ORA-600 parser and lookup. Thought you might all be interested if you have access to MetaLink: http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=153788.1blackfr ame=0 Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] 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-600 and ORA-603 issues with dlm resource hash list
just out of curiosity, what flavor of Unix? What are your dlm lock conversion statistics? what are your OS kernel settings for udp buffers at? -Original Message- Sent: Friday, December 14, 2001 6:10 PM To: Multiple recipients of list ORACLE-L Hello, Anyone out there having fun on OPS with the dlm resource hash list ORA-600 and ORA-603 errors. We are getting them more frequently with increased load on the system. See below for some particulars. The really bad part is having a critical process die with the 603 error. applicable init.ora parameters: lm_locks= 18 lm_ress = 12 dml_locks = 7250 _lm_direct_sends= lkmgr alertlog error: Thu Dec 13 14:34:36 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [526], [3339519528], [1], [dlm resour ce hash list], [38628], [3338960552], [34261], [] Thu Dec 13 14:34:38 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thu Dec 13 14:34:41 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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: 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: ORA-600 and ORA-603 issues with dlm resource hash list
Ross, The HP info for one of the two nodes is, HP-UX proteus B.11.00 U 9000/800. As to the conversion stats, how do I determine/obtain those ? I'll have to get the kernal setting tomorrow; I'm working from home today, so no hard-copy. -Original Message- Sent: Monday, December 17, 2001 11:40 AM To: Multiple recipients of list ORACLE-L just out of curiosity, what flavor of Unix? What are your dlm lock conversion statistics? what are your OS kernel settings for udp buffers at? -Original Message- Sent: Friday, December 14, 2001 6:10 PM To: Multiple recipients of list ORACLE-L Hello, Anyone out there having fun on OPS with the dlm resource hash list ORA-600 and ORA-603 errors. We are getting them more frequently with increased load on the system. See below for some particulars. The really bad part is having a critical process die with the 603 error. applicable init.ora parameters: lm_locks= 18 lm_ress = 12 dml_locks = 7250 _lm_direct_sends= lkmgr alertlog error: Thu Dec 13 14:34:36 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [526], [3339519528], [1], [dlm resour ce hash list], [38628], [3338960552], [34261], [] Thu Dec 13 14:34:38 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thu Dec 13 14:34:41 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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-600 and ORA-603 issues with dlm resource hash list
hmmm..HP do a man -k dlm and find something like 'dlmstats'. It'll be a 'big' command with lots of cmd line flags. That should get/find you lock up/down converts. Go to the specifics from there. Expect to find most of your converts are from null to shared, or vice versa...then, an order magniture (at least) fewer from shared to exclusive, etc. That's normal. Most decent dlmstats utilities will give you rudimentary waits and statistics. See if everything seems copacetic there. There are (although i honestly do NOT think this is your issue) UDP internode comms parameters that might be optimized up to, say, 256K-size send/receive buffers. What I'd look at is is the OS dlm version and patching and *its* kernel settings. I know nothing about HP, so maybe one of the truly informed on the list can chime in on that. If, OTOH, you are in a version of Oracle that internalizes the dlm (9i for sure, e.g.) then you'll likely have more knobs and dials to twist there. hope these hazily recalled, partially correct, and potentially irrelevant comments prove useful, if only as an example of what *not* to do. - Ross -Original Message- Sent: Monday, December 17, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Ross, The HP info for one of the two nodes is, HP-UX proteus B.11.00 U 9000/800. As to the conversion stats, how do I determine/obtain those ? I'll have to get the kernal setting tomorrow; I'm working from home today, so no hard-copy. -Original Message- Sent: Monday, December 17, 2001 11:40 AM To: Multiple recipients of list ORACLE-L just out of curiosity, what flavor of Unix? What are your dlm lock conversion statistics? what are your OS kernel settings for udp buffers at? -Original Message- Sent: Friday, December 14, 2001 6:10 PM To: Multiple recipients of list ORACLE-L Hello, Anyone out there having fun on OPS with the dlm resource hash list ORA-600 and ORA-603 errors. We are getting them more frequently with increased load on the system. See below for some particulars. The really bad part is having a critical process die with the 603 error. applicable init.ora parameters: lm_locks= 18 lm_ress = 12 dml_locks = 7250 _lm_direct_sends= lkmgr alertlog error: Thu Dec 13 14:34:36 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [526], [3339519528], [1], [dlm resour ce hash list], [38628], [3338960552], [34261], [] Thu Dec 13 14:34:38 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thu Dec 13 14:34:41 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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
RE: ORA-600 and ORA-603 issues with dlm resource hash list
Paul, I missed your original thread on this problem, but I suggest you call support. The problem you are seeing may be related to bug# 2009263. I am making some assumptions that you are running on HP 64bit and you are running on either 8.1.6 or 8.1.7. There are some little things you might need to know. In 8.1.7 lm_lock and lm_ress parameters can't be set using the syntax you have used below and the _lm_direct_sends parameter should be set to all which is the default or just removed. The bug 1189628 only appears to cause problems with tru64 or HP 64bit OPS and there is a patch for the problem. Setting _lm_direct_sends forces Oracle to use only 1 message channel and this can become performance issue. Hope this helps, Scott --- Mohan, Ross [EMAIL PROTECTED] wrote: just out of curiosity, what flavor of Unix? What are your dlm lock conversion statistics? what are your OS kernel settings for udp buffers at? -Original Message- Sent: Friday, December 14, 2001 6:10 PM To: Multiple recipients of list ORACLE-L Hello, Anyone out there having fun on OPS with the dlm resource hash list ORA-600 and ORA-603 errors. We are getting them more frequently with increased load on the system. See below for some particulars. The really bad part is having a critical process die with the 603 error. applicable init.ora parameters: lm_locks= 18 lm_ress = 12 dml_locks = 7250 _lm_direct_sends= lkmgr alertlog error: Thu Dec 13 14:34:36 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [526], [3339519528], [1], [dlm resour ce hash list], [38628], [3338960552], [34261], [] Thu Dec 13 14:34:38 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thu Dec 13 14:34:41 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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: 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott 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 600 error can't find reference on Metalink
Raj, You didn't tell me the Oracle Version. So I would assume this is most current version. Your error OERI:4427 is a transaction layer component internal error. By any chance you are using 2 phase commits (or ditributed transactions) in thiese databases? or database resource manager ? --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Hi all, I recently found following errors in alert log, but couldn't locate any information on Metalink, does anyone know what these errors are? I will be opening a TAR with OWS this AM. ORA-00600: internal error code, arguments: [4427], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [], [], [], [], [], [] = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ 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: 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 600 error can't find reference on Metalink
Sorry I didn't mention this before, this is 9.0.1.0.0 and I am not sure about any distributed transactions I'll check that though ... BTW all three instances of errors are on COMMIT statement. Thanks for the clue ... 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-600 when querying DBA_SOURCE, ALL_SOURCE.
oracle's answer will be patch to 8.1.7.2, thats what we were told just recently on a different ora-600 error. [EMAIL PROTECTED] 09/20/01 10:45AM And yes, I've got a TAR logged with Oracle on this, but I wonder if any of you have seen anything like this before. Whenever we try to query any of the *_SOURCE views we get an ORA-600. If you look at the view text for DBA_SOURCE: select u.name, o.name, decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 13, 'TYPE', 14, 'TYPE BODY', 'UNDEFINED'), s.line, s.source from sys.obj$ o, sys.source$ s, sys.user$ u where o.obj# = s.obj# and o.owner# = u.user# and o.type# in (7, 8, 9, 11, 13, 14) union select u.name, o.name, 'JAVA SOURCE', s.joxftlno, s.joxftsrc from sys.obj$ o, x$joxfs s, sys.user$ u where o.obj# = s.joxftobn and o.owner# = u.user# and o.type# = 28; I can query either side of the UNION separately and it works fine. It's when the whole shembang is queried where the ORA-600 occurs. And I've rebuilt with catalog, etc. Doesn't help. We are on IBM RS600, AIX 4.3.3, 8.1.7.0, on UTF8, FWIW. Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
RE: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.
Title: ORA-600 when querying DBA_SOURCE, ALL_SOURCE. Works OK with 8.1.7 on Win2K.. What do all you unix bigots think of that then G :P Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas JeffSent: Thursday, September 20, 2001 15:45To: Multiple recipients of list ORACLE-LSubject: ORA-600 when querying DBA_SOURCE, ALL_SOURCE. And yes, I've got a TAR logged with Oracle on this, but I wonder if any of you have seen anything like this before. Whenever we try to query any of the *_SOURCE views we get an ORA-600. If you look at the view text for DBA_SOURCE: select u.name, o.name, decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 13, 'TYPE', 14, 'TYPE BODY', 'UNDEFINED'), s.line, s.source from sys.obj$ o, sys.source$ s, sys.user$ u where o.obj# = s.obj# and o.owner# = u.user# and o.type# in (7, 8, 9, 11, 13, 14) union select u.name, o.name, 'JAVA SOURCE', s.joxftlno, s.joxftsrc from sys.obj$ o, x$joxfs s, sys.user$ u where o.obj# = s.joxftobn and o.owner# = u.user# and o.type# = 28; I can query either side of the UNION separately and it works fine. It's when the whole shembang is queried where the ORA-600 occurs. And I've rebuilt with catalog, etc. Doesn't help. We are on IBM RS600, AIX 4.3.3, 8.1.7.0, on UTF8, FWIW. Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
Re: ora-600/ora07445
ÌÌÌ X-Declude-Sender: [EMAIL PROTECTED] [63.26.83.243] X-Declude-Spoolname: D1f8e13e.SMD X-Note: This E-mail was sent from 1cust243.tnt1.circleville.oh.da.uu.net. ([63.26.83.243]). X-Note: Please send abuse reports to [EMAIL PROTECTED] usually 600/7445 errors need called into support, that would be the 1st thing i'd do. joe Seema Singh wrote: Hi I have oracle8.1.7 on Solaris 2.7. I am getting following error message in my alert log. ORA-07445: exception encountered: core dump [dredseek()+388] [SIGSEGV] [Address not mapped to object] [97552987] [] [] and ORA-00600: internal error code, arguments: [12700], [80087], [121694549], [23], [], [], [], [] What could be reason?Please suggest. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- 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-600/ora07445
We had the same thing not too long ago. Turned out to be a corrupt index block. You might try running DBVerify on all the datafiles. It will tell you if something is wrong. Ron Smith Database Administrator [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 08, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Hi I have oracle8.1.7 on Solaris 2.7. I am getting following error message in my alert log. ORA-07445: exception encountered: core dump [dredseek()+388] [SIGSEGV] [Address not mapped to object] [97552987] [] [] and ORA-00600: internal error code, arguments: [12700], [80087], [121694549], [23], [], [], [], [] What could be reason?Please suggest. Thanks -Seema _ 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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-600/ora07445
First: Searching metalink (http://metalink.oracle.com) for ORA-07445 dredseek() will return 3 hits, including the OWWS reply ...this could be bug:1095728. Searching on ORA-00600 [12700] returned 39 hits. Check it out. Fill out an iTar. Hound OWWS incessantly until you have a solution. Good Luck, Scott Shafer San Antonio, TX Seema Singh wrote: Hi I have oracle8.1.7 on Solaris 2.7. I am getting following error message in my alert log. ORA-07445: exception encountered: core dump [dredseek()+388] [SIGSEGV] [Address not mapped to object] [97552987] [] [] and ORA-00600: internal error code, arguments: [12700], [80087], [121694549], [23], [], [], [], [] What could be reason?Please suggest. _ 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: Scott Shafer 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-600/ora07445
this an internal error of oracle ,you must send your database and the error ora600 with his arguments to your oracle provider. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 10:50 AM Hi I have oracle8.1.7 on Solaris 2.7. I am getting following error message in my alert log. ORA-07445: exception encountered: core dump [dredseek()+388] [SIGSEGV] [Address not mapped to object] [97552987] [] [] and ORA-00600: internal error code, arguments: [12700], [80087], [121694549], [23], [], [], [], [] What could be reason?Please suggest. Thanks -Seema _ 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario 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-600/ora07445
Mario, You mean to say he should send database to the oracle provider ;) --- Mario [EMAIL PROTECTED] wrote: this an internal error of oracle ,you must send your database and the error ora600 with his arguments to your oracle provider. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ 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 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-600 ..sort extent pool??
It is an error of latch contention. IT IS NOT AN CORRUPTION ERROR. Maybe in those times when the error occurred you were experimenting some sort extent pool latch contention. Therefore identify for the next time identify which session is causing the contention and what it is running with v$session_wait, v$latch and v$sqltext or v$sqlarea. Or try with temporary local extent management. Regards. --- Joe Testa [EMAIL PROTECTED] wrote: call support joe Raghu Kota wrote: Hi Friends, When Iam rebuilding my index and clearing TEMP tablespace frequently..that time I got this error..Any suggestions?? ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent poo l], [], [], [], [], [] Thanks Raghu. _ 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: Raghu Kota 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ 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: 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-600 ..sort extent pool??
Raghu: What I have found suggests that you are having latch contention on the SORT EXTENT POOL. The 510 indicates that a call was made to free a latch that is unowned. The second parameter is the address for that latch. The third argument is the type of child latch that the kernel was trying to free. Oracle processes doing sorting that require access to a sort segment in a temporary tablespace are coordinated by a SHARED POOL structure called the SORT EXTENT POOL. This structure contains a description of all of the active sort segments and their extents in the sort segment. Access to this structure is controlled by the SORT EXTENT POOL latch. Your problem could be due to latch contention on this latch. You can view the statistics on this latch by joining v$latch and v$latchname on latch#. To reduce contention on this latch, increase the extent size by changing the NEXT value of the DEFAULT STORAGE clause of the temporary tablespace in which you are sorting. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 04, 2001 4:55 PM Hi Friends, When Iam rebuilding my index and clearing TEMP tablespace frequently..that time I got this error..Any suggestions?? ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent poo l], [], [], [], [], [] Thanks Raghu. _ 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: Raghu Kota 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: 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: ora-600 ..sort extent pool??
Thankyou very jon. From: Jon Walthour [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ora-600 ..sort extent pool?? Date: Sat, 04 Aug 2001 14:40:18 -0800 Raghu: What I have found suggests that you are having latch contention on the SORT EXTENT POOL. The 510 indicates that a call was made to free a latch that is unowned. The second parameter is the address for that latch. The third argument is the type of child latch that the kernel was trying to free. Oracle processes doing sorting that require access to a sort segment in a temporary tablespace are coordinated by a SHARED POOL structure called the SORT EXTENT POOL. This structure contains a description of all of the active sort segments and their extents in the sort segment. Access to this structure is controlled by the SORT EXTENT POOL latch. Your problem could be due to latch contention on this latch. You can view the statistics on this latch by joining v$latch and v$latchname on latch#. To reduce contention on this latch, increase the extent size by changing the NEXT value of the DEFAULT STORAGE clause of the temporary tablespace in which you are sorting. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 04, 2001 4:55 PM Hi Friends, When Iam rebuilding my index and clearing TEMP tablespace frequently..that time I got this error..Any suggestions?? ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent poo l], [], [], [], [], [] Thanks Raghu. _ 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: Raghu Kota 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: 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/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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-600 ..sort extent pool??
Thankyou very much jon. From: Jon Walthour [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ora-600 ..sort extent pool?? Date: Sat, 04 Aug 2001 14:40:18 -0800 Raghu: What I have found suggests that you are having latch contention on the SORT EXTENT POOL. The 510 indicates that a call was made to free a latch that is unowned. The second parameter is the address for that latch. The third argument is the type of child latch that the kernel was trying to free. Oracle processes doing sorting that require access to a sort segment in a temporary tablespace are coordinated by a SHARED POOL structure called the SORT EXTENT POOL. This structure contains a description of all of the active sort segments and their extents in the sort segment. Access to this structure is controlled by the SORT EXTENT POOL latch. Your problem could be due to latch contention on this latch. You can view the statistics on this latch by joining v$latch and v$latchname on latch#. To reduce contention on this latch, increase the extent size by changing the NEXT value of the DEFAULT STORAGE clause of the temporary tablespace in which you are sorting. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 04, 2001 4:55 PM Hi Friends, When Iam rebuilding my index and clearing TEMP tablespace frequently..that time I got this error..Any suggestions?? ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent poo l], [], [], [], [], [] Thanks Raghu. _ 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: Raghu Kota 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: 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/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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-600 ..sort extent pool??
call support joe Raghu Kota wrote: Hi Friends, When Iam rebuilding my index and clearing TEMP tablespace frequently..that time I got this error..Any suggestions?? ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent poo l], [], [], [], [], [] Thanks Raghu. _ 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: Raghu Kota 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- 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-600 : Internal error code.. Help!!!
Unal is my surname, Bilisim is a Turkish word which means Information relevant things. "Koivu, Lisa" wrote: OK. What is unal-bilisim, it sounds like it's kinda disgusting. But what do I know. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ora-600 : Internal error code.. Help!!! There is a web site, http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html, that lets you upload your trace file and it will give you links to any relavant info it can find on the subject. You might want to try it. -Original Message- Sent: Tuesday, June 12, 2001 1:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Kevin Lange 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
RE: Ora-600 : Internal error code.. Help!!!
Oracle Product Document Library(C) Oracle Corporation Manual: ORACLE 8.1.5 SERVER CODES Reference: A67785-01 ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: timeouts file corruption failed data checks in memory hardware, memory, or I/O errors incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Customer Support after gathering the following information: events that led up to the error the operations that were attempted that led to the error the conditions of the operating system and databases at the time of the error any unusual circumstances that occurred before receiving the ORA-00600 message contents of any trace files generated by the error the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error. -Original Message- Sent: Tuesday, June 12, 2001 2:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Van M. Etheridge 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-600 : Internal error code.. Help!!!
Hello, did you run iOraBugFinder ? Raj Gopalan wrote: DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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-600 : Internal error code.. Help!!!
There is a web site, http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html, that lets you upload your trace file and it will give you links to any relavant info it can find on the subject. You might want to try it. -Original Message- Sent: Tuesday, June 12, 2001 1:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Kevin Lange 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-600 : Internal error code.. Help!!!
Title: RE: Ora-600 : Internal error code.. Help!!! OK. What is unal-bilisim, it sounds like it's kinda disgusting. But what do I know. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ora-600 : Internal error code.. Help!!! There is a web site, http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html, that lets you upload your trace file and it will give you links to any relavant info it can find on the subject. You might want to try it. -Original Message- Sent: Tuesday, June 12, 2001 1:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Kevin Lange 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-600 : Internal error code.. Help!!!
Title: RE: Ora-600 : Internal error code.. Help!!! Lisa; According to their web site: Unal Bilisim is an organization which is specialized in Oracle Database. It's located in Adana/Turkey. Unal Bilisim applies and believes in Deductive Business Management philosophy. This management philosophy is the management method of internet age. It makes products and services centralized, reduces costs, broadens customer scope. So, products and services of Unal Bilisim will be internet-based. Products will be run on internet, services will be delivered over internet. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 3:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Ora-600 : Internal error code.. Help!!! OK. What is unal-bilisim, it sounds like it's kinda disgusting. But what do I know. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ora-600 : Internal error code.. Help!!! There is a web site, http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html, that lets you upload your trace file and it will give you links to any relavant info it can find on the subject. You might want to try it. -Original Message- Sent: Tuesday, June 12, 2001 1:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Kevin Lange 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-600
Thank you Deshpande, It's nice to hear good results. I genarally recommend search depth=1. Search depth=0 may return a lot of bugs and it may take time to find which one is yours. And, You may not see all bugs. It depends on your license and bug status. Many bugs are un-published(not only bugs, but also everythingl. This list has more internals than Metalink). If iOraBugFinder returns no hit, email Oracle support with HTML or URL returned by iOraBugFinder. Since Oracle support can see all bugs, That will reduce your support response time from Oracle support. I added new features on 1.0.1 version. It's now better to find bugs. If you have any recommendations, please feel free to contact me. "Deshpande, Kirti" wrote: Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: Deshpande, Kirti 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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-600
Kevin, ORA-600's and ORA-7445's are very similar in some respects in that they are related to the death of a process. ORA-600's are essentially exception handlers so there are literally thousands of different ORA-600's. Some errors are signaled in only one situation, others can occur in hundreds of cases. An ORA-7445 is merely the Oracle error assigned to the return code when the OS terminates the process (bad process!). BTW, ORA-7445's are not signaled on NT, NetWare or Linux. Instead, the following errors are signaled: Dr. Watson errors (NT), abends (NetWare) or Errors in file... entries in the alert.log and trace files containing Exception signal... (Linux). With ORA-600's the first argument is very specific, so when searching on metalink include the first argument. Any additional arguments are specific to the environment (DBA's, object ID's, memory addresses, etc...) so they should not be searched on since they are unlikely to be the same. The arguments on ORA-7445 errors are usually irrelevant as they are frequently generic ([SIGSEGV], [SIGBUS], [Address not mapped to object], [Invalid address alignment] etc...). If you can identify the type of operation generating the error, then it helps to search on that along with the error. In some cases this will be in the trace file under the heading Current SQL statement for this session. These errors frequently indicate bugs, but can also occur due to other reasons such as hardware/OS problems, corruption, or incorrect environment settings. For example, a corrupt block can signal an ORA-600 error because the information in the header of the block is out of sync. The best way to determine the cause of these errors is to log a tar with support as much of the information in the bugs is viewable only to support. They will need the alert.log (preferably going back to the last startup, but at least the last 3-10 days) along with the trace files generated (upload the whole file, don't just cut and paste portions of it). In the case of multiple errors in the alert.log, supply the trace files from the first couple of errors as often the first error can cause cascading errors. If a trace file is not generated by an ORA-7445, then you should try to extract a stack trace from the core file (see notes 1812.1 and 1007808.6). This needs to be done using the executables that generated the core file, so don't bother sending the core file to support. I'm developing this into a presentation that I hope to present at OpenWorld (ORA-3113's, 600's, and 7445's Oh My!) so please feel free to send me questions or topics I should cover. HTH, -- Anita --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject:ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: Deshpande, Kirti INET:
Re: ora-600
I worked with RDBMS support in Oracle Denmark for far too many years, and I'm not that scared of 600's anymore. To provoke a bit, I find that they are in general harmless, and then in some cases indicate serious stuff. When looking at Oracle source code, you will (if you ever get the chance :) ) see this kind of thing: If then signal ORA-942 (or rather OERR(00942)) if something unforeseen happens, signal 600 with specific arguments (OERI(17112)) Else... signal ORA-1000 (OERR(01000)) Of course I'm making up these numbers, but the two functions called are OERR for normal errors and OERI for Oracle ERror Internal. So the ora-00600 [17112] is because the normal error codes couldn't handle the situation. So the first argument for an ora-600 error is the error code and is indeed specific for a certain part of the Oracle code. Support/Development can easily look up where in the code this is signalled, but it can be very difficult to find out why it was signalled (I'm saying this, because I rarely could figure it out - of course all the smart types could, but I couldn't). In the case of ORA-00600 [17112], however, I do have some notes: Internal heap errors/corruptions: [17066] [17112] [17114] [17148] [17182] E.g. BAD MAGIC NUMBER in trace file So look in the trace file for BAD MAGIC NUMBER and you will know that a problem occurred in the heap. There can of course be a lot of reasons for this magic number to give errors when computed. Check the bug database or Support for specifics. But it's not fatal or anything. A. Bardeen wrote: Kevin, ORA-600's and ORA-7445's are very similar in some respects in that they are related to the death of a process. ORA-600's are essentially exception handlers so there are literally thousands of different ORA-600's. Some errors are signaled in only one situation, others can occur in hundreds of cases. An ORA-7445 is merely the Oracle error assigned to the return code when the OS terminates the process (bad process!). BTW, ORA-7445's are not signaled on NT, NetWare or Linux. Instead, the following errors are signaled: Dr. Watson errors (NT), abends (NetWare) or Errors in file... entries in the alert.log and trace files containing Exception signal... (Linux). With ORA-600's the first argument is very specific, so when searching on metalink include the first argument. Any additional arguments are specific to the environment (DBA's, object ID's, memory addresses, etc...) so they should not be searched on since they are unlikely to be the same. The arguments on ORA-7445 errors are usually irrelevant as they are frequently generic ([SIGSEGV], [SIGBUS], [Address not mapped to object], [Invalid address alignment] etc...). If you can identify the type of operation generating the error, then it helps to search on that along with the error. In some cases this will be in the trace file under the heading Current SQL statement for this session. These errors frequently indicate bugs, but can also occur due to other reasons such as hardware/OS problems, corruption, or incorrect environment settings. For example, a corrupt block can signal an ORA-600 error because the information in the header of the block is out of sync. The best way to determine the cause of these errors is to log a tar with support as much of the information in the bugs is viewable only to support. They will need the alert.log (preferably going back to the last startup, but at least the last 3-10 days) along with the trace files generated (upload the whole file, don't just cut and paste portions of it). In the case of multiple errors in the alert.log, supply the trace files from the first couple of errors as often the first error can cause cascading errors. If a trace file is not generated by an ORA-7445, then you should try to extract a stack trace from the core file (see notes 1812.1 and 1007808.6). This needs to be done using the executables that generated the core file, so don't bother sending the core file to support. I'm developing this into a presentation that I hope to present at OpenWorld (ORA-3113's, 600's, and 7445's Oh My!) so please feel free to send me questions or topics I should cover. HTH, -- Anita --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It
RE: ora-600
Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: Deshpande, Kirti 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-600
It means that you should be calling 1-800-223-1711 and have your CSI ready instead of having fun on this mailing list.. -Original Message- Sent: Monday, June 04, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: 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: ora-600
Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: Deshpande, Kirti 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: Kevin Kostyszyn 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-600
Raghu, as Mladen said .. it means that u have hit an oracle bug.. generally the first parameter tells Oracle what code path encountered the bug. Other parameters are specific and relavant measures that might vary based on what the first parameter is. In addition, ora-600 is accompanied by a trace file that dumps a lot of crap in addition to the stack tace that is nothing but the sequence of kernel calls that lead to the failure.. hth Deepak -Original Message- Sent: Monday, June 04, 2001 2:47 PM To: Multiple recipients of list ORACLE-L It means that you should be calling 1-800-223-1711 and have your CSI ready instead of having fun on this mailing list.. -Original Message- Sent: Monday, June 04, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thapliyal, Deepak 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-600
Ora-600 . thats the new race where they make you run around sending them this and that 600 times before they tell you we have no Idea. Its the Oracle Catch-All error. Call Support. They will probably want to see any dump or trace files generated. -Original Message- Sent: Monday, June 04, 2001 5:08 PM To: Multiple recipients of list ORACLE-L Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: Deshpande, Kirti 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: Kevin Kostyszyn 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: Kevin Lange 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-600
ora-600 is a severe error and the codes in parens are debugging codes for Oracle Support CALL SUPPORT when you get an ora-600 and ora-7445 From: Kevin Kostyszyn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ora-600 Date: Mon, 04 Jun 2001 14:08:06 -0800 Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject:ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: Deshpande, Kirti 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: Kevin Kostyszyn 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: Rachel Carmichael 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-600 and iOraBugFinder available
Hi, it's a a good news... and, It's not possible to suggest a bug number. but, bugs are ordered by metalink's score. to narrow down problem, select high level search depth and read high scores first. Rajesh Dayal wrote: Sorry for the delay. Yes you are quite right on this. SHMMAX had a value of 40 M, which I changed to suggested value and things are OK now. We would be benefited more, if these various levels are explained to list. I tried once more generating report through the Tool but it doesn't suggest me about any bug no. directly. Hope this will start working soon perfectly. I am sure this tool would be of great help in crisis. Good work done ;-)) Thanks again, Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of unal-bilisim Sent: Sunday, May 20, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Subject: Ynt: ORA-600 and iOraBugFinder available Hi, iOraBugFinder at level 3 generated following bugs: for ora_3858.trc: - 700613 PL/SQL PROCEDURE FAILS WITH ORA-600 [733] [11976048] [PGA HEAP] - 801644 INSTANCE FAILS TO RESTART (WITH ORA-600 [733]) AFTER UNCLEAN SHUTDOWN for ora_3912.trc: - same bugs your "alter database open" causes these errors. Bug#801644 matches your case. This bug occurs on Digital Unix. I'm pasting relevant part of this Bug#801644: *** It looks like we are hitting this alert because the value of SHMMAX is low (like 4 MB) in your machine. I understand that SHMMAX is 4 MB by default in DEC machine, and skgmqsubareasize() returns the value of SHMMAX. As this is smaller than the size requested by kcratr() who wants SSTTRBUF amount of memory ksm asserts 733. Please try to increase your SHMMAX and see if the problem goes away. *** 01/22/99 12:39 am *** (CHG: Sta-gt;92) Yep, increasing SHMMAX sorted the problem out. Thanks. A bit strange that the low SHMMAX value is only a problem after a shutdown abort, but there you go. *** - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 20, 2001 12:50 PM I was unsuccessfully trying to analyze (on this URL) one of the traces generated due to ORA-600 by one of TEST Database. This ORA-600 looks very funny to me. I just changed the log_archive_dest parameter to a non-existing destination and ORA-600 was there to greet me. Platform TRU64 Unix 4.0F Oracle 8.1.6.0.0 Can someone try to simulate (at your own risk). However trace file is attached and sent separately to [EMAIL PROTECTED] If anybody is interested, I can send directly. Appreciate your opinion, suggestions and ideas Regards, Rajesh -Original Message- Gazi Unal (Unal Bilisim) Sent: Saturday, May 19, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I developed a new web based product named iOraBugFinder. iOraBugFinder scans Oracle's alert log files and ORA-600/ORA-7445 trace files, extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. It's at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html regards... -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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: Rajesh Dayal 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
Re: ORA-600
Zabair I have no idea of argument 17090 but 15212 appeared on our database last week. We have HP-UNIX 11.0.32 with 8.1.6.2. If you check on metalink it says something wrong with PL/SQL code with undetermined reason. You may check on metalink with your complete error code. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 May 2001 02:16:06 -0800 Hello Does anybody know what the following ora 600 relates to, ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Wed May 2 20:51:16 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] Wed May 2 20:51:21 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Wed May 2 20:51:26 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] I got loads of these in the alert log last night when we had a long running query. Everything seems to be ok now but i'm curious what this is. 8.1.7 on Solaris 2.6 Thanks Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed 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).
RE: ora 600
Kevin, I have the same problem with 8.1.6 on NT. It's probably this bug : Bug No. 1365873 Filed 27-JUL-2000 Updated 25-FEB-2001 Product Oracle Server - Enterprise Edition V7 Product Version 8.1.6.1.2 Platform Generic Platform Version No Data Database Version 8.1.6.1.2 Affects Platforms Generic Priority Severe Loss of Service Status Q/A To Development Base Bug N/A Fixed in Product Version 8.1.7.99 Problem statement: ORA-600 INTERNAL ERROR CODE [17182] AFTER SETTING CURSOR_SHARING=FORCE SNIP . ]] Using cursor_sharing = FALSE could corrupt the CGA heap resulting in ]] Ora-600 [17xxx] errors or core dumps. This has been fixed. . Note that this has been fixed in 8.2/9i and so only applies to Oracle8i. *** 01/12/01 11:47 am *** *** 02/16/01 12:40 pm *** *** 02/20/01 10:49 am *** Backported to 8.1.6.4 . *** 02/25/01 11:41 am *** Backported to 8.1.7.2 . __ Neither 8.1.6.4 nor 8.1.7.2 is available yet (at least not on Metalink). Greetings, Frank -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: donderdag 15 maart 2001 16:51 To: Multiple recipients of list ORACLE-L Subject: ora 600 Hi all, Has anyone else experienced an 0ra 600 when using cursor_sharing=FORCE under Windows NT 4.0 Oracle 8.1.6 and 8.1.7? I was hoping it would have been fixed in 8.1.7 but it is not. The only apperent workaround is to alter the session, but I don't want to have to do that. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuijten, F. (Frank) 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 600
I looked it up on metaslow and apperantly it will not be fixed until 8.1.7.2. -Original Message- (Frank) Sent: Friday, March 16, 2001 5:05 AM To: Multiple recipients of list ORACLE-L Kevin, I have the same problem with 8.1.6 on NT. It's probably this bug : Bug No. 1365873 Filed 27-JUL-2000 Updated 25-FEB-2001 Product Oracle Server - Enterprise Edition V7 Product Version 8.1.6.1.2 Platform Generic Platform Version No Data Database Version 8.1.6.1.2 Affects Platforms Generic Priority Severe Loss of Service Status Q/A To Development Base Bug N/A Fixed in Product Version 8.1.7.99 Problem statement: ORA-600 INTERNAL ERROR CODE [17182] AFTER SETTING CURSOR_SHARING=FORCE SNIP . ]] Using cursor_sharing = FALSE could corrupt the CGA heap resulting in ]] Ora-600 [17xxx] errors or core dumps. This has been fixed. . Note that this has been fixed in 8.2/9i and so only applies to Oracle8i. *** 01/12/01 11:47 am *** *** 02/16/01 12:40 pm *** *** 02/20/01 10:49 am *** Backported to 8.1.6.4 . *** 02/25/01 11:41 am *** Backported to 8.1.7.2 . __ Neither 8.1.6.4 nor 8.1.7.2 is available yet (at least not on Metalink). Greetings, Frank -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: donderdag 15 maart 2001 16:51 To: Multiple recipients of list ORACLE-L Subject: ora 600 Hi all, Has anyone else experienced an 0ra 600 when using cursor_sharing=FORCE under Windows NT 4.0 Oracle 8.1.6 and 8.1.7? I was hoping it would have been fixed in 8.1.7 but it is not. The only apperent workaround is to alter the session, but I don't want to have to do that. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuijten, F. (Frank) 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: Kevin Kostyszyn 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).
