If you know where the Windows XP tnsnames.ora file is located on your system, this guide should help you.

Default tnsnames. ora is located in the ORACLE_HOME/network/admin directory.

Question: I’m having trouble finding tnsnames.ora on my windows server. image tnsnames.Exists or as inunix machine under

/home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

But on my Windows machine, nobody in this tnsnames.ora is underoracleproduct10.2.0client_1networkadmin

How do I find the tnsnames.File or create a tnsnames.file

Answer: or remember that being high is only one thing.tnsnames.ora to the server, regardless of the number of instances! remaining

WhenFind which tnsnames.ora file Location in Windows, seefor the TNS_ADMIN registry entryIn this case, if Is tns_admin is set, you will be able to invest the network in 1.aAlias, not the exact connection string “(DESCRIPTION…”).The parameter tells tns_admin to the oracle client where to find it.tnsnames.orafile.

Also make sure tns_admin is set toDOS Variable:

C:> $ path viewed is settns_admin=$path;oracle_homenetworkadmin

You are the tnsnames.ora file/home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora.The

but db_1 is $ORACLE_SID!

As you can see, tnsnames.ora is traditionally located in $oracle_home/network/admin one by onesymbolPhysical reference to the ORACLE_SID location.

On Windows, access style to the Tns_admin register.defined, your company must be able to use a specific network alias, and fully”(DESCRIPTION is not…” Connection string.TNS_ADMIN Oracle parameterCustomers, where to find our tnsnames.ora.

Also make sure tns_admin is set to $PATH in DOS.variables:

C:> set TNS_ADMIN=$PATH;ORACLE_HOMEnetworkadmin

According to written documents, Net oracle priority
Configuration files are allowed:

  1. Net oracle file types in current working directory (PWD/CWD)
  2. TNS_ADMIN space per session or user script
  3. TNS_ADMIN as a nice environment variable
  4. Global TNS_ADMIN defined throughout the registry
  5. Net oracle files in %ORACLE_HOME/network/admin
    (Oracle default location)

For more information, see the related thread on Le Moyen Le Plus Simple De Corriger Où Se Trouve Le Fichier Tnsnames.ora Dans Windows XP
A Maneira Mais Fácil De Corrigir Onde Está O Arquivo Tnsnames.ora No Windows XP
La Forma Más Fácil De Arreglar Dónde Está El Archivo Tnsnames.ora En Windows XP
Der Einfachste Weg, Um Zu Beheben, Wo Sich Die Datei Tnsnames.ora In Windows XP Befindet
Il Modo Più Semplice Per Correggere Dove Si Trova Il File Tnsnames.ora In Windows XP
Najprostszy Sposób Na Naprawienie Lokalizacji Pliku Tnsnames.ora W Systemie Windows XP
De Gemakkelijkste Manier Om Op Te Lossen Waar Het Tnsnames.ora-bestand Is In Windows XP
Det Enklaste Sättet Att Fixa Var är Filen Tnsnames.ora I Windows XP
Windows XP에서 Tnsnames.ora 파일을 수정하는 가장 쉬운 방법
Самый простой способ исправить, где находится файл Tnsnames.ora в Windows XP