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.
After completing this module, you will be able to:
Describe the syntax and function of Net parameter files
Define the components of Oracle network tools
Describe the components and functions of the tnsnames.ora file
Explain how the protocol.ora file operates
Explain the purpose and uses of the sqlnet.ora file
Establish Net communications at the process level
Explain the purpose and syntax of Oracle database links
Establish connections over database links
We will begin the module by looking at the syntax and function of the Net parameter files.
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
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.