topic Re: How to interpret the &quot;instance&quot; in a ArcCatalog connection? in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/how-to-interpret-the-quot-instance-quot-in-a/m-p/878280#M6626 <HTML><HEAD></HEAD><BODY><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/connect-oracle.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/connect-oracle.htm" rel="nofollow noopener noreferrer" target="_blank">Connect to Oracle from ArcGIS—Help | ArcGIS Desktop</A>&nbsp; This link provides all the details, regarding what can be provided in the 'Instance'parameter depending on the different scenarios.</P><P></P><P>I personally have never observed the 'LOCAL' part getting appended after making a connection. The addition of the "<SPAN style="background-color: #ffffff;">sde:oracle11g" is as expected and as designed.</SPAN></P><P></P><P><SPAN style="background-color: #ffffff;"><A class="link-titled" href="http://support.esri.com/en/technical-article/000005799" title="http://support.esri.com/en/technical-article/000005799" rel="nofollow noopener noreferrer" target="_blank">How To: Install ArcSDE on a machine that is remote from the Oracle RDBMS</A>&nbsp;</SPAN></P><P></P><P><SPAN style="background-color: #ffffff;">The above link mentions the below:</SPAN></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P></P><PRE class="lia-code-sample line-numbers language-none"><STRONG style="font-weight: 500;">Note:</STRONG> TWO_TASK (for UNIX/Linux) and LOCAL (for Windows) are Oracle environment variables. Refer to Oracle documentation for further information.</PRE></BLOCKQUOTE><P></P><P><A class="link-titled" href="http://dbathoughts.blogspot.com/2008/03/using-local-environment-variable.html" title="http://dbathoughts.blogspot.com/2008/03/using-local-environment-variable.html" rel="nofollow noopener noreferrer" target="_blank">Yet another DBA blog: Using "LOCAL" environment variable</A>&nbsp;</P></BODY></HTML> Sun, 12 Dec 2021 11:02:41 GMT Asrujit_SenGupta 2021-12-12T11:02:41Z How to interpret the "instance" in a ArcCatalog connection? https://community.esri.com/t5/geodatabase-questions/how-to-interpret-the-quot-instance-quot-in-a/m-p/878279#M6625 <HTML><HEAD></HEAD><BODY><P>I'm using ArcGIS 10.2.1. &nbsp;I have created a connection in Arc Catalog to an Oracle geodatabase. &nbsp;In the text box for the "instance" I put in "ddev1_linux". &nbsp;When I examine the connection properties, I see that it is set to "sde:oracle11g:ddev1_linux;LOCAL=gisdta". &nbsp;I'm curious why the LOCAL=gisdta has been appended. &nbsp;How do I interpret the "instance" string in the connection properties?</P></BODY></HTML> Wed, 02 Aug 2017 20:00:29 GMT https://community.esri.com/t5/geodatabase-questions/how-to-interpret-the-quot-instance-quot-in-a/m-p/878279#M6625 TheodoreRakel 2017-08-02T20:00:29Z Re: How to interpret the "instance" in a ArcCatalog connection? https://community.esri.com/t5/geodatabase-questions/how-to-interpret-the-quot-instance-quot-in-a/m-p/878280#M6626 <HTML><HEAD></HEAD><BODY><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/connect-oracle.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/connect-oracle.htm" rel="nofollow noopener noreferrer" target="_blank">Connect to Oracle from ArcGIS—Help | ArcGIS Desktop</A>&nbsp; This link provides all the details, regarding what can be provided in the 'Instance'parameter depending on the different scenarios.</P><P></P><P>I personally have never observed the 'LOCAL' part getting appended after making a connection. The addition of the "<SPAN style="background-color: #ffffff;">sde:oracle11g" is as expected and as designed.</SPAN></P><P></P><P><SPAN style="background-color: #ffffff;"><A class="link-titled" href="http://support.esri.com/en/technical-article/000005799" title="http://support.esri.com/en/technical-article/000005799" rel="nofollow noopener noreferrer" target="_blank">How To: Install ArcSDE on a machine that is remote from the Oracle RDBMS</A>&nbsp;</SPAN></P><P></P><P><SPAN style="background-color: #ffffff;">The above link mentions the below:</SPAN></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P></P><PRE class="lia-code-sample line-numbers language-none"><STRONG style="font-weight: 500;">Note:</STRONG> TWO_TASK (for UNIX/Linux) and LOCAL (for Windows) are Oracle environment variables. Refer to Oracle documentation for further information.</PRE></BLOCKQUOTE><P></P><P><A class="link-titled" href="http://dbathoughts.blogspot.com/2008/03/using-local-environment-variable.html" title="http://dbathoughts.blogspot.com/2008/03/using-local-environment-variable.html" rel="nofollow noopener noreferrer" target="_blank">Yet another DBA blog: Using "LOCAL" environment variable</A>&nbsp;</P></BODY></HTML> Sun, 12 Dec 2021 11:02:41 GMT https://community.esri.com/t5/geodatabase-questions/how-to-interpret-the-quot-instance-quot-in-a/m-p/878280#M6626 Asrujit_SenGupta 2021-12-12T11:02:41Z