Back to Search Results

Training Course Summary:

Potential networking security risks and Oracle’s optional security solutions to these issues will be presented. Net8 debugging tools and interpretation of debugging information will be covered. Most common errors and how to troubleshoot an Oracle networking environment will be covered.

Pre-Requisites:

Introduction to Oracle: SQL
Enterprise DBA Part1A: Architecture and Administration


Suggested Prerequisites

Basic operating system knowledge

Training Course Overview/Content:

Overview
Identifying networking business trends and problems
Presenting Oracle’s networking solutions

Basic Net8 Architecture
Identifying the key components of Net8 architecture and their interaction
Defining the procedure by which Net8 establishes a server connection
Defining the layers of Net8
Defining the steps involved in establishing a connection
Defining the steps involved in communication

Basic Net8 Server-Side Configuration
Configuring Net8 listener.ora file
Starting the Net8 listener using Listener Control utility
Stopping the Net8 listener using Listener Control utility
Identifying additional Listener Control commands
Configuring listener load balancing
Configuring Service and Instance Naming
Basic Net8 Client-Side Configuration
Configuring the Net8 client side using the HOSTNAME method
Configuring Net8 client side files using the TNSNAMES method
Configuring Net8 client using Service and Instance names and connecting to the configured listener
Using Net8 Assistant to configure the client side

Centralised Naming Concepts
Defining the concept of a Names server
Identifying the various names resolution methods
Identifying the benefits of a Names server
Defining the administration objects used in a Names server environment
Defining the Naming Models

Usage and Configuration of Oracle Names
Configuring centralized naming using Net8 assistant
Storing configuration in the filesystem
Preparing the database to store configuration
Storing the configuration in the database
Starting and stopping the nameserver using namesctl utility
Usage and Configuration of Multi-Threaded Server
Identifying the components of the Multi-Threaded Server
Configuring shared servers using init.ora
Configuring dispatchers using init.ora
Specifying listener address for Multi-Threaded server
Identifying dependencies between Multi-Threaded Server and Connection Pooling and Multiplexing

Usage and Configuration of Connection Manager
Identifying the roles of connection manager
Configuring Connection Pooling
Configuring the Firewall
Identifying the steps needed to configure the Multi-Protocol Interchange

Troubleshooting the Network Environment
Setting logging and tracing parameters
Analyzing and troubleshooting network problems using log and trace files
Storing audit trail information in the database
Formatting trace files using Trace Assistant

Security In the Network Environment
Identifying network security risks during data transmission
Identifying security features in Oracle Networking products
Characterising the role of firewalls and proxy servers in the network security strategy
Next Course
Enterprise DBA Part2: Performance Tuning Workshop




Course Objectives

Identify network trends and problems, and provide solutions for them.
Define the Net8 architectural layers.
Configure a simple client and server, and establish a connection between them.
Configure and start a Names server and use it to resolve a service name.
Configure and startup a Multithreaded server.
Configure the Connection Manager.
Analyze and troubleshoot Net8 problems using log files, trace files, and Trace Assistant.
Identify network security risks and their solutions, and configure data encryption using the Advanced Networking Option.