| Crontab problem [message #214485] |
Tue, 16 January 2007 13:20  |
usha_07
Messages: 2
Registered: January 2007
|
Junior Member |
|
|
Hello all,
I am trying to setup a job in crontab to run book_info script, but the problem is cron is giving me errors. I am able to run the script manually on command line but not being able to run it through crontab. At first cron complained of "sqlplus not found", but when I gave path to sqlplus explicitly I am receiving following errors:
Application book_info Script Running,
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
I do see sp1us.msb file in my $ORACLE_HOME/sqlplus directory. I do not have $ORACLE_SID path set up. Do I need it to be set? If so what should it be? Please let me know if I should check anything else to fix this problem.
Thank you for your time,
Nishi
|
|
|
|
|
|
| Re: Crontab problem [message #229756 is a reply to message #214494] |
Mon, 09 April 2007 22:54  |
timarcher52
Messages: 5
Registered: April 2007
|
Junior Member |
|
|
Hi Nishi. I just did a small writeup on how I write my shell scripts to call SQL PLus. My shell scripts are usually designed to be called through cron and include a section on setting up the PATH and other environment variables.
My little writeup is at <a href="http://timarcher.com/?q=node/48">http://timarcher.com/?q=node/48</a>
It also shows you how to pass shell variables into SQL Plus and how to get the return code from SQL Plus for use in your shell script.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
