Time outs which may not be SQL

  • From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 30 Apr 2008 11:12:14 -0400

We have a large test running for a client. It appears ALL DB connects
time out in 12 hours and 20 minutes. There isn't any sqlnet.ora file on
the database server.
 
What we have:
 
HP/UX B.11.11 U 9000/800
 
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
This is on the GA016d99 server as the database server. The application
server is GA016A0G1.
 
We have connections timing out in roughly 12 hours 20 minutes. 
 
So to further clarify the situation, we had nohup sql routines that
would sleep for 5 minutes and request something. We also had 6 hours and
rerun to test that, and one that would wait for the 12 hours and 20
minutes and rerun.
 
We expected it to only time out the one over 12 hours, but ALL of them
got canceled.
 
That makes me think it is probably the Unix, or the network that just
doesn't allow connections to exist over that period of time.
 
Where do we start?
 
 
Michael Kline
804.261.9446 
  
  
  
LEGAL DISCLAIMER 
The information transmitted is intended solely for the individual or entity to 
which it is addressed and may contain confidential and/or privileged material. 
Any review, retransmission, dissemination or other use of or taking action in 
reliance upon this information by persons or entities other than the intended 
recipient is prohibited. If you have received this email in error please 
contact the sender and delete the material from any computer. 
  
SunTrust and Seeing beyond money are federally registered service marks of 
SunTrust Banks, Inc. 
[ST:XCL] 
 
 
 
 

Other related posts: