Hello,

I am trying to configure Optim UDF on Oracle Exadata.  There are 12.1c and 19c databases on this host.  It is a RAC environment.  There are 2 nodes per DB.  I am using Direct mode.  One node is shut down while we are trying to get the other configured and working.  We installed 64 bit rhel_udf_ora on the Exadata server.  We have modified the extproc.ora file and the startup profile per the instructions found here:  Installing and configuring the Optim data privacy user-defined functions for Oracle in UNIX and Linux - IBM Documentation  The listener.ora and tnsnames.ora file have not been modified.  I am able to create the UDFs successfully in a database; however, when I run the validation script I get the following errors:

ORA-06520: PL/SQL: Error loading external library
ORA-06522: libODPPOSLibUnix.so.11.7: cannot open shared object file: No such file or directory
ORA-06522: libODPPORAUdf.so.11.7: cannot open shared object file: No such file or directory

It seems as though the Orace database cannot find the libraries even though I have the variable "LD_LIBRARY_PATH" set in the extproc.ora file. 

Is there someone who has done this successfully in Oracle Exadata and is there any "trick" to getting the "LD_LIBRARY_PATH" to be recognized?

Thank you,

Trong

------------------------------
Trong Bo
Senior Application Environment Analyst
Highmark Western New York
------------------------------

Hi Trong,

One of the steps in the install is to run createODPPsymboliclinks.sh. Did you do that? Please note, that when running it, the <full version> parameter should be for the fix pack level you are at. So, if you have ODPP Fix Pack 2, the full version is 11.7.0.2.

------------------------------
Rick Spagna
Optim Development Director
UNICOM Global
973-755-4092
------------------------------

Thanks for your response, Rick.

It turns out that the issue is a known bug in Oracle 12.1.0.2.  The bug is that LD_LIBRARY_PATH is ignored.  With a patch and a workaround to modify permissions on the extproc.ora the UDF is able to read LD_LIBRARY_PATH.

------------------------------
Trong Bo
Senior Application Environment Analyst
Highmark Western New York
------------------------------

Original Message:
Sent: Thu November 14, 2024 09:23 AM
From: Rick Spagna
Subject: Configuring UDF on Oracle Exadata

Hi Trong,

One of the steps in the install is to run createODPPsymboliclinks.sh. Did you do that? Please note, that when running it, the <full version> parameter should be for the fix pack level you are at. So, if you have ODPP Fix Pack 2, the full version is 11.7.0.2.

------------------------------
Rick Spagna
Optim Development Director
UNICOM Global
973-755-4092
------------------------------