使用Windows操作系統的DellPcserver，Oracledb報錯：ORA-8103

使用Windows操作系統的DellPcserver，Oracledb報錯：ORA-8103

 

Applies to:

Oracle Database - Personal Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Standard Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Microsoft Windows x64 (64-bit)

Symptoms

ORA-20011: Approximate NDV failed: ORA-12801: error signaled in parallel query server P004
ORA-08103: object no longer exists

KTRVAC: ktrvac returned error=8103

Cause

After identifying the data block causing the ORA-8103 using Note 8103.1, you should look for :

1. The block causing the ORA-8103 will have type: 0x2b=unknown
2. The dump of the block will have the string "7F87312B" at the first 8 bytes of the block were the Type, Format and filler are expected

Example :

buffer tsn: 9 rdba: 0x0b411b1d (45/72477)
scn: 0x000c.bbdc43b5 seq: 0x01 flg: 0x06 tail: 0x43b50601
frmt: 0x01 chkval: 0x9bc1 type: 0x2b=unknown  

Hex dump of corrupt header 4 = CORRUPT
Dump of memory from 0x0000000A405B2000 to 0x0000000A405B2014
A405B2000 7F87312B 0B411B1D BBDC43B5 0601000C [+1....A..C......]
A405B2010 00009BC1 [....]

Solution

This seems to be hardware related problem as the signature [7f87312b] seems to be a common memory overwrite sequence/signature 
found in some crashes reported by customers on Dell R910/R810 series machines.

Contact DELL Support to request for the most up to date BIOS and drivers. Refer to http://social.technet.microsoft.com/Forums/fr-FR/88ba1f9a-e199-4a4b-9652-096154288897/bsoding-with-memorymanagement-1a-in-windows-server-2008-r2?forum=winservergen