What does TNS stand for as in tnsnames.ora? I guess it's an
abbrevation. T... Name Service? (What is a tnsname?)

Transparent Network Substrate. It's Oracle's version of a network
protocol stack that sort of maps to the 7 layers in the OCI model.

Cheers,
Dave




Christian Eriksson wrote:

Interesting.

How does it work? Does the Oracle database running in Banyan-Vines need
to have a listener that supports the Appletalk protocol to talk to the
client?

- Dave




Hans Forbrich wrote:

On 24 Jun 2003 14:48:41 -0700, c-eriks (AT) algonet (DOT) se (Christian Eriksson)
wrote:

You can look it up in the glossary of the online manual.

http://otn.oracle.com

Dave Hau wrote:

Following is dredging up some old memories - I no longer have my copy of the
Multiprotocol Interchange Administrator's Guide ... (others of my
silver-haired compatriots are welcome to correct me <g>)

The gateway machine needs to have the appropriate cards for the two protocols
(eg: Banyam, AppleTalk, TCP, etc.).

Functionally it then gets two SQL Net (aka Net8) 'gateway' listeners, one
for each protocol. Each listener (on the incoming side) acts similar to a
regular listener for it's incoming protocol; on the outgoing side it acts as
a regluar client for it's outgoing protocol. Then there's the coordination
software, etc. to ensure messages & responses do the right thing, like get to
the right originating client - in today's world it's a lot like IP-Masq in
*nix in each direction.

Of course that's mainly for historical interest - now-a-days you'd probably
use a protocol bridge at the net leyer, below the SQL*Net layer.

Hans Forbrich <forbrich (AT) telusplanet (DOT) net> wrote



Well, you *could* get dedicated protocol bridges back in those days.
The real merit of Oracle's solution back then was that
each of the bridges would cost you a tremendous bundle,
*if* you could find one that would work with the mix you
wanted.

Oracle's solution could work in any existing box, provided
a NIC was available for each network. Ie, a software solution.
And very, very cheap for anyone already using Oracle.

Cheers
Nuno Souto
wizofoz2k (AT) yahoo (DOT) com.au.nospam

"Peter" <peter (AT) nomorenewsspammin (DOT) ca> wrote


Paul