Home » SQL & PL/SQL » SQL & PL/SQL » Administrationquestion
icon5.gif  Administrationquestion [message #186478] Tue, 08 August 2006 02:15 Go to next message
Messages: 28
Registered: May 2006
Junior Member
Hello NG!

Can someone tell me what TNS is? Which use does it have? How is it called in "long" version?

Best Regards
Re: Administrationquestion [message #186480 is a reply to message #186478] Tue, 08 August 2006 02:24 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
From the manuals ( a link can be found in the first post in this forum, the topic about tips and tricks).

from the manuals

Transparent Network Substrate (TNS): A foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.

The Oracle Net foundation layer is responsible for establishing and maintaining the connection between the client application and database server, as well as exchanging messages between them. The Oracle Net foundation layer is able to perform these tasks because of a technology called Transparent Network Substrate (TNS). TNS provides a single, common interface functioning over all industry-standard protocols. In other words, TNS enables peer-to-peer application connectivity. In a peer-to-peer architecture, two or more computers (called nodes when they are employed in a networking environment) can communicate with each other directly, without the need for any intermediary devices.

On the client side, the Oracle Net foundation layer receives client application requests and resolves all generic computer-level connectivity issues, such as:
  • The location of the database server or destination
  • Whether one or more protocols are involved in the connection
  • How to handle interrupts between client and database server based on the capabilities of each

On the server side, the Oracle Net foundation layer performs the same tasks as it does on the client side and also works with the listener to receive incoming connection requests.

In addition to establishing and maintaining connections, the Oracle Net foundation layer communicates with naming methods to resolve names and uses security services to ensure secure connections.

Previous Topic: Execute Immediate
Goto Forum:

Current Time: Thu Aug 17 14:28:36 CDT 2017

Total time taken to generate the page: 0.14803 seconds