Toad World® Forums

Multiple Copies of Toad ( v12.0.0.61)

Genarally i use multiple copies of Toad. So i enabled “Allow multiple copies of Toad to be loaded” feature

But every 5-10min it gives error about

“Cannot create file “C:\Users\XXXX\AppData\Roaming\Quest Software\Toad for Oracle\12.0\User Files\CONNECTIONPWDS.INI”. The process cannot access the file because it is being used by another process”

i just hit ok/ignore then continue work. I don’t know why it happens 'cos of my setting or bug.

Hello lostxp,

While it’s not an answer, why do you need multiple copies of Toad active?

Rich

Support for having multiple copies of Toad running has a history. Its only purpose was to let a 2nd copy of Toad to start for the sole purpose of ending connections
or resolving a problem in the first Toad, then exiting afterward. It was originally prohibited entirely.

Toad was never designed to work with multiple copies of itself running throughout the day. There are just too many variables involved. How do you resolve concurrent
access to all those shared files. It’s just inviting problems.

From: lostxp [mailto:bounce-lostxp@toadworld.com]

Sent: Monday, October 07, 2013 3:18 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Multiple Copies of Toad ( v12.0.0.61)

Multiple Copies of Toad ( v12.0.0.61)

Thread created by lostxp

Genarally i use multiple copies of Toad. So i enabled “Allow multiple copies of Toad to be loaded” feature

But every 5-10min it gives error about

“Cannot create file “C:\Users\XXXX\AppData\Roaming\Quest Software\Toad for Oracle\12.0\User Files\CONNECTIONPWDS.INI”. The process cannot access the file because it is being used by another
process”

i just hit ok/ignore then continue work. I don’t know why it happens 'cos of my setting or bug.

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.

Why do i need that because after 4or 5 DB connection TOAD itself has performance problem, changing tab/connection took longer.

I remember before v11 there was no problem with multiple copies or i’ve never bump into.

How does launching multiple instances of Toad help with one of those instances having a performance problem? I’m missing something.

Regarding multiple copy issues, you were lucky. They’ve been there from the start, though obviously as the product gets larger & more complex the opportunities
for concurrency issues rise too.

From: lostxp [mailto:bounce-lostxp@toadworld.com]

Sent: Tuesday, October 08, 2013 1:23 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Multiple Copies of Toad ( v12.0.0.61)

RE: Multiple Copies of Toad ( v12.0.0.61)

Reply by lostxp

Why do i need that because after 4or 5 DB connection TOAD itself has performance problem, changing tab/connection took longer.

I remember before v11 there was no problem with multiple copies or i’ve never bump into.

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.

I’ve been looking around to try to find the answer to this same question, and I keep seeing that same response. “Why in the big wide world would anyone want to have multiple copies of TOAD running?!?!”

Really? That is a question people ask??? There are only a few hundred trillion reasons to do so. I’d say the most obvious is to run multiple queries at one time. The whole concept of "I clicked ‘submit query’, and therefore my entire application is locked up, and it will do NOTHING until that query comes back, is hogwash. Whoever decided that was a good way to design a query program, was off their rocker. Another frequent reason I’ve seen users do this is to separate environments (production from test from development, etc). That way there is far less chance of accidentally running a test piece of code on a production box.

Anyway, what kind of shop does anyone work in, where 1 single copy of TOAD running at any given time is sufficient to complete their daily work tasks? I can’t even dream up a situation where that makes sense.

And for the icing on the cake, I’ve worked with a LOT of different SQL applications for ~20 years now. TOAD is the only one with issues, when multiple copies are open. So to claim “oh, uh, it’s hard to manage all those files”, is also complete hogwash. How did every single other app developer figure it out, but QUEST could not?

Horrible design. Horrible bug.

1 Like

The OCI limits us to running one query at a time per session. There is nothing we can do to change that. The only thing we can do is work around it. Here are a couple of ways to do that:

  1. Go to Options -> Oracle -> Transactions and check “Execute queries in threads”. When you check that, we make a separate connection in the background and run your query there. You can do other things in Toad while it is running.

  2. In the Editor, instead of running with F9, click the little dropdown arrow next to the "excute as script, and choose either “Execute in Toad Script Runner” or “Execute in SQL*Plus”.

The “multiple copies of Toad” problem was solved some time ago. See this post:

www.toadworld.com/…/24246

There are also numerous ways around this issue. Specifically the /Virtual flag. One reason that it was difficult is because of the thousands of extra features that Toad has that many other programs do not. Specifically, the automatic saving of your settings x number of minutes. Most programs do not have this but Toad does (requested by users) and this can cause issues if you have multiple instances open because you’re saving to the same location. We’ve also solved this issue with the /virtual command line parameter but it was introduced in 12.7. Since you’re running a version that is several years old, it’s very possible you don’t know about the changes and enhancements that have occurred.

Also, are you running queries in threads (an option)?

Are you running things as a scrip (F5)t? If so, we have to wait for the script to complete before returning control. If you have a long running script, execute via QSR or SQL*Plus to get control back.

Have you looked at connection colors to keep track of what is dev and what is prod?

Also remember that Toad was designed a very long time ago when MDI was the way. We have looked at alternatives but given the user base and the effort required, it’s not really a viable option. Look at the nightmare M$ created for themselves when they redesigned Office to have ribbons. They can get over it because they have infinite resources and a monopoly on the space. Most companies simply can not toss their app into the garbage heap and start over. We’re constantly trying to improve and will continue to improve things but posting an insult ridden tirade on a three year old post is not helpful at all.

How many copies of Toad would you want to have open at a time?

I easily spend 90% of my work day in Toad writing and running queries and pl/sql. I also use the Session and Schema Browsers on a regular basis. I can easily do everything I need to with a single copy of Toad open without having to wait on queries to do other things. I use the “execute queries in threads” option and sometimes have as many as 4 queries running at the same time in different tabs and sometimes different editor windows and I pretty consistently have at least 10 tabs and/or windows open.

The only time I open a second copy of Toad (usually the Beta and the GA), is when I need to compare data grids with lots of rows and columns side by side so I can use two monitors to do it or if I have somehow managed to lock it up and need to kill my own session. But the number of times I need to do this per month that could be counted on one hand. :slight_smile:

After all these years (I’ve been using Toad for 20+ years), I’ve found that if there is something I don’t like in Toad, there is probably an option to fix/change that behavior.

On Tue, Nov 1, 2016 at 3:12 PM, Gregory Liss bounce-GTDG@toadworld.com wrote:

RE: Multiple Copies of Toad ( v12.0.0.61)

Reply by Gregory Liss
There are also numerous ways around this issue. Specifically the /Virtual flag. One reason that it was difficult is because of the thousands of extra features that Toad has that many other programs do not. Specifically, the automatic saving of your settings x number of minutes. Most programs do not have this but Toad does (requested by users) and this can cause issues if you have multiple instances open because you’re saving to the same location. We’ve also solved this issue with the /virtual command line parameter but it was introduced in 12.7. Since you’re running a version that is several years old, it’s very possible you don’t know about the changes and enhancements that have occurred.

Also, are you running queries in threads (an option)?

Are you running things as a scrip (F5)t? If so, we have to wait for the script to complete before returning control. If you have a long running script, execute via QSR or SQL*Plus to get control back.

Have you looked at connection colors to keep track of what is dev and what is prod?

Also remember that Toad was designed a very long time ago when MDI was the way. We have looked at alternatives but given the user base and the effort required, it’s not really a viable option. Look at the nightmare M$ created for themselves when they redesigned Office to have ribbons. They can get over it because they have infinite resources and a monopoly on the space. Most companies simply can not toss their app into the garbage heap and start over. We’re constantly trying to improve and will continue to improve things but posting an insult ridden tirade on a three year old post is not helpful at all.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

I agree with Phyllis. I use Toad constantly, and in the 15+ years I’ve been using Toad, there might have been one or two occasions that having an additional copy running would have been nice, but never a show stopper.

I have found Toad to be a critical development tool, head and shoulders above any other db tool I’ve used (except maybe MS SSMS), and the only real option out there for Oracle db’s.

How anyone could have a “hundred trillion” reasons to need multiple copies of Toad running at the same time is beyond me; maybe they should re-think how they manage their programming tasks.

for anyone seeking to run 1 Toad-instance on one monitor and another on a second monitor (like me), without the option "Allow multiple copies of Toad to be loaded" checked - because this option gives the above pitfall

solution (I have Toad 13.3):
search for "run multiple toad instances" in Toad Help (menu-item Help -> Contents) and choose topic "Run multiple Toad instances" = use startup parameter /VIRTUAL