Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^4: Cron revisited

by mildside (Friar)
on Jan 22, 2013 at 02:34 UTC ( [id://1014534]=note: print w/replies, xml ) Need Help??


in reply to Re^3: Cron revisited
in thread Cron revisited

I don't know the cause of your problem, but I've had success with the Solaris/Perl/OracleInstantClient/cron combination by including a BEGIN block in my perl code as below:
BEGIN { unless (($ENV{BEGIN_BLOCK}) or $^C) { $ENV{ORACLE_HOME} = '/usr/local/instantclient'; $ENV{LD_LIBRARY_PATH} = '/lib:/usr/local/instantclient:/usr/local/ +lib'; $ENV{TNS_ADMIN} = '/apps/admin'; $ENV{BEGIN_BLOCK} = 1; exec 'env',$0,@ARGV; } }
Obviously you should set your ORACLE_HOME and LD_LIBRARY_PATH env variables to the correct ones for your installations in the above. Note that the TNS_ADMIN env variable tells you where to look for tnsnames.ora.

Replies are listed 'Best First'.
Re^5: Cron revisited
by tweetiepooh (Hermit) on Jan 23, 2013 at 14:07 UTC
    Thanks for the sane reply. I've now implemented something similar. What was puzzling me was that on version of Client worked without these shenanigans. My feeling now is that is could be a change within the Oracle software rather than the Perl side of things so that, as compiled, Perl can see the library it calls but that library can't see its dependencies.
Re^5: Cron revisited
by Anonymous Monk on Jan 22, 2013 at 03:44 UTC
    :) Thanks buddy I covered that already, and that type of thing usually yields an error message of : failed to load ...so ... Dynaloader ... library not found

    The error message tells you what needs fixing :)

      My apologies. It appears I was repeating information already provided.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1014534]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (2)
As of 2024-04-20 05:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found