Oracle 111g 安装ArcSDE报ora-285955 Extproc 代理:DLL 路径无效 解决办法

在配置好SDE后报如下错误：

住要原因还是在tnsnames.ora中没有配置好；

首先配置一下listener.ora;重点我用红色标注：

# listener.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS="EXTPROC_DLLS=E:\Program Files\ArcGIS\ArcSDE\ora11gexe\bin\st_shapelib.dll;E:\Program Files\ArcGIS\ArcSDE\ora11gexe\bin\libst_raster_ora.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521))
)
)

ADR_BASE_LISTENER = E:\app\Administrator

接下来配置tnsnames.ora文件：

# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

MYHGEE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 数据库实例名（SID）)
)
)

LISTENER_MYHGE =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521))

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)    //这句话最关键  网上查了好多文章讲述的配置中没有提到这一点  这边的SID跟Listener.ora中的SID_LIST_LISTENER 下的SID_NAME的只一样的；
(PRESENTATION = RO)
)
)

纠结了两天的问题终于解决了；

如果还有什么不明白的话，可以参考官网配置介绍：

http://help.arcgis.com/zh-cn/arcgisdesktop/10.0/help/index.html#//002n00000091000000；

记录一下 ，以防日后忘记！