空间SQL配置---Oracle11G

空间SQL配置---Oracle11G

--TNS

LISTENER_ORCL =  
  (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-D8I6M3NGPDF)(PORT = 1521))  
  
  
EXTPROC_CONNECTION_DATA =  
  (DESCRIPTION =  
    (ADDRESS_LIST =  
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))  
    )  
    (CONNECT_DATA =  
      (SID = CLRExtProc)  
      (PRESENTATION = RO)  
    )  
  )  
  
ORCL =  
  (DESCRIPTION =  
    (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-D8I6M3NGPDF)(PORT = 1521))  
    (CONNECT_DATA =  
      (SERVER = DEDICATED)  
      (SERVICE_NAME = orcl)  
    )  
  ) 

--监听

SID_LIST_LISTENER =  
  (SID_LIST =  
    (SID_DESC =  
      (SID_NAME = CLRExtProc)  
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)  
      (PROGRAM = extproc)  
      (ENVS = "EXTPROC_DLLS=ANY")  
    )  
    (SID_DESC =  
      (GLOBAL_DBANAME = orcl)  
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)  
      (SID_NAME = orcl)  
    )  
  )  
  
LISTENER =  
  (DESCRIPTION_LIST =  
    (DESCRIPTION =  
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))  
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-D8I6M3NGPDF)(PORT = 1521))  
    )  
  )  
  

注意事项：

1. Linux,Unix下没有把$SDEHOME/lib目录添加到oracle用户下的.profile或者.bash_profile的相关环境变量中。
2. 监听器除了监听TCP协议，一定还要要监听IPC协议，可以通过lsnrctl status命令来查看。
3. St_shapelib对象所指向的动态库的路径不正确，可以通过select * from user_libraries查看指向的动态库的路径是否正确，如果不正确可以通过create or replace library st_shapelib as ‘your lib path’来修改。

参考：

http://support.esri.com/en/knowledgebase/techarticles/detail/38043

http://blog.csdn.net/linghe301/article/details/7102447  还有少华同志这个很有用，不理解的11GR1,R2的都可以直接复制黏贴

空间数据库专项研究群：Oracle+Arcsde：278243013