TNS Names | Generate TNS names in one line

 cat dbList.out | awk {'print $1"=\n (DESCRIPTION=\n  (ADDRESS_LIST=\n    (ADDRESS=(PROTOCOL=tcp)(HOST="$3")(PORT="$4")))\n  (CONNECT_DATA=\n    (SERVICE_NAME="$1")))"'}


SID serviceName Hostname/IP PORT

Komentarze