OraFAQ Forum: Linux » Shell Script Doesn't Set Variables Correctly When Run From Cron

Home » Infrastructure » Linux » Shell Script Doesn't Set Variables Correctly When Run From Cron (RHEL 5 + Oracle 10.2.0.5/11.1.0.7/11.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Shell Script Doesn't Set Variables Correctly When Run From Cron [message #611115]

Thu, 27 March 2014 13:33

coreyr
Messages: 18
Registered: March 2014

Junior Member

I've written a basic script that does a datapump export of all databases running on the server, zips/moves them to a final destination, and writes a success/failure message for each to a status table.

The script runs fine when I kick it off from a command line but fails when I kick it off from cron -- and it appears to be because ORAENV isn't being executed (and/or some other variables or paths aren't being set correctly.)

All of the searching I've done hasn't given me enough of a clue to be able to resolve things so I'm hoping somebody can help out.

Shown below are: 1) The cron entry; 2) The script itself; 3) Output from a successful command-line execution; and 4) Output from a failed cron execution.

Thanks for your consideration and let me know if I can provide additional details.

Corey

________________________________________________________________________________________________________________________

Cron entry:

# Datapump export of all running databases
##########################################
40 12 * * 1-5 /opt/oracle/scripts/datapump_export_cron.sh >/opt/oracle/scripts/logs/datapump_cron.txt

Script:

#!/bin/bash -xv


# Define the log file that will store all datapump processing info
##################################################################
  LOG=/opt/oracle/scripts/logs/datapump_exports.log
  DATETIME=`date +%c`
  echo "----------- ${DATETIME} ------------------"  >> ${LOG}
  echo -e "\n" >> ${LOG}


# Loop through each of the databases for which an export is to be done, setting the appropriate variables
#########################################################################################################
  for INSTANCE in klwtst lvdfcbdv kcorptst
# for INSTANCE in `ps -ef | grep pmon | grep -v grep | awk 'BEGIN{FS="_"}{print $NF}'`
  do
    echo "The Oracle SID is this:  $ORACLE_SID" >> ${LOG}
    echo "Oracle Home is this:  $ORACLE_HOME" >> ${LOG}
    echo "The path is: $PATH" >> ${LOG}
    export ORACLE_SID=${INSTANCE}
    export ORAENV_ASK=NO;
    . oraenv;
    echo "The Oracle SID is this:  $ORACLE_SID" >> ${LOG}
    echo "Oracle Home is this:  $ORACLE_HOME" >> ${LOG}
    echo "The path is: $PATH" >> ${LOG}
    VERSION=`echo $ORACLE_HOME | awk 'BEGIN{FS="/"}{print $NF}' | cut -c 1-2`
      if [ ${VERSION} == 10 ]
      then
           COMPRESSION_TYPE="metadata_only"
      else
           COMPRESSION_TYPE="all"
      fi
    PWD1=`head -1 /opt/oracle/scripts/.pwd.txt`
    PWD2=`tail -1 /opt/oracle/scripts/.pwd.txt`
    DATE=`date +%Y%m%d`
    DUMPDIR=/opt/oracle/scripts/datapump_exports/datapump_temp
    MOVEDIR=/opt/oracle/scripts/datapump_exports/${ORACLE_SID}
    LOGDIR=/opt/oracle/scripts/logs/${ORACLE_SID}
    TEMPLOG=/opt/oracle/scripts/logs/.datapump_temp.log
    UPPER_SID=`echo $ORACLE_SID | tr '[:lower:]' '[:upper:]'`
    SERVER=`uname -n | awk -F. '{print $1}' | tr '[:lower:]' '[:upper:]'`


  # Export the database's objects via datapump
  ############################################
    echo "Exporting objects for ${ORACLE_SID} now.........................." >> ${LOG}
    expdp system/${PWD1} parallel=4 directory=DP_EXPORTS dumpfile=dpexport%u_${ORACLE_SID}_${DATE}.dmp \
    logfile=dpexport_${DATE}.log job_name=${ORACLE_SID} full=y exclude=statistics compression=${COMPRESSION_TYPE} \
    flashback_time=\"to_timestamp\(to_char\(sysdate,\'yyyy-mm-dd hh24:mi:ss\'\),\'yyyy-mm-dd hh24:mi:ss\'\)\"
    tail -1 ${DUMPDIR}/dpexport_${DATE}.log >> ${LOG}
    echo -e "\n" >> ${LOG}
    tail -1 ${DUMPDIR}/dpexport_${DATE}.log >> ${TEMPLOG}
    DP_LAST_TIME=`cat ${TEMPLOG} | tail -2 | head -1 | awk 'BEGIN{FS=" "}{print $6}'`
    DP_THIS_TIME=`cat ${TEMPLOG}| tail -1 | awk 'BEGIN{FS=" "}{print $6}'`
    cat ${TEMPLOG} | tail -1 | grep -qw 'successfully'
    if [ $? -eq 0 ] && [ "$DP_LAST_TIME" != $"DP_THIS_TIME" ]
    then
      DP_STATUS=succeeded
    else
      DP_STATUS=failed
    fi


  # Move the export and log files to their final destinations and tar/gzip them
  #############################################################################
    if [ ! -d "$MOVEDIR" ]
    then
      mkdir /opt/oracle/scripts/datapump_exports/${ORACLE_SID}
      mkdir /opt/oracle/scripts/logs/${ORACLE_SID}
    fi
    mv ${DUMPDIR}/*.dmp ${MOVEDIR}
    cd ${MOVEDIR}
    tar -czvf dp_${ORACLE_SID}_${DATE}.tar.gz *.dmp
    rm ${MOVEDIR}/*.dmp
    mv ${DUMPDIR}/dpexport_${DATE}.log ${LOGDIR}/dp_${ORACLE_SID}_${DATE}.log
    gzip ${LOGDIR}/dp_${ORACLE_SID}_${DATE}.log


  # Remove export and log files older than three days
  ###################################################
    find ${MOVEDIR} -mtime +3 -type f -name "*.gz" -exec rm -f {} \;
    find ${LOGDIR} -mtime +3 -type f -name "*.gz" -exec rm -f {} \;


  # Write status of export to status table
  ########################################
    export PWD2
    export DP_STATUS
    export DATE
    export UPPER_SID
    export SERVER
    sqlplus -S /nolog <<-EOF
    connect dp_user/$PWD2@rman2
    declare
      db_id NUMBER;
      max_db_id NUMBER;
    begin
      select id into db_id from dp_user.dp_status where database_name='$UPPER_SID';
      if db_id is not null
      then
        update dp_user.dp_status set datapump_status='$DP_STATUS', last_run_date='$DATE'
        where database_name='$UPPER_SID';
      end if;
      exception
        when no_data_found then
        select max(id) into max_db_id from dp_user.dp_status;
        insert into dp_user.dp_status values(max_db_id+1,'$UPPER_SID','$SERVER','$DP_STATUS','$DATE');
    end;
    /
    exit
EOF
  done

Success (command-line):


----------- Thu 27 Mar 2014 08:07:46 AM CDT ------------------

The Oracle SID is this:
Oracle Home is this:  /opt/oracle/product/11.1.0.7
The path is: /usr/kerberos/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/opt/oracle/product/11.1.0.7/bin
The Oracle SID is this:  klwtst
Oracle Home is this:  /opt/oracle/product/11.1.0.7
The path is: /usr/kerberos/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/opt/oracle/product/11.1.0.7/bin
Exporting objects for klwtst now..........................
Job "SYSTEM"."KLWTST" successfully completed at 08:11:21


The Oracle SID is this:  klwtst
Oracle Home is this:  /opt/oracle/product/11.1.0.7
The path is: /usr/kerberos/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/opt/oracle/product/11.1.0.7/bin
The Oracle SID is this:  lvdfcbdv
Oracle Home is this:  /opt/oracle/product/11.2.0
The path is: /usr/kerberos/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/opt/oracle/product/11.2.0/bin
Exporting objects for lvdfcbdv now..........................
Job "SYSTEM"."LVDFCBDV" successfully completed at 08:15:24


The Oracle SID is this:  lvdfcbdv
Oracle Home is this:  /opt/oracle/product/11.2.0
The path is: /usr/kerberos/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/opt/oracle/product/11.2.0/bin
The Oracle SID is this:  kcorptst
Oracle Home is this:  /opt/oracle/product/10.2.0.5
The path is: /usr/kerberos/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/opt/oracle/product/10.2.0.5/bin
Exporting objects for kcorptst now..........................
Job "SYSTEM"."KCORPTST" successfully completed at 08:17:42

Failure (cron):


----------- Thu Mar 27 09:12:01 2014 ------------------

The Oracle SID is this:
Oracle Home is this:
The path is: /usr/bin:/bin
The Oracle SID is this:  klwtst
Oracle Home is this:
The path is: /usr/bin:/bin
Exporting objects for klwtst now..........................


The Oracle SID is this:  klwtst
Oracle Home is this:
The path is: /usr/bin:/bin
The Oracle SID is this:  kcorptst
Oracle Home is this:
The path is: /usr/bin:/bin


The Oracle SID is this:  kcorptst
Oracle Home is this:
The path is: /usr/bin:/bin
The Oracle SID is this:  lvdfcbdv
Oracle Home is this:
The path is: /usr/bin:/bin