Home » RDBMS Server » Server Administration » low open file descriptor message (Oracle 9i: RHEL AS4)
low open file descriptor message [message #357106] Mon, 03 November 2008 23:40 Go to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Dear All,

I am getting error in Alert logfile
>>>"low open file descriptor message"

I have done the following to sort it but invain.

1.I have set the nofile to 65535 /etc/security/limits.conf.
2.I have increased the open files to 65535 because it cannot
be set to unlimited

Kindly provide me action plan to resolve the issue


Thanks
Yasir
Re: low open file descriptor message [message #357122 is a reply to message #357106] Tue, 04 November 2008 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forget it, this line is just information does not matter.
Nevertheless, check nofiles (or the like) in "ulimit" for Oracle instance owner (the user that starts the instance).

Regards
Michel
Re: low open file descriptor message [message #357135 is a reply to message #357106] Tue, 04 November 2008 02:25 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Hi Michel,

thanks for your reply......following are the values for files

>>>>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) 65535
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) 278528
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

>>>/etc/security/limits.conf
hard nofile 65535
soft nofile 65535


but the problem stil persist....

Regards,
Yasir
Re: low open file descriptor message [message #357138 is a reply to message #357135] Tue, 04 November 2008 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is NOT a problem, ignore it.

Regards
Michel
Re: low open file descriptor message [message #357167 is a reply to message #357106] Tue, 04 November 2008 03:26 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Hi Michel,

Thanks for update..... if it is not a problem then why it keep coming on Alert logfile? i will really appreciate it if u can provide me any remedy?

Thanks & Regards
Yasir
Re: low open file descriptor message [message #357193 is a reply to message #357167] Tue, 04 November 2008 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Alert.log contains:
- informational message
- warnings
- errors

This is an informational message.

Regards
Michel
Re: low open file descriptor message [message #359228 is a reply to message #357106] Fri, 14 November 2008 04:04 Go to previous message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Hello Everyone,

The warrning message is vanished by adding

'*' at the begning of each parameter or you have to add the Os user name
i-e
* hard nofile 65535
* soft nofile 65535
Or
oratest soft nproc 2047
oratest hard nproc 16384
oratest soft nofile 65536
oratest hard nofile 65536

Thanks
Yasir
Previous Topic: help!ORA-00600: internal error code, arguments: [kcratr1_lostwrt],
Next Topic: error occurred at recursive SQL level 1
Goto Forum:
  


Current Time: Fri Jul 05 11:50:58 CDT 2024