Log file Creation

Shell Programming and Scripting
1

Hi

I have unix script which does execute some OS commands and DB Commands. I would like to create log file for each command execution, Could some one advise how do we create log file.

Example Script:

###########################################################################
ORACLE_SID=ERS11G
ORACLE_HOME=/u03/app/oracle/product/11.2.0/db_1
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID ORACLE_HOME PATH LD_LIBRARY_PATH
###################################### Defining the Paths####################
SOURCETYPE=$1
INPUTFILESPATH=/ersdg3/ERS/TEST/RIO/files
BASEPATH=/ersdg3/ERS/TEST
ARCHIVEPATH=$BASEPATH/$SOURCETYPE/archive
CONTROLFILEPATH=$BASEPATH/$SOURCETYPE/control
AUDITFILENAME=${SOURCETYPE}_AUDIT_FILE.TXT
SOURCELOADER=${SOURCETYPE}_SOURCE_LOADER
AUDITCONTROLFILENAME=${SOURCETYPE}_REC_CNT.ctl
SOURCECONTROLFILENAME=$SOURCETYPE.ctl
SOURCECONTROLFILENAMENEW=${SOURCETYPE}_NEW.ctl
SOURCETABLENAME=ERS_${SOURCETYPE}_SRC
ARCHAUDITFILEPATH=${ARCHIVEPATH}/auditfiles
USERID=ETL_ERS
PASSWORD=ETL_ERS
SCHEMA=ERS11G
#####################################End of Paths###########################
cd $INPUTFILESPATH
################# Entry into Audit Table####################################
if [ -f *.LOG ]
        then
sqlplus -s -L ETL_ERS/ETL_ERS@ERS11G<<EOF
set feedback off heading off
#exec ETL_LOG.P_LOG_START_PROCESS(trunc(sysdate),'${SOURCELOADER}','ETL_SRC');
exit;
EOF
        else
                echo "Files doesnt exist"
                exit;
fi
####################End of Entry into Audit Table##########################
ls *.LOG >FILE.LIST
###################Check whether Audit file Exists#########################
if [ -f $AUDITFILENAME ]
    then
        rm $AUDITFILENAME
    else
        touch $AUDITFILENAME
fi
#########################################################################
while read filename
        do
##############Date Format for Sql Loader Script and for Directory Creation#####
        filename=$filename
        fname=${filename%%.*}
        date1=${fname##*_}
        date=`print $date1 |cut -c1-8`
        dat=`print $date |cut -c7-8`
        yr=`print $date |cut -c1-4`
        mon=`print $date |cut -c5-6`
        var01="Jan"
        var02="Feb"
        var03="Mar"
        var04="Apr"
        var05="May"
        var06="Jun"
        var07="Jul"
        var08="Aug"
var09="Sep"
        var10="Oct"
        var11="Nov"
        var12="Dec"
        val=$( eval eval echo \$var$mon )
        DATE="$dat-$val-$yr"
        dir=${SOURCETYPE}_${DATE}
echo $dir
############End of Date Format################################################
done <FILE.LIST
2

Use exec > logfile 2> errorfile at the beginning of your script it would help :slight_smile: