This module introduces you to the details about the configuration and management of Oracle Net on both the client and the server.
We will look more closely at the parameter files that are used in configuration, and we will look at the GUI tools that Oracle Net provides to simplify the management of the parameter files.
Server-side connectivity is far more complex than configuring a client for Oracle Net.
This is because the TNS listener must be properly configured to handle multiple simultaneous connections to many databases on the server, with incoming connections from hundreds or even thousands of remote clients.
For sophisticated multi-protocol environments, the listener.ora file can become very complicated.
We will begin with a conceptual overview of the listener, its functions and uses. We will then look at the Oracle Net assistant GUI tool before moving to the syntax of the listener configuration file (listener.ora).
We will also take a close look at the TNS listener and understand how Oracle Net creates, starts, and uses it.
The module concludes with a look at how to configure multiple listeners on a Oracle Net server.
After completing this module, you will be able to:
Identify the main server components of Oracle Net
Explain how the listener manages incoming connections
Identify the relevant listener parameters and how they affect operations
Interact with the Oracle Net Assistant tool
Explain where the password is stored and how to specify it
Identify the basic listener control functions
Find the listener command syntax
Start the listener and the output from the command
Stop the listener
Run three types of listeners on the same server
Oracle Net (which is Oracle’s network interface), was formerly known as Net8 when used in
Oracle8, and SQL*Net when used with Oracle7 and previous versions of Oracle.
You can use Oracle Net over a wide variety of network protocols, although TCP/IP is by
far the most common protocol today. Features associated with Oracle Net, such as
shared servers, are referred to as Oracle Net Services.