Howdy, My search fu is not working very well today. I did several searches and did not find an answer. I work for a.gov agency. We have folks who remotely connect and use the various Oracle products as well as other products that connect to Oracle (TOAD being one). What we are doing is instead of maintaining one master tnsnames.ora file (and putting up with the problems a corrupted one brings) is for each of us to have our own tnsnames. Confirmit Manual. ora file. The remote access installed version of TOAD points to the tnsnames.ora file that OEM etc point to.

Oracle provides for the ability to have multiple tnsnames aliases for connection to the same database instance in a standard TNSNAMES.ORA file. Creating Multiple Listeners Tips. Configure the service name entries in the tnsnames.ora file under the network/admin directory under the Oracle Home. There may be multiple tnsnames.ora files on the server - and the one used by one session can be different from the one used by another session.

Where can I go to change where TOAD points to the tnsnames.ora file? I've been peeking/poking around but have not found that. I know about TNS_ADMIN, but if I remember correctly this info used to be part of TOAD also.