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
Original Message:
Sent: Mon November 04, 2024 03:44 PM
From: Trong Bo
Subject: Configuring UDF on Oracle Exadata
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
------------------------------