thanks for your response, but
I will have to do a tnsping on whatever is there in the SID =
for example

test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = xxxx.yyyy.com)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = test2)(server=dedicated)
)
)
##########
dbtest =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aaaa.bbbb.com)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = testdb)(server=dedicated)
)
)
##########################

In this case, I will have to do a tnsping on test2 and testdb
and a nslookup on xxxx.yyyy.com and aaaa.bbbb.com

I apprciate your help