Help with extproc procedure

From: Jose Luis Delgado <joseluis_delgado_at_yahoo.com>
Date: Mon, 12 Sep 2005 09:18:17 -0700 (PDT)
Message-ID: <20050912161817.57878.qmail@web41008.mail.yahoo.com>

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_at_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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 12 2005 - 11:20:18 CDT