Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 109 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
ORA-28575: unable to open RPC connection to external procedure
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
-
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
-
How do I ask a question on the forums?
-
Hi sb92075,
i didn't get you ......what is the problem with my question ?
-
[[email protected] ~]$ 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.
-
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
-
file a bug report with MOS
-
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