Sunday, June 6, 2010

ORA-00600: internal error code

ORA-00600: internal error code
====================================

Today i face a problem. problem is, when i am tring to update a table with oracle form6i
whenever I am pressing F10(save), first time it saves but after the second time
it hang and shows message "Connection timeout....."
at the same time i found in alertlog the follwoing error message..

"ORA-00600: internal error code"

At that time i searching the oracle Forms code and found there have many variable
are assign by dual table like :-

select trunc(sysdate)
into v_date
from dual ;


whenever i replace all dual table assignment by directly

then the problem is out.....................



ORA-00600 is an internal error
================================

ORA-600 is an internal error generated by the generic kernel code of the Oracle RDBMS software.


1. Each ORA-00600 error generates a database trace file.
You can find in Details about the application code involve with this error.



2. Each ORA-00600 error comes with a list of arguments They usually enclosed in
square brackets and follow the error on the same line for example:

ORA-00600 [14000][51202][1][51200][][]

Each argument has a specific meaning which can only be interpreted by an Oracle
support analyst. The arguments may also change meaning from version to version.



Possible causes
========================
Possible causes include:

1. time-outs,
2. file corruption,
3. failed data checks in memory, hardware, memory, or I/O messages,
4. incorrectly restored files
5. SELECT FROM DUAL statement in PL/SQL within Oracle Forms (you have to use SELECT FROM SYS.DUAL instead!)



How to fix it
========================
Contact Oracle Support with the following information:

1. events that led up to the error
2. the operations that were attempted that led to the error
3. the conditions of the operating system and database at the time of the error
4. any unusual circumstances that occurred prior to receiving the ORA-00600 message.
5. contents of any trace files generated by the error
6. the relevant portions of the Alert file
7. in Oracle Forms PL/SQL, use SELECT FROM SYS.DUAL to access the system "dual" table




Another way may be it will be fix
===================================

The BUG is fixed in 10.1.0.4 Server Patch Set


ORA-00600: internal error code, arguments: [17183], [0xA2C0044], [], [], [], [], [], []

It is reported as BUG.

It can be found in Oracle 9i,10gr2.

The BUG is fixed in 10.1.0.4 Server Patch Set

Kindly Refer Metalink Note: 3350337.8



Another problem like this and solution
=======================================

ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []

ORA-600 [kjhn_post_ha_alert0-862] Continuously Repeated in the Alert Log - 401640.1


metalink Doc ID: 401640.1

solutions:
-----------

1. Log in as SYS
2. SQL> truncate table recent_resource_incarnations$
3. Shutdown DB
4. Startup DB

No comments: