Oracle-L: Where to set LD_LIBRARY_PATH in Database for 3rd Party Utilities

From: Scott Graves <scott.graves_at_mo.nisc.cc>
Date: Thu, 03 Apr 2003 08:58:44 -0800
Message-ID: <F001.005797DD.20030403085844@fatcity.com>

I hope someone on the list can help.

Environment:

            Oracle 9.2.0.1
            Red Hat Linux

I’m in the process of trying to connect to a Progress database via Java Stored Procedures in Oracle 9.2.0.1. The Progress JDBC driver is a type 2 driver, which means that it has shared libraries that it must access.

The java test code works outside of the database. The connection to the Progress database is successful. The library path for the Progress JDBC driver was added to the LD_LIBRARY_PATH variable.

The Progress JDBC driver was loaded into the database via the loadjava utility. When I run the test program though the database, I get an error indicating that the library files could not be found. The Oracle user’s profile has the additions to the LD_LIBRARY_PATH for the Progress JDBC driver, but this didn’t help.

I was able to find one forum note on Metalink where someone got this to work, but no details. Where should I set the LD_LIBRARY_PATH variable for the database to be able to find this 3rd party library files? Any ideas would be appreciated. As you can probably tell, I’m new to Unix/Linux.

Thanks in Advance,

Scott Graves
Sr. Systems Programmer
NISC RDQ-STP
Email: scott.graves_at_nisc.cc
Phone: 636-922-9122 x7616
Fax: 636-922-2080

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Scott Graves
INET: scott.graves_at_mo.nisc.cc

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 03 2003 - 10:58:44 CST