When creating a direct connect from ArcGIS Desktop installed on a computer installed with Windows 64-bit, the following error message is displayed:
"Failed to connect to the specified server. Underlying DBMS error[ORA-12154: TNS:could not resolve the connect identifier specified. No extended error.]"
Note: This article pertains to ArcGIS versions 9.x only. Later versions of ArcGIS may contain different functionality, as well as different names and locations for menus, commands and geoprocessing tools.
This is a known issue with parentheses in install path names on the Windows 64-bit operating system.
Perform one of the following workarounds:
Note: Externally authenticated usernames containing a parenthsis or an equal sign cannot be authenticated. Additionally, if a program name / path contains these characters, it may not be possible to connect (ORA-12154).