Re: DBLINKS and Network Traffic

Having just gone thru setting up such a link in a Netware 4.11 environment I discovered that you need to have the IP address of the REMOTE1 server in the tnsnames.ora on HOST1 (and vice versa in case you want to create a dbalink on HOST1 to Remote1 ) -- You cannot use a DNS-type service name, since Netware is not able to do a DNS names lookup...

( Your client works, because the client's TCP/IP setup knows how to do that...)

Hope it helps,

John Greco

mohotta_at_my-deja.com wrote:

>I am interested in understanding the difference in network traffic
>between a direct client session with a remote database, call it REMOTE1,
>and a session where I am connecting with REMOTE1 via a database link
>created at my Oracle server, call it HOST1.
>
>I noticed that when connecting directly with REMOTE1 using SQLPLUS,
>Oracle checked my client TNSNAMES.ORA for service names. I was
>successful because my client TNSNAMES.ORA included the service name for
>REMOTE1.
>
>But when I connected with HOST1 using SQLPLUS, and tried to query a
>table in REMOTE1 using my database link, ORACLE initially could not
>recognize the service name. This was because it was reading the
>TNSNAMES.ORA on the HOST1 server, which did not include REMOTE1's
>service name.
>
>After adding the service name to the HOST1 TNSNAMES.ORA, I still could
>not query a REMOTE1 table, getting a TNS-012203 SQLNET error.
>
>The fact that the database link way of accessing REMOTE1 was using a
>different TNSNAMES.ORA indicates a fundamentally different network path
>for database links. Also the TNS-012203 error seems to suggest a
>network problem that did not occur with my direct connection to REMOTE1.
>
>The HOST1(Netware 4.11) and REMOTE1(NT 4.0) servers are in the same
>building and can see each other over a T-100 copper connection.
>
>I hope that my story was clear, and that someone can shed some light on
>the issue.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Aug 27 1999 - 15:30:07 CDT