Re: HELP with CRONTAB and SQLPLUS

>I am running Solaris 2.4 and Oracle 7.1.4. We get customer updates from our
>accounting system and we place them on an NFS mounted drive. I am attempting
>to run the following script file from crontab to run sqlplus and do the
>updates. Unfortunately sqlplus does not seem to run. I know the script run
>because the file gets moved and stored in an update directory. I have run
 the
>script as the root user and it works. What can I do to get it to work from
>CRONTAB or is it not possible to run sqlplus from a crontab ?

I stand corrected. I only ran it as SU and therefore I got all the right variables from the original user. I logged in directly as root and got the following message.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Message 133 not found; No message file for product=SQLPlus, facility=SP2: Releas
e 3.1.3.5.1 - Production on Tue Nov 28 08:40:20 1995  

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.  

Message 428 not found; No message file for product=SQLPlus, facility=SP2Message
231 not found; No message file for product=SQLPlus, facility=SP2
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

I had added the following lines to my file;

set ORACLE_SID=sql
set ORACLE_HOME=/opt/oracle/V7
set ORAENV_ASK=NO

What should I do next ???? Received on Tue Nov 28 1995 - 00:00:00 CET