| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help with extproc procedure... SOLVED
Dick/Jason...
Thanks a lot for your help...
The problem was solved in this way:
I put **all** the environments variables declared in ENVS in ONE line!!!
That's did the trick!
Now my proc was executed sucessfully!.
Thanks again!
JL
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Jose Luis Delgado
> Sent: Monday, September 12, 2005 12:18 PM
> To: oracle-l_at_freelists.org
> 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_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
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 12 2005 - 14:18:13 CDT
 |
 |