Shell Programming and Scripting

ORA-00206: Message 206 not found;  product=RDBMS; facility=ORA

ORA-00202: Message 202 not found;  product=RDBMS; facility=ORA

ORA-27063: Message 27063 not found;  product=RDBMS; facility=ORA

ORA-00206: Message 206 not found;  product=RDBMS; facility=ORA

ORA-27063: Message 27063 not found;  product=RDBMS; facility=ORA

ORA-00221: Message 221 not found;  product=RDBMS; facility=ORA

awk '/ORA/ { print $0 }' awk1.log > new

a=0
while read LINE
do a=$(($a+1));
awk '/ORA-/ { print $0 }' new | cut -c -10 > new1
awk '/ORA-/ { print $0 }' new | cut -d ":" -f 2- new > new2
mail -s $LINE -r sj@xxxx.com sj@xxxx.com < /home/sss/new2 
echo $LINE;
done < new
echo "Final line count is: $a";

awk '/ORA-/ { print $0 }' new | cut -d ":" -f 2- new > new2

awk '/ORA-/ { print $0 }' new | cut -d ":" -f 2- > new2

awk '/ORA-/ { print $0 }' $LINE | cut -d ":" -f 2- > new2

awk '/ORA-/ { print $0 }' new | cut -d ":" -f 2- > new2

awk -F: '/ORA-/{print $1 >"new1";sub($1 FS " ",z);$1=$1;print $0 >"new2"}' new

awk -F: '/ORA-/{print $1 >"new1";sub($1 FS " ",z);$1=$1;print $0 >"new2"}' $LINE