We now have instances of 11g clustered across 2 servers, so the tnsnames entry contains both servers and the LOAD_BALANCE and FAILOVER switches are set to Yes. If I leave the TOAD session idle for a while and then try to use it, I get the subject error and must reconnect, which takes a long time. How can TOAD be configured to prevent these disconnections?
Toad 12.0
10g Oracle Client (must stay with this, as I also have to connect to 8i databases)
I have never tested this, but it looks like if you configure Transparent Application Failover, which looks like just a few more tnsnames settings, it should
“just work” in Toad……although we might have to make a few changes so that Toad accurately reflects which instance you are connected to.
http://docs.oracle.com/cd/E11882_01/network.112/e10836/advcfg.htm#NETAG349
From: Mike Zarzycki [mailto:bounce-zman@toadworld.com]
Sent: Monday, October 28, 2013 4:12 PM
Subject: [Toad for Oracle - Discussion Forum] Tns packet writer failure
Thread created by Mike Zarzycki
We now have instances of 11g clustered across 2 servers, so the tnsnames entry contains both servers and the LOAD_BALANCE and FAILOVER switches are set to Yes.
If I leave the TOAD session idle for a while and then try to use it, I get the subject error and must reconnect, which takes a long time. How can TOAD be configured to prevent these disconnections?
Toad 12.0
10g Oracle Client (must stay with this, as I also have to connect to 8i databases)
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Hi!
I’m just curious.
if you leave the same amount of time in ordinary sqlplus (with previously executed same sqls like was in Toad example) do you get the same disconnection?
I think yes …
THX for your answer
Brg
Damir Vadas