A client has SQL Plus, Toad & D2K intalled. I have added new db service in tnsnames.ora & I can connect to db through sql plus but while connecting through Toad I get tnsname protocol error. This might be because since multiple tnsnames.ora file is created, the file used is not the one in which the db service is added. Can I now which tnsnames.ora file is being used & can I restrict to use a specific tnsnames.ora file.
The scenario u are using is a very common one.
because u are using local naming,each of these softwares use their own tnsnames.ora files.
if u have configured a service name in the oracle home then all the products in that home can use that tnsnames.
if u want d2k to use a service name then u will have to configure it using the net easy config tool in the d2k home.
Toad does not have a network config utility.it uses the available tnsnames.ora from oracle client or d2k