Hi,
Using Toad for Oracle Xpert 12.1.0.22. It will not minimize. Any ideas?
Thanks, Mike
I've seen this happen before a few times and have not been able to figure out what causes it. Closing and re-opening Toad is the only way I know to work-around
it.
I have 12.6.0.40 and just saw this yesterday. I noticed that Alt-Tab or Window-Tab seemed to show not the normal Toad screen but a dialog box, probably “Computer
has just awakened from hibernation, should I reconnect?”. I presumed that Toad wouldn’t minimize because that dialog box was up (somewhere), but I could never actually see the dialog box to click Cancel.
Does that help, Brad?
Nate Schroeder
US Row Crops IT Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WB - Saint Louis, MO - 63167
314-694-2592
Yes, I've noticed this happening after an unexpected error or exception, maybe a window is getting stuck behind Toad MDI in this case.
As usual with the buggiest piece of software in the world, this still happens more than 6 years after the last comment.
Even the "SKIPS THESE TIPS" on the ugly layer when one connects for the 1st time to this forum doesn't work.
Pepei,
We've fixed a lot of bugs in the last 6 years, and we have worked on this one too.
Please be specific about the problem that you are having, tell us what Toad version you are using, and maybe provide a screen shot or two and we'll do our best to help you.
-John
Hello,
What happens is an error message pops up but at the same time toad maybe tries a reconnect and puts the main screen out front.
Then there is no way to get to it, so you have to use task manager to kill it.
thats the last thing toad spit out and no matter where i click it just bongs at me, technical term
All versions of toad I have used has done this from 13 up to 16.3 (current).
Sometimes I have been able to use the windows key to get main toad to move and get to the error but today wont do anything. The sqlplus session I called from toad still worked though.
Thanks
Dave
ok so this just worked.
Killed everything in the task manager associated with toad except for the main and I guess editor main
then i right clicked on the SUPP in task manager and clicked minimize and it left the error up. Now I have auto reconnect on, I feel like that is the only error that I have ever got stuck in the back. Not connect or something along those lines
Hi Dave,
Thanks for the info. I'll try to reproduce that. Do you remember what Toad was trying to do when the error occurred? (where you clicked, etc).
That's a good tip about minimizing the error from the sub-node of task manager like that. I see you can also do that from the windows task bar.
If you hover over the doubled task bar button, then the preview appears. Then you can right-click on the popup that is not in the foreground and choose "Close"
-John
I think I was clicking on the tablespace explorer, but i can reproduce the error by disconnecting from vpn but not always the issue, I feel like the stars align when the issue happens. So I noticed that this issue doesnt generate another preview window.
1 Like
and as I was posting that, I reconnected to VPN and toad is going crazy, I am assume its trying to reconnect but not connecting. Its got toad all locked and keeps not responding.
I have all the actions its doing but it would be too much info to remove. You want me to create a support ticket and then share it or just caulk this up to an anomaly?
It's up to you if you want to create a support case for it. The main difference if you create it vs if you don't are the documentation of the problem, and support following up with me and you until the problem is resolved.
I am in middle of something now and haven't tested it yet, but will soon. So, correct me If I am wrong but the basic steps to reproduce the problem are:
- make a connection that requires VPN
- Close the VPN
- Do something in Toad that will cause a SQL to run (like open Administer -> Tablespaces from the main menu)
- Lost connection dialog appears. Click "Reconnect".
- problem doesn't happen every time, but sometimes a dialog goes behind Toad so you can't minimize Toad.
Is that right?
I'd appreciate any more details you can provide. (Do you have only one connection or more than one, any steps I left out or got wrong, etc).
Thanks.
correct and the only reason why i did the vpn disconnect was because I know it would force the error instead of waiting for a timeout, so I dont think VPN is the issue, it just gives me an ip i can use to connect. Firewall is restricted by IP.
I just want to be able to provide you with as much information as i can and to remove IP's and schema name would be annoying lol.
in task manager toad is looping through these. they will all go away then come back.
Whats interesting is I have a lot of connections to different instance but all the errors are from 1 PDB.
here is a trace, thats what it seems to be stuck on.
Trace file
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20
Build label: RDBMS_19.20.
ORACLE_HOME:
System name: Linux
Node name: not interesting
Release: 3.10.0-1160.102.1.el7.x86_64
Version: #1 SMP Mon Sep 25 05:00:52 EDT 2023
Machine: x86_64
Instance name: not_interesting
Redo thread mounted by this instance: 1
Oracle process number: 167
Unix process pid: 42641, image: oracle@fgsdfgs
*** 2023-11-02T11:48:40.820304-04:00 (INSTANCE(5))
*** SESSION ID:(394.59949) 2023-11-02T11:48:40.820343-04:00
*** CLIENT ID:() 2023-11-02T11:48:40.820350-04:00
*** SERVICE NAME:(INSTANCE) 2023-11-02T11:48:40.820355-04:00
*** MODULE NAME:(TOAD background query session) 2023-11-02T11:48:40.820360-04:00
*** ACTION NAME:(257243312,563939760,563976528) 2023-11-02T11:48:40.820366-04:00
*** CLIENT DRIVER:(OCI) 2023-11-02T11:48:40.820371-04:00
*** CONTAINER ID:(5) 2023-11-02T11:48:40.820376-04:00
CLOSE #140254894425864:c=13,e=13,dep=0,type=3,tim=10915277718
PARSING IN CURSOR #140254894425864 len=60 dep=0 uid=172 oct=47 lid=172 tim=10915283370 hv=4018518245 ad='3db4f9020' sqlid='79u1xf7rsbf75'
begin :id := sys.dbms_transaction.local_transaction_id; end;
END OF STMT
PARSE #140254894425864:c=22,e=22,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=10915283368
BINDS #140254894425864:
Bind#0
oacdty=01 mxl=8192(8000) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1400000 frm=01 csi=178 siz=8192 off=0
kxsbbbfp=7f8fa22a13b8 bln=8192 avl=00 flg=05
WAIT #140254894425864: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=160357 tim=10915283576
EXEC #140254894425864:c=159,e=159,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=10915283598
*** 2023-11-02T11:50:41.816239-04:00 (INSTANCE(5))
WAIT #140254894425864: nam='SQL*Net message from client' ela= 120994958 driver id=1413697536 #bytes=1 p3=0 obj#=160357 tim=11036278586 <-- that object is unified audit table but unified auiting is not enabled and the table is less then 3G
CLOSE #140254894425864:c=17,e=17,dep=0,type=3,tim=11036278707
PARSE #140254894425864:c=17,e=17,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=11036278752
BINDS #140254894425864:
Bind#0
oacdty=01 mxl=8192(8000) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1400000 frm=01 csi=178 siz=8192 off=0
kxsbbbfp=7f8fa22a13b8 bln=8192 avl=00 flg=05
WAIT #140254894425864: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=160357 tim=11036278898
EXEC #140254894425864:c=142,e=142,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=11036278916
Ill get back to this and if you need more info let me know
Interesting. The only reason Toad should be looking at Unified Audit table would be if you had it selected in the Schema Browser. If we are trying to query it, you should be able to see that in Spool SQL.
I couldnt recover the that toad, windows ended up forcing it closed so spool was lost, unless its saved somewhere Im unaware of.
I was doing a lot of different things but the session that was looping the connect shouldnt have been querying the unified audit trail