oracle 查询空间数据的配置

oracle 查询空间数据，首先要用到sde的dll包，具体步骤如下
indows 2008 server 64位



1.将

C:\Program Files (x86)\ArcGIS\ArcSDE\ora10gexe\bin\st_shapelib.dll

拷贝至

C:\Program Files\ArcGIS\ArcSDE\ora10gexe\bin\st_shapelib.dll



2.修改库路径

create or replace library st_shapelib as 'C:\Program Files\ArcGIS\ArcSDE\ora10gexe\bin\st_shapelib.dll';

修改完成以后从新启动oracle的监听


3.查看库路径

select * from user_libraries;

查询出来的结果如图，如果能显示路径，并且服务器中存在，所以已经配置成功了
4，对于10.1的，需要改些oracle的监听文件

b）Oracle监听器设置——修改listener.ora文件
添加(ENVS="EXTPROC_DLLS=ANY")
-----------------------------------------------------------------------------------------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
[color=red] (ENVS="EXTPROC_DLLS=ANY")[/color] )
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521))
)
)
c）修改tnsnames.ora文件

添加(ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521))
-----------------------------------------------------------------------------------------------------------
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
[color=red] (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521))[/color]
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


[img]http://dl.iteye.com/upload/attachment/0072/8326/08e8d14a-214a-38b1-9412-67f9b40aab4d.png[/img]

------------------------------------------------------------------------
下面几步是从网上看到了，我没用到，仅供参考

4.listener.ora

添加(ENVS="EXTPROC_DLLS=ANY")

--------------------------------------------------------------------------

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
(ENVS="EXTPROC_DLLS=ANY")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = dxth4.bjdxth.com)(PORT = 1521))
)
)

------------------------------------------------------------------------------

5.tnsnames.ora

添加(ADDRESS = (PROTOCOL = TCP)(HOST = dxth4.bjdxth.com)(PORT = 1521))

-------------------------------------------------------------------------------

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = dxth4.bjdxth.com)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

---------------------------------------------------------------------------------

6.listener.ora中的KEY值要和tnsnames.ora中的KEY一致