Just to let all know that those "partial address" entries in the tnsnames.ora are used by the Oracle Names Server...FYI

.