RE: SQL*Net - Connection Timeout
- From: M Rafiq <rafiq9857@xxxxxxxxxxx>
- To: <paul.moore@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 29 Feb 2008 14:49:00 -0500
If that client is connecting using ODBC connection then you might enable query
time out setting on that client ODBCconnection. Check the box under Application
tab.
HTH.
Regards
Rafiq
Subject: SQL*Net - Connection TimeoutDate: Fri, 29 Feb 2008 16:16:20 +0000From:
Paul.Moore@xxxxxxxxxxxxxxxx: oracle-l@xxxxxxxxxxxxx
I have a problem with a remote database, where any attempt to connect to that
database from one particular client hangs indefinitely (more precisely, for
longer than I have been willing to wait to see if it's actually "hours" rather
than "forever" :-)) The inability to connect from this particular client isn't
a major problem, but having jobs which attempt to connect hang indefinitely
rather than fail with a TNS timeout error is.
I have looked through the SQL*Net reference, and asked colleagues, but I cannot
find any way of setting a parameter to say that the client (OCI, actually
Python with cx_Oracle) connection should timeout after XXX seconds, regardless.
Is there such a setting anywhere?
The connection attempt is part of a long-running process, so I cannot simply
kill the hung process. Running the connection in a thread and giving up waiting
after a timeout sort of works, but the thread stays there, hung, and as time
goes on the process accumulates hung threads. I'd really, really like to avoid
having to re-engineer my process to spawn subprocesses for each connection
(especially as this is on Windows where spawning subprocesses is a bit of a
pain compared to using threads).
Has anyone got any suggestions?
Thanks, Paul
Paul Moore Oracle DBA Support Atos Origin UK Ltd Daresbury Court Runcorn
Tel: +44 (0)1928 598537
_______________________________________________________
Atos Origin and Atos Consulting are trading names used by the Atos Origin
group. The following trading entities are registered in England and Wales: Atos
Origin IT Services UK Limited (registered number 01245534) and Atos Consulting
Limited (registered number 04312380). The registered office for each is at 4
Triton Square, Regents Place, London, NW1 3HG.
This e-mail and the documents attached are confidential and intended solely for
the addressee, and may contain confidential or privileged information. If you
receive this e-mail in error, you are not authorised to copy, disclose, use or
retain it. Please notify the sender immediately and delete this email from your
systems. As emails may be intercepted, amended or lost, they are not secure.
Atos Origin therefore can accept no liability for any errors or their content.
Although Atos Origin endeavours to maintain a virus-free network, we do not
warrant that this transmission is virus-free and can accept no liability for
any damages resulting from any virus transmitted. The risks are deemed to be
accepted by everyone who communicates with Atos Origin by email.
_______________________________________________________
_________________________________________________________________
Climb to the top of the charts! Play the word scramble challenge with star
power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan
Other related posts:
