Failed to connect to the specified DBMS instance

512
8
08-01-2021 03:28 PM
Amjad_Bahati
New Contributor

Hello, Dear All

I have a problem with a database connection, when I am trying to connect to oracle database, I face the below-attached error.

Amjad_Bahati_0-1627855902836.png

Please let me know if you have any idea

Many thanks.

 

 

 

 

0 Kudos
8 Replies
DavinWalker2
Esri Contributor

Hi Amjad,

Hopefully this ESRI Technical Article can assist.

John_Spence
Occasional Contributor II

That error message looks like it is missing some information and/or letters.

0 Kudos
Amjad_Bahati
New Contributor

Just as a reminder, I'm only  faced  with ArcGISPro 2.8

I've solved with ArcMap 10.7 by download Oracle Instant Client "instantclient_11_2" and placed on drive C then named it under environment variables under path as C:\instantclient_11_2 and it works.

0 Kudos
MichaelVolz
Esteemed Contributor

You would need a 64-bit Instant Client for Pro whereas ArcMap uses the 32-bit Instant Client.

0 Kudos
Amjad_Bahati
New Contributor

Dear All

I tried to use many solutions to fix this issue... I instilled 64- bit client for ArcPro I reinstalled ArcPro but I got an unknown error !! it is different from the previous error please see in below picture

 

Amjad_Bahati_0-1629890405508.png

 

 

 

 

 

 

0 Kudos
George_Thompson
Esri Frequent Contributor

Did you put the 64 bit client before the 32 bit client in the PATH variable?

Are you using TNSNAMES or EZConnect for the instance field?

--- George T.
0 Kudos
Amjad_Bahati
New Contributor

Amjad_Bahati_0-1630227927584.png

yes, I've put it 64 before ...

I am using TNSNAMES ..

0 Kudos
George_Thompson
Esri Frequent Contributor

Did you configure the TNSNAMES for the instant client following this article?

https://support.esri.com/en/technical-article/000011850

--- George T.
0 Kudos