Toad World® Forums

toad reconnect bug

hi!

when toad reconnect to a session,is prompt ORA-03135,the bug appears.it's exist in toad 11.6.1,toad 12.0.0.47-12.0.0.52.

the attachment file is a video appears the problem.(1,the bottom windows appear a blank area.2,cannot exit toad unitl kill toad.exe in taskmgr.)

my os is xp sp3 32bit,toad 12.0.0.52.

waiting for you reply,thanks.
toad reconnect bug.zip (433 KB)

I don’t think this is a Toad bug. I think the problem has something to do with your environment.

Read this, the solution may be to change a SQL Net parameter.

http://www.oracle-experts.info/ora-03135-connection-lost-contact

From: salmon5 [mailto:bounce-salmon5@beta.toadworld.com]

Sent: Thursday, May 16, 2013 5:59 AM

To: toadoraclebeta@beta.toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] toad reconnect bug

hi!

when toad reconnect to a session,is prompt ORA-03135,the bug appears.it’s exist in toad 11.6.1,toad 12.0.0.47-12.0.0.52.

the attachment file is a video appears the problem.(1,the bottom windows appear a blank area.2,cannot exit toad unitl kill toad.exe in taskmgr.)

my os is xp sp3 32bit,toad 12.0.0.52.

waiting for you reply,thanks.

appreciate for your reply,yes,ORA-03135 and (Toad and ORA-03135) itself not a bug,but the problem is after Toad processed ORA-03135(reconnect a session),Toad can’t regular exit until kill it’s process, Toad 12.0.0.46 hasn’t this problem in the same environment.Thanks.

I will look back at the source between .46 and .47 to check, but I don’t think we made any changes that would affect this.

In the meantime, please try the SQL Net parameter and let me know if it solves the problem.

i follows the url content add a parameter sqlnet.expire_time = 10 to the oracle server sqlnet.ora,than capture oracle generate Dead connection detection frame to Toad every 10 minutes over the iptables,than ORA-03135 not occurs.

but I think Toad will process ORA-03135 as a exception,to reconnect the database,and can work as normal continuous.

sorry for my poor english.

Thanks.