exited
oracle7445,impdp因致命错误终⽌ORA-7445[kpodpals]-
Oracle
基本要素
前天好不容易成功给⽤户把数据全库导出，今天⽤户⼜告知导出的数据⽆法导⼊，⾸先就问⽤户有什么错误提⽰，给我的回答是就⼀个‘作业”SYSTEM”.”SYS_IMPORT_FULL_03″ 因致命错误于 xxxx  elapsed 0 03:01:06 停⽌’，其他什么提⽰都没有，信息量太少了，这个处理起来还挺⿇烦的。
问题分析
步骤⼀：⾸先还是添加跟踪信息
还是得靠⾃⼰，还好咱们会点跟踪技巧，具体⽅法见我之前的⽂章How to Diagnose Oracle Data Pump-如何给数据泵添加诊断信息，来吧，看下跟踪后的结果orcl_，错误提⽰的位置如下：
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
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
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
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
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_ (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_
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。