Owner's Manual

46 Deployment Guide
Troubleshooting
Table 1-8 provides recommended actions for problems that you may encounter while deploying and
using your Red Hat Enterprise Linux and 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 nod e :
1 Log in as oracle .
2 Type 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 nodes by typing the
following lines:
srvctl stop database –d <dbname>
srvctl start database –d <dbname>
5 Open the
/opt/oracle/admin/< dbname >/bdump/
alert_<
SID >.log file and verify that the private
IP addresses are being used for all instances.