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

最新推荐文章于 2025-12-04 15:25:15 发布

最新推荐文章于 2025-12-04 15:25:15 发布 · 141 阅读

文章标签：

#数据库

此文章描述了Oracle 10g在IBMAIX5L系统上可能遇到的数据库崩溃问题，错误涉及ORA-221、ORA-206等，并提供了调整服务器设置的工作区解决方案。

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