Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 30 2010
Added on May 28 2010
#database-key-features, #scheduler
8 comments
2,005 views