oracle 7445,impdp因致命错误终止ORA-7445[kpodpals]-Oracle

基本要素

前天好不容易成功给用户把数据全库导出，今天用户又告知导出的数据无法导入，首先就问用户有什么错误提示，给我的回答是就一个‘作业”SYSTEM”.”SYS_IMPORT_FULL_03″ 因致命错误于 xxxx  elapsed 0 03:01:06 停止’,其他什么提示都没有，信息量太少了，这个处理起来还挺麻烦的。

问题分析

步骤一：首先还是添加跟踪信息

还是得靠自己，还好咱们会点跟踪技巧，具体方法见我之前的文章How to Diagnose Oracle Data Pump-如何给数据泵添加诊断信息，来吧，看下跟踪后的结果orcl_dm00_10856.trc，错误提示的位置如下：

KUPM:13:38:03.378: Log message received from worker DG,KUPC$C_1_20141208103757,KUPC$A_1_103800203000000,MCP,510,Y

KUPM:13:38:03.378: . . 导入了 "ZLHIS"."体检套餐计价" 576.4 KB 20817 行

KUPM:13:38:03.378: ****OUT DISPATCH, request type=3031, response type =2041

*** 2014-12-08 13:38:04.392

KUPM:13:38:04.392: Client count is: 1

KUPM:13:38:04.392: In check_workers...

KUPM:13:38:04.392: Live worker count is: 1

KUPM:13:38:04.392: In set_longops

KUPM:13:38:04.392: Work so far is: 107805.74195098876953125

KUPM:13:38:04.392: Checking for resumable waits

KUPM:13:39:05.435: Client count is: 1

*** 2014-12-08 13:39:05.435

KUPM:13:39:05.435: In check_workers...

KUPM:13:39:05.435: Live worker count is: 0

KUPM:13:39:05.435: worker id is:

KUPM:13:39:05.435: Worker error is: 0

KUPM:13:39:05.435: Exited main loop...

KUPM:13:39:05.435: Returned to MAIN

KUPV:13:39:05.435: Update request for job: SYSTEM.SYS_IMPORT_FULL_03, func: 1

KUPM:13:39:05.435: Entered state: STOPPING

KUPM:13:39:05.435: keeping master because job is restartable

KUPM:13:39:05.435: Final job_info_flags = 1

KUPM:13:39:05.435: Log message received from MCP

KUPM:13:39:05.435: 作业 "SYSTEM"."SYS_IMPORT_FULL_03" 因致命错误于 星期一 12月 8 13:39:05 2014 elapsed 0 03:01:06 停止

KUPM:13:39:05.498: In RESPOND_TO_START

KUPM:13:39:05.498: In check_workers...

KUPM:13:39:05.498: Live worker count is: 0

KUPM:13:39:05.498: worker id is:

KUPM:13:39:05.498: Worker error is: 0

结果非常令人失望，也没什么有价值的错误提示。

步骤二：查看下alert日志

这时候想到查看下alert日志，也许里面能给一些提示，打开日志果然发现了非常有价值的信息，如下：

Tue Dec 09 02:00:00 2014

Closing scheduler window

Closing Resource Manager plan via scheduler window

Clearing Resource Manager plan via parameter

Tue Dec 09 02:00:12 2014

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x0] [PC:0x14575B408, kpodpals()+5174]

ERROR: Unable to normalize symbol name for the following short stack (at offset 213):

dbgexProcessError()+200

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_dw00_5304.trc (incident=8636):

ORA-07445: 出现异常错误: 核心转储 [kpodpals()+5174] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x14575B408] [UNABLE_TO_READ] []

Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\incident\incdir_8636\orcl_dw00_5304_i8636.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.