TOAD for Oracle 9 or TOAD 10 – 64-bit Windows – ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open
I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x, no problem. This really threw me off for a minute, so I thought I would share the resolution.
You are likely running a 64-bit Windows OS and have installed TOAD into C:\Program Files (x86)\....
I simply copied over my entire Quest Software directory from C:\Program Files (x86)\... to C:\Program Files\..., and restarted the TOAD.exe. Everything is working great, without having to reinstall anything.
PS: Not sure who to blame here. Vendors (like Oracle and TOAD) should know Microsoft is capable of doing strange things with important directory names (using spaces and, in this case, “strange” characters like parentheses)…and of course, Microsoft should simply stop perpetuating the use of these characters in important directories.
UPDATE on 1/12/11: I had to install TOAD again today and noticed a message in the installer about directories with parentheses — glad to see Quest now added a note about it (see screenshot below).
Funny thing is, even though I installed to C:\Program Files\, there were still files created in C:\Program Files (x86)\ that I had to manually copy and paste over. This time, by the way, I cut and paste which also worked — so no files are actually needed in the C:\Program Files (x86)\ folders.
I wasted 9 straight hours trying to figure this out with no luck.
I finally gave up and resorted to google; and bingo!
Your post helped me out. Many thanks.
thank you very much…i spent lot of time….your post totally helped me…thanks so much
Thank you very much for the post!
It has been very useful.
It worked for me too.
I simply copied over my entire Quest Software directory from C:\Program Files (x86)\… to C:\Program Files\…, and restarted the TOAD.exe. Everything is working great, without having to reinstall anything.
Thanks guys..
if i want to install toad 9.x in win 7(64 bit), do i have to install oracle client for 64 bit?
I believe their requirements state that you need oracle client 32 bit.
My colleague struggled for a couple of days trying to sort out this issue and finally we came across your post and bingo, all set!!! Thanks a lot!
Good Post! worked fine for me
I’m running Win 7 (64) bit and Toad 9 all was ok but after installinte Toad 11 I got the ORA-12154 message. Toad 9 is still ok but not Toad 11.
I just copied the “Program Files (x86)\Quest Software” installation to a Program Files\Quest Software directory and restarted Toad from that without any probelm.
Now both version of Toad works perfectly.
Thanks.
Awesome!!!!!!!! Thanks a ton!
Thanks a lot, it really works