Oracle Net Services
In the field of database computing, Oracle Net Services consists of sets of software which enable client applications to establish and maintain network sessions with Oracle Database servers. Since Oracle databases operate in and across a variety of software and hardware environments, Oracle Corporation supplies high-level transparent networking facilities with the intention of providing networking functionality regardless of differences in nodes and protocols.
Terminology
[edit | edit source]- network service name (NSN): "[a] simple name for a service that resolves to a connect descriptor"[1] For example:
sales.acme.co.uk
Components
[edit | edit source]Oracle Corporation defines Oracle Net Services as comprising:[2]
- Oracle net
- listener
- Oracle Connection Manager
- Oracle Net Configuration assistant
- Oracle Net Manager
Oracle Net
[edit | edit source]![[icon]](/index.php/File:Wiki_letter_w_cropped.svg){kind=small} | This section needs expansion. You can help by adding to it. (May 2008) |
Oracle Net,[3] a proprietary networking stack, runs both on client devices and on Oracle database servers in order to set up and maintain connections and messaging between client applications and servers. Oracle Net (formerly called "SQL*Net" or "Net8"[4]) comprises two software components:
- Oracle Net Foundation Layer: makes and maintains connection sessions. The Oracle Net Foundation Layer establishes and also maintains the connection between the client application and server. It must reside on both the client and server for peer-to-peer communication to occur.
- Oracle Protocol Support: interfaces with underlying networking protocols such as TCP/IP, named pipes, or Sockets Direct Protocol (SDP).
The listener
[edit | edit source]The listener process(es) on a server detect incoming requests from clients for connection - by default on port 1521[5] - and manage network-traffic once clients have connected to an Oracle database. The listener uses a configuration-file - listener.ora - to help keep track of names, protocols, services and hosts. The listener.ora file can include three sorts of parameters:[6]
- listener-address entries
- SID_LIST entries
- control entries
Apart from pre-defined and known statically-registered databases, a listener can also accept dynamic service registration from a database.
Oracle Connection Manager
[edit | edit source] | This section needs expansion. You can help by adding to it. (May 2008) |
The Oracle Connection Manager (CMAN) acts as a lightweight router for Oracle Net packets.[7]
Oracle Net Manager
[edit | edit source] | This section needs expansion. You can help by adding to it. (February 2010) |
Oracle Net Manager, a GUI tool, configures Oracle Net Services for an Oracle home on a local client or server host.[8] (Prior to Oracle 9i known as "Net8 Assistant".[9])
Associated software
[edit | edit source]Utilities and tools
[edit | edit source]tnsping: determines the accessibility of an Oracle net service.[10]
Software suites
[edit | edit source]Oracle software integrating closely with and/or depending on Oracle Net Services includes:
- Oracle Clusterware
- Oracle Data Guard
- Oracle Enterprise Manager
- Oracle Internet Directory
- Oracle RAC (real application clusters)
- Oracle Streams
See also
[edit | edit source]References
[edit | edit source]- Arun Kumar, John Kanagaraj and Richard Stroupe: Oracle Database 10g Insider Solutions. Sams, 2005. Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
External links
[edit | edit source]Footnotes
[edit | edit source]- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Glossary:Oracle Net Services, retrieved 2007-12-03
- ^ Introduction to Oracle Net Services" in Oracle Database Net Services Administrator's Guide 11g Release 1 (11.1), retrieved 2008-01-05
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).