Toad World® Forums

TNSName Path


#1

What is the name of the folder on C: drive where the TNSName.ora file is stored?

Ocie


#2

Anything you want it to be if you use TNS_ADMIN. If you’re looking for existing tnsnames.ora file, search for it. If you’re trying to setup a client then the
easiest option is to dedicate a folder for your net configuration files (tnsnames.ora, ldap.ora, sqlnet.ora) and store those files in that folder. Create a new environment variable named TNS_ADMIN and set its value to the folder you created.

The
Oracle documentation spells out the search order for locating those files. They can be placed in several locations depending
on your needs, but TNS_ADMIN is the easiest and ensures that all of your clients and tools share a common set of options and connect descriptors.

Michael

From: ocie.adams [mailto:bounce-ocieadams@toadworld.com]

Sent: Tuesday, April 07, 2015 5:24 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] TNSName Path

TNSName Path

Thread created by ocie.adams

What is the name of the folder on C: drive where the TNSName.ora file is stored?

Ocie

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

it will be under your Oracle installation or something like this:

C:/Oracle/product/11.2.0/client_i/network/admin/TNSname.ora


#4

Thanks Mike.

Ocie Adams

DOT&PF Commissioner’s Office

P.O. Box 112500

Juneau, AK 99811

Office: (907) 465-6940

Cell: (907) 209-8052

ocie.adams@alaska.gov

“Keep Alaska Moving through service and infrastructure.”

From: mike.biddle [mailto:bounce-mikebiddle@toadworld.com]

Sent: Wednesday, April 08, 2015 7:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] TNSName Path

RE: TNSName Path

Reply by mike.biddle

it will be under your Oracle installation or something like this:

C:/Oracle/product/11.2.0/client_i/network/admin/TNSname.ora

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.