RelationalDBDesign 





Network Topology   «Prev  Next»
Lesson 1

Introduction to Oracle Net Services Architecture

This module adds more depth to our prior discussion of Net architecture. We will look at the Net components and at all of the parameter files, including the tnsnames.ora, listener.ora, protocol.ora, and sqlnet.ora files. We will also see how the pieces fit together and how Net uses these files to establish database communications.

Learning objectives

After completing this module, you will be able to:
  1. Describe the syntax and function of Net parameter files
  2. Define the components of Oracle network tools
  3. Describe the components and functions of the tnsnames.ora file
  4. Explain how the protocol.ora file operates
  5. Explain the purpose and uses of the sqlnet.ora file
  6. Establish Net communications at the process level
  7. Explain the purpose and syntax of Oracle database links
  8. Establish connections over database links
We will begin the module by looking at the syntax and function of the Net parameter files.


Oracle Names

Oracle Names is a product that stores connection information about all databases in a distributed environment in a single location. Any time an application issues a connection request, it consults the Oracle Names repository to determine the location of the database server. Oracle Names is primarily an administrative aid that makes the maintenance of this information easier. Its use is not required; the alternative is to provide local tnsnames.ora files on every client machine.
Oracle supplies three key components that interact to locate services, establish connections, transport data, and handle exceptions. They are:
  1. SQL*Net and Net 8 are legacy technologies.
  2. Transparent Network Substrate (TNS)
  3. Oracle Listener
While the interaction among these products does not generally require intervention beyond the initial installation, some customizations are often beneficial in an environment that is making heavy use of snapshots, symmetric replication, or other distributed functionality.

About Oracle Net Services

Oracle Net Services provides enterprise-wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services eases the complexities of network configuration and management, maximizes performance, and improves network diagnostic capabilities. This section introduces the basic networking concepts involved in a typical network configuration.

Understanding Connectivity

Oracle Net, a component of Oracle Net Services, enables a network session from a client application to an Oracle Database server. When a network session is established, Oracle Net acts as the data courier for both the client application and the database. It is responsible for establishing and maintaining the connection between the client application and database, as well as exchanging messages between them. Oracle Net is able to perform these jobs because it is located on each computer in the network.