Using Toad for Oracle
640032Dec 12 2008 — edited Dec 30 2008Hi All,
I am using Oracle 10g ver. I am able to connect to this database server using SQLDeveloper.
I have recently installed Toad.
I have installed Oracle Client 10.2.0 to run Toad.
And as I have read tnsnames.ora needs to be created in $ORACLE_HOME/network/admin.
But i do not see any network/admin directory structure in the $ORACLE_HOME.
I have manually created this structure and placed tnsnames.ora here.
The entries are as follows:
DUMMY_LIVE =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = xxxx)
(Port = 1521)
)
(CONNECT_DATA = (SID = xxx)
)
)
When I run Toad, the oracle home (D:\oracle\product\10.2.0\client_1) is shown as valid.
But when I connect to this database, the error "ORA-12154:TNS: could not resolve the connect identifier specified" comes up.
Can somebody please tell me where am I going wrong?
Where exactly should tnsnames.ora be placed?
Thanks in Advance,
Sandhya