topic Re: Failed to connect to database. Underlying DMS error in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864470#M5921 <HTML><HEAD></HEAD><BODY><P>It is Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production</P><P></P><P>Do you have a sample for TNS or LDAP access?</P><P></P><P>In Oracle SQL Server I am using LDAP as connection Type</P></BODY></HTML> Mon, 15 Jun 2020 13:43:27 GMT JoseSanchez 2020-06-15T13:43:27Z Failed to connect to database. Underlying DMS error https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864468#M5919 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am trying to connect to an Oracle database with ArcCatalog and one of the accounts is returns the following error message:</P><P></P><P>Failed to Connect to Database. Underlying DBMS error [Unknown error:&nbsp; ...]</P><P></P><P>I am able to connect to this database same database using Oracle SQL Developer .</P></BODY></HTML> Mon, 15 Jun 2020 13:03:14 GMT https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864468#M5919 JoseSanchez 2020-06-15T13:03:14Z Re: Failed to connect to database. Underlying DMS error https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864469#M5920 <HTML><HEAD></HEAD><BODY><P>I would recommend removing the "sde:oracle11g:.." from the instance name. I would use TNS or EZConnect syntax.</P><P></P><P>What version is the ArcGIS Client?</P><P></P><P>What version is the Oracle geodatabase?</P></BODY></HTML> Mon, 15 Jun 2020 13:07:13 GMT https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864469#M5920 George_Thompson 2020-06-15T13:07:13Z Re: Failed to connect to database. Underlying DMS error https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864470#M5921 <HTML><HEAD></HEAD><BODY><P>It is Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production</P><P></P><P>Do you have a sample for TNS or LDAP access?</P><P></P><P>In Oracle SQL Server I am using LDAP as connection Type</P></BODY></HTML> Mon, 15 Jun 2020 13:43:27 GMT https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864470#M5921 JoseSanchez 2020-06-15T13:43:27Z Re: Failed to connect to database. Underlying DMS error https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864471#M5922 <HTML><HEAD></HEAD><BODY><P>This is usually something set up on the Oracle DBA side and outside of ArcGIS.</P><P></P><P>I have used TNS alot with no issues. I have not used LDAP before.</P><P></P><P>I would review the Oracle doc for more guidance;&nbsp;<A class="link-titled" href="https://docs.oracle.com/en/database/oracle/oracle-database/12.2/netrf/local-naming-parameters-in-tnsnames-ora-file.html#GUID-A3F9D023-9CC4-445D-8921-6E40BD900EAD" title="https://docs.oracle.com/en/database/oracle/oracle-database/12.2/netrf/local-naming-parameters-in-tnsnames-ora-file.html#GUID-A3F9D023-9CC4-445D-8921-6E40BD900EAD">Local Naming Parameters in the tnsnames.ora File</A>&nbsp;</P></BODY></HTML> Mon, 15 Jun 2020 13:48:56 GMT https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864471#M5922 George_Thompson 2020-06-15T13:48:56Z Re: Failed to connect to database. Underlying DMS error https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864472#M5923 <HTML><HEAD></HEAD><BODY><P>That connect string looks odd to me.&nbsp; What is the name of the database you are trying to connect to?</P></BODY></HTML> Mon, 15 Jun 2020 15:57:25 GMT https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864472#M5923 JoshuaBixby 2020-06-15T15:57:25Z Re: Failed to connect to database. Underlying DMS error https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864473#M5924 <HTML><HEAD></HEAD><BODY><P>I did the same test with ArcCatalog 10.7.1 and it worked fine.</P><P></P><P>These are the values I use on the connection:</P><P>Database Platform: Oracle</P><P>Instance:&nbsp;sde:oracle11g:[Instance]</P><P>Authentication Type: Database Authentication</P><P>UserName: [UserId]</P><P>Password; [Password]</P><P></P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/496781_ConnectFromArcCatalog107.png" /></P></BODY></HTML> Tue, 16 Jun 2020 12:26:52 GMT https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864473#M5924 JoseSanchez 2020-06-16T12:26:52Z Re: Failed to connect to database. Underlying DMS error https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864474#M5925 <HTML><HEAD></HEAD><BODY><P>Ok, you still do not need to add the sde:oracle11g:..." in the instance field. Is it being added when you reopen the connection?</P><P></P><P>If you just add the Oracle Instance to the "Instance" entry, in ArcGIS Pro, do you still get the same behavior?</P><P></P><P>Do you have the 64-bit Oracle client configured on that machine?</P></BODY></HTML> Tue, 16 Jun 2020 12:34:20 GMT https://community.esri.com/t5/geodatabase-questions/failed-to-connect-to-database-underlying-dms-error/m-p/864474#M5925 George_Thompson 2020-06-16T12:34:20Z