topic Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version in Geodatabase Questions

Oracle 12.2 connection from ArcGIS 10.5 or higher version

ÖmerÜNSAL — Mon, 14 Aug 2017 11:54:55 GMT

Hi,

Is there someone who can connect to Oracle 12.2 form ArcGIS 10.5 or higher version?

Do you know the time or version for this connection?

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

VinceAngelo — Mon, 14 Aug 2017 13:01:59 GMT

The system requirements for 10.5.x don't mention Oracle 12.2 or 13.x. It's unlikely that Esri will announce a time when they will be supported. Contacting Tech Support to get on a list is your best recourse.

- V

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

VinceAngelo — Fri, 24 Nov 2017 18:42:11 GMT

Okay, so it appears that Oracle 12cR2 support is now available with ArcGIS 10.5.1 builds with the ArcGIS 10.5.1 (Desktop, Engine, Server) Oracle critical issues and 12.2.0.1 support Patch applied.

- V

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

GonçaloRevez1 — Wed, 20 Dec 2017 17:09:00 GMT

Hi,

After aplying the patch, I tried to connect with ArcGIS 10.5.1 Desktop to Oracle 12.2 64bits (Enterprise Linux - Oracle Developer days virtual machine).

The ArcGIS 10.5.1 Desktop create the database connection but when I select it to connect, the ArcGIS Desktop blocks and stays Not Responding.

I used several oracle client (and instant) both x64 and x32 (12.2 and 11.2.0.4 as it says on patch)

I can connect through sqldeveloper and sql plus easy connect.

Thanks,

Gonçalo Revez

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

VinceAngelo — Wed, 20 Dec 2017 17:48:03 GMT

This is probably something to discuss directly with Tech Support. The alternative is to post a new question, giving lots of details on the exact OS and software, the exact PATH contents, and the exact procedure to produce the error.

- V

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

MichaelVolz — Wed, 20 Dec 2017 18:40:54 GMT

What is the exact version of the Oracle database that you are trying to connect to. You mention 12.2, but the ESRI patch documentation explicitly references 12.2.0.1. Could it be that you are at a higher version of Oracle than 12.2.0.1?

ArcGIS 10.5.1 (Desktop, Engine, Server) Oracle critical issues and 12.2.0.1 support Patch

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

GonçaloRevez1 — Wed, 20 Dec 2017 19:01:54 GMT

The release is 12.2.0.1, the same as the Patch.

An update:

I was trying connecting with system user.

I created a new user, and now I can connect to the Oracle, but the connection took 5 to 10 min to connect!

I just created one table to see it on ArcGIS 10.5.1 Desktop.

Thanks

Gonçalo Revez

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

MichaelVolz — Wed, 20 Dec 2017 19:20:32 GMT

Is the system user a user with elevated privileges to the database whereas a new user just has viewer privileges? I'm asking because it seems odd that you could not make a connection with the system user.

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

GonçaloRevez1 — Thu, 21 Dec 2017 00:25:00 GMT

Hi,

it seems some kind of priviliges that ArcGIS is trying to access.

With a simple user with grant connect session took 5 min.

With system user took more than 1 hour.

With sys user is immediatly.

Thanks.

Re: Oracle 12.2 connection from ArcGIS 10.5 or higher version

VinceAngelo — Thu, 21 Dec 2017 16:24:18 GMT

There are very few reasons to ever connect using ArcGIS as SYSTEM (it probably qualifies as a Worst Practice). This is especially true if the number of objects in the database is large, since connection time closely correlates to the number of objects visible by the user (and SYSTEM can see everything, including the thousands of demo/sample tables that should not reside in any production server).

- V