listener.log extract

[LKBrwn_DBA]

Try this:

#!/bin/ksh
awk '/HOST=/ && /PORT=/ {
i=match($0,"HOST="); i=i+RLENGTH; h0=substr($0,i); 
i=match(h0,")"); host=substr(h0,1,(i-1));
i=match($0,"PORT="); i=i+RLENGTH; h0=substr($0,i); 
i=match(h0,")"); port=substr(h0,1,(i-1));
print "Host="host", Port="port;
}' listener.log| \
sort -u