ORA-07445 ACCESS_VIOLATION,UNABLE_TO_READ問題處理

今天在處理Windows 平臺的Oracle 10.2.0.3版本資料庫升級到11.2.0.3版本時，系統出現以下的症狀：

-- AlertLOG警告日誌

Wed Dec 04 13:06:24 2013

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x18] [PC:0x2E7368C, hshget1()+198]

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\zh10g\zh10g\trace\zh10g_ora_2488.trc  (incident=25447):

ORA-07445: 鍑虹幇寮傚父閿欒?: 鏍稿績杞?偍 [hshget1()+198] [ACCESS_VIOLATION] [ADDR:0x18] [PC:0x2E7368C] [UNABLE_TO_READ] []

Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\zh10g\zh10g\incident\incdir_25447\zh10g_ora_2488_i25447.trc

Use ADRCI or Support Workbench to package the incident.

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

Wed Dec 04 13:06:26 2013

Dumping diagnostic data in directory=[cdmp_20131204130626], requested by (instance=1, osid=2488), summary=[incident=25447].

Wed Dec 04 13:06:28 2013

Sweep [inc][25447]: completed

Sweep [inc2][25447]: completed

-- INCIDENT日誌

Dump continued from file: D:\APP\ADMINISTRATOR\diag\rdbms\zh10g\zh10g\trace\zh10g_ora_2488.trc

ORA-07445: 出現異常錯誤: 核心轉儲 [hshget1()+198] [ACCESS_VIOLATION] [ADDR:0x18] [PC:0x2E7368C] [UNABLE_TO_READ] []

========= Dump for incident 25447 (ORA 7445 [hshget1()+198]) ========

----- Beginning of Customized Incident Dump(s) -----

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x18] [PC:0x2E7368C, hshget1()+198]

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Process Id: 0x00000538  Thread Id : 0x000009b8    Time : Wed Dec 04 13:06:24 

Excp. Code: 0xc0000005  Excp. Type: ACCESS_VIO    Flags: 0x00000000

------------------- Registers ----------------------------

ip=0000000002E7368C sp=000000001430EDF0 rp=0000000000000001

r1=000007FF37A498A8 r2=0000000000000002 r3=0000000000000000 

r4=0000000000000002 r5=000000001430EDF0 r6=0000000000000001 r7=000007FF3767CA58 

r8=0000000000000000 r9=000007FF37A496D8 r10=0000000000000002 r11=000000000AEB3D78 

r12=0000000000000002 r13=000000000CB36F08 r14=0000000014313370 r15=0000000000000002 

------------------- End of Registers ---------------------

*** 2013-12-04 13:06:24.918

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)

----- Current SQL Statement for this session (sql_id=fyvqzrmdj8g9s) -----

ALTER PACKAGE "SYS"."DBMS_REGISTRY_SYS" COMPILE BODY REUSE SETTINGS

-- 資料庫症狀

SYS@ zh10g SQL>select open_mode from v$database;

OPEN_MODE

----------------------------------------

READ WRITE

SYS@ zh10g SQL>SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual

  2  ;

SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual

*

第 1 行出現錯誤:

ORA-03113: 通訊通道的檔案結尾

程式 ID: 2488

會話 ID: 5 序列號: 5

ERROR:

ORA-03114: 未連線到 ORACLE

解決方案：

ORA-07445: exception encountered: core dump [mdcsgetwkt()+111] [ACCESS_VIOLATION] [ADDR:0x2A8C1928] [PC:0x14691B067] [UNABLE_TO_READ] (Doc ID 1574679.1)

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

On Windows Patch bundles 20-22, creating a Spatial index or running a Spatial query fails with the following errors:

ORA-07445: exception encountered: core dump [mdcsgetwkt()+111] [ACCESS_VIOLATION] [ADDR:0x2A8C1928] [PC:0x14691B067] [UNABLE_TO_READ]

"no more data to read from socket"

 

The call stack in the trace file has the following function calls:

----- Call Stack Trace -----
mdcsgetwkt mdgsetgeocs mdidxs spefcpfa spefmccallstd pextproc psdexsp rpiswu2 psdextp pefccal 

Changes

Installation of Windows Patch bundle 20, 21, or 22

Cause

This issue was identified in the following bug:

Bug 17082161 : ON PATCH 20, 21, SPATIAL QUERIES FAIL WITH ORA-7445 [MDCSGETWKT()+111]
 
The root cause for the core dumps and "no more data to read from socket" errors is the backport fix (BLR) for Bug 16339328: SPATIAL: Performance enhancement to validate_geometry.  
 

Solution

Windows Patch bundle 23 has a new, corrected version of bug fix 16339328. To resolve this issue, install Windows Patch 23 (17163633)

- link  to download patch 17163633 for Microsoft Windows (32-Bit)

- link  to download patch 17163634 for Microsoft Windows (x64)

References

 - ON PATCH 20, 21, SPATIAL QUERIES FAIL WITH ORA-7445 [MDCSGETWKT()+111