Oracle Bug 4401119 for AIX Database crashes with ORA-221, ORA-206, ORA-202, ORA-27072

Bug4401119AIX:CrashpossibleonAIX(ORA-206)

Thisbugismarkedasanimportantissue.

Affects:

Product(Component)	OracleServer(Rdbms)
Rangeofversionsbelievedtobeaffected	Versions<11
Versionsconfirmedasbeingaffected	·10.1.0.2 ·10.1.0.3 ·10.1.0.4 ·10.2.0.1
Platformsaffected	·IBMAIX5LBasedSystems(64bit)

Fixed:

Thisissueisfixedin	·10.1.0.5(ServerPatchSet) ·10.2.0.2(ServerPatchSet) ·11.1.0.6(BaseRelease)
Symptoms:	RelatedTo:
·ErrorMayOccur ·Corruption ·InstanceMayCrash ·ORA-206/ORA-27072	·(NoneSpecified)

Appliesto:

OracleServer-EnterpriseEdition-Version:10.1.0.2to10.1.0.4,10.2.0.1
AIX5LBasedSystems(64-bit)

Purpose

Alertuserstopossibledatabasecrasheswitherror221unabletowritetocontrolfileonAIX5L.Theerrorstackthatisgeneratedis:

ORA-00221:erroronwritetocontrolfile
ORA-00206:errorinwriting(block3,#blocks1)ofcontrolfile
ORA-00202:controlfile:'/u03/oradata/paimg/control03.ctl'
ORA-27072:FileI/Oerror
IBMAIXRISCSystem/6000Error:22:Invalidargument
Additionalinformation:7

ScopeandApplication

ThisproblemisspecifictoOracle10gonAIX5L.

DatabasecrasheswithORA-221,ORA-206,ORA-202,ORA-27072

Impact:

Thedatabaseimpactisseveresinceitcausesthedatabasetocrash.Inadditionthiserrorisusuallytheresultofaresource
exhaustion.Soonceitisencountereditismorethanlikelythatthisproblemwillbeencounteredagainontheproduction
system.

Workaround:

None.HoweverthedefaultserversettingsforAIXare:

MINIMUMnumberofservers[1]
MAXIMUMnumberofserverspercpu[100]
MaximumnumberofREQUESTS[4096]

Thisproblemisimprovedslightlybychangingtheabovevaluestosomethinglike:

MINIMUMnumberofservers(minservers)[64]
MAXIMUMnumberofserverspercpu(maxservers)[256]
MaximumnumberofREQUESTS(maxreqs)[8192]

Solution:

Applypatchforbug4401119

References

BUG:4401119-DatabaseDownWithControlfileCorruption

<!--EndFragment-->