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

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.

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