Failed to connect to database. Underlying DMS error

[JoseSanchez]

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 .

[George_Thompson]

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?

[JoseSanchez]

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

[George_Thompson]

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 

[JoshuaBixby]

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

[JoseSanchez]

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]

[George_Thompson]

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?