topic Re: issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment in ArcGIS Enterprise Questions

issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment

IrvinGoldblatt — Thu, 28 Jul 2016 19:20:10 GMT

I install 32 bit client and ArcGIS Desktop (arcCatalog) can access our Oracle SDE databases. However, when I install the 64 bit client, I can get ArcGIS Pro to access the SDE Database but get client not running error with 32 bit ArcCatalog access. Any suggestions? Our IT department has banned 11.2 clients, which we did successfully get 11.2 32bit and 12.164bit to work together.

Re: issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment

JoshuaBixby — Thu, 28 Jul 2016 22:37:45 GMT

Looping in the Geodatabase place.

Re: issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment

AsrujitSengupta — Thu, 28 Jul 2016 22:42:53 GMT

We will need more details...

What is the version of Oracle database (Example: Oracle 11.2.0.4 )

Version of ArcGIS Desktop and ArcGIS Pro

Version of the Oracle Clients installed

Type of Oracle Client being used (Full Client or Instant Client)

In the Environment Variable, you need to place the 64-bit client ahead of the 32-bit Client to get both 64-bit and 32-bit Applications to work successfully.

Re: issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment

IrvinGoldblatt — Thu, 28 Jul 2016 23:01:27 GMT

As stated Client versions are 12.1 32 and 64 bit, full clients. Hitting oracle 11.2 database. SDE version 10.2.2.

ArcGIS 10.3.3

Arcgis Pro 1.3

64 bit client is first in PATH.

Re: issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment

IrvinGoldblatt — Thu, 28 Jul 2016 23:03:15 GMT

Additional thought. As stated, 32 bit client worked until 64 bit installed. I am wondering if that is the issue. Are any users able to have both clients on a Windows 10 p=workstation work with Desktop and Pro?

Re: issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment

User35489 — Mon, 15 Aug 2016 10:54:40 GMT

@ Irvin,

32 bit is required for connection. 64 bit probably is causing loss in connectivity.

I have 32 as well as 64 on my workstation. If you need to have both, try installing both in different sequence. It shall work.

Re: issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment

JoshuaBixby — Mon, 15 Aug 2016 14:17:56 GMT

If you reverse the PATH order of the 32-bit and 64-bit client, I assume ArcMap will work, but I would be interested whether ArcGIS Pro still does.

Re: issues witth Oracle 12.1 32 bit and 64 bit clients running on Windows 10 environment

IrvinGoldblatt — Mon, 15 Aug 2016 14:27:29 GMT

The issue is that when the 64 bit client is installed the user account loses rights to the 32 bit install folder. We have IT staff looking into issue. Just wondering if others had this issue and how it was resolved. Sounds like we have a security profile that is unique and causing the issue.

Irvin A Goldblatt

IDEM/IS 317-233-3410