ORA-0600 Internal Error

Hello every body

 I m facing following errors in my database ORACLE 8.1.7.2.1 installed on WIN2K Advanced Server
having 4 GB RAM.
The Errors are :
======================================================
ORA-00600: internal error code, arguments: [17182], [482029052], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [482054636], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [475897848], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [475867112], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [475872856], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [475782312], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [502871916], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [502871944], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [502865160], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [804855048], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [17182], [1096672444], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [1120623960], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [1125735804], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [kqlblfc-1], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [kcoadd_size], [1684187188], [65535], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcoadd_size], [1918937140], [65535], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcoadd_size], [1650632756], [65535], [], [], [], [], []
=============================================================

rest of operations are working properly in Database but when i use to_char function with Group by clause, then prolem arises. Aslo when i use decode function, the problem also arises.

Any body can help to resolve the issue ?

Thanks in advance
LVL 7
FayyazAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

schwertnerCommented:
You need upgrade to 8.1.7.4 or bettre to 9.2.0.6.


Oracle Server - Enterprise Edition - Version: <8.1.7.4
This problem can occur on any platform.
Oracle RDBMS Server Versions < 8.1.7.4
Errors
ORA-600 [17182] "Heap chunk header BAD MAGIC"
Symptoms
Intermittent Heap Corruptions errors like ora-00600 [17182] reported in the alert.log file.
No impact to the database other than the process which encounters the errors getting killed.
Cause
From the trace file generated for this ora-00600 error , check if the top few functions are :
kgherror kghfrf kkscls opicca

Also note that the initial few functions in the call stack that begin kg* and ks* are usually ignorable.

If the trace file shows that kkscls calls kghfrf , then it is related to
Bug:2281320 -- ORA-600[17182] POSSIBLE AFTER CTRL-C OR CLIENT DEATH
Fix
The problem is caused because of the Oracle Bug :
2281320 -- ORA-600[17182] POSSIBLE AFTER CTRL-C OR CLIENT DEATH

Problem is when we call kghfrf to free a chunk of Memory we expect that this chunk to have been allocated from the Heap Memory and hence have a valid header although internally we have used Frame Memory managed chunk. As a result , kghfrf errors out with the "Bagic Magic Number" in the Memory Chunk header error message.

If you are running Oracle 8174 , encounter this ora-00600 [17182] and the call stack indicates the following functions { kgherror kghfrf kkscls } then download and apply Patch:2281320 from Metalink. This issue has been fixed in Oracle Server 8.1.7.5 and later versions.

Note: 2281320 is not limited to dblinks and can occur during normal database operation as well.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sujit_kumarCommented:
Ora-600 alone does not specify any thing. See the associated trace log or alert log file for the actual error.
jaspreet_bajajCommented:
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:
1. timeouts
2. file corruption
3. failed data checks in memory
4. hardware, memory, or I/O errors
5. 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 Support Services 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.
 
********************************************************
If you have registered product
Goto http://www.oracle.com/support/metalink/index.html
(OracleMetaLink is FREE for Oracle customers with current product support contracts.)

Use these
How to deal with ORA-600 Internal Errors
http://metalink.oracle.com/metalink/plsql/showdoc?db=Not&id=144652.1

How to find the offending SQL from a trace file
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=154170.1%20&blackframe=0

Troubleshoot an ORA-600 Error Using the ORA-600 Argument Lookup Tool
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=153788.1


*********************************************************
Use this free bug finder
http://www.ubtools.com/cgi-bin/ib/ikonboard.cgi?act=Pages;page=iorabugfinder
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

jaspreet_bajajCommented:

U need to register but its free

*********************************************************
Use this free bug finder
http://www.ubtools.com/cgi-bin/ib/ikonboard.cgi?act=Pages;page=iorabugfinder

*********************************************************

FayyazAuthor Commented:
Dear Jaspreet_bajaj

as u r saying that the errors may be due to following reasons

1. timeouts
2. file corruption
3. failed data checks in memory
4. hardware, memory, or I/O errors
5. incorrectly restored files

I just want to clarify the steps, so that i can able to check each and every thing relating to S.No.2) file corruption and S.No. 5).incorrectly restored files

Can u tell how can i check which file(s) are corrupted regarding S.No.2 and
which files u think may be accidently restored incorrectly regarding S.No.5

please tell , so that i check especifically for that area

thanks
jaspreet_bajajCommented:
First important thing is trace file
Have you got Tracing On?? if not
Set trace on, and check the contents of the trace files generated by the error.
Also check the relevant portions of the Alert file

The author has experienced this error a few times, and in each situation, he found it was a memory issue. Consider increasing the size of the table space where the tables will be created

In your case it can be problem with space in Tempory Table space which is used for sorting operation... try to create a bigger Temp Table space

If all else fails, report to Oracle Support. It may be something inherently more serious.

Jaspreet
jaspreet_bajajCommented:

You can also try this tool. iOraBugFinder is a free product.
If you are not subscribed yet, subscribe here.
http://www.ubtools.com/cgi-bin/ib/ikonboard.cgi?act=Pages;page=iorabugfinder

Hope it helps

Jaspreet
FayyazAuthor Commented:
i have come to know that the package DBMS_SHARED_POOL is invalid .

are there any problem due to this package?

how to re-create this package again and in which schema ?

i checked Iorabugfinder, but it tell that check on Metalink, but i have no account to access Metalink and also i have not code to register?

can any body tell me the code to register with Metalink

regards
schwertnerCommented:
seems you have upgraded the oracle version and have forgoten to run ... rpm.sql (see README.HTM of the upgrade kit) that compiles all invalid program objects.
FayyazAuthor Commented:
I have upgraded my DB 8.1.7 to 9.2.0.1.0, now the problem is ORA-03113:end-of-file on communication channel. This problem occurs on some queries of select and insert. Also some remote procedures can not compile and when we check it at back end- the problem reported by the clients is ORA-03113. When i checked the ALERT Log file, the problem is old :

Mon Jul 25 17:07:15 2005
Errors in file e:\oracle\admin\starr\udump\starr_ora_1976.trc:
ORA-00600: internal error code, arguments: [qerrmOFBu1], [3113], [], [], [], [], [], []

Mon Jul 25 17:07:16 2005
Errors in file e:\oracle\admin\starr\udump\starr_ora_1976.trc:
ORA-00600: internal error code, arguments: [qerrmOFBu1], [3113], [], [], [], [], [], []

Any help

Fayyaz
schwertnerCommented:
Now you have to upgrade to 9.2.0.5 or 6 according the OS you use.
9.2.0.1.0 is very bugy and there is no reason to try to use it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.