Where to find tnsnames.ora file in windows

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete?

Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Oracle technology is changing and we strive to update our BC Oracle support information.

If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. All rights reserved by Burleson. Example Multiple Address Lists in tnsnames. Oracle Net Manager supports only the creation of one protocol address list for a connect descriptor. The parameter is added manually to the file. The following is an example of the syntax:.

Refer to Oracle Database Reference for additional information. When a connect descriptor in a tnsnames. Example illustrates failover of multiple Oracle Connection Manager protocol addresses.

The client is instructed to connect to the protocol address of the first Oracle Connection Manager, as indicated by:. The first Oracle Connection Manager is instructed to connect to the first protocol address of another Oracle Connection Manager.

If the first protocol address fails, then it tries the second protocol address. This sequence is specified with the following configuration:. Example illustrates client load balancing among two Oracle Connection Managers and two protocol addresses:. Example Client Load Balancing in tnsnames. These parameters are described in this section. The protocol address section of the tnsnames. To allow the caller to detect a terminated remote server, typically it takes 2 hours or more to notice.

Operating system TCP configurables, which vary by platform, define the actual keepalive timing details. When you set the parameter to on , yes , or true , Oracle Net fails over at connect time to a different address if the first protocol address fails.

When you set the parameter to off , no , or false , Oracle Net tries one protocol address. When you set the parameter to on , yes , or true , Oracle Net goes through the list of addresses in a random sequence, balancing the load on the various listener or Oracle Connection Manager protocol addresses. When you set the parameter to off , no , or false , Oracle Net tries the protocol addresses sequentially until one succeeds. The default value for this parameter is specific to the operating system.

The default for the Linux 2. To instruct Oracle Net to optimize the transfer rate of data packets being sent across the network with a specified session data unit SDU size. If you're unable to connect and wish to replace the file, follow the instructions above but overwrite the existing TNSnames.

If you do this and connect to Oracle databases which are not in the new file, make sure you create a backup copy of your preexisting TNSnames. If you have a TNSnames. You will need administrator access on your machine to follow the instructions below:.