ORA-28595: Extproc agent : Invalid DLL Path


SYMPTOMS
SQL> execute DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT;
BEGIN DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT; END;
*
ERROR at line 1:
ORA-28595: Extproc agent : Invalid DLL Path
CAUSE
A call DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT simply loads the extproc.exe process and has not attempted to load any external libraries.
As a result, the error can be a bit misleading. 
 
For this scenario, it was found that within the $ORACLE_HOME/hs/admin directory the extproc.ora file had the following value.
SET EXTPROC_DLLS=any
SOLUTION
Edit the extproc.ora file in the $ORACLE_HOME/hs/admin directory and change "any" to "ANY".
bash-3.2$ 
bash-3.2$ 
bash-3.2$ id
uid=100(oracle) gid=100(oinstall)
bash-3.2$ 
bash-3.2$ 
bash-3.2$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_3
bash-3.2$ 
bash-3.2$ cd $ORACLE_HOME/hs/admin 
bash-3.2$ ls
extproc.ora initdg4odbc.ora listener.ora.sample tnsnames.ora.sample
bash-3.2$ cat extproc.ora 
# 
# extproc.ora is used by extproc in the default Oracle configuration.
#
# This is a sample extproc init file that contains a name-value(s) pair which
# is same as the value of ENVS parameter in listener.ora file.
#
# Syntax: SET name=value (environment variable name and value)
# 
# When specifying the EXTPROC_DLLS environment variable to restrict the DLLs 
# that extproc is allowed to load, you may set EXTPROC_DLLS to one of the 
# following values:
# 
# * ONLY (maximum security) 
#
# When EXTPROC_DLLS=ONLY:DLL[:DLL], only the specified DLL(s) can be loaded.
# 
# Syntax: SET EXTPROC_DLLS=ONLY:DLL[:DLL]
#
# * NULL (the default value)
#
# When EXTPROC_DLLS=, only the DLL(s) in $ORACLE_HOME/bin and ORACLE_HOME/lib
# can be loaded.
#
# Syntax: SET EXTPROC_DLLS=
#
# * Colon-seperated list of the DLLs
#
# When EXTPROC_DLLS=DLL[:DLL], the specified DLL(s) and the DLLs in 
# $ORACLE_HOME/bin and ORACLE_HOME/lib can be loaded.
# 
# Syntax: SET EXTPROC_DLLS=DLL:DLL
#
# * ANY 
# When EXTPROC_DLLS=ANY, DLL checking is disabled.
# 
# Syntax: SET EXTPROC_DLLS=ANY
#
SET EXTPROC_DLLS=ANY
MOS ID: Doc ID 1467901.1
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: