Re: cron scripting of sql*plus

Make sure in your script you specify the full path to what you are running.
e.g /bin/tar to tar a file in stead of tar. Just a simple example. Reason it works from the command line is your environment variables are set. ANother option is to specify all environment variables in scripts.

In article <3A6E18F0.6377E618_at_bay.csuhayward.edu>,   Matt Collins <mcollins_at_bay.csuhayward.edu> wrote:
> I am wondering if anyone can help me troubleshoot a sqlplus script.
>
> I have some sqlplus commands in a script file that is run by a cron
> job. I am getting an error message from the cron run as follows:
>
> Message file sp1<lang>.msb not found
> Error 6 initializing SQL*Plus
> Message 2100 not found; No message file for product=RDBMS,
> facility=ULMessage 2100 not found; No message file for product=RDBMS,
> facility
> =ULMessage 2100 not found; No message file for product=RDBMS,
> facility=ULMessage 2100 not found; No message file for product=RDBMS,
> facil
> ity=ULMessage 2100 not found; No message file for product=RDBMS,
> facility=ULMessage 2100 not found; No message file for product=RDBMS,
 fa
> cility=ULMessage file sp1<lang>.msb not found
> Error 6 initializing SQL*Plus
>
> If I run the same script from the command line (as the same user) then
> it works fine. Any suggestions would be helpful.
>
> Thanks,
> -Matt-
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 09:32:27 CST