Topic: Database Administration >> TNS Listener
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| paulo111 |
Posted: Jan 08, 2008 08:21:42 AM |
Total Post: 2
Joined: Jan, 2008
|
Can any of you admin experts give me a real plain english beginners idea of what the TNS Listener is in relation to Oracle Applications.
Many Thanks |
|
|
 Babu |
| Posted: Jan 08, 2008 08:33:48 AM |  |
|
Total Post: 90
Joined: Oct, 2007
|
TNS Listner - Is database connectivity
Actually what do u want. Your facing any problem in Tns listener? Can you show my ora numebr?
Babu
|
|
|
|
|
| paulo111 |
| Posted: Jan 08, 2008 08:36:40 AM | |
|
Total Post: 2
Joined: Jan, 2008
|
No just seen the term TNS Listener a lot and didnt really know what it related to, thanks
|
|
|
|
|
| Murtuja |
| Posted: Jan 08, 2008 10:29:36 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Oracle TNS Listener - This listener allows communication between the Oracle database server and other servers or clients.
The Transparent Network Substrate (TNS) listener, also known as the SQL*NET listener, is a service which establishes and maintains connections with Oracle database services. When it receives a request from a client, the TNS listener establishes a connection between the client and server over a transparent network substrate, which allows communication regardless of the network protocol being used by either system. For example, a client which uses IPX could communicate with a server using TCP/IP over the transparent network substrate.
In addition to requests for connections, the TNS listener also recognizes a number of commands which can be used to view or change status or configuration information about the listener itself. Some of these commands can be restricted such that they can only be used by authenticated users, but others cannot.
One capability of the Oracle TNS listener is the ability to call functions from libraries on the operating system. The listener communicates with another process, called External Procedures (EXTPROC), which is responsible for loading the library and calling the function. The listener communicates with EXTPROC using a named pipe, which is an inter-process communication mechanism which is local to the system.
|
|
|
|
|
| Murtuja |
| Posted: Jan 08, 2008 10:54:07 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Oracle TNS Listener - This listener allows communication between the Oracle database server and other servers or clients.
The Transparent Network Substrate (TNS) listener, also known as the SQL*NET listener, is a service which establishes and maintains connections with Oracle database services. When it receives a request from a client, the TNS listener establishes a connection between the client and server over a transparent network substrate, which allows communication regardless of the network protocol being used by either system. For example, a client which uses IPX could communicate with a server using TCP/IP over the transparent network substrate.
In addition to requests for connections, the TNS listener also recognizes a number of commands which can be used to view or change status or configuration information about the listener itself. Some of these commands can be restricted such that they can only be used by authenticated users, but others cannot.
One capability of the Oracle TNS listener is the ability to call functions from libraries on the operating system. The listener communicates with another process, called External Procedures (EXTPROC), which is responsible for loading the library and calling the function. The listener communicates with EXTPROC using a named pipe, which is an inter-process communication mechanism which is local to the system.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
