nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ST_SHAPELIB + Oracle 19c + ArcGIS Enterprise 10.6.1 = ORA-28578 error

Jean-FrançoisMourgues

I'm upgrading our database from Oracle 11G to Oracle 19C. Our ArcGIS version still the same : Enterprise 10.6.1

I'm getting a problem when using the SHAPELIB library (same that was installed in the Oracle 11C server :

ORA-28578: erreur de protocole lors du callback depuis une procédure externe
ORA-06512: à "SDE.ST_GEOMETRY_SHAPELIB_PKG", ligne 12
ORA-06512: à "SDE.ST_POINT", ligne 181
28578. 00000 -  "protocol error during callback from an external procedure"
*Cause:    An internal protocol error occurred while trying to execute a
           callback to the Oracle server from the user's 3GL routine.
*Action:   Contact Oracle customer support.

Does anyone knows how to solve this problem?

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

George_Thompson

You may need to install the patch for 10.6.1 and make sure that you grab the latest st_shape lib file from that release; https://desktop.arcgis.com/en/system-requirements/10.6/database-requirements-oracle.htm

Patch: https://support.esri.com/en/download/7734

You may also need to recompile the SDE schema after the package update.

Jean-FrançoisMourgues

Thanks for your answer!

We did all the actions you recommend :

- Install patch 10.6.1

- Download and install the latest libst_shepelib.so from https://my.esri.com/#/downloads/ArcGIS%20Pro/2.2 (we download the version corresponding to ArcGIS Pro 2.2 as detailed in the link you provided)

- Recompile the SDE schema with the command

EXECUTE sys.utl_recomp.recomp_serial('SDE');

After all these actions, when executing query :

select sde.ST_Buffer(sde.st_point(1006849.0, 1874381.0, 2), .1) from dual;

this error still there:

ORA-28578: erreur de protocole lors du callback depuis une procédure externe
ORA-06512: à "SDE.ST_GEOMETRY_SHAPELIB_PKG", ligne 12
ORA-06512: à "SDE.ST_POINT", ligne 181
28578. 00000 -  "protocol error during callback from an external procedure"
*Cause:    An internal protocol error occurred while trying to execute a
           callback to the Oracle server from the user's 3GL routine.
*Action:   Contact Oracle customer support.

George_Thompson

So it looks like there is an EXTPROC issue. Was that updated on the new Oracle19c instance?

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/configure-oracle-extproc.htm

Jean-FrançoisMourgues

As per below ESRI + oracle documentation

https://desktop.arcgis.com/fr/arcmap/10.5/manage-data/gdbs-in-oracle/configure-oracle-extproc.htm

https://desktop.arcgis.com/fr/arcmap/latest/manage-data/gdbs-in-oracle/configure-oracle-extproc.htm

https://docs.oracle.com/en/database/oracle/oracle-database/19/ntqrf/registering-an-external-procedure.html#GUID-7BC71588-E0C0-46EC-8C1A-AFB16C61269C

We copied the library files at their location

[oracle@zeaca50f arcsde]$ ll

total 21828

-rwxr-xr-x. 1 oracle oinstall 7579206 Sep 27 2016 libst_raster_ora.so

-rwxr-xr-x. 1 oracle oinstall 2359296 Nov 5 13:40 libst_shapelib.so

-rwxr-xr-x. 1 oracle oinstall 11107430 Oct 4 15:40 libst_shapelib.so.old

Then we updated all config files as below :

listener.ora : adding this bloc
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /logiciels/oracle/oradb/19.5.0/oh1)
(PROGRAM = extproc)
(ENVS="EXTPROC_DLLS=/oierdf/appli/SIK/arcsde/libst_shapelib.so")
)

tnsnames.ora : adding this bloc
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = LISTENER))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

extproc.ora :

SET EXTPROC_DLLS=ONLY:/oierdf/appli/SIK/arcsde/libst_shapelib.so:/oierdf/appli/SIK/arcsde/libst_raster_ora.so

Once all those files were configured, we ran the following

-- As user SDE :

SQL> CREATE or REPLACE LIBRARY ST_SHAPELIB AS '/oierdf/appli/SIK/arcsde/libst_shapelib.so';

SQL> ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE REUSE SETTINGS;

-- As user SYS :

SQL> EXECUTE sys.utl_recomp.recomp_serial('SDE');

--Finally we still receive same error :

-- As user SDE

SQL> select sde.ST_Buffer(sde.st_point(1006849.0, 1874381.0, 2), .1) from dual;

select sde.ST_Buffer(sde.st_point(1006849.0, 1874381.0, 2), .1) from dual

ERROR at line 1:

ORA-28578: protocol error during callback from an external procedure

ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12

ORA-06512: at "SDE.ST_POINT", line 181

Jean-FrançoisMourgues

George, thx pour your reply.
I tried with SET EXTPROC_DLLS=ANY but same issue again.

However note that I haven't restarted the listener. Do you confirm it is mandatory?

--Sebastian

George_Thompson

I can say that is not mandatory, just something I have seen in the past. No promise that it will fix the issue.

Again, it should not have been modified to make this work.

Jean-FrançoisMourgues

OK George, we can't go further... how can we contact Esri technical support please?

-- Sebastian

George_Thompson

Hi @Jean-FrançoisMourgues - If you are international, you need to contact your local distributor for assistance. If you are located in the US here is the contact info: https://www.esri.com/en-us/contact#c=us&t=5

Please report back the end result(s). Thanks!

LiJia

We are facing the same issue. Where we copied the library file to the DB server, configure the extproc.ora file to point to the file, restart DB instance, create/replace the library to the new location. Alter the package. Still got the same error. Would appreciate if you let us know how you resolve the issue.

CM0001

We have the same issue. @Jean-FrançoisMourgues,@LiJia Did you ever resolve this?

MMBR

Note: you need to copy the new version of the esri st_geometry library for Oracle 19c to your Oracle Database Server, we have st_geometry library for ArcMap and for ArcGIS Pro, make sure you download the correct version from My Esri.

Configure extproc to access ST_Geometry in Oracle—ArcGIS Pro | Documentation

Download the ST_Geometry library from My Esri and place it in a directory on the Oracle machine.
Note:
Be sure to download or copy the correct library for your Oracle operating system.
The ST_Geometry library requires the Microsoft Visual C++ Redistributable Package (x64) when deployed on a Microsoft Windows server. See ArcGIS requirements for Oracle for the package version required. If this package is not present on the Oracle server, download it from the Microsoft site and install it.
FYI: If you still have an issue, then open a ticket with Esri Technical Support for further assistance.
Contact Esri Technical Support - USA
Esri International Support Services - Outside USA | Contact your distributor

CM0001

Since the ArcGIS Pro downloads included references to 21c (i.e. - Oracle Instant Client Downloads (v21.6.0.0.0) for Linux x86-64 (64-bit) etc.) we installed Oracle 21c on a Linux server. Is the ArcGIS Pro ST_Geometry Library (Oracle - libst_shapelib.so) only valid up to version19c of Oracle? Thanks for your help!

MMBR

@CM0001 - It works with 21c, but officially is not certified.

ArcGIS 11.1 and ArcGIS Pro 3.1 requirements for Oracle—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

I have myself a 21c Linux server and the ArcGIS Pro st_geometry library for Oracle works just fine.

Note, Oracle 21c is a short-term release, 21c is the "innovation release", the long-term release is still 19c with a long patch lifecycle.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.