Configure extproc in Oracle on Red Hat Enterprise Linux (RHEL) Server 8 or Oracle Linux 8 systems to support SQL queries against an enterprise geodatabase

Summary

Newly created enterprise geodatabases, or geodatabases upgraded using ArcGIS Pro 3.7 and ArcGIS Enterprise 12.1, require an additional library file (libstdc++.so.6) to configure the extproc on systems running Red Hat Enterprise Linux (RHEL) 8 or Oracle Linux 8, including Oracle Exadata systems running Oracle Linux 8.

Procedure

Use the following steps to configure the extproc:

1. Review the Configure extproc to access ST_Geometry in Oracle documentation.
2. As part of the preparatory steps, download the “ArcGIS Enterprise ST_Geometry Libraries (Oracle)” from My Esri.
3. Extract and copy the following required files to the same directory (either $ORACLE_HOME/lib or a separate folder) on the Oracle machine:
   • libst_shapelib.so library from the “Linux64” directory
   • libstdc++.so.6 library from the “Additional_File_For_RHEL_8” directory
4. Update your shell configuration file for the Oracle installation owner by adding the following line:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

• include the path to the directory containing the libst_shapelib.so file if it’s not in the $ORACLE_HOME/lib

For example:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/usr/arcgislibs/libst_shapelib.so

4. Continue with the steps under the Configure extproc section of the documentation to complete the external procedure setup in Oracle.