Owner's Manual

12 Troubleshooting
c 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>’
d Create these entries for each node in the cluster.
e Re-start the database on all nodes by entering the following
commands:
srvctl stop database –d <dbname>
srvctl start database –d <dbname>
f Open the /opt/oracle/admin/<dbname>/bdump/alert_<SID>.log
file, and verify that the private IP addresses are being used for all
instances.
11.1.0.7 RAC Database Instance Hangs at 1000 concurrent user
connections.
Oracle 11.1.0.7 RAC database instance hangs when the number of concurrent
user connections reaches 1000.
Perform the following steps to fix the issue:
a Apply 11.1.0.7 CRS patch # 8287931
b Add a line in the /etc/init.d/init.cssd file as
ULIMIT_FILES= "ulimit -n 65536"
c Add a line in the $ORACLE_HOME/bin/ocssd and
$
ORA_CRS_HOME/bin/ocssd files as ulimit -n 65536 4 .
Modify the
/etc/security/limits.conf as
* soft nofile 327679
* hard nofile 327679
* soft nproc 327679
* hard nproc 327679
d Re-start the database and clusterware.