Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Emad Al-MousaFeb 23 2014 — edited Feb 25 2014

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).
This post has been answered by Emad Al-Mousa on Feb 25 2014
Jump to Answer

Comments

sb92075

How do I ask a question on the forums?

https://forums.oracle.com/message/9362002#9362002

Emad Al-Mousa

Hi sb92075,

i didn't get you ......what is the problem with my question ?

sb92075

[oracle@localhost ~]$ oerr ora 28575

28575, 00000, "unable to open RPC connection to external procedure agent"

// *Cause:   Initialization of a network connection to the extproc agent did

//           not succeed. This problem can be caused by network problems,

//           incorrect listener configuration, or incorrect transfer code.

// *Action:  Check listener configuration in LISTENER.ORA and TNSNAMES.ORA, or

//           check Oracle Names Server.

1 person found this helpful
Emad Al-Mousa

i have checked the configuration of the listener.ora and tnsnames.ora and they are identical to what is needed from the documentation.

So, when i start up the listener the "external procedure" services comes up successfully.

Please note that per Oracle Documentation theses configurations are "NOT" required with Oracle 11g (my database version), setting the configuration from "extproc.ora" is only needed.

i have used the parameter: SET EXTPROC_DLL=ANY

1 person found this helpful
sb92075

file a bug report with MOS

Emad Al-Mousa
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

Marked as Answer by Emad Al-Mousa · Sep 27 2020
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 25 2014
Added on Feb 23 2014
#general-database-discussions
6 comments
3,681 views