If
you’re an Oracle DBA, you are likely to have come across an error message in
your Oracle Database alert.log files prefixed by either ORA-600 or ORA-7445.
Let’s see when, how and why does these appears.
Example: One
of the ORA 600 could look like as below
ORA 600
[ktfbtgex-7], [1015817] ORA 600 [3600]
ORA 7445
[kewa_dump_time_diff()+157]
The
internal error messages include no attached explanation in the way that
other error messages do (for example
ORA-01017: invalid username/password" while connecting ), it is difficult
to assess the seriousness of the error and whether it is cause for concern.
ORA-600
is a message that indicates an error internal to the database code. Oracle
Database performs checks to confirm that the information being used in internal
processing is healthy, the variables
being used for codes are within a valid range, that changes are being made to a
consistent structure, and that a change won’t put a structure into an unstable
state. If a check fails, Oracle Database signals an ORA-600 error and, if
necessary, terminates the operation to protect the health of the database.
The
first argument to the ORA-600 error message indicates the location in the code
where the check is performed.The subsequent arguments have different meanings,
depending on the particular check.
Whereas,
An ORA-7445 error, on the other hand, traps a notification the operating system
has sent to a process and returns that notification to the user. Unlike the
ORA-600 error, the ORA-7445 error is an unexpected failure rather than a
handled failure.
Both
ORA-600 and ORA-7445 errors will Write the error message to the alert.log,
along with details about the location of a trace containing further
information.
Assessing and resolving ORA-600 and ORA-7445 errors
ORA-600
and ORA-7445 errors, you can either identify the cause and resolve the error on
your own or find ways to avoid the error. The information provided in this
section will help you resolve or work around some of the more common errors.
Example
1: ORA-600 [729]. The first argument to this ORA-600 error message, 729,
indicates a memory-handling issue. The error message text will always include
the words space leak, but the number after 729 will vary:
ORA-00600:
internal error code, arguments: [729], [800], [space leak], [], [],
The
number in the second set of brackets (800) is the number of bytes of memory
discovered. A space leak occurs when some code doesn't completely release the
memory it used while executing. In this example, when that process disconnected
from the database, it discovered that some memory was not cleaned up at some
point during its life and reported ORA-600 [729]. You cannot determine the cause of the space
leak by checking your application code, because the error is internal to Oracle
Database. OR you can enable the tracing
in database to investigate the issue
e.g.
SQL>alter
system set events '10262 trace name context forever, level xxxx' scope=spfile;
Note
: You will also need to shut the database down and restart it to enable the
event to take effect.
Replace
xxxx with a number greater than the value in the second set of brackets in the
ORA-600 [729] error message. In the example above, you could set the number to
1000, in which case the event instructs the database to ignore all user space
leaks that are smaller than 1000 bytes.
Example
2 :
ORA-00600:
internal error code, arguments: [3020], [117], [125002], [352446538], [], [],
[], [], [], [], [], []
ORA-10567:
Redo is inconsistent with data block (file# 117, block# 125002, file offset is
1024016384 bytes)
ORA-10564:
tablespace SYSTEM
ORA-01110:
data file 02: '+DATA01/myprod_host129 /datafile/sysaux_01.422.914282521'
ORA-10561:
block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 119838Incident
details in: /app/ora/local/admin/myprod/diag/rdbms/myprod_host129/myprod/incident/incdir_63521/myprod_mrp0_2616275_i63521.trc
This
error tells that there is issue with datafile #02. It could be corruption on
file system or a block corruption on DB level. How
I solved this one, Check this post.
Example
3 :
ORA-600
[6033]. This error is reported with no additional arguments, as shown in the
following alert.log file describes :
bdump/prod_ora_4345618.trc:
ORA-600:
internal error code, arguments: [6033], [], [], [], [], [], [], []
The ORA-600 [6033] error often indicates an index corruption. To identify the affected index, you’ll need to look at the associated trace file whose name is provided in the alert.log file, just above the error message. In this alert.log excerpt, the trace file you need to look at is called prod_ora_4345618.trc which is located in /bdump directory. There are two possible ways to identify the table on which the affected index is built: Look for the SQL statement that was executing at the time of the error. This statement should appear at the top of the trace file, under the heading “Current SQL Statement.” The affected index will belong to one of the tables accessed by that statement.
Example
4 :
ERROR
at line 1:
ORA-00600:
internal error code, arguments: [kfgpCreate_60], [10], [2], [65535], [65535],
[65535], [65535], [], [], [], [], []
This
will issue appear while dropping disk in ASM.
As
per MOS it’s a bug (metalink doc
2031394.1). Here is the post how I solved it
Oracle
Database users with Oracle support introduces support for the ORA-600/ORA-7445
lookup tool Knowledge on this Article 153788.1 it enables you to enter the
first argument to an ORA-600 or ORA-7445 error message and use that information
to identify known defects, workarounds, and other knowledge targeted
specifically to that error/argument combination.
