kroy_74

Oracle not getting connected in Windows Xp 64 bit + ArcGis 9.1

Discussion created by kroy_74 on May 3, 2010
Dear Friends.
I have developed some tools using Arcobject(ArcGis 9.1) in a 32 bit windows XP machine and we have users which are using 64 bit windows xp machine with ArcGis 9.1 installed.

All the tools are working perfectly without any problem in a 32 bit windows xp machines but in the 64 bit windows xp machines the application throws following error
�??ORA-12154: TNS:could not resolve the connect identifier specified. No extended error�?�

In this application I have used �??System.Data.OracleClient�?� for the direct oracle connection. When I debugged the code in the 64 bit machine I found that this error occurs when the application tries to connect database.

I found resolution from the ESRI forum from the following Link
�??http://resources.arcgis.com/content/...how&d=31875�?�

The solution is as follows

************************************************** *
Solution or Workaround
Perform one of the following workarounds:
�?� Reinstall ArcGIS Desktop on a Windows 64-bit computer to a path that does not contain parenthesis. For example:

C:\Program Files\ArcGIS

�?� Fix the bug on a 64-bit computer:

1. Download and install the Oracle 10g 32 bit client from Oracle.com. This installs version 10.2.0.1 of the client.

2. Download and install Oracle Patch Number 4547817, which is '10.2.0.2 Patch for Windows 32-bit'. This upgrades the client to version 10.2.0.2.

3. Download and install Oracle 32-Bit Patch Number 5383042. This patch fixes Oracle Bug 3807408:
Externally authenticated usernames containing a '(',')' or '=' cannot be authenticated, additionally if a program name / path contains these characters, it may not be possible to connect (ORA-12154).
************************************************

Its working fine in the following combination

Windows 64 bit machine+ArcGIS �??9.2�?�(Installed in \Program files (X64) folder)+Oracle 11g 32 bit Client

But not working in the following combination

Windows 64 bit machine+ArcGIS �??9.1�?�(Installed in outside \Program files (X64) folder)+Oracle 11g 32 bit Client
As mentioned before the application throws following error for the above combination

�??ORA-12154: TNS:could not resolve the connect identifier specified. No extended error�?�


Please help me for this issue as our users are reluctant to upgrade to ArcGis 9.2

Outcomes