TNSNAMES.ORA file?

[Tempora Telora]

I have been instructed to use the TNSNAMES.ORA file on my local machine to allow me to connect to the DB. WHAT is this file? I have the file but where do I put it?

Thanks,
Randy

[David O'Meara]

short answer: c:\oracle\ora92\network\admin\tnsnames.ora

It can contain a series of entries which provide the location of databases. The better way to configure the file is using the oracle database manager applications, but if you're like me then external databases are just remote versions of your own so it is easier to just cut and paste config information in tnsnames.ora

[sachin K Kansal]

TNSNAMES.ora is configuration file in Oracle which specifies what database needs to be connected when a particular host string is provided.so basically it's an database pointing config file.

This needs to be placed at the Oracle home directory. It should be under Network/Admin.