Problem
Toad 8.6 installation on a 64-bit windows 7 machine gives error as below when trying to connect Database.
"ORA-12154: TNS:could not resolve the connect identifier specified"
Root Cause
64-bit Microsoft OS's install 32-bit applications into the following location
"C:\Program Files (x86)\..."
rather than the typical location of
"C:\Program Files\..."
This causes an existing networking bug to occur where the networking layer is unable to parse program locations that contain parenthesis() in the path to the executable which is attempting to connect to Oracle.
Uninstall Toad from the following location
C:\Program Files (x86)\Quest Software\Toad for Oracle\
and reinstall it in the following location
C:\Oracle\Quest\Toad 9.1
(Any other location having no parenthesis in the path)
Posts
1 Response to Toad Connection Error on a Windows 64-bit Machine
Thanks.... I have this problem too :P
Post a Comment