limitation with socket connection/file opening

From: Rajput raj (veerajput@hotmail.com)
Date: Thu Mar 11 2004 - 16:56:38 EST


Hi Gurus,

we just upgraded our oracle client to 9.2.0 and since then, we are having
problem in connecting to the database server after a certain number of
connections. I did truss on the process and looks like after certain number
the Solaris (i dont know for sure) stops to open files.

here is a sample truss output from a succesful connection:-

open("/etc/hosts", O_RDONLY) = 254
fstat64(254, 0xFFBE5D38) = 0
brk(0x013033B0) = 0
brk(0x013073B0) = 0
ioctl(254, TCGETA, 0xFFBE5CC4) Err#25 ENOTTY
read(254, " #\n #\n 1 9 2 . 1 6 8 .".., 8192) = 4464
llseek(254, 0xFFFFFFFFFFFFF2F5, SEEK_CUR) = 1125
close(254) = 0

Here is a sample truss output from an unsuccessful connection :-

open("/etc/hosts", O_RDONLY) = 257
close(257) = 0
stat("/bin/../java/bin/../jre/bin/../lib/sparc/nss_dns.so.1", 0xFFBE5AD4)
Err#2
ENOENT
stat("/opt/home/oracle/product/9.2.0/lib32/nss_dns.so.1", 0xFFBE5AD4) Err#2
ENOE
NT
stat("/usr/lib/nss_dns.so.1", 0xFFBE5AD4) = 0
open("/usr/lib/nss_dns.so.1", O_RDONLY) = 257
fstat(257, 0xFFBE5AD4) = 0

Which is basically saying that since I can't find the hostname in
/etc/hosts, I am going to use DNS.

We are running 2.8 with patch 18. Does anyone has come across issue like
this?? Any help will be great.

Thanks
-Raj

_________________________________________________________________
Get a FREE online computer virus scan from McAfee when you click here.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:28:15 EDT