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!

tnsnames.ora and/or ODBC

839378Feb 13 2011 — edited Feb 14 2011
Hi there,

I am not a newbie and already certified on Oracle but am confused no matter what on databae connections. to connect from an Oracle DB to another Oracle DB on

I) same server, is tnsnames in enought or ODBC is a must?
II) remote server, is tnsnames in enought or ODBC is a must?

I thank you if I am sent some resource regardgin to both. can either of tnsnames AND ODBC replace eachother or they are completely separate and are need both???

Please give me as much as detail information as you can. I don't know how I got confused on this basic setting!!!

Now any additional questio from/to oracle to another db also much appreciated.

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2011
Added on Feb 13 2011
6 comments
680 views