extproc agents doesn't recognize new library

From: Michael Schaefers <schaefe3_at_cs.uni-bonn.spam-remove.de>
Date: Wed, 10 Nov 2004 15:52:22 +0100
Message-ID: <cmt9v8$8se$1@f1node01.rhrz.uni-bonn.de>

Hi there,

I have successfully registered and used a C-library with Oracle 10g. The only problem I have is:

extproc does not recognize changes in the .so file and keeps using old cached versions. Whenever I alter the .so file (e.g. by recompilation), I have to kill the extproc process explicitly to let Oracle recognize the new library. Another way is: logging off and on again :-(

The listener.ora looks like this:

SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =


       (SID_NAME = extproc)

       (ORACLE_HOME = /opt/oracle/product/10.1.0/db_1)

       (PROGRAM = extproc)

 
(ENVS="EXTPROC_DLLS=ANY,DEBUG_MODULES=ALL,DEBUG_FILE=/tmp/ext_proc.log")
     )

   )

LISTENER =
   (DESCRIPTION_LIST =

     (DESCRIPTION =


       (ADDRESS_LIST =

         (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver1)(PORT = 1521))
         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
       )
     )

   )

My question: Is there an easy way to tell the extproc process not to use   cached versions of .so files? Received on Wed Nov 10 2004 - 08:52:22 CST