In the field of database computing, Oracle Net Services consists of sets of software which enable client

application Application may refer to: Mathematics and computing * Application software, computer software designed to help the user to perform specific tasks ** Application layer, an abstraction layer that specifies protocols and interface methods used in a c ...

s to establish and maintain network sessions with

Oracle Database Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online t ...

server Server may refer to: Computing *Server (computing), a computer program or a device that provides functionality for other programs or devices, called clients Role * Waiting staff, those who work at a restaurant or a bar attending customers and su ...

s. Since Oracle databases operate in and across a variety of software and hardware environments,

Oracle Corporation Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells da ...

supplies high-level transparent networking facilities with the intention of providing networking functionality regardless of differences in nodes and

protocol Protocol may refer to: Sociology and politics * Protocol (politics), a formal agreement between nation states * Protocol (diplomacy), the etiquette of diplomacy and affairs of state * Etiquette, a code of personal behavior Science and technology ...

Terminology

* network service name (NSN): " simple name for a service that resolves to a connect descriptor" For example: sales.acme.co.uk

Components

Oracle Corporation defines Oracle Net Services as comprising: * Oracle net * listener * Oracle Connection Manager * Oracle Net Configuration assistant * Oracle Net Manager

Oracle Net

Oracle Net, a proprietary

networking stack The protocol stack or network stack is an implementation of a computer networking protocol suite or protocol family. Some of these terms are used interchangeably but strictly speaking, the ''suite'' is the definition of the communication protoco ...

, 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") 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

The listener process(es) on a server detect incoming requests from clients for connection - by default on port 1521 - 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: # 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

The Oracle Connection Manager (CMAN) acts as a lightweight router for Oracle Net packets.

Oracle Net Manager

Oracle Net Manager, a

GUI The GUI ( "UI" by itself is still usually pronounced . or ), graphical user interface, is a form of user interface that allows users to interact with electronic devices through graphical icons and audio indicator such as primary notation, inste ...

tool, configures Oracle Net Services for an Oracle home on a local client or server host. (Prior to Oracle 9i known as "Net8 Assistant".)

Associated software

Utilities and tools

* tnsping: determines the accessibility of an Oracle net service.

Software suites

Oracle software integrating closely with and/or depending on Oracle Net Services includes: *

Oracle Clusterware Oracle Clusterware is the cross-platform cluster software required to run the Real Application Clusters (RAC) option for Oracle Database. It provides the basic clustering services at the operating-system level that enable Oracle Database sof ...

Oracle Data Guard The software which Oracle Corporation markets as Oracle Data Guard forms an extension to the Oracle relational database management system (RDBMS). It aids in establishing and maintaining secondary standby databases as alternative/supplementary rep ...

* Oracle Enterprise Manager *

Oracle Internet Directory Oracle Internet Directory (OID) is a directory service produced by Oracle Corporation, which functions compatible with LDAP version 3. Functionality OID makes the following features available from within an Oracle database environment: * inte ...

Oracle RAC In database computing, Oracle Real Application Clusters (RAC) — an option for the Oracle Database software produced by Oracle Corporation and introduced in 2001 with Oracle9i — provides software for clustering and high availability in Oracle ...

(real application clusters) *

Oracle Streams In computing, the Oracle Streams product from Oracle Corporation encourages users of Oracle databases to propagate information within and between databases. It provides tools to capture, process ('stage') and manage database events via Advanced ...

References

* Arun Kumar, John Kanagaraj and Richard Stroupe: ''Oracle Database 10g Insider Solutions''. Sams, 2005.

External links

"Oracle Network Configuration"

Footnotes

{{reflist Oracle software