Hi,

Objective - do a tnsping on all sid's and also do a nslookup on all the host names and store the results of the tnsping and nslookup which FAILED in a file. O/S Sun Solaris 5.8

I need to capture all the sid names and host names from the tnsnames file(which is quite large) and I have to do a tnsping on all the sid's and a nslookup on all the host names to ensure there are no invalid entries.

Could someone help me with a robust shell script.

Sample Tnsnames entry
================
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = xxxx.yyyy.com)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = test)(server=dedicated)
)
)

Thanks a bunch