ORA-07445: exception encountered: core dump
Oracle defines the ORA-7445 as an unhandled exception error that
could be result of an Oracle bug. The ORA-7445 errors depend on the
version of the Oracle software, OS version.
For more details about the error, you need to check the trace files
generated. The ORA-7445 exception generates a trace file located under
the CORE_DUMP_DEST directory for oracle versions prior to 11g and under
the ADR Home / cdump (Automatic Diagnostic Repository) for 11g versions.
Workaround:
From Oracle trace file, It looks like that the reason of problem is memory issue. So, I decided to
increase SGA and PGA size .After making the changes, the ORA-07445 errors are gone. The database is running fine since one week now without problems.
No comments:
Post a Comment