topic Failed to connect to the specified DBMS instance in Geodatabase Questions

Failed to connect to the specified DBMS instance

Amjad_Bahati — Sun, 01 Aug 2021 22:28:28 GMT

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.

Please let me know if you have any idea

Many thanks.

Re: Failed to connect to the specified DBMS instance

DavinWalker2 — Sun, 01 Aug 2021 23:15:39 GMT

Hi Amjad,

Hopefully this ESRI Technical Article can assist.

Re: Failed to connect to the specified DBMS instance

John_Spence — Mon, 02 Aug 2021 00:33:59 GMT

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

Re: Failed to connect to the specified DBMS instance

Amjad_Bahati — Mon, 02 Aug 2021 12:22:08 GMT

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.

Re: Failed to connect to the specified DBMS instance

MichaelVolz — Mon, 02 Aug 2021 12:13:45 GMT

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

Re: Failed to connect to the specified DBMS instance

Amjad_Bahati — Wed, 25 Aug 2021 11:21:06 GMT

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

Re: Failed to connect to the specified DBMS instance

George_Thompson — Wed, 25 Aug 2021 13:20:11 GMT

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?

Re: Failed to connect to the specified DBMS instance

Amjad_Bahati — Sun, 29 Aug 2021 09:06:32 GMT

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

I am using TNSNAMES ..

Re: Failed to connect to the specified DBMS instance

George_Thompson — Mon, 30 Aug 2021 10:49:06 GMT

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

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