Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Writing a shell script to install cron job
- export ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1
- export PATH=$ORACLE_HOME/bin:$PATH
- export ORACLE_SID=HEER
- #!/bin/bash
- ORACLE_HOME="/opt/app/oracle/product/11.2.0/dbhome_1"
- ORACLE_SID="HEER"
- ORACLE_USER="USER1"
- ORACLE_PASSWORD="USERPASS"
- echo "export ORACLE_HOME=$ORACLE_HOME" >> $PWD/sqlcronprocedure.sh
- echo "export PATH=$ORACLE_HOME/bin:$PATH" >> $PWD/sqlcronprocedure.sh
- echo "export ORACLE_SID=$ORACLE_SID" >> $PWD/sqlcronprocedure.sh
- echo "rTmpDir=/tmp" >> $PWD/sqlcronprocedure.sh
- echo "sqlplus -s $ORACLE_USER@$ORACLE_SID/$ORACLE_PASSWORD > $rTmpDir/deleteme.txt 2>&1 <<EOF" >> $PWD/sqlcronprocedure.sh
- echo " select 1 from dual;" >> $PWD/sqlcronprocedure.sh
- echo " execute prvsapupd(1000,14);" >> $PWD/sqlcronprocedure.sh
- echo "EOF" >> $PWD/sqlcronprocedure.sh
- chmod 755 $PWD/sqlcronprocedure.sh
- crontab -l > $PWD/sqlcorn.sh
- echo "0,15,30,45 * * * * $PWD/sqlcronprocedure.sh" >> $PWD/sqlcorn.sh
- crontab $PWD/sqlcorn.sh
- # Clobber previous edition of script!
- cronscript=$HOME/scripts/cronSqlprocedure.sh
- cat <<EOF > $cronscript
- export ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1
- export PATH=$ORACLE_HOME/bin:$PATH
- export ORACLE_SID=HEER
- ...and whatever else is needed...
- EOF
- chmod u+x $cronscript
- # Add to crontab
- tmp=${TMPDIR:-/tmp}/xyz.$$
- trap "rm -f $tmp; exit 1" 0 1 2 3 13 15
- crontab -l | sed '/cronSqlprocedure.sh/d' > $tmp # Capture crontab; delete old entry
- echo "0,15,30,45 * * * * $cronscript" >> $tmp
- crontab < $tmp
- rm -f $tmp
- trap 0
- * * * * * env > /tmp/cron.env
- #!/bin/bash
- ORACLE_HOME="/opt/app/oracle/product/11.2.0/dbhome_1"
- ORACLE_SID="HEER"
- ORACLE_USER="USER1"
- ORACLE_PASSWORD="USERPASS"
- echo "export ORACLE_HOME=$ORACLE_HOME" >> $PWD/sqlcronprocedure.sh
- echo "export PATH=$ORACLE_HOME/bin:$PATH" >> $PWD/sqlcronprocedure.sh
- echo "export ORACLE_SID=$ORACLE_SID" >> $PWD/sqlcronprocedure.sh
- echo "rTmpDir=/tmp" >> $PWD/sqlcronprocedure.sh
- echo "sqlplus -s $ORACLE_USER@$ORACLE_SID/$ORACLE_PASSWORD > $rTmpDir/deleteme.txt 2>&1 <<EOF" >> $PWD/sqlcronprocedure.sh
- echo " select 1 from dual;" >> $PWD/sqlcronprocedure.sh
- echo " execute prvsapupd(1000,14);" >> $PWD/sqlcronprocedure.sh
- echo "EOF" >> $PWD/sqlcronprocedure.sh
- cronscript=$PWD/sqlcronprocedure.sh
- {
- echo "export ORACLE_HOME=$ORACLE_HOME"
- echo "export PATH=$ORACLE_HOME/bin:$PATH"
- echo "export ORACLE_SID=$ORACLE_SID"
- echo "rTmpDir=/tmp"
- echo "sqlplus -s $ORACLE_USER@$ORACLE_SID/$ORACLE_PASSWORD > $rTmpDir/deleteme.txt 2>&1 <<EOF"
- echo " select 1 from dual;"
- echo " execute prvsapupd(1000,14);"
- echo "EOF"
- } > $cronscript
- chmod 755 $PWD/sqlcronprocedure.sh
- chmod 755 $cronscript
- crontab -l > $PWD/sqlcorn.sh
- echo "0,15,30,45 * * * * $PWD/sqlcronprocedure.sh" >> $PWD/sqlcorn.sh
- crontab $PWD/sqlcorn.sh
- crontab=sqlcron.sh
- crontab -l > $crontab
- echo "0,15,30,45 * * * * $cronscript" >> $crontab
- crontab $crontab
- rm -f $crontab
- {
- crontab -l
- echo "0,15,30,45 * * * * $cronscript"
- } | (sleep 1; crontab -)
Add Comment
Please, Sign In to add comment