In Oracle 9i they made a change to the Extproc agent. It will only recognize and load shared libraries in the $ORACLE_HOME/lib or $ORACLE_HOME/bin directories. If $SDS_HOME is not the same as $ORACLE_HOME it will not work. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jose Luis Delgado Sent: Monday, September 12, 2005 12:18 PM To: oracle-l@xxxxxxxxxxxxx Subject: Help with extproc procedure Guys... would you mind to review this conf? I'm having problems to execute an ext proc. ERROR: ------------- SQL> exec sds_admin.LMConnect_Password('sds_sys'); BEGIN sds_admin.LMConnect_Password('sds_sys'); END; * ERROR at line 1: ORA-20101: SDS_Sys password changed but procedure FAILED to store new value in SDS_Parameter table. -28595:::ORA-28595: Extproc agent : Invalid DLL Path ORA-06512: at "SDS_SYS.SDS_ADMIN", line 1466 ORA-06512: at line 1 LOG FILE: -------------- masterlit:oracle9> cat extproc_agt_8407.trc Failed to load Extproc Library : ${SDS_HOME}/lib/libsds_unix.so Oracle Error : ORA-28595 : Request originating from address : (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)) **PLEASE** Note that the file "libsds_unix.so" exists and its path is valid!. LISTENER.ORA ------------------- .... .... (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle1/app/oracle/product/9201) (PROGRAM = extproc) (ENVS = "LM_LICENSE_FILE=1700@masterlit, LD_LIBRARY_PATH=/oracle1/app/oracle/product/9201/lib,TWO_TASK=psrm25, LD_LICENSE_FILE=$ORACLE_HOME/lib, SDS_HOME=/Applications/psrm25/sds, EXTPROC_DLLS=ANY") ) .... .... ) Any help? TIA JL __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l