ORA-28579:在从外部过程代理程序回调时，发生网络错误

 在以往项目中oracle11g 11.2.0.1版本的数据库服务器和GIS服务器分别装在不同的网络服务器上，进行空间查询时会报以下错误：

ORA-28579:在从外部过程代理程序回调时，发生网络错误

在新建sde时，先扩展表空间+创建空间查询

扩展表空间：

select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;

select  * from dba_data_files;

ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SDE_TBS' 
RESIZE 1024M; 

select  * from dba_data_files;

ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SDE_TBS' AUTOEXTEND ON NEXT 100M;

创建空间查询：

select * from user_libraries;

create or replace library ST_SHAPELIB as 'D:\app\Administrator\product\11.2.0\dbhome_1\hs\admin\st_shapelib.dll'; 

alter package sde.st_geometry_shapelib_pkg compile reuse settings; 

SELECT SDE.ST_ASTEXT(SDE.ST_POINT(1024,4513, 2435)) FROM DUAL;

测试st_astext通过后，测试通过空间面选择点、线等要素：

select Count(0) as 供水节点
  from GSSS_NODE
 where 1 = 1
   and sde.st_intersects(shape,
                         (select sde.st_geometry('POLYGON ((12375431.963616155 4489113.926673949, 12375374.635844935 4489113.926673949, 12375374.635844935 4489056.5989027275, 12375431.963616155 4489056.5989027275, 12375431.963616155 4489113.926673949))',
                                                 3857)
                            from dual)) = 1
   and sde.st_isempty(shape) = 0

测试后显示 ORA-28579:在从外部过程代理程序回调时，发生网络错误

问题：

解决：升级oracle11g 版本，升级为11.2.0.4 即可解决。