topic Update the TNSNames file on the SOC machines in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/update-the-tnsnames-file-on-the-soc-machines/m-p/122793#M4766 <HTML><HEAD></HEAD><BODY><SPAN>We added a new oracle database. Then updated the TNSNames file on the SOM machines and started testing it with Map Services. </SPAN><BR /><BR /><SPAN>We were having problems with the following errors:</SPAN><BR /><BR /><SPAN>The Layer:'Counties' in Map:'Data Layers' is invalid. The base table definition string "NEWSCHEMA.COUNTIES" is invalid. Underlying DBMS error [ORA-12154: TNS:could not resolve the connect identifier specified No extended error.].</SPAN><BR /><BR /><BR /><SPAN>It would work sometimes but other times, not.&nbsp; We missed the step to update the TNSNames files on other SOC machines.&nbsp; Hopefully this will help you if you run into a similar situation.</SPAN></BODY></HTML> Thu, 16 Aug 2012 14:23:15 GMT soniadickerson1 2012-08-16T14:23:15Z Update the TNSNames file on the SOC machines https://community.esri.com/t5/arcgis-enterprise-questions/update-the-tnsnames-file-on-the-soc-machines/m-p/122793#M4766 <HTML><HEAD></HEAD><BODY><SPAN>We added a new oracle database. Then updated the TNSNames file on the SOM machines and started testing it with Map Services. </SPAN><BR /><BR /><SPAN>We were having problems with the following errors:</SPAN><BR /><BR /><SPAN>The Layer:'Counties' in Map:'Data Layers' is invalid. The base table definition string "NEWSCHEMA.COUNTIES" is invalid. Underlying DBMS error [ORA-12154: TNS:could not resolve the connect identifier specified No extended error.].</SPAN><BR /><BR /><BR /><SPAN>It would work sometimes but other times, not.&nbsp; We missed the step to update the TNSNames files on other SOC machines.&nbsp; Hopefully this will help you if you run into a similar situation.</SPAN></BODY></HTML> Thu, 16 Aug 2012 14:23:15 GMT https://community.esri.com/t5/arcgis-enterprise-questions/update-the-tnsnames-file-on-the-soc-machines/m-p/122793#M4766 soniadickerson1 2012-08-16T14:23:15Z Re: Update the TNSNames file on the SOC machines https://community.esri.com/t5/arcgis-enterprise-questions/update-the-tnsnames-file-on-the-soc-machines/m-p/122794#M4767 <HTML><HEAD></HEAD><BODY><SPAN>using the TNS_Admin system variable to have all the SOC servers use the same tnsnames.ora would solve this problem as would a sync methodology to keep the files the same between the servers.</SPAN></BODY></HTML> Wed, 29 Aug 2012 18:12:33 GMT https://community.esri.com/t5/arcgis-enterprise-questions/update-the-tnsnames-file-on-the-soc-machines/m-p/122794#M4767 TrevorWeiland 2012-08-29T18:12:33Z