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)
     (ENVS="EXTPROC_DLLS=ANY")    )
  )
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))
     (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521)) 
     )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )   




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

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一致