Re: 32/64-bit EXTPROC Problem With 9i

My advice would be to fix this thing once and for all and not try to find a workaround. But, if you really want a solution to this, you can try this...

I don't have the environment to test this out, so can not say if it will work. If you ever find out let me know.

1. Put the 2 copies of library file on 2 machine both with ORALCE installed and listeners running.
2. Modify both TNSNAMES.ORA AND LISTENER.ORA on the 2 machines, so that the EXTPROC_CONNECTION_DATA on each machine points to the right version of the library.
3. In your "create library" statement use the "agent" clause to indicate you want to run that library from another database on anohter server - I think this is what it means. For one version of the library you use the agent on the remote machine, for another you use the default local agent - extproc.

Theoretically this should work. You have 2 external procedure agents running simultaneously and taking requests from your applcations, and your library definition specifies which agent it is tied to.

• Jusung Yang

Big Chuck <ccarson_at_echeeba.com> wrote in message news:<3EE8C0E5.3050501_at_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 Fri Jun 13 2003 - 02:34:44 CDT