underlying dbms error whileconnceting to oracle database

3831
13
10-14-2018 10:21 AM
SatyamDave
New Contributor

error while connecting to database

0 Kudos
13 Replies
Asrujit_SenGupta
MVP Regular Contributor

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?
SatyamDave
New Contributor

hi Asrujit SenGupta,

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

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

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.

0 Kudos
SatyamDave
New Contributor

any idea abt this ???

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

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.

AlexandraDubovis2
New Contributor III

Is it the same patch for 10.6.1?

0 Kudos
BirajaNayak
Esri Contributor

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

0 Kudos
AlexandraDubovis2
New Contributor III

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

0 Kudos
BirajaNayak
Esri Contributor

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

0 Kudos