Re: cron scripting of sql*plus

Most probably your environment is not set up properly. Run env in your script and then run env in your UNIX environment and compare. You may add a line, say, . $HOME/.profile in your script (for ksh).

Anthony

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 Tue Jan 23 2001 - 18:26:42 CST