Hi All,
I am using toad 8.0 in my project . when i start toad application it is creating a folder under Program Files with name as Tnsnames and it has two files in the folder, sqlnet.ora and tnsnames.ora.
\Program Files\Tnsnames.
It is trying to the load the tnsnames.ora from this location, and it displays an error when i try to connect to oracle server .
ORA-12154: TNS: Colud not resolve service name.
if i delete this folder from the Program files, and try to connect it works(Since toad now is looking for the tnsnames,ora file in the Admin folder.)
Please help in understanding why this tnsnames dir is created at toad startup and how to make toad to refrain from doing so.
Thanks,
Thomas Reddy
Which version of the Oracle client are you using? And also the operating system
in use could be an issue.
Groetjes,
Wim
On Wed, Jul 13, 2011 at 08:24, Thomas Reddy wrote:
Message from: reddyth
Hi All,
I am using toad 8.0 in my project . when i start toad application it is
creating a folder under Program Files with name as Tnsnames and it has two
files in the folder, sqlnet.ora and tnsnames.ora.
\Program Files\Tnsnames.
It is trying to the load the tnsnames.ora from this location, and it
displays an error when i try to connect to oracle server .
ORA-12154: TNS: Colud not resolve service name.
if i delete this folder from the Program files, and try to connect it
works(Since toad now is looking for the tnsnames,ora file in the Admin
folder.)
Please help in understanding why this tnsnames dir is created at toad
startup and how to make toad to refrain from doing so.
Thanks,
Thomas Reddy
Historical Messages
Author: Thomas Reddy
Date: Tue Jul 12 23:24:54 PDT 2011
Hi All,
I am using toad 8.0 in my project . when i start toad application it is
creating a folder under Program Files with name as Tnsnames and it has two
files in the folder, sqlnet.ora and tnsnames.ora.
\Program Files\Tnsnames.
It is trying to the load the tnsnames.ora from this location, and it
displays an error when i try to connect to oracle server .
ORA-12154: TNS: Colud not resolve service name.
if i delete this folder from the Program files, and try to connect it
works(Since toad now is looking for the tnsnames,ora file in the Admin
folder.)
Please help in understanding why this tnsnames dir is created at toad
startup and how to make toad to refrain from doing so.
Thanks,
Thomas Reddy
__
_______________________________________
i am using oracle client 9i and OS is windows xp
SQLNet setup and/or configuration (e.g. tnsnames.ora) is not Toad specific. If
you have a standard SQLnet home setup say as
c:\oracle\product\11.2.0\client_1\network\admin then simply on the Toad
connection screen tell Toad to use the default SQLNet home. You do not need a
special copy for Toad placed anywhere. If you do not have a SQNNet setup and
simply wish to use Oracle’s instant client – that too does not need
to be under Toad directory. You simply place it both on your path (for DLL
resolution) and set TNS_ADMIN to point to the dir so that essentially becomes
the Oracle home. Of course trying to use an old version of Toad (Toad 8.0 is
from 2004) is not advisable – upgrade. For example that version of Toad
may not recognize Oracle 11g client since it did not come out until 3 years
after Toad 8.0. And using an old client with newer database may not support all
the newer data types that you may want to use.
Saying 9i does not really answer the question. 9i could mean 9.1.x which is no
longer supported by oracle or 9.2.x which is. Then is it 9.2.0.5 or greater
– which again is the currently orcle supported/recommended versions. You
need to be far more specific. Also – here is a blog I wrote some time ago
about common Toad to Oracle connection issues – which are 99.99% of the
time improper standard oracle client setup - and not toad issues ….
http://www.toadworld.com/BLOGS/tabid/67/EntryId/488/TOAD-Database-Connections-Pro
blems.aspx