Library Path Issue

From: Scott Canaan <srcdco_at_rit.edu>
Date: Thu, 1 Jul 2021 15:08:56 +0000
Message-ID: <14bc73ad7bac4ac2acb25a6a30e37de4_at_ex04test91a.ad.rit.edu>

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_at_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

The library is defined in the database:

SQL> select library_name, file_spec from user_libraries;

LIBRARY_NAME

---

FILE_SPEC

---

RIT_SYSLOG_LIB
/oracle/data/scripts/lib/syslog.so

SQL> The procedure is:
CREATE OR REPLACE procedure ITS_MON.rit_audit_syslog(message in char) as external

   name "loggr"
   library rit_syslog_lib
   language c
   parameters (message string);
/

I have a test procedure and when I run it, I get:

SQL> exec audit_log_capture_test2;
BEGIN audit_log_capture_test2; END;

*
ERROR at line 1:

ORA-28595: Extproc agent : Invalid DLL Path
ORA-06512: at "ITS_MON.RIT_AUDIT_SYSLOG", line 1
ORA-06512: at "ITS_MON.AUDIT_LOG_CAPTURE_TEST2", line 4
ORA-06512: at line 1

The sysadmin has tried to strace it, but got nothing.

This all works in Red Hat 7.

Any ideas?

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 01 2021 - 17:08:56 CEST