Help with extproc procedure
- From: Jose Luis Delgado <joseluis_delgado@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 12 Sep 2005 09:18:17 -0700 (PDT)
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
Other related posts:
