ARCGIS问题解决方案
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以上的版本）
