I have a need to get the sid, host string, and the port from the tnsnames.ora for the tnsnames entry the user specifies when logging in to an app I wrote using DOA. The problem is there can be (and frequently are) more than one Oracle client installed on a given machine. So, how can I find the exact tnsnames.ora used by my DOA app?

Thanks,
Eldon