When accessing the Spatial Type for Oracle using SQL, the following error message displays:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: libsg.so: cannot open shared object file: No such file or directory
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12
ORA-06512: at "SDE.ST_GEOMETRY", line 56"
A required library file cannot be located and loaded by the extproc process.
The extproc process uses the directory paths listed in the environment variable EXTPROC_DLLS to find library files it directly loads, including libst_shapelib.so or st_shapelib.dll. However, that library in turn loads other libraries, such as the projection engine (libpe.so or pe.dll). The EXTPROC_DLL environment variable is not used to find those additional libraries. Those additional libraries are found using standard operating system methods, such as looking up their paths in the PATH or LD_LIBRARY_PATH environment variables.
Refer to Oracle's Database Net Services Administrator's Guide chapter on Enabling Advanced Features of Oracle Net Services for information about configuring the Oracle extproc process.
Get help from ArcGIS experts
Download the Esri Support App