ORA-28575: Unable to open RPC connection resolved with external process agent

ORA-28575: Unable to open the RPC connection with the external process agent solution 1. Modify the listener. ora file, add the following content, note that the Library is located in the bin directory under the SDE installation directory:

(ENVS = "EXTPROC_DLLS=C:\Program Files\ArcGIS\ArcSDE\ora10gexe\bin\st_shapelib.dll")--listener.ora:SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = ngrm)      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)      (SID_NAME = ngrm)    )    (SID_DESC =      (GLOBAL_DBNAME = topodb)      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)      (SID_NAME = topodb)    )    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=C:\Program Files\ArcGIS\ArcSDE\ora10gexe\bin\st_shapelib.dll")    )  )

 

2. Modify the tnsnames. ora file and add the following line. Note that the KEY values in listener and tnsnames must match:

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.205.41)(PORT = 1521))--tnsnames.ora:EXTPROC_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.205.41)(PORT = 1521))    )    (CONNECT_DATA =      (SID = PLSExtProc)      (PRESENTATION = RO)    )  )

 

Restart the service.