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; } } }

underlying dbms error whileconnceting to oracle database

SatyamDave

error while connecting to database

Find more posts tagged with

Accepted answers

All comments

BirajaNayak

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

AlexandraDubovis2

Is it the same patch for 10.6.1?

Asrujit_SenGupta

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.

SatyamDave

any idea abt this ???

Asrujit_SenGupta

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.

SatyamDave

hi Asrujit SenGupta,

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

Asrujit_SenGupta

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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