Failed to connect to database. Underlying DMS error

Question

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 .

ArcCatalogOracle.png

Katherine_Clark_0-1655390911431.png

George_Thompson · Answer

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?

JoseSanchez · Answer

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]

JoshuaBixby · Answer

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