Re: Failure in dynamic dependency from external procedure

Hi Jeremy,

as far as I understand the listener's LD_LIBRARY_PATH on startup is the one that is passed to the spawned extproc.

So correct your LD_LIBRARY_PATH as you already did, stop and restart your listener. I hope this helps.

Martin

Jeremy Beal wrote:
>
> Greetings...
>
> I am having difficulties with executing an external procedure on the
> Sun platform with Oracle 8.1.5.
>
> It appears that the extproc listener is correctly picking up the need
> to execute the .so file which was compiled. However, it seems to be
> failing to pick up a secondary dependency which was dynamically
> linked into the .so which I wrote. (I get an ld.so.1 error complaining
> that the secondary .so was not found)
>
> Both the main external procedure .so file and the secodnary .so which
> it depends upon reside in the same directory, which is part of the
> LD_LIBRARY_PATH variable for the oracle user. Calling the external
> procedure .so file from a C program front end within this directory
> succeeds without difficulty.
>
> Is there something simple which I am missing here? I haven't been able
> to glean useful information from the Oracle documentation for this
> problem. I'm not certain what login/environment is used for the
> execution of the external procedure, and why it might be failing
> to pick up a .so in the LD_LIBRARY_PATH if things are run from the
> Oracle user's login environment.
>
> Anybody run across this before? Any suggestions?
>
> TIA for any help,
>
> Jeremy Beal
Received on Wed May 31 2000 - 00:00:00 CDT