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
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
4096 Columns1 week ago
-
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment