Home » Infrastructure » Linux » Oracle instance running on a system with low open file descriptor limit (Linux)
Oracle instance running on a system with low open file descriptor limit [message #423310] Wed, 23 September 2009 05:34 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

In my alert log, i am getting following errors:

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.

select count(*) from dba_data_files;
count(*)
---------
43


ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 139263
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

[root@dbprod ~]# ulimit -n
1024

[root@dbprod ~]# uname -a
Linux dbprod 2.6.9-22.ELsmp #1 SMP Mon Sep 19 18:32:14 EDT 2005 i686 i686 i386 GNU/Linux


Thanks in advance



Re: Oracle instance running on a system with low open file descriptor limit [message #423315 is a reply to message #423310] Wed, 23 September 2009 05:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just a (standard) warning, it does not check if there is a problem or not, just the value.
You can ignore it.

Regards
Michel
Re: Oracle instance running on a system with low open file descriptor limit [message #423317 is a reply to message #423310] Wed, 23 September 2009 06:01 Go to previous message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Thanks for your reply
Previous Topic: please help on installing oracle9i on linux4
Next Topic: problem in installing Oracle developer and link with Net Conf
Goto Forum:
  


Current Time: Thu Dec 08 03:49:42 CST 2016

Total time taken to generate the page: 0.05493 seconds