ORACLE Disconnect every 5 mins [message #560295] |
Wed, 11 July 2012 21:28 |
|
vicky_eloquent
Messages: 3 Registered: July 2012 Location: china
|
Junior Member |
|
|
Dear all,
Recently I came across a problem that 'ORACLE Client Side Disconnect every 5mins in app server' these days.
Situation: We have 3 APP servers, which was configured the same OS and ORACLE Client version and 1 DB server.
2 app servers ORACLE Client Side Disconnect every 5mins.but it's ok in another App server.
1. both Oracle SQL PLUS and PLSQL have this problem.
2. SQLNET.EXPIRE_TIME is the same for 3 APP
3. 2 APP server are virtual machine and balance server
3. APP servers : OS: 2003 Server ORACLE 9i
DB server : ORACLE 11g
4. I don't think it's DB server problem because one App server hasn't this problem
Is there anybody can help me ? Thanks.
Thanks
[Updated on: Wed, 11 July 2012 21:37] Report message to a moderator
|
|
|
|
|
|
|
Re: ORACLE Disconnect every 5 mins [message #560391 is a reply to message #560305] |
Thu, 12 July 2012 08:28 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>only these two new VM are running and
>they are the same as other 1 App
if they really were 100% identical to first Server, then results would be the same & no timeouts.
ipso facto, SOMETHING is different!
>APP servers : OS: 2003 Server ORACLE 9i
this is certainly a nice ancient & unsupported combination of hardware & software
|
|
|