Re: Anyone ever need more file handles on Solaris 8/Oracle 8.1.7

In comp.sys.sun.admin Chuckster <chuckycarson_at_networkcloud.com> wrote:
> Yea, all this has been done. This has been a working system for over a
> year. Just recently these intermittent problems appeared, thus it works
> one minute and not the next. In the absence of configuration changes to
> the oracle client, this rules out syntax errors and etc...

Fair enough, however, the obvious can sometimes be overlooked.

Have you enabled tracing for the TNS Listener? Is it getting but failing to look up a valid service name, or it is getting the query at all-- perhaps you're dropping a few packets, and getting an occasional timeout because the machine is busy dealing with other network traffic?

A mildly flaky ethernet cable, or one loose in the RJ45 which only drops one packet out of a thousand tends to do fine under testing, but will cause this kind of thing under heavier loads. What does netstat -s and -i look like?

Is your app holding a few persistant DB connections open, or are there situations where you might create and drop a bunch of connections in a row?

-Chuck

       Chuck Swiger | chuck_at_codefab.com | All your packets are belong to us.
       -------------+-------------------+-----------------------------------
       "The human race's favorite method for being in control of the facts
        is to ignore them."  -Celia Green