It sounds like that bug is the one you have hit. The easy way to tell is if the db is started with srvctl you see the low file descriptor warning, if you use sqlplus, you do not. This assumes the ulimit is set correctly for the oracle unix account.
Regards, Greg Rahn http://structureddata.org -------- Original Message -------- Subject: RAC - Low FILE DESCRIPTOR LIMIT From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx> To: Oracle-L <oracle-l@xxxxxxxxxxxxx> Date: 5/9/2007 6:11 AM
Hello. We are on RAC on 64 bit RedHat Linux 2.6.9-34 on 10.2.0.2.0 DB with ASM.I keep getting following message on Alert log of the DB Instances. *"WARNING:Oracle instance running on a system with low open file descriptor limit. Tune your system to increase this limit to avoid severe performance degradation." * I have db_files parameter set at 1000. I have file descriptor at OS level on 64K.I do not know why I am getting this message on the alert log. Has any of you got this? What is the work around?Based on Note 330883.1, I thought we had the bug 4462367 and modified the init.crsd to include ulimit -c unlimited. That has not helped either.My sev 2 TAR [6286597.994] is over a day old, and begging for any response from Oracle.I hope some of the expert good souls here can throw some light. Thanks, Shiva
-- //www.freelists.org/webpage/oracle-l
