topic How to Install Database Clients for ArcGIS in ArcGIS Utility Network Questions

topic How to Install Database Clients for ArcGIS in ArcGIS Utility Network Questions https://community.esri.com/t5/arcgis-utility-network-questions/how-to-install-database-clients-for-arcgis/m-p/1372458#M4403 <P>----------------------------------------------------------------------------------------------------------------</P><P><UL><LI style="list-style-type:disc; margin-left:30px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId--651615363" target="_blank">1. PostgreSQL Client - Windows</A></LI><LI style="list-style-type:disc; margin-left:30px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId-1835897470" target="_blank">2. PostgreSQL Client - Linux</A></LI><LI style="list-style-type:disc; margin-left:30px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId-28443007" target="_blank">3. SQL Server Client - Windows</A></LI><LI style="list-style-type:disc; margin-left:30px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId--1779011456" target="_blank">4. SQL Server Client - Linux</A></LI><LI style="list-style-type:disc; margin-left:30px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId-708501377" target="_blank">5. Oracle Client - Windows</A></LI><LI style="list-style-type:disc; margin-left:30px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId--1098953086" target="_blank">6. Oracle Client - Linux</A></LI><LI style="list-style-type:disc; margin-left:30px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId-1388559747" target="_blank">7. Oracle Instant Client on Linux - Important Remarks</A></LI><LI style="list-style-type:disc; margin-left:40px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId-2079121221" target="_blank">Connect to Oracle from ArcGIS Server</A></LI><LI style="list-style-type:disc; margin-left:30px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426#toc-hId-2068618117" target="_blank">8. Oracle Instant Client on Ubuntu</A></LI></UL></P><P>----------------------------------------------------------------------------------------------------------------</P><P class="lia-align-center" style="text-align: center;"><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarceloMarques_0-1705690610678.jpeg" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="MarceloMarques_0-1705690610678.jpeg" style="width: 474px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/92248i314189F8023ACE11/image-size/large?v=v2&px=999" role="button" title="MarceloMarques_0-1705690610678.jpeg" alt="MarceloMarques_0-1705690610678.jpeg" /></span></SPAN></P><P>----------------------------------------------------------------------------------------------------------------</P><H4 id="toc-hId--651615363"><STRONG>1. PostgreSQL Client - Windows</STRONG></H4><P><SPAN>PostgreSQL client files are installed with ArcGIS Pro and ArcGIS Server; </SPAN></P><P><SPAN>you do <U>not</U> need to install a PostgreSQL client or set environment variables to access the client.</SPAN></P><P><STRONG>ArcGIS Documentation:</STRONG></P><P><A title="https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-postgresql.htm" href="https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-postgresql.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to PostgreSQL from ArcGIS Server on Windows</A> </P><P><A title="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-postgresql.htm" href="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-postgresql.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to PostgreSQL from ArcGIS Pro</A> </P><P><A title="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm" href="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm" target="_blank" rel="noreferrer noopener nofollow">ArcGIS Requirements for PostgreSQL</A></P><P><A title="https://support.esri.com/en-us/knowledge-base/faq-what-postgresql-database-versions-are-supported-by-000030040" href="https://support.esri.com/en-us/knowledge-base/faq-what-postgresql-database-versions-are-supported-by-000030040" target="_blank" rel="noreferrer noopener nofollow">What PostgreSQL database versions are supported by ArcGIS Enterprise and ArcGIS Pro?</A></P><P>----------------------------------------------------------------------------------------------------------------</P><H4 id="toc-hId-1835897470"><STRONG>2. PostgreSQL Client - Linux</STRONG></H4><P><SPAN>PostgreSQL client files are installed with ArcGIS Pro and ArcGIS Server; </SPAN></P><P><SPAN>you do <U>not</U> need to install a PostgreSQL client or set environment variables to access the client.</SPAN></P><P><STRONG>ArcGIS Documentation:</STRONG></P><P><A title="https://enterprise.arcgis.com/en/server/latest/manage-data/linux/connect-postgresql.htm" href="https://enterprise.arcgis.com/en/server/latest/manage-data/linux/connect-postgresql.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to PostgreSQL from ArcGIS Server on Linux</A></P><P><A title="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-postgresql.htm" href="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-postgresql.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to PostgreSQL from ArcGIS Pro</A></P><P><A title="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm" href="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm" target="_blank" rel="noreferrer noopener nofollow">ArcGIS Requirements for PostgreSQL</A></P><P><A title="https://support.esri.com/en-us/knowledge-base/faq-what-postgresql-database-versions-are-supported-by-000030040" href="https://support.esri.com/en-us/knowledge-base/faq-what-postgresql-database-versions-are-supported-by-000030040" target="_blank" rel="noreferrer noopener nofollow">What PostgreSQL database versions are supported by ArcGIS Enterprise and ArcGIS Pro?</A></P><P>----------------------------------------------------------------------------------------------------------------</P><H4 id="toc-hId-28443007"><STRONG>3. SQL Server Client - Windows</STRONG></H4><P><A title="https://learn.microsoft.com/en-us/sql/connect/odbc/windows/microsoft-odbc-driver-for-sql-server-on-windows?view=sql-server-ver16" href="https://learn.microsoft.com/en-us/sql/connect/odbc/windows/microsoft-odbc-driver-for-sql-server-on-windows?view=sql-server-ver16" target="_blank" rel="noreferrer noopener nofollow">Microsoft ODBC Driver for SQL Server on Windows - ODBC Driver for SQL Server | Microsoft Learn</A></P><P><STRONG>Note:</STRONG> ArcMap 10.8.2 does <STRONG>not </STRONG>work with ODBC 18 and for those machines must install only the ODBC 17</P><P><STRONG>Read my white paper - <A title="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-the-sql-server-client-for-arcgis/ba-p/1238958" href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-the-sql-server-client-for-arcgis/ba-p/1238958" target="_blank">How to Install the SQL Server Client for ArcGIS?</A></STRONG></P><P><STRONG>ArcGIS Documentation:</STRONG></P><P><A title="https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-sqlserver.htm" href="https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-sqlserver.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Microsoft SQL Server from ArcGIS Server on Windows</A> </P><P><A title="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-sqlserver.htm" href="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-sqlserver.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Microsoft SQL Server from ArcGIS Pro</A> </P><P><A title="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm" href="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm" target="_blank" rel="noreferrer noopener nofollow">ArcGIS Requirements for Microsoft SQL Server</A></P><P><A title="https://support.esri.com/en-us/knowledge-base/faq-what-sql-server-database-versions-are-supported-by-000030039" href="https://support.esri.com/en-us/knowledge-base/faq-what-sql-server-database-versions-are-supported-by-000030039" target="_blank" rel="noreferrer noopener nofollow">What SQL Server database versions are supported by ArcGIS Enterprise and ArcGIS Pro?</A></P><P>----------------------------------------------------------------------------------------------------------------</P><H4 id="toc-hId--1779011456"><STRONG>4. SQL Server Client - Linux</STRONG></H4><P><STRONG>Microsoft ODBC 18 - "must follow the steps in the document below"</STRONG></P><P><A title="https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=alpine18-install%2calpine17-install%2cdebian8-install%2credhat7-13-install%2crhel7-offline" href="https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=alpine18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline" target="_blank" rel="noreferrer noopener nofollow">Install the Microsoft ODBC driver for SQL Server (Linux)</A></P><P><STRONG>ArcGIS Documentation: </STRONG></P><P><A title="https://enterprise.arcgis.com/en/server/latest/manage-data/linux/connect-sqlserver.htm" href="https://enterprise.arcgis.com/en/server/latest/manage-data/linux/connect-sqlserver.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Microsoft SQL Server from ArcGIS Server on Linux</A></P><P><A title="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-sqlserver.htm" href="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-sqlserver.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Microsoft SQL Server from ArcGIS Pro</A> </P><P><A title="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm" href="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm" target="_blank" rel="noreferrer noopener nofollow">ArcGIS Requirements for Microsoft SQL Server</A></P><P><A title="https://support.esri.com/en-us/knowledge-base/faq-what-sql-server-database-versions-are-supported-by-000030039" href="https://support.esri.com/en-us/knowledge-base/faq-what-sql-server-database-versions-are-supported-by-000030039" target="_blank" rel="noreferrer noopener nofollow">What SQL Server database versions are supported by ArcGIS Enterprise and ArcGIS Pro?</A></P><P>----------------------------------------------------------------------------------------------------------------</P><H4 id="toc-hId-708501377"><STRONG>5. Oracle Client - Windows</STRONG></H4><P><STRONG>Notes:</STRONG></P><UL><LI>ArcGIS Pro and ArcGIS Enterprise install the 64 bits client</LI><LI>ArcMap install the 32 bits client</LI><LI>the same machine can have the 32-bits and the 64-bits client installed.<BR /><BR /><STRONG>Read my white paper - </STRONG><A title="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-the-oracle-database-client-for/ba-p/1236633" href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-the-oracle-database-client-for/ba-p/1236633" target="_blank"><STRONG>How to Install the Oracle Database Client for ArcGIS?</STRONG></A></LI></UL><P><A title="https://www.oracle.com/database/technologies/instant-client/microsoft-windows-32-downloads.html" href="https://www.oracle.com/database/technologies/instant-client/microsoft-windows-32-downloads.html" target="_blank" rel="noreferrer noopener nofollow">Instant Client for Microsoft Windows (32-bit)</A>  - ArcGIS Desktop ( ArcMap & ArcCatalog )</P><P><A title="https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html" href="https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html" target="_blank" rel="noreferrer noopener nofollow">Instant Client for Microsoft Windows (x64)</A> - ArcGIS Pro & ArcGIS Server</P><P class="lia-indent-padding-left-30px" style="padding-left : 30px;">expand the <I><STRONG>"Installation Instructions"</STRONG></I> for more information</P><P><STRONG>ArcGIS Documentation:</STRONG></P><P><A title="https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-oracle.htm" href="https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-oracle.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Oracle from ArcGIS Server on Windows</A> </P><P><A title="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-oracle.htm" href="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-oracle.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Oracle from ArcGIS Pro</A> </P><P><A title="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-oracle.htm" href="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-oracle.htm" target="_blank" rel="noreferrer noopener nofollow">ArcGIS Requirements for Oracle</A></P><P><A title="https://support.esri.com/en-us/knowledge-base/faq-what-oracle-database-versions-are-supported-by-arcg-000030041" href="https://support.esri.com/en-us/knowledge-base/faq-what-oracle-database-versions-are-supported-by-arcg-000030041" target="_blank" rel="noreferrer noopener nofollow">What Oracle database versions are supported by ArcGIS Enterprise and ArcGIS Pro?</A><BR /> ----------------------------------------------------------------------------------------------------------------</P><H4 id="toc-hId--1098953086"><STRONG>6. Oracle Client - Linux</STRONG></H4><P><A title="https://public-yum.oracle.com/oracle-instant-client.html" href="https://public-yum.oracle.com/oracle-instant-client.html" target="_blank" rel="noreferrer noopener nofollow">Instant Client for Oracle Linux</A></P><P><A title="https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html" href="https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html" target="_blank" rel="noreferrer noopener nofollow">Instant Client for Linux x86-64 (64-bit) (oracle.com)</A> </P><P class="lia-indent-padding-left-30px" style="padding-left : 30px;">expand the <I><STRONG>"Installation Instructions"</STRONG></I> for more information.</P><P><STRONG>ArcGIS Documentation:</STRONG></P><P><A title="https://enterprise.arcgis.com/en/server/latest/manage-data/linux/connect-oracle.htm" href="https://enterprise.arcgis.com/en/server/latest/manage-data/linux/connect-oracle.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Oracle from ArcGIS Server on Linux</A>  -  <STRONG>Important !!!</STRONG> Read this documentation !!!</P><P><A title="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-oracle.htm" href="https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-oracle.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Oracle from ArcGIS Pro</A> </P><P><A title="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-oracle.htm" href="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-oracle.htm" target="_blank" rel="noreferrer noopener nofollow">ArcGIS Requirements for Oracle</A></P><P><A title="https://support.esri.com/en-us/knowledge-base/faq-what-oracle-database-versions-are-supported-by-arcg-000030041" href="https://support.esri.com/en-us/knowledge-base/faq-what-oracle-database-versions-are-supported-by-arcg-000030041" target="_blank" rel="noreferrer noopener nofollow">What Oracle database versions are supported by ArcGIS Enterprise and ArcGIS Pro?</A></P><P>----------------------------------------------------------------------------------------------------------------</P><H4 id="toc-hId-1388559747"><STRONG>7. Oracle Instant Client on Linux - Important Remarks</STRONG></H4><P>A few more important remarks.</P><UL><LI><STRONG>Install Oracle Instant Client for Linux</STRONG></LI></UL><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><A title="https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html" href="https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html" target="_blank" rel="noreferrer noopener nofollow">Instant Client for Linux x86-64 (64-bit) (oracle.com)</A></P><UL><LI>use the <STRONG>RPMs</STRONG> to install, avoid the .ZIP</LI></UL><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarceloMarques_1-1705691112531.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="MarceloMarques_1-1705691112531.png" style="width: 379px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/92249i1AAF5C9A61978486/image-size/large?v=v2&px=999" role="button" title="MarceloMarques_1-1705691112531.png" alt="MarceloMarques_1-1705691112531.png" /></span></SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">*OCI – Oracle Call Interface API</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">“basic” – all files required to run OCI, OCCI, and JDBC-OCI applications</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">“sqlplus” – SQL Plus command line tool for SQL and PL/SQL queries</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">“tools” – Data Pump, SQL Loader, Workload Replay tools</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">“jdbc” – additional support for internationalization under JDBC</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">“odbc” – additional libraries for enabling ODBC applications</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">“devel” – additional header files and example makefile for developing Oracle applications with Instant Client</P><UL><LI>The RPMs package installs the files under <STRONG>/usr/lib/oracle/21/client64</STRONG></LI><LI>You need to install only the RPMs for “<STRONG>basic</STRONG>” and “<STRONG>sqlplus</STRONG>”</LI></UL><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN><STRONG># su – root</STRONG></SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN><STRONG># yum install oracle-instantclient-basic-21.11.0.0.0-1.el8.x86_64.rpm</STRONG></SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN><STRONG># yum install oracle-instantclient-sqlplus-21.11.0.0.0-1.el8.x86_64.rpm</STRONG></SPAN></P><UL><LI>There is<STRONG> <U>no</U></STRONG> need to install any of the other RPMs like “tools”, “jdbc”, “odbc”, “devel”</LI><LI><STRONG>ArcGIS Software (ArcMap, ArcGIS Pro, ArcGIS Server)</STRONG> uses the <STRONG>OCI – Oracle Call Interface API</STRONG> to connect to Oracle Geodatabases</LI><LI><STRONG>ArcGIS Software (ArcMap, ArcGIS Pro, ArcGIS Server) </STRONG>does <STRONG><U>not</U></STRONG> use<STRONG> </STRONG>the<STRONG> RPM “odbc”</STRONG> package</LI><LI><STRONG>OCI</STRONG> is installed when the “<STRONG>basic</STRONG>” RPM package is installed</LI></UL><P class="lia-indent-padding-left-30px" style="padding-left : 30px;"><STRONG># yum install oracle-instantclient-basic-21.11.0.0.0-1.el8.x86_64.rpm</STRONG></P><UL><LI>the RPM “<STRONG>basic</STRONG>” will create the folder “<STRONG>lib</STRONG>” under <STRONG>/usr/lib/oracle/21/client64</STRONG></LI><LI>the RPM “<STRONG>sqlplus</STRONG>” will create the folder “<STRONG>bin</STRONG>” under <STRONG>/usr/lib/oracle/21/client64</STRONG></LI><LI>Oracle Instant Client Directory is <SPAN><STRONG>/usr/lib/oracle/21/client64</STRONG></SPAN><STRONG>  </STRONG></LI><LI>“<STRONG>lib</STRONG>” folder contains the OCI API libraries</LI><LI>“<STRONG>bin</STRONG>” folder contains utilities like “sqlplus”</LI></UL><P> </P><UL><LI><H5 id="toc-hId-2079121221"><STRONG>Connect to Oracle from ArcGIS Server</STRONG></H5></LI></UL><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><A title="https://enterprise.arcgis.com/en/server/latest/manage-data/linux/connect-oracle.htm" href="https://enterprise.arcgis.com/en/server/latest/manage-data/linux/connect-oracle.htm" target="_blank" rel="noreferrer noopener nofollow">Connect to Oracle from ArcGIS—ArcGIS Server | Documentation for ArcGIS Enterprise</A></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN><U>In the link above please read</U>:</SPAN>   <STRONG>Connect from ArcGIS Server | Set the LD_LIBRARY_PATH environment variable</STRONG></P><UL><LI>In the Linux User running the ArcGIS Server Service edit the .bash_profile</LI></UL><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><STRONG>$ su – arcgis                       <== Linux User running the ArcGIS Server Service</STRONG></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><STRONG>$ vi .bash_profile</STRONG></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><STRONG>export PATH=/usr/lib/oracle/21/client64/bin:$PATH</STRONG></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><STRONG>export LD_LIBRARY_PATH=/usr/lib/oracle/21/client64:$LD_LIBRARY_PATH</STRONG></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><STRONG>:wq!</STRONG></P><P>              <STRONG>Note:</STRONG> <STRONG>PATH</STRONG> variable needs to include  “/bin” in the directory path to be able to call “sqlplus”</P><UL><LI>It is also necessary on Linux ArcGIS Server deployments to edit the file  <SPAN><STRONG>$<ArcGIS Server Home>/arcgis/server/usr/init_user_param.sh</STRONG></SPAN><BR /> </LI></UL><P class="lia-indent-padding-left-30px" style="padding-left : 30px;">If you are using the Oracle database Instant client libraries, you only need to uncomment and set the $LD_LIBRARY_PATH, for example:</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>#</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN># For connection with Oracle Instant Client</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>#</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>export LD_LIBRARY_PATH=/usr/lib/oracle/21/client64:$LD_LIBRARY_PATH</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">Save and close the script.</P><UL><LI>For the changes you made in the <STRONG>init_user_param.sh</STRONG> file to take effect, you must restart ArcGIS Server.</LI></UL><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">To do this, run the stopserver.sh script, then run the startserver.sh script on each machine in the ArcGIS Server site.</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">./stopserver.sh</P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;">./startserver.sh</P><UL><LI>Test the Oracle Geodatabase connection using SQL PLUS<BR /> </LI></UL><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>$ su – arcgis                       <== Linux User running the ArcGIS Server Service</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>$ sqlplus /nolog</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>connect sde/<password>@mcsdboralnx7:1577/topo1.esri.com</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>show user_name</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>show con_name</SPAN></P><P class="lia-indent-padding-left-60px" style="padding-left : 60px;"><SPAN>exit</SPAN></P><P>Now users can use</P><UL><LI>ArcGIS Server Manager > Site > Data Store</LI></UL><P class="lia-indent-padding-left-30px" style="padding-left : 30px;">or</P><UL><LI>ArcGIS Pro > Add Data Store</LI><LI>To add the data store using the Oracle Geodatabase Connection File<BR /><BR /></LI></UL><P>----------------------------------------------------------------------------------------------------------------</P><H4 id="toc-hId-2068618117"><STRONG>8. Oracle Instant Client on Ubuntu<BR /><BR /></STRONG></H4><P><A href="https://docs.oracle.com/en/database/oracle/oracle-database/26/lacli/supported-ubuntu-distributions-for-x86-64.html" target="_blank" rel="noopener nofollow noreferrer">https://docs.oracle.com/en/database/oracle/oracle-database/26/lacli/supported-ubuntu-distributions-for-x86-64.html</A><BR /><BR /><A href="https://docs.oracle.com/en/database/oracle/oracle-database/21/lacli/supported-ubuntu-distributions-for-x86-64.html" target="_blank" rel="noopener nofollow noreferrer">https://docs.oracle.com/en/database/oracle/oracle-database/21/lacli/supported-ubuntu-distributions-for-x86-64.html</A></P><P><A href="https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/instant-client-install-linux.html" target="_blank" rel="noopener nofollow noreferrer">https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/instant-client-install-linux.html</A><BR /><BR /><A href="https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/install-instant-client-using-zip.html" target="_blank" rel="noopener nofollow noreferrer">https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/install-instant-client-using-zip.html</A><BR /><BR /><A href="https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/install-instant-client-using-rpm.html" target="_blank" rel="noopener nofollow noreferrer">https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/install-instant-client-using-rpm.html</A></P><P><BR />To install Oracle Instant Client on Ubuntu 24.04 (Noble Numbat), follow these steps.<BR />This process focuses on the ZIP file method, which is the most reliable way to avoid RPM compatibility issues.</P><P><STRONG>1. Install System Dependencies</STRONG></P><P>Ubuntu 24.04 replaced the old libaio1 package with libaio1t64.<BR />Since the Oracle client specifically looks for libaio.so.1,<BR />you must install the new package and create a symbolic link.</P><P>Update and install required tools:</P><P>sudo apt update<BR />sudo apt install -y libaio1t64 unzip</P><P>Create the necessary symbolic link:</P><P>sudo ln -s /usr/lib/x86_64-linux-gnu/libaio.so.1t64 /usr/lib/x86_64-linux-gnu/libaio.so.1</P><P><STRONG>2. Download the Instant Client</STRONG></P><P>Go to the Oracle Instant Client Downloads for Linux page.</P><P>Required: Download the Basic Package (ZIP) (e.g., instantclient-basic-linux.x64-23.x.x.zip).</P><P>Optional: Download the SQL*Plus Package (ZIP) if you want a command-line interface to the database.</P><P><STRONG>3. Extract the Files</STRONG></P><P>It is standard practice to install Oracle software in /opt/oracle.</P><P>Create the directory:</P><P>sudo mkdir -p /opt/oracle</P><P>Unzip the basic package (replace the filename with your downloaded version):</P><P>sudo unzip ~/Downloads/instantclient-basic-linux.x64-23.7.0.25.01.zip -d /opt/oracle</P><P>/* Oracle Instant Client 19.30<BR />unzip -q /tmp/instantclient-basic-linux.x64-19.30.0.0.0dbru.zip -d /opt/oracle<BR />unzip -q /tmp/instantclient-sqlplus-linux.x64-19.30.0.0.0dbru.zip -d /opt/oracle<BR />*/</P><P>This creates a folder like /opt/oracle/instantclient_23_7.</P><P><STRONG>4. Configure Environment Variables</STRONG></P><P>You must tell Ubuntu where to find the Oracle libraries and binaries.</P><P>Add the library path to the system configuration:</P><P>sudo sh -c "echo /opt/oracle/instantclient_23_7 > /etc/ld.so.conf.d/oracle-instantclient.conf"<BR />sudo ldconfig</P><P>/* Oracle Instant Client 19.30<BR />sudo sh -c "echo /opt/oracle/instantclient_19_30 > /etc/ld.so.conf.d/oracle-instantclient.conf"<BR />sudo ldconfig<BR />*/</P><P>Update your user profile to include the binaries in your PATH. Open your .bashrc file:</P><P>bash<BR />nano ~/.bashrc</P><P>Append these lines to the end of the file (adjust the version number to match your folder):</P><P>export LD_LIBRARY_PATH=/opt/oracle/instantclient_23_7:$LD_LIBRARY_PATH<BR />export PATH=/opt/oracle/instantclient_23_7:$PATH</P><P>/* Oracle Instant Client 19.30<BR />export LD_LIBRARY_PATH=/opt/oracle/instantclient_19_30:$LD_LIBRARY_PATH<BR />export PATH=/opt/oracle/instantclient_19_30:$PATH<BR />*/</P><P>Reload the profile:</P><P>source ~/.bashrc<BR /><BR /><STRONG>5. Verify the Installation</STRONG></P><P>If you installed the SQL*Plus package, you can verify everything is working by typing:</P><P>sqlplus -v</P><P>You should see the version information without any "shared library not found" errors.</P><P>/* Oracle Instant Client 19.30</P><P>marc7777@ubuntu2404ora:~$ sqlplus /nolog</P><P>SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 13 21:50:22 2026<BR />Version 19.30.0.0.0</P><P>Copyright (c) 1982, 2025, Oracle. All rights reserved.</P><P>SQL> connect gis/****@mcsdboralnx.esri.com:1577/topo1.esri.com<BR />Connected.</P><P>SQL> show con_name</P><P>CON_NAME<BR />------------------------------<BR />TOPO1</P><P>SQL> show user<BR />USER is "GIS"</P><P>SQL> disconnect</P><P>SQL> exit</P><P>*/</P><P> </P> Wed, 18 Mar 2026 06:33:25 GMT ShareUser 2026-03-18T06:33:25Z How to Install Database Clients for ArcGIS https://community.esri.com/t5/arcgis-utility-network-questions/how-to-install-database-clients-for-arcgis/m-p/1372458#M4403 <P><EM>"To connect to the Database from ArcGIS clients, install a <SPAN class="">Database</SPAN></EM><SPAN><EM> client on the ArcGIS client machines."</EM><BR /></SPAN></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarceloMarques_2-1705690293305.jpeg" style="width: 802px;"><IMG src="https://community.esri.com/t5/image/serverpage/image-id/92245i4818A7CE81CABC60/image-dimensions/802x453?v=v2" width="802" height="453" role="button" title="MarceloMarques_2-1705690293305.jpeg" alt="MarceloMarques_2-1705690293305.jpeg" /></SPAN></P> Wed, 18 Mar 2026 06:33:25 GMT https://community.esri.com/t5/arcgis-utility-network-questions/how-to-install-database-clients-for-arcgis/m-p/1372458#M4403 ShareUser 2026-03-18T06:33:25Z