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<-dbgeExecuteForError()+65<-dbgePostErrorKGE()+2269<-dbkePostKGE_kgsf()+77<-kgeade()+562<-kgerelv()+151<-kgerev()+45<-kgerec5()+60<-sss_xcpt_EvalFilterEx()+1862<-sss_xcpt_EvalFilter()+174<-.1.4_5+59<-0000000077C985A8<-0000000077CA9D0D<-0000000077C991AF<-0000000077CD1278<-kpodpals()+5174<-kpodpp()+4946<-opiodr()+1631<-kpoodr()+699<-xupirtrc()+2833<-upirtrc()+117<-kpurcsc()+150<-kpudpxp_ctxPrepare()+19418<-OCIDirPathPrepare()+11<-kupd_initDirPath()+1048<-kupdls()+2863<-spefcifa()+3937<-spefmccallstd()+532<-pextproc()+47<-PGOSF493_peftrusted()+134<-psdexsp()+297<-rpiswu2()+3039<-psdextp()+951<-pefccal()+785<-pefcal()+225<-pevm_FCAL()+164<-pfrinstr_FCAL()+69<-pfrrun_no_tool()+77<-pfrrun()+1241<-plsql_run()+903<-peicnt()+328<-kkxexe()+616<-opiexe()+20959<-kpoal8()+2397<-opiodr()+1631<-kpoodr()+699<-xupirtrc()+2833<-upirtrc()+117<-kpurcsc()+150<-kpuexec()+10984 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.
