nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Pro Beta cannot connect to SDE based on Oracle.

AZendel

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......

Najděte více příspěvků označených jako

Accepted answers

AsrujitSengupta

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.

All comments

HakanKOCAMAN1

It is worked this method for me.

Note: Adam haklı beyler.

mvolz47

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.

mvolz47

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

TonyAlfredsson

Hi,

Yeah, it was seamless. Worked very well

Regards, Tony

AsrujitSengupta

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

AZendel

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

TonyAlfredsson

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

Regards, Tony

AsrujitSengupta

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.

TonyAlfredsson

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

AsrujitSengupta

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

AZendel

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

AsrujitSengupta

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.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.