Home » Other » Client Tools » Toad - Database connectivity problem
Toad - Database connectivity problem [message #300996] Mon, 18 February 2008 23:26 Go to next message
arunsiva05
Messages: 3
Registered: February 2008
Location: Newark
Junior Member

Hi,

I installed Toad free version, i already have Oracle 10g database. i am getting some error message while i am connecting to this database.
the error message is as follows


ora-12154:TNS: could not resolve the connect identifier specified


my TNSNAMES.ORA file is in my E drive .
I installed Toad in C Drive.

Help me in solving this problem !!

Re: Toad - Database connectivity problem [message #301019 is a reply to message #300996] Tue, 19 February 2008 00:27 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to set the TNS_ADMIN system variable to point to the TNSNAMES.ORA? Something like (on MS Windows]
SET TNS_ADMIN=E:\some_directory\
Re: Toad - Database connectivity problem [message #301025 is a reply to message #301019] Tue, 19 February 2008 00:37 Go to previous messageGo to next message
arunsiva05
Messages: 3
Registered: February 2008
Location: Newark
Junior Member

i am unable to find that "TNS_ADMN"

IF possible can u specify which folder it is ?

i am new to this... is it a file or folder

bye
Re: Toad - Database connectivity problem [message #301039 is a reply to message #301019] Tue, 19 February 2008 00:51 Go to previous messageGo to next message
arunsiva05
Messages: 3
Registered: February 2008
Location: Newark
Junior Member

i cannot able to locate the tns_admin in environment variables / [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE] as well !!!

Re: Toad - Database connectivity problem [message #301042 is a reply to message #301039] Tue, 19 February 2008 01:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do it at the command prompt.
Re: Toad - Database connectivity problem [message #301043 is a reply to message #301039] Tue, 19 February 2008 01:04 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
set it to the complete directory name where your tnsnames.ora is
Re: Toad - Database connectivity problem [message #301047 is a reply to message #301043] Tue, 19 February 2008 01:15 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's a screenshot; I hope you'll get the point.

/forum/fa/3922/0/
  • Attachment: tns_admin.PNG
    (Size: 6.86KB, Downloaded 1593 times)
Previous Topic: Comparison between different sql tools
Next Topic: Problem debugging in SQL Developer
Goto Forum:
  


Current Time: Thu Mar 28 09:23:00 CDT 2024