UNIX for Advanced & Expert Users

eg: su - abcora -c /tmp/runtime_DB1.ksh

su - abcora -c /tmp/runtime_DB1.ksh </dev/null

while read line <&3;do
 ... # stdin will read from &1 - while the loop reads from &3
done 3< list.txt

$CAT $TMP_FILE1|while read sid
do
fecho "Processing $sid for cleanup"
fecho "-----------------------------------"
export lv_INSTANCE_OWNER=$($PS -ef|$GREP pmon|$GREP $sid|$GREP -v grep|$AWK '{print$1}')
fecho "Instance Owner: $lv_INSTANCE_OWNER"

###############################################################
# CREATING RUNTIME SCRIPT TO EXECUTE AS ORACLE INSTANCE OWNER
###############################################################

$CAT > /tmp/runtime_${sid}.ksh <<EOF2
#!/usr/bin/ksh

. $SDDC_SCRIPT_LOC/sddc_ora_Housekeep_SetEnv.ksh
. $SDDC_SCRIPT_LOC/sddc_ora_Housekeep_FunctionLib.ksh #----Calling Function Script

rc=0
OUTFILE="/tmp/sddc_ora_${gv_host}_Housekeeping_${lv_TIMESTAMP}.log"
fecho "Executing /tmp/runtime_${sid}.ksh..."
chk_db_version $sid  #----Checking DB Version

if [ ${lv_ANY_DAY:-'FALSE'} = 'TRUE' ];then
        db_diag_cleanup \$mdb_ver "force"
else
        db_diag_cleanup \$mdb_ver
fi
fecho "Result code of /tmp/runtime_${sid}.ksh: \$rc"
fecho " "
EOF2

$CHMOD 755 /tmp/runtime_${sid}.ksh

$ECHO "Switching to $sid Instance Owner $lv_INSTANCE_OWNER"
$SU - $lv_INSTANCE_OWNER -c /tmp/runtime_${sid}.ksh > /dev/null
#rm_if_exists /tmp/runtime_${sid}.ksh
done

$SU - $lv_INSTANCE_OWNER -c /tmp/runtime_${sid}.ksh > /dev/null </dev/null

while read sid <&3 # no $CAT $TMP_FILE1 |
do
 ...
done 3< $TMP_FILE1