PL/SQL (MOSC)

MOSC Banner

Creating a External Procedure Language C in Oracle 11g not able to connect

edited Dec 10, 2013 1:31AM in PL/SQL (MOSC) 2 commentsAnswered
Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center