Owner's Manual

56 Deployment Guide
Troubleshooting
Table 1-9 provides recommended actions for problems that you may encounter while deploying and
using your Red Hat Enterprise Linux and Oracle software.
Table 1-9. Troubleshooting
Category Problem / Symptom Cause Recommended Corrective Action
Database Nodes that start up
correctly with
Patchset 10.2.0.1
may fail to start up
with ORA-4031
errors in Patchset
10.2.0.2.
RAC instances with
greater than 4 Gb
db_cache_sizes.
Set the variable set _ksmg_granule_size=
16777216 in the init.ora file.
Database Lock Manager
Service (LMS) crash
with ORA-00600
error: internal error
code, arguments:
[kclastf_1], [2], [].
Due to Oracle bug
5071492. See the
Oracle Metalink
website at
metalink.oracle.com.
Apply patch 5071492 available on the Oracle Metalink
website at metalink.oracle.com.
Database The instance can
terminate with
ORA-600 error
[kclcls_5] in the
RAC instance.
Due to Oracle bug
4639236. See the
Oracle Metalink
website at
metalink.oracle.com.
Apply patch 4639236 available on the Oracle Metalink
website at metalink.oracle.com.
Database ERROR IN KQLM-
BIVG SEE LCK
TRACE FILE"
[LT] [LB]
KJUSERCLIENT-
LOCK
Due to Oracle bug
4690794. See the
Oracle Metalink
website at
metalink.oracle.com.
Apply patch 4690794 available on the Oracle Metalink
website at metalink.oracle.com.
Database LMD0 PROCESS
RECEIVED OS
SIGNAL #11
Due to Oracle bug
5036588. See the
Oracle Metalink
website at
metalink.oracle.com.
Apply patch 5036588 available on the Oracle Metalink
website at metalink.oracle.com.
Performance
and stability
Red Hat Enterprise
Linux exhibiting
poor performance
and instability.
Excessive use of
swap space.
The Oracle System
Global Area (SGA)
exceeds the
recommended size.
• Ensure that the SGA size does not exceed 65% of total
system RAM.
•Type
free at a command prompt to determine total
RAM and reduce the values of
db_cache_size and
shared_pool_size parameters in the Oracle
parameter file accordingly.