Hi Scott,
LD_LIBRARY_PATH=/oracle/data/scripts/lib:$LD_LIBRARY_PATH
Have you checked $LD_LIBRARY_PATH in your listener env variables?
and you haven't shown ls -l /oracle/data/scripts/lib
has oracle permissions to it?
On Thu, Jul 1, 2021 at 6:12 PM Scott Canaan <srcdco@xxxxxxx> wrote:
I have a c program that sends audit data to the OS syslog. I just moved
the database from a Red Hat 7 server to a Red Hat 8 server. I had this
same problem last year after applying the April PSU.
The listener.ora contains:
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/product/19.0.0.0)
(PROGRAM = extproc)
# (ENVS = "EXTPROC_DLLS=ANY:/oracle/data/scripts/lib/syslog.so")
(ENVS =
"EXTPROC_DLLS=ANY,LD_LIBRARY_PATH=/oracle/data/scripts/lib:$LD_LIBRARY_PATH")
)
The library is here:
/oracle/data/scripts/lib
oracle@dbmon06:DBMONITR>ls
syslog.bak3 syslog.o syslog.so syslog.so.bak test.o
syslog.c syslog.o.bak syslog.so.051120 test.c test.so