【翻译自mos文章】使用Windows操作系统的Dell Pcserver，Oracle db报错：ORA-8103

sweli

　　

翻译自mos文章：使用Windows操作系统的Dell Pcserver，Oracle db报错：ORA-8103
　　ORA-8103 using Windows platform and DELL servers (Doc ID 1921533.1)
　　

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