Re: HELP with CRONTAB and SQLPLUS

In article <49f0kf$5vm_at_sol.sun.csd.unb.ca>,

   pmccarth_at_rpc.unb.ca (Patrick McCarthy) wrote:
>>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 ????

Try executing the script 'coraenv' (C-shell) or 'oraenv' (all other shells) after you set the environment variables. (Scripts are located in $ORACLE_HOME/bin)

Good luck,
Rene.

| Rene Hoekstra
| E-Mail : Rene.Hoekstra_at_rivm.nl
| National Institute of Public Health and Environmental
| Protection (R.I.V.M.)
| Bilthoven, The Netherlands
============================================================
      " Alleen slaapwandelaars kunnen in slaap vallen "
============================================================