RE: TNSNAMes - 11g & TOAD 11
Michael Staszewski <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <6548C9485A5E9C41AE3BB626E669B547100893F4@ALVMBXW01.prod.quest.corp> |
With instant client you need to setup TNS_ADMIN environment variable to point to the path containing tnsnames.ora. You may be able to just copy the tnsnames.ora file to the same path containing oci.dll for your instant client and bypass the TNS_ADMIN variable, but I'm not 100% on that. Michael From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, October 14, 2011 9:26 AM To: [email protected] Subject: [toad] TNSNAMes - 11g & TOAD 11 In my continuing saga of loading 11GR2 with a rusty mind, I've successfully loaded 11G 64 bit, crated tablespace, datafile, user and loaded 32 bit Instant client for use with TOAD 11 I loaded TOAD 11 and it's having a hard time connecting. (ORA-12154 TNS could not resolve...) I'm assuming it's because of TNSNAMES.ORA. I loaded my client into a D:\app directory as per default. I loaded Oracle into d:\Oracle\..... Currently I see a correct TNSNames.ora in d:\Oracle\product\11.2.0\dbhome_1\network\admin Where does the TNSNAMES have to be located, in the client directory somewhere? Jerry (Arggg!)