RE: Help with extproc procedure

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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: