Ever want to run oracle’s sqlplus with crontab? Most of the time, the script won’t be executed, even though you’re already using the right user account. This is because crontab does not source the user’s environment variable when executing the command, and this cause some specific ORACLE variables not having the correct vaules, and in turn caused sqlplus to be unable to find some files required to run.

To solve this, you need to source the environment variables on your script. This is how the crontab script looks like :

$ more gstat.sh
. /home/oracle/.profile

and gstatsql.sh contains the sqlplus command that I want to run, while the gstat.sh is the one called by crontab. This is how my crontab looks like :

30     19      *       *       *       /scripts/gstat.sh

With this, crontab will source the environment variables for the user oracle, and sqlplus will be able to run correctly.

By ikhsan

2 thoughts on “sqlplus with crontab”
  1. Hi,
    This is my script:
    # more tosh.sh
    . /home/oracle/.profile
    echo “Good morning, world.”
    export ORACLE_HOME=/u01/app/oracle/product/9.0.1
    export PATH=$ORACLE_HOME/bin:/usr/local/bin
    export ORACLE_SID=xxxx

    /u01/app/oracle/product/9.0.1/bin/sqlplus -s xxxx/xxxx @/home/ivbbuild/rec.sql > rech.txt

    However when I run it from crontab I dont get anything. What am I missing here.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.