空间SQL配置---Oracle11G

来源：互联网发布：antlr解析java 编辑：程序博客网时间：2024/05/16 19:20

空间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