topic Re: failed to connect to database in Data Management Questions

failed to connect to database

SyedMasood_Khadri — Thu, 12 Jun 2014 03:53:59 GMT

hi

I have installed Oracle client 64 bit software on windows 2008 R2 server.
The Oracle database server 11g R2 is on Redhat Linux 5.
The oracle client is able to connect with server by using SQLPLUS.
But it is failed to connect to database from ArcGIS desktop 10.1
Does it require any additional config ??
Please help me.

Re: failed to connect to database

EmadAl-Mousa — Thu, 12 Jun 2014 09:00:48 GMT

try installing oracle 11g client 32 bit. (after removing the old oracle 11g 64bit client)

Regards,

Re: failed to connect to database

SyedMasood_Khadri — Thu, 12 Jun 2014 10:27:59 GMT

Hi

Oracle client 32-bit was there before and able to connect with database server without any problem.
But we also have ArcGIS server and our database requires registration and hence 64-bit is required.

Re: failed to connect to database

George_Thompson — Thu, 12 Jun 2014 12:19:52 GMT

Make sure the 64-bit client is first in the PATH variable, then the 32-bit client. This should allow you to connect to your Oracle database form both ArcCatalog and ArcGIS Server.

Registering an Oracle database with server: http://resources.arcgis.com/en/help/main/10.2/index.html#/Registering_an_Oracle_database_with_the_server/015400000617000000/

-George

Re: failed to connect to database

SyedMasood_Khadri — Thu, 12 Jun 2014 12:58:50 GMT

hi

i have removed 32-bit client before installing 64-bit. Is this ok ? Whether it requires both clients ?

Do i need to remove path of 32-bit client in env variable or shall i maintain the order as mentioned by you ?

Re: failed to connect to database

AsrujitSengupta — Thu, 12 Jun 2014 13:20:43 GMT

You need both the 32-bit and 64-bit client installed on that machine.

Once they are both installed, just make sure the 64-bit client is first in the PATH variable in the Environment Variable and then try connecting.

Re: failed to connect to database

VinceAngelo — Thu, 12 Jun 2014 14:06:23 GMT

If you have a 64-bit Oracle install, a 64-bit Server install and a 32-bit Desktop install
on the same host, you may need to add both 32-bit and 64-bit Instant Client software
to get the PATH to have the right clients in the right order.

Sometimes it helps to split up the software stack, and place Desktop on a different host,
without the database or Server components to muddle the 32-bit/64-bit evaluation order.

- V

Re: failed to connect to database

SyedMasood_Khadri — Fri, 13 Jun 2014 09:01:17 GMT

Thanks to all, registered arcgis server with oracle

Re: failed to connect to database

VinceAngelo — Fri, 13 Jun 2014 09:59:22 GMT

It would help others who find this thread if you mention what it
actually took to fix the problem. Think of it as payment for the
assistance.

- V

Re: failed to connect to database

SyedMasood_Khadri — Sat, 14 Jun 2014 07:37:54 GMT

i have set environment variable order for PATH as suggested
how to mark this thread as answered ?

Re: failed to connect to database

VinceAngelo — Sat, 14 Jun 2014 20:27:32 GMT

http://resources.arcgis.com/en/help/forums-mvp/ #4