DB lost connection ?

[vr76413]

Hello all..

Sun 5.8/ Oracle 9.2

Our application servers make multi connections to the database and keeps these connections open. Everything works fine until I come back a day later, then some of the connections to the database are invalid and I get socket errors. Not all connections have this problem, only about 25% of them.

So i tried to look into Listener.log file to see if there are any errors in the DB about lost connections?...

But Listener.log file tells only about the connections and not disconnections from the client boxes....Am i missing something here...Correct me if iam wrong

Where can i find the disconnections from client to Server box ?

Thanks
ron

 

[Swany]

Do you have a DBA that is killing off long running (apparently) idle sessions? .
.. Eat, think and be merry .
... ....................... .