Not like interactive logon, cron does not run your ".profile". It might be crazy to ask whether you have explicitly executed your ".profile" before invoking your Perl script.
L Y -----Original Message----- From: Bruce Johnson [mailto:[email protected]] Sent: 18 February, 2014 06:44 Cc: [email protected] ([email protected]) Subject: Re: I have a weird issue with a script running under cron On Feb 17, 2014, at 2:48 PM, John D Groenveld <[email protected]> wrote: > In message <[email protected]>, Richie writes: >> Is LD_LIBRARY_PATH exported? It's hard to see whats going on without >> a full test case. > > The OP shouldn't need to set a LD_LIBRARY_PATH so long as he built > DBD::Oracle with the correct runtime link path, but a simple shell > script to see which libraries aren't resolving would be a useful test: > #!/bin/ksh > /bin/env - /usr/bin/ldd > /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so Everything works on the command line interactively. The error only happens when the script is run via cron; however the ORACLE_HOME and LD_LIBRARY_PATH variables appear to be set correctly. This is a fairly lengthy script that hits tables in use during working hours, yet depends on remote databases not available to me most of the nights, so it may take a few days to work through checking stuff since I only have about two hours a day when I can actually run it :-) -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs Disclaimer: This email (including any attachments) is for the use of the intended recipient only and may contain confidential information and/or copyright material. If you are not the intended recipient, please notify the sender immediately and delete this email and all copies from your system. Any unauthorized use, disclosure, reproduction, copying, distribution, or other form of unauthorized dissemination of the contents is expressly prohibited.
