Home » RDBMS Server » Networking and Gateways » ORACLE Disconnect every 5 mins
ORACLE Disconnect every 5 mins [message #560295] Wed, 11 July 2012 21:28 Go to next message
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 #560296 is a reply to message #560295] Wed, 11 July 2012 22:04 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
>I don't think it's DB server problem because one App server hasn't this problem
I agree that the root cause is NOT the Oracle database.

when was last time all worked without error?
what changed?
Re: ORACLE Disconnect every 5 mins [message #560297 is a reply to message #560296] Wed, 11 July 2012 22:08 Go to previous messageGo to next message
vicky_eloquent
Messages: 3
Registered: July 2012
Location: china
Junior Member
2 App server was newly installed. we only use 1 APP server before, but because of performance problem, our company add 2 App virtual server.
Re: ORACLE Disconnect every 5 mins [message #560299 is a reply to message #560297] Wed, 11 July 2012 22:27 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
>2 App server was newly installed. we only use 1 APP server before,
>but because of performance problem, our company add 2 App virtual server.

It sounds like the two new VM are mis-configured.

Before when all was OK, was App Server running on a separate system distinct from DB Server?
How many physical systems are now running App server software?
To which system were the two new VM installed?

Re: ORACLE Disconnect every 5 mins [message #560305 is a reply to message #560299] Thu, 12 July 2012 00:06 Go to previous messageGo to next message
vicky_eloquent
Messages: 3
Registered: July 2012
Location: china
Junior Member
only these two new VM are running and they are the same as other 1 App
APP servers : OS: 2003 Server ORACLE 9i
Re: ORACLE Disconnect every 5 mins [message #560391 is a reply to message #560305] Thu, 12 July 2012 08:28 Go to previous message
BlackSwan
Messages: 22558
Registered: January 2009
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
Previous Topic: Materialized view data replication
Next Topic: connecting two ORACLE Servers
Goto Forum:
  


Current Time: Fri Aug 01 22:38:03 CDT 2014

Total time taken to generate the page: 0.09665 seconds