topic Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle. in ArcGIS Pro Questions

ArcGIS Pro Beta cannot connect to SDE based on Oracle.

AZendel — Thu, 17 Jul 2014 16:55:11 GMT

I'm using Beta 4, Build 1141. I copied the instance 'string' from ArcCatalog 10.2.0 to the instance string input box in ArcGIS Pro. The ArcCatalog connection dialog box is on the left and the AGP dialog box is on the right. They are identical

I have no problem connecting to and editing this SDE database via ArcMap, which strongly suggests that the Oracle client libraries are properly installed on my computer. But I get the following error from AGP when I click 'OK'

---------------------------

Connection Error

---------------------------

Failed to connect to the specified server.

A database connection exception has occurred.

Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.

---------------------------

Any ideas what's going on or how I can correct this problem? I realize that this is a beta version......

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

AsrujitSengupta — Thu, 17 Jul 2014 17:01:44 GMT

ArcGIS Pro is a 64-bit application and thus will need Oracle 64-bit Client to be present for you to connect.

The ArcGIS Desktop is a 32-bit application and should be using the Oracle 32-bit client libraries to connect.

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

AZendel — Thu, 17 Jul 2014 18:36:33 GMT

Of course! I bet that's the issue. Oracle client configurations can be tricky, especially when using LDAP and OS Authentication. I'm tempted to co-install the 64-bit client to run along side the current 32-bit installation, but I'm not going to risk causing problems with my ability to edit critical SDE feature classes.

Another question: I'm aware that some 10.2 'background' geoprocessing tools run on 64-bit. In ArcGIS Pro, do all of the other geoprocessing tools run on 64-bit? Or is ArcGIS Pro using the same geoprocessing libraries as 10.2?

Thanks for the speedy response,

Alex

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

AsrujitSengupta — Thu, 17 Jul 2014 18:50:31 GMT

I am not completely sure about that, but am 99% sure that the answer to that question is Yes! All the GP tools run on 64-bit

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

TonyAlfredsson — Wed, 29 Oct 2014 13:02:31 GMT

So what is the recommended configuration if you use both ArcGIS Desktop 10.x and ArcGIS Pro and like to connect to Oracle databases from both clients?

Regards, Tony

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

AsrujitSengupta — Wed, 29 Oct 2014 13:16:07 GMT

Install both the 64-bit & 32-bit Oracle client and then ensure that the 64-bit client is listed first in the path environment variable.

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

TonyAlfredsson — Wed, 29 Oct 2014 13:21:51 GMT

Ah 64-bit first in the path, thank you for the quick reply!

Regards, Tony

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

AZendel — Thu, 13 Nov 2014 15:44:50 GMT

Tony,

Are you successfully running 32 bit and 64 bit oracle clients on the same Windows desktops? It would be nice to use the 64 bit geoprocessing on Pro but I absolutely need to be edit our SDE data that I'm currently accessing via the 32 bit client.

Also, are you having to change the path string when you need to switch between 32 and 64? Or is it "seamless"?

Thanks

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

AsrujitSengupta — Thu, 13 Nov 2014 15:47:26 GMT

It should be seamless. You don't need to change the path string when you need to switch between 32 and 64.

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

TonyAlfredsson — Fri, 14 Nov 2014 07:30:40 GMT

Hi,

Yeah, it was seamless. Worked very well

Regards, Tony

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

MichaelVolz — Tue, 24 Jan 2017 18:43:09 GMT

Asrujit:

Do you know where the .sde files would be stored for Pro in a Windows 10 environment?

I can find the .sde files for ArcCatalog at

C:\Users\"User Name"\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

MichaelVolz — Tue, 24 Jan 2017 18:56:00 GMT

I found the location, at least for me:

C:\Users\"User Name"\AppData\Local\ESRI\Index\Connections

Now I imported an mxd into a new Pro project with 1 SDE layer, but this SDE connection did not get added to this location. It appears that only database connections created within a Pro project get the SDE connection file added to this location. It would be nice for all distinct SDE connection files to be added to the above location in the Pro project automatically so they can be used to add additional SDE layers to the Pro project.

Re: ArcGIS Pro Beta cannot connect to SDE based on Oracle.

HakanKOCAMAN1 — Wed, 05 Apr 2017 12:00:31 GMT

It is worked this method for me.

Note: Adam haklı beyler.