In order to be able to log into the ODS through Discoverer or any other tool, you must have the current version of the tnsnames.ora file, which is available now.

If you have not used Discoverer previously, then prior to downloading the tnsnames.ora file, make sure that none of the following files exist on your PC. If they do, delete them:

If using Windows95 and Windows98:

• Delete C:\orawin95\NET80\ADMIN\Sqlnet.ora
• Delete C:\orawin95\NET80\ADMIN\Tnsnames.ora
• Delete C:\orawin95\NETWORK\ADMIN\Sqlnet.ora
• Delete C:\orawin95\NETWORK\ADMIN\Tnsnames.ora

• Delete C:\oraNT\NET80\ADMIN\Sqlnet.ora
• Delete C:\oraNT\NET80\ADMIN\Tnsnames.ora
• Delete C:\oraNT\NETWORK\ADMIN\Sqlnet.ora
• Delete C:\oraNT\NETWORK\ADMIN\Tnsnames.ora

If you are using Windows95 or Windows98, save the new Tnsnames.ora file at C:\orawin95\net80\admin. If you are using WindowsNT, save the new file to C:\orant\net80\admin. Right-click on the link below to download the file.

Download Tnsnames.ora Updated 01/16/2004.

Warning: Be sure that you save the file as tnsnames.ora. If your computer does not display file extentions, it is possible that the file will have an extension you are not aware of and will not work properly. For example, there have been cases where the file appeared to be named tnsnames.ora, but when the file extensions were turned on, the name was actually tnsnames.ora.txt.