Search This Blog

Sunday, May 6, 2012

Database Crashes With ORA-221, ORA-206, ORA-202, ORA-27072

Database Crashes With ORA-221, ORA-206, ORA-202, ORA-27072

One of my TEST database crashed with the above error.



Reason: it is due to BUG.



Solution: Apply the following patch 4401119



Solution



Workaround:

None. However the default server settings for AIX are:

MINIMUM number of servers [1]

MAXIMUM number of servers per cpu [100]

Maximum number of REQUESTS [4096]



This problem is improved slightly by changing the above values to something like:

MINIMUM number of servers (minservers) [64]

MAXIMUM number of servers per cpu(maxservers) [256]

Maximum number of REQUESTS (maxreqs) [8192]

Solution:

Apply patch 4401119 for the applicable Oracle version and Operating System



The issue is fixed in

10.1.0.5 (Server Patch Set)

10.2.0.2 (Server Patch Set)

11.1.0.6 (Base Release)

Please refer to

Note 4401119.8 - Bug 4401119 - AIX: Crash possible on AIX (ORA-206)



Metalink NOTE: [ID 332867.1]

No comments: