RelationalDBDesign
RedhatLinuxSys Seomining
module4/sql-net-architecture-conclusion.php prev next prev next
  Course navigation
Lesson 1
Basic Net8 and SQL*Net server-side configuration
 
This module introduces you to the details about the configuration and management of Net8 on both the client and the server. We'll look more closely at the parameter files that are used in configuration, and we'll look at the GUI tools that Net8 provides to simplify the management of the parameter files.
Server-side connectivity is far more complex than configuring a client for Net8. 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'll begin with a conceptual overview of the listener, its functions and uses. We will then look at the Net8 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 Net8 creates, starts, and uses it. The module concludes with a look at how to configure multiple listeners on a Net8 server.
Learning objectives
After completing this module, you will be able to:
  1. Identify the main server components of SQL*Net and Net8
  2. Explain how the listener manages incoming connections
  3. Identify the relevant listener parameters and how they affect operations
  4. Interact with the Net8 Assistant tool
  5. Explain where the password is stored and how to specify it
  6. Identify the basic listener control functions
  7. Find the listener command syntax
  8. Start the listener and the output from the command
  9. Stop the listener
  10. Run three types of listeners on the same server
The next lesson examines the Oracle server components for SQL*Net and Net8.
  Course navigation