ARCGIS问题解决方案

linux下 ArcSDE10.1 配置Oracle11g 监听器来使用SQL操作ST_Geometry

1、进入$OraHome/hs/admin/目录，打开extproc.ora文件，

 

 

[oracle@localhost admin]$ cat -n extproc.ora

     1  # 

     2  # extproc.ora is used by extproc in the default Oracle configuration.

     3  #

     4  # This is a sample extproc init file that contains a name-value(s) pair which

     5  # is same as the value of ENVS parameter in listener.ora file.

     6  #

     7  # Syntax: SET name=value (environment variable name and value)

     8  # 

     9  # When specifying the EXTPROC_DLLS environment variable to restrict the DLLs 

    10  # that extproc is allowed to load, you may set EXTPROC_DLLS to one of the 

    11  # following values:

    12  # 

    13  # * ONLY (maximum security) 

    14  #

    15  #   When EXTPROC_DLLS=ONLY:DLL[:DLL], only the specified DLL(s) can be loaded.

    16  # 

    17  #   Syntax: SET EXTPROC_DLLS=ONLY:DLL[:DLL]

    18  #

    19  # * NULL (the default value)

    20  #

    21  #   When EXTPROC_DLLS=, only the DLL(s) in $ORACLE_HOME/bin and ORACLE_HOME/lib

    22  #   can be loaded.

    23  #

    24  #   Syntax: SET EXTPROC_DLLS=

    25  #

    26  # * Colon-seperated list of the DLLs

    27  #

    28  #   When EXTPROC_DLLS=DLL[:DLL], the specified DLL(s) and the DLLs in 

    29  #   $ORACLE_HOME/bin and ORACLE_HOME/lib can be loaded.

    30  # 

    31  #   Syntax: SET EXTPROC_DLLS=DLL:DLL

    32  #

    33  # * ANY 

    34  #   When EXTPROC_DLLS=ANY, DLL checking is disabled.

    35  # 

    36  #   Syntax: SET EXTPROC_DLLS=ANY

    37  #

    38  SET EXTPROC_DLLS=

 

这里，只需要修改一个地方

SET EXTPROC_DLLS=ANY即可

 

2、将相关的dll和So文件拷贝到$ORACLE_HOME/bin或者$ORACLE_HOME/lib里面

3、重启监听即可。（注意，这种方式只针对Oracle11g以上的版本）