Script to check tnsnames.ora syntax

[LKBrwn_DBA]

Thanks gandolf, it did help alot.

Also I found these "partial address" lines which I had never seen before in any other installation; obviously they produced error, but I'm not sure if they are required (or used) by some obscure application out there -- any clues?

on_unix1 = (ADDRESS=(PROTOCOL=TCP)(HOST=UNIX1)(PORT=1575))
on_hpux3 = (address=(protocol=tcp)(host=hpux3)(port=1575))

PS: I tweeked a bit gandolf's script:

#!/usr/bin/bash

export CONNSTRINGS=`sort -u $TNS_ADMIN/tnsnames.ora | grep -v "^ " | grep -v "^#" | grep -v "^(" | grep -v "^)" | sed "s/ =//g" | grep -v "^$"`

echo "${CONNSTRINGS}" | while read line
do
  dbsv=`echo $line|cut -d' ' -f1`
  addr=`echo $line|cut -d' ' -f2-`
  echo "#####+--- Checking: $dbsv ---+#####"
  tnsping $addr
done

exit 0