配置ST_Geometry时出错,解决办法很简单:
1.将listener.ora文件中配置的外部DLL路径修改为ANY,如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ANY")
)
)
2.将extproc.ora文件中的EXTPROC_DLLS的值也修改为ANY:
SET EXTPROC_DLLS=ANY
3.SDE用户登录PLSQL,检查ST_SHAPELIB的路径配置是否有效,如果无效则修改:
select * from user_libraries;
create or replace library ST_SHAPELIB as 'D:\app\administrator\product\11.2.0\dbhome_1\BIN\st_shapelib.dll';
4.重启数据服务OracleServiceORCL和监听服务OracleOraDb11g_home1TNSListener。
5.测试可以了: