More than 20000 Blocks Corrupted in system09.dbf After Fresh Installation of E-Business Suite R12.1.1 on Linux x86_64 Platform (Doc ID 840963.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Applications Manager - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Applications DBA - Version 12.1.3 to 12.1.3 [Release 12.1]
Linux x86-64
***Checked for relevance on 05-June-2013***

Symptoms

Once the  FRESH (PROD instance) installation of  Oracle E-Business Suite 12.1.1 on Linux x86_64 platform completed successfully,  I checked datafiles via dbv utility and I found 26473 blocks corrupt  in system09.dbf datafile.

Corrupt block relative dba: 0x58028718 (file 352, block 165656)
Completely zero block found during backing up datafile
Reread of blocknum=165656, file=/d02/oracle/R1211/db/apps_st/data/system09.dbf.
found same corrupt data
Reread of blocknum=165656, file=/d02/oracle/R1211/db/apps_st/data/system09.dbf.
found same corrupt data
Reread of blocknum=165656, file=/d02/oracle/R1211/db/apps_st/data/system09.dbf.
found same corrupt data
Reread of blocknum=165656, file=/d02/oracle/R1211/db/apps_st/data/system09.dbf.
found same corrupt data
Reread of blocknum=165656, file=/d02/oracle/R1211/db/apps_st/data

 

All blocks is clear (Completely zero block found during dbv).

Check the corruption
~~~~~~~~~~~~~~~~~

/d1/bug8561151/oracle/PROD/db/tech_st/11.1.0>dbv
file=/d1/bug8561151/oracle/PROD/db/apps_st/data/system09.dbf

DBVERIFY: Release 11.1.0.7.0 - Production on Mon Jun 8 13:28:55 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

DBVERIFY - Verification starting : FILE = /d1/bug8561151/oracle/PROD/db/apps_st/data/system09.dbf


DBVERIFY - Verification complete

Total Pages Examined : 128000
Total Pages Processed (Data) : 52119
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 26470
Total Pages Failing (Index): 0
Total Pages Processed (Other): 2123
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 47288
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 3712614476 (1388.3712614476) 

 

NB:

The R12.1.1 Media Distribution "Part number B54465" were downloaded from E-Delivery resource : https://edelivery.oracle.> />com> />

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms