Hi experts,

The maximum number of file descriptors per process in Solaris is defined by
the setting of 'rlim_fd_cur'. By default, it is set to 64.

Does opening of an Oracle connection from an application count as using one
file descriptor ? For example, if I have a multi-threaded java process which
opens more than 64 connections simultaneously using JDBC, then is it going
to run out of file descriptors ?

We have a problem on a Solaris box, where the java application run
successfully most of the time, but sporadically gives the TNS error
ORA-12154. It is opening/closing many connections simultaneously, and I
suspect that if this java process has 64 fds already open, and it tries to
open one more connection, it fails.

We have many other java processes also running on the same box, but they do
not open/close connections so frequently, and they do not show any such
error. The environment is Oracle 8.1.6, Solaris 2.8, JRE 1.2.2_06

Thanks.

- Nihar

Oracle LazyDBA home page