Shell Programming and Scripting

 
X=0
Y=0
cat -n temp_file | grep VPORCL | awk '{print $1}' > temp_head
while read line
do
arr_head[$X]=$line
X=`expr $X + 1`
done < temp_head
cat -n temp_file | grep "Listener Port" | awk '{print $1}' > temp_tail
while read line
do
arr_tail[$Y]=$line
Y=`expr $Y + 1`
done < temp_tail
n=0
while [ $n -lt $Y ]
do
var1=`echo ${arr_head[$n]}`
var2=`echo ${arr_tail[$n]}`
sed -n "${var1},${var2}p" temp_file > tmp_part_file
instance=`cat tmp_part_file | sed -n "1p" | awk '{print $4}'`
WSL=`cat tmp_part_file | sed -n "2p"  | awk -F"=" '{print $2}'`
JSL=`cat tmp_part_file | sed -n "3p"  | awk -F"=" '{print $2}'`
JRAD=`cat tmp_part_file | sed -n "4p"  | awk -F"=" '{print $2}'`
echo $instance $WSL $JSL $JRAD
n=`expr $n + 1`
done

echo 'instance name WSL port JSL port JRAD port'; echo ""
awk '/^THE/ {printf("%s\t", $4); next}
     /=/ { gsub( /.*=/, "", $0); printf("%s\t", $0); next}
     /^$/ {printf("\n")}
    ' filename

/home/jmcnama> t.awk
instance name WSL port JSL port JRAD port

VPORCL01        1533    9000    9100

VPORCL02        7000    9000    9100