Owner's Manual

Deployment Guide 43
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.
Enterprise
Manager
The Enterprise
Manager agent goes
down or fails.
The Enterprise
Manager repository
is not populated.
Type the following to recreate the configuration file and
repository for the DB Console:
emca -config dbcontrol db repos
recreate
For detailed instructions, see Oracle Metalink Note
330976.1.
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 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 >.l
og
file and verify that the private IP addresses are being
used for all instances.
OCFS When you type
service o2cb
start, the
procedure fails.
SELinux is enabled. Disable SELinux by following the steps in the section
"Configuring Shared Storage for Clusterware."