RE: Re: TNSNAMes - 11g & TOAD 11

> TOAD does have red X's on the TNSNames Editor, LDAP Editor and SQNET editor - that seems to me that it cant find those

Did you restart Toad after changing environment variable? Typically environment variable changes aren't pushed out to running applications. If you have, ensure that your TNS_ADMIN environment variable is setup properly. Mine, for instance is setup as...

TNS_ADMIN=C:\Oracle\TNS_ADMIN

And in C:\Oracle\TNS_ADMIN I have tnsnames.ora and sqlnet.ora.

Also, verify that your tnsnames.ora file is setup properly, your DB is up and running, etc.

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Gerald N
Sent: Friday, October 14, 2011 11:00 AM
To: [email protected]
Subject: [toad] Re: TNSNAMes - 11g & TOAD 11

I copied it to the client (root) directory containing the oci.dll.
No luck. Tried the TNS_ADMIN var and that didnt work either. 
I'm running Windows 7.
I still get teh resolution error.  I think there is something really basic that I'm missing as I havent installed Oracle for quite some time. 
Here's my understanding:

Oracle sets up itself, I set up the user(schema), tablespace, default tablespace. 

I install a 32 bit client and it can talk to Oracle 64. I think I need to do a few things here that I havent done..TNSNAMES, SQLNET ?

I install TOAD 11 and need to put in my username. password, Database (TOAD doesnt know it because of 64 bit)

that's where I'm at. I have other items that I dont think matter. My database name is in lowercase - case doesnt seem to matter in TOAD, same error.
TOAD does have red X's on the TNSNames Editor, LDAP Editor and SQNET editor - that seems to me that it cant find those. 

Any ideas from the gang would be appreciated.

--- In [email protected], Michael Staszewski <michael.staszewski@...> wrote:
>
> 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 gerald.novak@...
> 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!)
>




------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/