Oracle 10gR2/Solaris x64: Must Have Patches for E-Business Suite 11.5.10

If you have an Oracle E-Business Suite 11.5.10 database running on Oracle 10gR2 (10.2.0.2) / Solaris x86-64 platform, make sure you have the following two Oracle patches to avoid concurrency issues and intermittent Oracle shadow process crashes.

1) If the top 5 database timed events look something similar to the following in AWR, it is very likely that the database is running into the bug 4770693 Intel Solaris: Unnecessary latch sleeps by default.

Top 5 Timed Events

Event

Waits

Time(s)

AvgWait(ms)

% TotalCall Time

Wait Class

latch: cache buffers chains

94,301

169,403

1,796

86.1

Concurrency

CPU time

5,478

2.8

wait list latch free

247,466

4,756

19

2.4

Other

buffer busy waits

14,928

1,382

93

.7

Concurrency

db file sequential read

98,750

552

6

.3

User I/O

Apply Oracle server patch 4770693 to get rid of the concurrency issue(s). Note that the fix will be part of 10.2.0.3.

2) If the application becomes unstable and if you notice core dumps in cdump directory, have a look at the corresponding stack traces generated in udump directory. If the call stack looks similar to the following stack, apply Oracle server patch 5666714 to overcome this problem.