Select to view content in your preferred language

Failed to connect to database. Underlying DMS error

921
6
06-15-2020 06:03 AM
JoseSanchez
Regular Contributor

Hello everyone,

I am trying to connect to an Oracle database with ArcCatalog and one of the accounts is returns the following error message:

Failed to Connect to Database. Underlying DBMS error [Unknown error:  ...]

I am able to connect to this database same database using Oracle SQL Developer .

0 Kudos
6 Replies
George_Thompson
Esri Frequent Contributor

I would recommend removing the "sde:oracle11g:.." from the instance name. I would use TNS or EZConnect syntax.

What version is the ArcGIS Client?

What version is the Oracle geodatabase?

--- George T.
0 Kudos
JoseSanchez
Regular Contributor

It is Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Do you have a sample for TNS or LDAP access?

In Oracle SQL Server I am using LDAP as connection Type

0 Kudos
George_Thompson
Esri Frequent Contributor

This is usually something set up on the Oracle DBA side and outside of ArcGIS.

I have used TNS alot with no issues. I have not used LDAP before.

I would review the Oracle doc for more guidance; Local Naming Parameters in the tnsnames.ora File 

--- George T.
0 Kudos
JoshuaBixby
MVP Esteemed Contributor

That connect string looks odd to me.  What is the name of the database you are trying to connect to?

0 Kudos
JoseSanchez
Regular Contributor

I did the same test with ArcCatalog 10.7.1 and it worked fine.

These are the values I use on the connection:

Database Platform: Oracle

Instance: sde:oracle11g:[Instance]

Authentication Type: Database Authentication

UserName: [UserId]

Password; [Password]

0 Kudos
George_Thompson
Esri Frequent Contributor

Ok, you still do not need to add the sde:oracle11g:..." in the instance field. Is it being added when you reopen the connection?

If you just add the Oracle Instance to the "Instance" entry, in ArcGIS Pro, do you still get the same behavior?

Do you have the 64-bit Oracle client configured on that machine?

--- George T.
0 Kudos