32/64-bit EXTPROC Problem With 9i

From: Big Chuck <ccarson_at_echeeba.com>
Date: Thu, 12 Jun 2003 11:05:25 -0700
Message-ID: <3EE8C0E5.3050501@echeeba.com>

We are trying to migrate from 8.1.7.4 32-bit to 9.2.0.3 64-bit on Solaris 8 64-bit. The migration is done we are now trying to get our myriad of 3rd party cartridges working. These are biotech related software packages and for the most part they are not written by software developers but scientists. (thus you get my drift)

Anyway, some need extproc32 and now need extproc. I cannot get both working together. Some are linked against 32-bit libraries even though they label them as 64-bit.

Is it possible to enable both in the listener.ora file:

LISTENER =
   (DESCRIPTION_LIST =

     (DESCRIPTION =


       (ADDRESS_LIST =

         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
       )


       (ADDRESS_LIST =

         (ADDRESS = (PROTOCOL = TCP)(HOST = 10.250.200.44)(PORT = 1521))
       )
     )

   )

SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =


       (SID_NAME = PLSExtProc)

       (ORACLE_HOME = /u01/app/oracle/product/9.2.0.1)

       (PROGRAM = extproc)

       (ENVS = "EXTPROC_DLLS=ANY")

     )
     (SID_DESC =


       (SID_NAME = PLSExtProc)

       (ORACLE_HOME = /u01/app/oracle/product/9.2.0.1)

       (PROGRAM = extproc32)

       (ENVS = "EXTPROC_DLLS=ANY")

     )
     (SID_DESC =


       (GLOBAL_DBNAME = chem1.syrrx.com)

       (ORACLE_HOME = /u01/app/oracle/product/9.2.0.1)

       (SID_NAME = chem1)

     )

   )

It seems one of the extproc sections is overwriting the other one (more than likely the latter one is the one that is used)

Thanks for any help,
CC Received on Thu Jun 12 2003 - 13:05:25 CDT