Help - Search - Members - Calendar
Full Version: control dblink timeout
Oracle DBA Forums > Oracle > Oracle Forum
DBAuser
hello all
Is there any way to control the timeout before connecting via dblink.
the idea is to test the dblink before calling functions over it, the problem it when i try 'select 1 from dual@dblink' in case if the remote server is down it takes too long time 5-7 min. which causing hang up the session,
So is there any parameter to reduce the waiting time say after 3 sec stop and return the timeout exception.
I try the SQLNET.INBOUND_CONNECT_TIMEOUT parameter but not working, also try the tnsping but it alse take long time when the server down.

the database version is 10gr2.
Regards.
burleson
Hi,

>> Is there any way to control the timeout before connecting via dblink.

Before?

I've written systems where each transactions is one second, no more,no leess, not never a deliberate delay at connect time!
burleson
Hi,

>> Is there any way to control the timeout before connecting via dblink.

Before?

I've written systems where each transactions is one second, no more,no leess, not never a deliberate delay at connect time!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.