Today's Messages (on)  | Unanswered Messages (off)

Forum: Client Tools
 Topic: Help with tnsname.ora
Re: Help with tnsname.ora [message #678869 is a reply to message #678867] Sat, 18 January 2020 01:04
Michel Cadot
Messages: 66774
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The file in %ORACLE_HOME%\network\admin\sample is just an example of tnsnames.ora file to help you write yours.
The file used by the programs must be in %ORACLE_HOME%\network\admin.
You have 2 ways to build a valid tnsnames.ora:

1/ Copy the tnsnames.ora from sample directory into ?/network/admin, open it with notepad and create an entry using the example one

2/ Using the Oracle Network Configuration Assistant with one the 2 methods
2a/ Open a DOS box, verify that ORACLE_HOME and PATH are correctly set, type "netca"
2b/ Click on Windows "Start" button, scroll down to "Oracle..." folder, then to "Configuration and migration tools" and click on "Oracle Net Configuration Assistant"
then follow the screens.

Current Time: Sat Jan 18 03:21:27 CST 2020