Creating a External Procedure Language C in Oracle 11g not able to connect
We are lifecycling a version 9 database to version 11, and need to recreate the external procedure definitions in the new environment.
The old environment is 32bit, new environment is 64bit, both environments are Windows (2003 and 2008R2).
In the old environment, someone else compiled the .dll and published it, while the DBAs created the library, adjusted listener and tnsnames for external procedure.
In the new environment with trying the new default method for connection, the old .dll is copied across to the new server, library is created and granted to public.
The publishing objects are there, and I've adjusted the db_home/hs/admin/extproc.ora to have EXTPROC_DLLS = ANY. The db_home listener and tnsnames have not been updated, as it mentions this is no longer required.