Encounter error when using hawk agent with oracle databse:Error establishing socket to host and port::udbb01:1521. Reason: Too many open files
Article ID: KB0090796
Updated On:
| Products | Versions |
|---|---|
| TIBCO Hawk | - |
| Not Applicable | - |
Description
Resolution:
This error is telling us that: on a machine with the host name udbb01, there are not enough sockets/file descriptors and that too many files (and/or sockets) are currently open. Please increase the number of file descriptors on the problematic machine. This is done using the ulimit command (use man ulimit for additional information)
File descriptors are managed by OS. Please make sure when you set a maximum limit to file descriptors, please consider all processes on this machine which opens files/sockets consume file descriptors.
To retrieve the number of file descriptors used in Solaris, you can use "pfiles <pid>".
For more information regarding file descriptors, please consult your local System Administrator.
For investigating how many file descriptors are being used on the machines, we would recommend running a tool called 'lsof' (or an equivalent tool) which lists information about files opened by processes. It is freely available for download - one such location is:
http://gd.tuwien.ac.at/utils/admin-tools/lsof/
This tool helps to determine how many file descriptors are being used by each one of the processes on the affected machine. You can monitor your file descriptor per process which give you an idea of how many you would actually need and then set the Max limit on your environment as per the usage. If you observe that FD usage in a particular application grows rapidly, then please check the design and implementation details and rectify the application first before trying to increase the FD Limit on your system. You can then examine potential causes of why the machine is running out of file descriptors.
This utility should be run as a root user and you can use the command lsof -p <the PID of the process> | wc -l to get the number of open files by this process+1.
This error is telling us that: on a machine with the host name udbb01, there are not enough sockets/file descriptors and that too many files (and/or sockets) are currently open. Please increase the number of file descriptors on the problematic machine. This is done using the ulimit command (use man ulimit for additional information)
File descriptors are managed by OS. Please make sure when you set a maximum limit to file descriptors, please consider all processes on this machine which opens files/sockets consume file descriptors.
To retrieve the number of file descriptors used in Solaris, you can use "pfiles <pid>".
For more information regarding file descriptors, please consult your local System Administrator.
For investigating how many file descriptors are being used on the machines, we would recommend running a tool called 'lsof' (or an equivalent tool) which lists information about files opened by processes. It is freely available for download - one such location is:
http://gd.tuwien.ac.at/utils/admin-tools/lsof/
This tool helps to determine how many file descriptors are being used by each one of the processes on the affected machine. You can monitor your file descriptor per process which give you an idea of how many you would actually need and then set the Max limit on your environment as per the usage. If you observe that FD usage in a particular application grows rapidly, then please check the design and implementation details and rectify the application first before trying to increase the FD Limit on your system. You can then examine potential causes of why the machine is running out of file descriptors.
This utility should be run as a root user and you can use the command lsof -p <the PID of the process> | wc -l to get the number of open files by this process+1.
Issue/Introduction
Encounter error when using hawk agent with oracle databse:Error establishing socket to host and port::udbb01:1521. Reason: Too many open files
Feedback
Yes
No
Powered by
