Deployment Guide

Deployment Guide 55
Troubleshooting
Table 1-8 provides recommended actions for problems that you may encounter while deploying and
using your Red Hat Enterprise Linux and the Oracle software.
Table 1-8. Troubleshooting
Category Problem / Symptom Cause Recommended Corrective Action
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.
Performance
and stability
Unknown interface
type warning
appears in Oracle
alert file.
Poor system
performance.
The public interface is
configured as cluster
communications (private
interface).
Force cluster communications to the private
interface by performing the following steps
on
one node :
1 Log in as oracle .
2 Ty p e sqlplus "/ as sysdba"
at the command prompt.
The
SQL> prompt appears.
3 Enter the following lines at the SQL> prompt:
alter system set
cluster_interconnects=’
<private IP address node1>’
scope=spfile sid=’<SID1>’
alter system set
cluster_interconnects=’
<private IP address node2>’
scope=spfile sid=’<SID2>’
Continue entering lines for each node in
the cluster.
4 Restart the database on all the nodes by typing:
srvctl stop database –d <dbname>
srvctl start database –d <dbname>
5 Open the
/opt/oracle/admin/< dbname >/bdump/
alert_<
dbname >.log file and verify that
the private IP addresses are being used for
all instances.