`
hunxiejun
  • 浏览: 1142419 次
文章分类
社区版块
存档分类
最新评论

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-->
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics