oracle 账号创建ORA-28575:无法打开与外部过程代理程序的RPC连接解决

ORA-28575:无法打开与外部过程代理程序的RPC连接解决

 

1. 修改listener.ora文件,增加如下内容,注意该库位于SDE的安装目录下的bin目录下:

(ENVS = "EXTPROC_DLLS=C:\Program Files\ArcGIS\ArcSDoracle账号E\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. 修改tnsnames.ora文件,添加如下一行,注意listener和tnsnames中的KEY值要匹配上:

(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)    )  )

 

重启服务。

 

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。