topic Re: underlying dbms error whileconnceting to oracle database in Geodatabase Questions

underlying dbms error whileconnceting to oracle database

SatyamDave — Sun, 14 Oct 2018 17:21:54 GMT

error while connecting to database

Re: underlying dbms error whileconnceting to oracle database

Asrujit_SenGupta — Mon, 15 Oct 2018 04:02:15 GMT

For a start, check other similar posts on GeoNet:

connect oracle 12c from arcgis for desktop and server 10.3.1

What version for ArcGIS Desktop (Example: ArcGIS Desktop 10.5) and Oracle database (Example: Oracle 11.2.0.4) are you working with?
Is Oracle installed on the same machine as ArcGIS Desktop? If not, does the Desktop machine have access to the Database server?
Are you able to connect using SQLPlus in cmd from the same machine?

Re: underlying dbms error whileconnceting to oracle database

SatyamDave — Mon, 15 Oct 2018 06:21:30 GMT

hi Asrujit SenGupta,

im using 10.5, 12C R2(12.2) on the same machine, and even i can connect to sqlplus from CMD

Re: underlying dbms error whileconnceting to oracle database

Asrujit_SenGupta — Mon, 15 Oct 2018 06:54:20 GMT

Oracle database requirements for ArcGIS 10.5.x—System Requirements | ArcGIS Desktop

*You must install ArcGIS 10.5.1 (Desktop, Engine, Server) Oracle critical issues and 12.2.01 Support Patch on all 10.5.1 client machines to use Oracle 12.2.01 with ArcGIS

I think connection from ArcGIS Desktop 10.5 is not supported. You will need Desktop 10.5.1 along with the below patch:

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

Also, make sure you are putting the correct hostname in the connection file.

Re: underlying dbms error whileconnceting to oracle database

SatyamDave — Mon, 15 Oct 2018 07:58:51 GMT

any idea abt this ???

Re: underlying dbms error whileconnceting to oracle database

Asrujit_SenGupta — Mon, 15 Oct 2018 08:03:09 GMT

You must have ArcGIS 10.5 installed.....the patch is for ArcGIS 10.5.1. Desktop 10.5 and Desktop 10.5.1 are different ArcGIS Desktop versions.

So download the setup for ArcGIS Desktop 10.5.1, install it, install the patch and then try connecting to your Database.

Re: underlying dbms error whileconnceting to oracle database

AlexandraDubovis2 — Tue, 13 Aug 2019 20:15:30 GMT

Is it the same patch for 10.6.1?

Re: underlying dbms error whileconnceting to oracle database

BirajaNayak — Wed, 14 Aug 2019 01:11:45 GMT

ArcMap or ArcGIS 10.6.1 supports Oracle 12.2 and here is the web help link:

Oracle database requirements for ArcGIS 10.6.x—System Requirements | ArcGIS Desktop

Asrujit suggested the oracle critical patch for ArcMAP 10.5.1 as you are using 10.5.1 with Oracle 12.2. If you upgraded your ArcGIS Desktop or AraMAP to 10.6.1 then you can directly connect to Oracle 12.2 as 10.6.1 supports Oracle 12.2 and do not need the patch. That patch is for ArcMAP 10.5.1.

Thanks,

Biraja

Re: underlying dbms error whileconnceting to oracle database

AlexandraDubovis2 — Wed, 14 Aug 2019 11:19:11 GMT

Database is still 11G and has no SDE. I have no issues to connect to the database from 10.2.2 desktop. We are testing upgrade to 10.6.1 now.

Thanks,

Alex

Re: underlying dbms error whileconnceting to oracle database

BirajaNayak — Wed, 14 Aug 2019 16:11:15 GMT

Hi Alex,

10.6.1 supports both oracle 11g ( Oracle 11.2.0.4) and Oracle 12.2. You should be good to go as far as connection from ArcGIS is concern.

Thanks,

Biraja

Re: underlying dbms error whileconnceting to oracle database

AlexandraDubovis2 — Wed, 14 Aug 2019 16:42:36 GMT

I found patches for 10.6.1 https://support.esri.com/en/download/7675

Getting ready to install. Will let you know ☺

Re: underlying dbms error whileconnceting to oracle database

BirajaNayak — Wed, 14 Aug 2019 16:50:52 GMT

Hi Alex,

Patch" https://support.esri.com/en/download/76" is for Oracle 18c. You have Oracle 11g. Just for your reference.

Thanks,

Biraja

Re: underlying dbms error whileconnceting to oracle database

AlexandraDubovis2 — Wed, 14 Aug 2019 16:58:48 GMT

Read the comments. It is working for 11 and above. And it did fix my problem.

Re: underlying dbms error whileconnceting to oracle database

AlexandraDubovis2 — Wed, 14 Aug 2019 16:58:48 GMT

It works ☺.

Thank you so much for your help,

Alex