I agree to Idea Better handling of disconnected sessions in TOAD
Voting Disabled

102 votes

I disagree to Idea Better handling of disconnected sessions in TOAD

Rank4

Idea#127

This idea is active.
Connections »

Better handling of disconnected sessions in TOAD

I'm not sure if this is a TOAD problem or an Oracle problem but its one I experience daily in TOAD. I often have multiple connections open in TOAD and I'll be jumping between them throughout the day. Often, the connection will be lost as I haven't used it for a while so I need to reconnect to the database, my problem is I don't know this until I have tried to do a refresh/change tab/execute procedure in TOAD. When this happens its not unusual to get messages like:

Access violation at address 61CDF6A4 in module 'OraClient11.Dll'. Read of address 00000010.

I get lots of other ones too, sometimes offering me the Reconnect button, sometimes not. Often I get multiple messages. I often get them when I try to Test Connections (Reconnect) as well - lots of them.

I'm not sure, but I suspect, this is often a cause of crashes/hangs in TOAD or at least a loss of stability (again, often, once I've had these messages I'll keep getting them until I find them too annoying and restart TOAD), even after I've reconnected.

So, in summary, can we handle this better in TOAD? I know we can't "keep alive" our TOAD connections but can we better handle instances where we've tried to execute some code against a connection that's been dropped.

Submitted by 4 years ago

Comments (31)

  1. I'm working over VPN, which is timed to 2 hours. After that the VPN connection is automatically closed from the other end. TOAD doesn't seems to notice that. If I'm running a long query / package, it will not come back again...

    3 years ago
    1 Agreed
    0 Disagreed
  2. When I'm working remotely and I lose my remote connection to my DB, and I don't realize it, when I try to do something , Toad gives me errors and in the end I have to kill it with Task Manager. I then have to reboot if I want to use Toad again... Please make Toad deal with disconnects better.

    3 years ago
    1 Agreed
    0 Disagreed
    1. Moderator
      3 years ago
      1 Agreed
      0 Disagreed
  3. Along with handling disconnects better, while working with TOAD, why not let TOAD close without disconnect errors? When I'm shutting down, being disconnected is not an error.

    3 years ago
    2 Agreed
    0 Disagreed
  4. I agree, I also find that Toad hangs for a minute or two when it has lost a connection. This is very fustrating when shutting down.

    3 years ago
    1 Agreed
    0 Disagreed
  5. Yes, this is a major problem for me. As I start shutting down for the day, the dropped connections would make Toad Hang for a fairly long time and there are very few days, I dont have to kill toad.

    3 years ago
    1 Agreed
    0 Disagreed
  6. I use VPN and keep TOAD up all day. To keep a connection alive, I make sure the Session Browser opens with each connection automatically. I set the refresh to 600 seconds. With a "ping" every 5 minutes, my connections stay open!

    3 years ago
    0 Agreed
    0 Disagreed
  7. I vote for this Idea, as it is extremely annoying the way TOAD handles disconnected sessions, especially when trying to close down. It is probably to do with the commit/rollback selection in the options, but most of the time, I have only run select statements, so don't need to commit or rollback

    TOAD for Mysql automatically reconnects if the session has disconnected, so maybe some communication between product dev groups would be good.

    3 years ago
    0 Agreed
    0 Disagreed
  8. After an ORA-3113, there's a workaround. You can use the "test sessions(reconnect)" item from the session window.

    It would be better if the error dialog on ora-3113 included a RECONNECT button.

    3 years ago
    0 Agreed
    0 Disagreed
  9. I highly agree with this one. This sometimes get's so bad that even using the "use the "test sessions(reconnect)" item from the session window." doesn't help. It's like Toad goes off to la la land and you have to go into the task manager kill it the Toad process, and restart.

    3 years ago
    1 Agreed
    0 Disagreed
  10. In TOAD version 11, clicking on the Reconnect button reconnects ALL the sessions the user has logged onto. This is a great feature which I've been asking for ages!

    However, it would be even better if the Startup Script is also run after a reconnection. This will have the effect of re-login proper of a session.

    2 years ago
    1 Agreed
    0 Disagreed
  11. Running startup scripts at reconnect should be an on/off configuration setting.

    2 years ago
    1 Agreed
    0 Disagreed
  12. I'm agree with this one,too.

    2 years ago
    0 Agreed
    0 Disagreed
  13. I agree 100x over. As a consultant, I use TOAD for multiple clients over VPN every day. It's a daily task for me to force-close TOAD because of hung connections. It's always been this way from Win XP thru Win 7. HUGE frustration and often makes me want to choose another tool.

    2 years ago
    2 Agreed
    0 Disagreed
  14. I agree with @JustinK, I'm not sure why, but Toad is incredibly flakey over VPN. Constantly loses connections. I never have these issues with any other software over VPN, just Toad.

    2 years ago
    1 Agreed
    0 Disagreed
  15. I agree with all. I get disconnected from the databases I work in frequently during the day. Reconnecting is always an issue. At best it takes a couple of minutes. Otherwise I either get a host of access violation errors, that I have to click thru to hopefully get back running again, or Toad freezes entirely and I have to kill it and start over. These problems cost me at least a half hour out of my work day everyday, plus considerable frustration.

    2 years ago
    1 Agreed
    0 Disagreed
  16. I use Session Browser as a workaround for those types of problems. Setting a refresh value like 60secs and checking Refresh box, keeps you connected for a long long time.

    2 years ago
    0 Agreed
    0 Disagreed
  17. see also

    https://support.quest.com/SolutionDetail.aspx?id=SOL82763

    for avoiding the second session (Toad 11), shown as

    "TOAD background query session"

    Toad Options -> Editor -> Display

    and disable all Syntax Highlighting ticks

    otherwise this session times out.

    The session browser workaround, coupled with this, avoids firewalls killing your TOAD connections

    1 year ago
    0 Agreed
    0 Disagreed
    1. May be useful a "Test Connections (Reconnect)" schedulable every x secs

      1 year ago
      0 Agreed
      2 Disagreed
  18. We need the ability to reconnect to individual sessions instead of having to reconnect to all or none. I often have twenty or more sessions at a time with databases all over the world with widely varying response times. It can easily take thirty minutes to reconnect to a whole bunch of databases I don't need right now just to get back into the one that I do.

    1 year ago
    0 Agreed
    0 Disagreed
    1. BTW: I submitted a trouble-ticket with Quest years ago asking for the ability to reconnect individual sessions. I was told that the engineers did not believe that there was sufficient interest to make it worthwhile.

      1 year ago
      0 Agreed
      0 Disagreed
    2. Moderator

      The next beta (12.0.0.41) will have the ability to reconnect just the active connection instead of all of them.

      1 year ago
      0 Agreed
      0 Disagreed
  19. In addition, Toad should not notify me when I close an individual session that it finds already closed. I am CLOSING the session for goodness sake! I don't need to be told that the session was already dead. This works fine when shutting down all of Toad, but not when closing individual connections.

    1 year ago
    0 Agreed
    0 Disagreed
    1. Moderator

      Starting in the next beta (12.0.0.41), this message will have a "don't show this message again" checkbox that you can check to never see the message again.

      1 year ago
      1 Agreed
      0 Disagreed
  20. I'm using version 12.0.0.61 When I click on an editor or schema browser window for a disconnected session, I get a dialog saying it's closed, and then the entire app just disappears -- no error message, no option to save files, nothing. I expect much better error handling in software that costs as much as Toad does. I never had these kinds of issues using SQLDeveloper.

    1 year ago
    0 Agreed
    0 Disagreed
  21. Moderator

    What exactly is the message you're seeing? To test I opened Toad and a session. I opened an Editor and ran a statement. I disconnected my network adapter to simulate a dropped network and then tried to open a Schema Browser. I received an end of file communication error followed by a not logged on message. I repeated that test, but instead of disconnecting my network adapter I killed my session from another copy of Toad. In this case I received the end of file communication error and Toad reconnected the session. Is there anything else perhaps in your setup that might assist in reproducing?

    1 year ago
    0 Agreed
    0 Disagreed
  22. When connected to a DB over a VPN connection, and I let things sit without activity long enough for the connection to be dropped, clicking on a session that has been disconnected will result in:

    If I'm "lucky" I get a dialog box saying with a caption of "TOAD Error" and contents of "ORA-03135: connection lost contact Process ID: 30921 Session ID: 151 Serial number: 29". When I click the "OK" button in this dialog, Toad frequently (90% of the time) just exits immediately without any further messages. If I'm unlucky, Toad will just exit without warning.

    Note: This exit without warning seems to be new behavior in Toad 12. Toad 11.5 Will notify my that the session is disconnected, give me the opportunity to reconnect, and seems considerably more stable in this area.

    1 year ago
    0 Agreed
    0 Disagreed
  23. I normally have connections to multiple databases and some go down to be flashbacked or for whatever reason. The error window usually goes whacko and is unable to be closed. Then all bottom panels are unable to be used as the content is not displayed. I hate having to disconnect all my sessions and restart Toad just to fix a UI bug. Fix it please!

    1 year ago
    0 Agreed
    0 Disagreed
    1. Also the "No to All" button on the Save prompt for the open sql Editor windows does not work in this case. So I have go one-by-one to try to close them one at a time. It still sometimes does not work that way and I have to just kill the Toad.exe process.

      1 year ago
      0 Agreed
      0 Disagreed
  24. Moderator

    Are you actively debugging (stepping, stopped at breakpoint or exception break, etc.) by chance when this happens? I've tried numerous times and after throwing at least one ORA error about the lost session I can regain control quickly without any unhandled exceptions, vanishing Toad, hanging, etc. I was able to reproduce a scenario just now where debugging during a lost session made it impossible for me to close the Editor. I'll take a peek at this.

    1 year ago
    0 Agreed
    0 Disagreed
  25. Moderator

    For those of you with "disconnected session" problems, please read this:

    http://www.toadworld.com/products/toad-for-oracle/f/10/p/20525/41887.aspx#41887

    It's the case of one user who solved 10-15 minutes of "Toad hang" after a lost connection simply by reinstalling his Oracle client.

    1 year ago
    0 Agreed
    0 Disagreed

Events

  1. The Idea titled Better handling on DB disconnects was merged with this Idea
    3 years ago