Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Toad for Oracle

640032Dec 12 2008 — edited Dec 30 2008
Hi 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
This post has been answered by 439427 on Dec 13 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 27 2009
Added on Dec 12 2008
3 comments
1,007 views