underlying dbms error whileconnceting to oracle database

1228
13
10-14-2018 10:21 AM
Highlighted
New Contributor

error while connecting to database

Reply
0 Kudos
13 Replies
Highlighted
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?
Highlighted
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

Reply
0 Kudos
Highlighted
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.

Reply
0 Kudos
Highlighted
New Contributor

any idea abt this ???

Reply
0 Kudos
Highlighted
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.

Highlighted
New Contributor III

Is it the same patch for 10.6.1?

Reply
0 Kudos
Highlighted
Occasional Contributor III

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

Reply
0 Kudos
Highlighted
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

Reply
0 Kudos
Highlighted
Occasional Contributor III

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

Reply
0 Kudos