Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

setting env variables through scheduler

DaljitMay 28 2010 — edited Jun 2 2010

Hi All,

I am trying to run a PERL script which makes database connection using DBI module through scheduler. The script works fine if I run it manually but from scheduler it fails because it can't fine libclnt.sh.10.1 lib file. I have LD_LIBRARY_PATH & LIBPATH set in my .profile and i guess when scheduler runs the external job, it creates a new shell but doesn't inherit the .profile settings (same as cron). I tried setting these env variables in PERL script itself but even then it's not working. I tried my theory by running this script from shell but without running .profile and it fail with exact same error.

I want to know how you guys are handling this situation? How to set or call .profile from scheduler job so that all the env variable get set properly?

OS: SUSE Linux
DB: 11gR2

Thanks
Daljit Singh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2010

Added on May 28 2010

#database-key-features, #scheduler

8 comments

2,120 views