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

By M&S Consulting (Ashok) on Feb 27th, 2010
Filed Under Technical Tips // Tags: in the trenches, oracle dev, oracle sql, quest toad

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.

Related Information:

TOAD SQL Editor Useful Shortcuts

SHIFT-F9 This will run only the SQL that your cursor is on. You do not need to highlight the line...

Upgrading to APEX 4 on Oracle XE and Windows

Overview
 This tutorial article and it's associated video will help guide you through the process of upgrading a previously installed...

BPA 10.1.3.4 Windows Install with XE

I have just had a heck of a time with installing BPA (Architect) Evaluation on a Windows Server 2003 machine....

Oracle Materialized View DDL

Are you a TOAD fanatic when it comes to “anything-Oracle”? If so, you probably realized that TOAD will not show...

Outlook/Exchange 2003 Address Book

Have you wondered why the Outlook/Exchange 2003 address book does the (sometimes strange) things that it does? …when does it...

Oracle Express Edition (XE) 10g Windows Download

The following are links to the download page for Oracle Database 10g Release 2 (10.2.0.1) Express Edition (XE) for Microsoft...

Installing APEX 4 on Windows Server 2003 64 bit edition with Oracle Database 11g

Overview
 This tutorial article and it's associated video will help guide you through the process of installing APEX version 4.0...

SQL LIKE - Oracle LIKE Operator - SQL Syntax Examples

The reserved word LIKE in Oracle SQL represents an operator that performs some basic matching on text. LIKE provides a...

7 Responses to “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”

Stuart
Mar 02, 2010

I’d really like to thank you for your post. It was really that simple.
- ashok.aggarwal
  Mar 02, 2010
  
  Thank you for your comment, Stuart. I’m glad this helped you.
J.Mari
Apr 12, 2010

Hi,

I have installed oracle 10.2.0.1.0 on xp 64 bit and i have installed toad 9.5 when trying to connect i got an error message that “You have no Oracle clients installed”.So i copied the entries of Quest Software directory from C:\Program Files (x86)\… to C:\Program Files\…, and restarted the TOAD.exe.Still getting the same error.Could you help me to fix this?

Thanks in advance
J.Mari…
Mark Lerch
Apr 16, 2010

This is a known Oracle bug. There are patches for it for 10G Instant Client as well as the 10G 64 bit client. Here is one thread among many talking about it-
http://forums.oracle.com/forums/thread.jspa?messageID=3810917

Mark
Toad Dev Team
jkm
May 03, 2010

Thankyou…just spent all day working this issue!
Aj
Jun 17, 2010

Thanks mate it worked!
Huub Vankan
Jun 28, 2010

Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….