ORA-07445: exception encountered: core dump [string] [string] [string] [string] [string] [string] ORACLE 报错 故障修复 远程处理

文档解释

ORA-07445: exception encountered: core dump [string] [string] [string] [string] [string] [string]

Cause: An operating system exception occurred which should result in the creation of a core file. This is an internal error.

Action: Visit My Oracle Support to access the ORA-07445 Lookup tool (reference Note 7445.1) for more information regarding the specific ORA-07445 error encountered. An Incident has been created for this error in the Automatic Diagnostic Repository (ADR). When logging a service request, use the Incident Packaging Service (IPS) from the Support Workbench or the ADR Command Interpreter (ADRCI) to automatically package the relevant trace information (reference My Oracle Support Note 411.1). The following information should also be gathered to help determine the root cause:
– changes leading up to the error
– events or unusual circumstances leading up to the error
– operations attempted prior to the error
– conditions of the operating system and databases at the time of the error Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.

。

ORA-07445错误发生，是由于Oracle数据库内核发生异常导致程序崩溃，产生核心转储文件。

官方解释

ORA-07445错误是一个警告信息，指明了一个函数程序产生了一个程序错误，从而导致了系统生成一个核心转储文件。核心转储文件可以用于帮助分析系统故障原因。

常见案例

ORA-07445错误通常发生在用户访问Oracle数据库时，或者当一个存储过程发生异常时，核心转储文件中可能含有程序崩溃的信息，帮助故障分析。

正常处理方法及步骤

1. 首先，应该查看alert_SID.log文件，记录异常的错误详细信息。

2. 然后，需要查看当前数据库Session的Trace文件，至少有两个信息：session被杀死的信息，以及诊断数据的位置。

3. 接着，压缩生成的核心转储文件、Trace文件和alert_SID.log文件，并将其上传给Oracle官方支持。

4. 最后， 用于分析故障，并由Oracle官方提供一个解决方案并消除ORA-07445错误。