This course uncovers the mystery of the Oracle database middleware contained within Oracle Net / SQL*Net. All of the configuration files are considered along with their contents and how these can be customized. The Oracle Net assistant is also covered and this tool is used for multi-threaded server configuration of the database, activating the Oracle Names Server and the Oracle Connection Manager.

Oracle Training Prerequisites

The course Introduction To Oracle9i SQL

• The course Introduction To Oracle9i: SQL
• The course Introduction To Oracle9i: PL/SQL Language
• The course Introduction To Oracle9i: Advanced SQL
• The course Oracle9i Database Administration - DBA I
• The course Oracle9i Database Backup & Recovery - DBA II
• The course Oracle9i Database Performance Tuning

Oracle database administrators.

Oracle Training Objectives

• Configure a distributed Oracle Net and SQL*Net environment
• Use the Oracle Net Assistant for simple and complex configurations
• Place the database in multi-threaded server mode
• Incorporate the Oracle Names Server and Connection Manager into the environment

The course Oracle 9i New & Advanced Features For DBAs

Oracle Training Course duration

3 Days

Oracle Training Course outline

UNDERSTANDING ORACLE NET

ORACLE NET ENVIRONMENT • WHAT IS A DISTRIBUTED DATABASE?

ORACLE NET SERVER-SIDE ADMINISTRATION • THE LISTENER

ORACLE NET CLIENT-SIDE ADMINISTRATION • CONFIGURING CLIENT PARAMETERS

ORACLE NAMES SERVER • CONFIGURATION, FILE SYSTEM REGISTRATION • CONFIGURATION, DATABASE REGISTRATION • NAMES SERVER ADMINISTRATION

ORACLE INTELLIGENT AGENT

SHARED SERVER CONNECTIONS • CONFIGURATION OF SHARED SERVER MODE • ORACLE 9I VERSION INFORMATION

ORACLE CONNECTION MANAGER

DIRECTORY • CONFIGURATION REQUIREMENTS • ORACLE NET SERVICES

TROUBLESHOOTING THE NETWORK • ISOLATING THE PROBLEM • NETWORK TROUBLESHOOTING UTILITIES