What does TNS stand for?

[Christian Eriksson]

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

[Dave Hau]

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:

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

[Dave Hau]

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:

> Dave Hau wrote:
>
>

>>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.

>
>
> To supplement this answer - it was created in the days when there were
> many different protocols competing with TCP/IP. Oracle's answer was to
> create a SQL interconnect stack that was 'transparent' to all the
> different protocols.
>
> A major innovation from Oracle was the protocol interchange gateways so
> a request made by an AppleTalk client could thread through the gateway
> and land on an Oracle database running in a Banyan-Vines environment.
> Although moderately commonplace now, this was very impressive in those
> days!
>

[Peter]

On 24 Jun 2003 14:48:41 -0700, [email]c-eriks@algonet.se[/email] (Christian Eriksson)
wrote:

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

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

[url]http://otn.oracle.com[/url]

[Hans Forbrich]

Dave Hau 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

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.

[Nuno Souto]

Hans Forbrich <forbrich@telusplanet.net> wrote in message news:<3EF8DE70.A60A7C63@telusplanet.net>...

> 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.

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
[email]wizofoz2k@yahoo.com.au.nosp[/email]am

[Paul Brewer]

"Peter" <peter@nomorenewsspammin.ca> wrote in message
news:lelhfvc8e59d15qsv5p8dg11l6teh5dsc0@4ax.com...

> On 24 Jun 2003 14:48:41 -0700, [email]c-eriks@algonet.se[/email] (Christian Eriksson)
> wrote:
>

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

>
> You can look it up in the glossary of the online manual.
>
> [url]http://otn.oracle.com[/url]
>
>

ROFL

Paul