Forum Stats

  • 3,767,932 Users
  • 2,252,731 Discussions
  • 7,874,385 Comments

Discussions

ORA-28575: unable to open RPC connection to external procedure

Emad Al-Mousa
Emad Al-Mousa Member Posts: 716 Bronze Trophy
edited Feb 25, 2014 11:54AM in General Database Discussions

hi,

i am receiving the following error:

ORA-28575: unable to open RPC connection to external procedure

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

ORA-06512: at "SDE.ST_GEOM_UTIL", line823

my environment:

ORACLE 11gR2 (11.2.0.3)

IBM AIX 6.1

ESRI Software: ArcSDE 10.1 SP1

since i am using oracle 11g release 2, i used the external procedure method:

under $ORACLE_HOME/hs/admin

within "extproc.ora" file i have added the line

SET EXTPROC_DLL=ANY

and still having the same problem.

so i have performed the (listener and tnsnames configuration method) in case this could resolve the problem.However, it didn't resolve the issue..........

i also followd the oracle metalink DOC ID 1256784.1

but with no Luck and i am still receiving this error (ORA-28575).

Best Answer

  • Emad Al-Mousa
    Emad Al-Mousa Member Posts: 716 Bronze Trophy
    Accepted Answer

    after extensive troubleshooting, i found out that this will occur in one of two situations:

    1. the .so external procedure library is corrupted.

    OR

    2. the .so external procedure library is a 32 bit.......to check that use the Unix Command ( file lib.so) the output should give you 64bit

Answers

This discussion has been closed.