RE: ora-600 / ora-00604 during migrate

2003-11-21 Thread Jeroen van Sluisdam
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

RE: ora-600 / ora-00604 during migrate

2003-11-20 Thread DENNIS WILLIAMS
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

RE: ora-600 / ora-00604 during migrate

2003-11-20 Thread Jeroen van Sluisdam
-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

RE: ora-600 / ora-00604 during migrate

2003-11-20 Thread Igor Neyman
: 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

Re: ora-600 question

2003-10-28 Thread John Shaw
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], [], [],

RE: ora-600 question

2003-10-28 Thread Jesse, Rich
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

RE: Re: ora-600 question

2003-10-28 Thread Odland, Brad
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

Re: Re: ora-600 question

2003-10-28 Thread John Shaw
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

Re: Re: ora-600 question

2003-10-28 Thread ryan_oracle
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

Re: Re: ora-600 question

2003-10-28 Thread Tanel Poder
/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

Re: Re: ora-600 question

2003-10-28 Thread Yong Huang
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

Re: Re: ora-600 question

2003-10-28 Thread Tanel Poder
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

RE: ORA-600 Error [Possible Data Loss]

2003-09-22 Thread MacGregor, Ian A.
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

Re: ORA-600 Error [Possible Data Loss]

2003-09-18 Thread Tanel Poder
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

RE: ORA-600 Error [Possible Data Loss]

2003-09-18 Thread MacGregor, Ian A.
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

Re: ORA-600 Error [Possible Data Loss]

2003-09-18 Thread Tanel Poder
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

Re: ORA-600 Error [Possible Data Loss]

2003-09-18 Thread Tanel Poder
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

RE: ORA-600 Error [Possible Data Loss]

2003-09-18 Thread MacGregor, Ian A.
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

Re: ORA-600

2003-09-16 Thread Hemant K Chitale
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]

RE: ORA-600

2003-09-16 Thread Jamadagni, Rajendra
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 !

RE: ora-600 when analyzing IOT

2003-08-14 Thread Igor Neyman
]To: [EMAIL PROTECTED] on.com cc: [EMAIL PROTECTED] Subject: RE: ora-600 when analyzing IOT 08/07/2003 12:13 PM Rick

RE: ora-600 when analyzing IOT

2003-08-14 Thread Igor Neyman
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-

RE: ora-600 when analyzing IOT

2003-08-14 Thread Rick_Cale
] on.com cc: [EMAIL PROTECTED] Subject: RE: ora-600 when analyzing IOT

Re: ora-600 when analyzing IOT

2003-08-14 Thread Rick_Cale
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

RE: ora-600 when analyzing IOT

2003-08-07 Thread Alexander . Feinstein
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

RE: ora-600 when analyzing IOT

2003-08-07 Thread Rick_Cale
cc: Sent by: Subject: RE: ora-600 when analyzing IOT [EMAIL PROTECTED

RE: ora-600 errors for X_$KCBCBH x_$kcbrbh

2003-07-18 Thread Vergara, Michael (TEM)
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

RE: ORA-600 [12501] Error ??

2003-03-31 Thread Jacques Kilchoer
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

Re: ORA-600 error(solution for all of them).

2002-12-13 Thread Joe Testa
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

RE: ORA-600 error(solution for all of them).

2002-12-12 Thread Jerry Hess
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

RE: ORA-600 error(solution for all of them).

2002-12-12 Thread Jeremy Pulcifer
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

Re: ORA-600

2002-10-26 Thread Jared Still
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

RE: ORA-600

2002-10-23 Thread DENNIS WILLIAMS
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:

RE: ORA-600

2002-10-23 Thread Arun Chakrapanirao
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:

Re: ORA-600

2002-10-23 Thread Joe Testa
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], [], []

Re: ORA-600

2002-10-23 Thread Stephane Faroult
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 --

RE: ORA-600 on insert over dblink to RDB

2002-08-16 Thread DENNIS WILLIAMS
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

Re: ORA-600 on insert over dblink to RDB

2002-08-16 Thread dunal (ubTools)
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

Re: ORA-600 during replication

2002-07-01 Thread Stephane Faroult
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

Re: ORA-600 during replication

2002-07-01 Thread Danisment Gazi Unal (ubTools)
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

Re: ORA-600 during replication

2002-07-01 Thread Alessandro Guimaraes
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

Re: ORA-600 during replication

2002-07-01 Thread Jared . Still
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:

RE: ORA-600

2002-05-31 Thread Michael P Sale
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

RE: ORA-600

2002-05-31 Thread Nalla Ravi
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

Re: ORA-600

2002-05-31 Thread Danisment Gazi Unal (ubTools)
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

Re: ORA-600

2002-05-27 Thread Chris McGrail
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:

RE: Ora-600

2002-05-26 Thread DENNIS WILLIAMS
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

RE: Ora-600

2002-05-26 Thread Nalla Ravi
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

RE: ORA-600 [3708] During Database SHUTDOWN

2002-05-22 Thread K Gopalakrishnan
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

RE: ORA-600 Error

2002-04-01 Thread CHAN Chor Ling Catherine (CSC)
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

RE: ORA-600 Error

2002-03-31 Thread John Kanagaraj
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

RE: ORA-600 [1158] on 8.1.7

2002-03-04 Thread Veronica Levin
: 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

Re: ORA-600 [1158] on 8.1.7

2002-02-14 Thread Mohammad Rafiq
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]

RE: ORA-600 Parser...

2002-01-09 Thread Jamadagni, Rajendra
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:

Re: ORA-600 Parser...

2002-01-09 Thread Jared . Still
Interesting, thanks for the link. Jared HAWKINS, JAMES W

RE: ORA-600 and ORA-603 issues with dlm resource hash list

2001-12-17 Thread Mohan, Ross
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

RE: ORA-600 and ORA-603 issues with dlm resource hash list

2001-12-17 Thread Sherman, Paul R.
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

RE: ORA-600 and ORA-603 issues with dlm resource hash list

2001-12-17 Thread Mohan, Ross
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

RE: ORA-600 and ORA-603 issues with dlm resource hash list

2001-12-17 Thread Scott
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

Re: ORA 600 error can't find reference on Metalink

2001-11-15 Thread K Gopalakrishnan
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 ? ---

RE: ORA 600 error can't find reference on Metalink

2001-11-15 Thread Jamadagni, Rajendra
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

Re: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.

2001-09-20 Thread JOE TESTA
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

RE: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.

2001-09-20 Thread Mark Leith
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

Re: ora-600/ora07445

2001-09-03 Thread Joe Testa
ÌÌÌ X-Declude-Sender: [EMAIL PROTECTED]

RE: ora-600/ora07445

2001-08-08 Thread Smith, Ron L.
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

Re: ora-600/ora07445

2001-08-08 Thread Scott Shafer
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

Re: ora-600/ora07445

2001-08-08 Thread Mario
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

Re: ora-600/ora07445

2001-08-08 Thread K Gopalakrishnan
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 !!

Re: ora-600 ..sort extent pool??

2001-08-06 Thread Christian Trassens
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

Re: ora-600 ..sort extent pool??

2001-08-04 Thread Jon Walthour
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

Re: ora-600 ..sort extent pool??

2001-08-04 Thread Raghu Kota
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

Re: ora-600 ..sort extent pool??

2001-08-04 Thread Raghu Kota
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

Re: ora-600 ..sort extent pool??

2001-08-04 Thread Joe Testa
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.

Re: Ora-600 : Internal error code.. Help!!!

2001-06-13 Thread Danisment Gazi Unal (Unal Bilisim)
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 i

RE: Ora-600 : Internal error code.. Help!!!

2001-06-12 Thread Van M. Etheridge
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

Re: Ora-600 : Internal error code.. Help!!!

2001-06-12 Thread Danisment Gazi Unal (Unal Bilisim)
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],

RE: Ora-600 : Internal error code.. Help!!!

2001-06-12 Thread Kevin Lange
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

RE: Ora-600 : Internal error code.. Help!!!

2001-06-12 Thread Koivu, Lisa
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!!!

2001-06-12 Thread Kevin Lange
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

Re: ora-600

2001-06-05 Thread Danisment Gazi Unal (Unal Bilisim)
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

RE: ora-600

2001-06-05 Thread A. Bardeen
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

Re: ora-600

2001-06-05 Thread Mogens Nørgaard
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 :) )

RE: ora-600

2001-06-04 Thread Deshpande, Kirti
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, -

RE: ora-600

2001-06-04 Thread Gogala, Mladen
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,

RE: ora-600

2001-06-04 Thread Kevin Kostyszyn
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

RE: ora-600

2001-06-04 Thread Thapliyal, Deepak
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

RE: ora-600

2001-06-04 Thread Kevin Lange
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:

RE: ora-600

2001-06-04 Thread Rachel Carmichael
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

Re: ORA-600 and iOraBugFinder available

2001-05-20 Thread Danisment Gazi Unal (Unal Bilisim)
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

Re: ORA-600

2001-05-03 Thread Mohammad Rafiq
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

RE: ora 600

2001-03-16 Thread Kuijten, F. (Frank)
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

RE: ora 600

2001-03-16 Thread Kevin Kostyszyn
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 :