From oracle-l-bounce@freelists.org Mon Sep 12 14:18:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8CJIDWj001448 for ; Mon, 12 Sep 2005 14:18:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8CJIAhJ001436 for ; Mon, 12 Sep 2005 14:18:10 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 43CAE1EBE5D; Mon, 12 Sep 2005 14:18:07 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17227-08; Mon, 12 Sep 2005 14:18:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF6A21E98EB; Mon, 12 Sep 2005 14:18:06 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Vs3ifaEE4ixkq03c7gixsFAUt2IjZoxZQxFf0BKlu++truZf98EvNI8D4nXWF5nSVO+6utrIpwOGEw77kiMdfPwRfmZWtaeJ/j8nV8t9LsZFzYcrs0uTAmxkyWO4N2FcRPFgKNIQlJ3Ax/3J/opy2FloYAgOMkWBqxd7PzlpBjM= ; Message-ID: <20050912191605.56425.qmail@web41010.mail.yahoo.com> Date: Mon, 12 Sep 2005 12:16:05 -0700 (PDT) From: Jose Luis Delgado Subject: RE: Help with extproc procedure... SOLVED To: DGoulet@vicr.com, oracle-l@freelists.org In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502C8B9DE@25exch1.vicorpower.vicr.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-archive-position: 25302 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: joseluis_delgado@yahoo.com Precedence: normal Reply-To: joseluis_delgado@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.8 required=5.0 tests=AWL,BAYES_00, FORGED_YAHOO_RCVD autolearn=no version=2.63 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 --- "Goulet, Dick" wrote: > 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@freelists.org > [mailto:oracle-l-bounce@freelists.org] On Behalf Of > Jose Luis Delgado > Sent: Monday, September 12, 2005 12:18 PM > To: oracle-l@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@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 > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l