My Oracle Support Banner

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 JULY 27, 2023

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

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=<DIR>/db/apps_st/data/system09.dbf.
found same corrupt data
Reread of blocknum=165656, file=<DIR>/db/apps_st/data/system09.dbf.
found same corrupt data
Reread of blocknum=165656, file=<DIR>/db/apps_st/data/system09.dbf.
found same corrupt data
Reread of blocknum=165656, file=<DIR>/db/apps_st/data/system09.dbf.
found same corrupt data
Reread of blocknum=165656, file=<DIR>/db/apps_st/data

 

Note: <DIR> is a user-defined value, that corresponds to the base directory where Oracle E-Business Suite has been installed.

<DIR>/db (for example, /u01/install/VISION/db)

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

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

<DIR>/db/tech_st/11.1.0>dbv
file=<DIR>/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 = <DIR>/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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.