Hi All, my case is the following: In the GIS server I have installed oracle client 11g r2 32 bits to connect Arcgis Desktop to oracle DB and also I have installed the oracle client 11g r2 64 bits to register Oracle with ArcGIS Server. The connection from AGS Desktop to oracle has been done succesfully, however the moment of register the ORA database with ArcGIS Server I got the following error: [Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.] Thanks in advance
I am glad to hear that it started to work. I did not mention that you need to "restart" the ArcGIS clients (ArcGIS Desktop, ArcGIS Server, etc....) after updating the PATH variable, sorry.
Sounds like you may have the PATH variable for the clients incorrect. The 64-bit client goes first in the PATH variable if you have desktop and server installed on the same machine.
Are you using the full Oracle client or the Instant Client provided by Esri?
Thanks George, I think that the dba install the full oracle client. Is there any difference between the full client and the provided by esri? We did what say in the link that you sent me. In the PATH variable we put first the 64 bits and next 32 bits but without success. what could it be happening? As an comment in this GIS Server initially installed the oracle client 12 of 32 bits but ArcGIS Desktop could not connect to oracle then we installed the oracle client 11g 32 bits and we could connect ArcGIS Desktop to oracle. After we install the oracle client 11g 64 bits to connect ArcGIS Server but without success. Thanks in advance.
The client that Esri provides is an Instant Client (Light weight). You are not required to install the full client to make a connection. You could test by downloading the Instant Client form the Customer Care Portal and follow in the installation instructions.
Thanks George, Finally I could register my oracle database with my ArcGIS Server 10.2.1. I just reboot the GIS Server and the setting is as it say in the arcgis resource. My oracle DB is in Linux red hat 6.4. Best Regards,
I am glad to hear that it started to work. I did not mention that you need to "restart" the ArcGIS clients (ArcGIS Desktop, ArcGIS Server, etc....) after updating the PATH variable, sorry.