topic Oracle Instant Client and tnsnames.ora file in Data Management Questions https://community.esri.com/t5/data-management-questions/oracle-instant-client-and-tnsnames-ora-file/m-p/21812#M1119 <HTML><HEAD></HEAD><BODY><SPAN>I have a question about the Oracle Instant Client that is now supported at ArcGIS v10.1 and its interaction with a tnsnames.ora file.</SPAN><BR /><BR /><SPAN>Pre ArcGIS v10.1 my organization has used a full Oracle Client where we make use of a tnsnames.ora file for ArcGIS to recognize which database to connect to (we have a dev, test, and production SDE database).&nbsp; In the Instance input box I entered oracle:10g and the password had @sde at the end of the string.</SPAN><BR /><BR /><SPAN>I have an ArcGIS v10.1 computer setup with both the full Oracle 10g client as well as the Oracle Instant client.&nbsp; I used the same connection information to connect to SDE in ArcGIS v10.1, but I think it was using the full Oracle 10g client to make this connection.&nbsp; I also then removed the reference to the tnsnames file but I was not able to connect to the SDE database unless I changed the syntax in the Instance input box to SDE database server name/SDE database name.&nbsp; This is not desirable as I will need to include the SDE database server name in every SDE connection which will cause problems when I retire that server.</SPAN><BR /><BR /><SPAN>So my question is "Does the Oracle Instant client work with the tnsnames.ora file?"&nbsp; Or does the tnsnames.ora become obsolete if you migrate to the Oracle Instant client?</SPAN></BODY></HTML> Thu, 14 Feb 2013 12:48:56 GMT MichaelVolz 2013-02-14T12:48:56Z Oracle Instant Client and tnsnames.ora file https://community.esri.com/t5/data-management-questions/oracle-instant-client-and-tnsnames-ora-file/m-p/21812#M1119 <HTML><HEAD></HEAD><BODY><SPAN>I have a question about the Oracle Instant Client that is now supported at ArcGIS v10.1 and its interaction with a tnsnames.ora file.</SPAN><BR /><BR /><SPAN>Pre ArcGIS v10.1 my organization has used a full Oracle Client where we make use of a tnsnames.ora file for ArcGIS to recognize which database to connect to (we have a dev, test, and production SDE database).&nbsp; In the Instance input box I entered oracle:10g and the password had @sde at the end of the string.</SPAN><BR /><BR /><SPAN>I have an ArcGIS v10.1 computer setup with both the full Oracle 10g client as well as the Oracle Instant client.&nbsp; I used the same connection information to connect to SDE in ArcGIS v10.1, but I think it was using the full Oracle 10g client to make this connection.&nbsp; I also then removed the reference to the tnsnames file but I was not able to connect to the SDE database unless I changed the syntax in the Instance input box to SDE database server name/SDE database name.&nbsp; This is not desirable as I will need to include the SDE database server name in every SDE connection which will cause problems when I retire that server.</SPAN><BR /><BR /><SPAN>So my question is "Does the Oracle Instant client work with the tnsnames.ora file?"&nbsp; Or does the tnsnames.ora become obsolete if you migrate to the Oracle Instant client?</SPAN></BODY></HTML> Thu, 14 Feb 2013 12:48:56 GMT https://community.esri.com/t5/data-management-questions/oracle-instant-client-and-tnsnames-ora-file/m-p/21812#M1119 MichaelVolz 2013-02-14T12:48:56Z Re: Oracle Instant Client and tnsnames.ora file https://community.esri.com/t5/data-management-questions/oracle-instant-client-and-tnsnames-ora-file/m-p/21813#M1120 <HTML><HEAD></HEAD><BODY><SPAN>Hi Michael,</SPAN><BR /><BR /><SPAN>Yes, instant client should work with the tnsnames.ora file. Try setting the TNS_ADMIN environment variable. See this oracle link for more information:</SPAN><BR /><BR /><A class="jive-link-external-small" href="http://www.oracle.com/technetwork/database/features/oci/ic-faq-094177.html#A5028" rel="nofollow" target="_blank">Oracle Instant Client FAQ</A><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Fri, 15 Feb 2013 15:05:57 GMT https://community.esri.com/t5/data-management-questions/oracle-instant-client-and-tnsnames-ora-file/m-p/21813#M1120 ForrestJones 2013-02-15T15:05:57Z Re: Oracle Instant Client and tnsnames.ora file https://community.esri.com/t5/data-management-questions/oracle-instant-client-and-tnsnames-ora-file/m-p/21814#M1121 <HTML><HEAD></HEAD><BODY><SPAN>More information on this topic can also be found here:</SPAN><BR /><BR /><A href="http://support.esri.com/en/knowledgebase/techarticles/detail/41495">FAQ:&nbsp; Can Oracle Instant Client be set up to use a tnsnames.ora file when connecting to Oracle from an ArcGIS 10.1 or newer client?</A></BODY></HTML> Thu, 05 Sep 2013 16:19:20 GMT https://community.esri.com/t5/data-management-questions/oracle-instant-client-and-tnsnames-ora-file/m-p/21814#M1121 ForrestJones 2013-09-05T16:19:20Z