Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Monday, 30 July 2012

ORA-600 and ORA-7445 errors

ORA-7445 and ORA-600 messages are internal errors of oracle In general, should be reported to Oracle. Here we should consider the some arguments that follow these errors. Because there are many reasons for that error and that argument tells, in which area one should look for, to resolve this error.
ORA -600
It contains all internal error messages for Oracle program exceptions. It indicates that a process has met a low-level, unexpected condition.
Possible Causes:
– time-outs,
– file corruption,
– failed data checks in memory,
– While recompiling stored PLSQL if a procedure/function argument name matches to a
    column name referred to in that function/procedure.
– Hardware, memory, or I/O errors,
– incorrectly restored files

What to Do?
Report to Oracle support for this error as a bug. Submit with the SR the following details:
-         Internal error number.
-         Alert. log
-         Trace Files
-         Describe what was happening when you had these errors. This would provide more insight on the type of error.
Note: Try to avoid free help when you have ORA-600 and ORA-07445. These errors could be because of BUGS. Oracle Support will know this from the call stack in the trace file.
ORA-7445
An operating system exception occurred which should result in the creation of a core file.
We have to apply the patch sets or patch to resolve that internal errors. 

1 comments:

  1. Dear Shahid,

    The post is really very informative. As per my work experience, I found that in most of the cases 'ORA -600' error occurs because of file corruption. Oracle inbuilt utility RMAN help in this case. But when oracle database inbuilt utility get failed to repair corrupt file then third party Oracle database recovery helps users to repair corrupt file. Stellar Phoenix Oracle Database Recovery Software is one of the best tool!!

    ReplyDelete