ORACLE8i NETWORKING for DBA’s

Duration: 2 days

Develop the advanced skill of networking to effectively administer an Oracle Server Database

Print Outline in PDF format

Course Description:

This course provides students with the knowledge and hands-on experience needed to configure Oracle networking.

Participants will learn…

• Net8 Architecture

• Net8 Client and Server Configuration

• Names Resolution

• Multi-Threaded Server Architecture

• Net8 Failover and Load Balancing

• Advanced Security

• Net8 and the Internet

Who Needs to Attend:

Application Developers and Designers, Managers, Database Administrators, Systems Administrators, Network Managers and Technical Support Personnel

Prerequisites:

Oracle Foundation Classes, Oracle DBA I or equivalent experience

Course Content:

DUTIES OF THE DBA

OVERVIEW OF ORACLE NETWORK ARCHITECTURE

• Oracle Networking: A History

• Oracle Net8 Architecture

• Net8 Layers

• Net8 Communication Stacks

• Oracle Compatible Protocols

NAME RESOLUTION

• Local Naming

• Directory Naming

• Centralized Naming

• Host Naming

NET8 CLIENT CONFIGURATION

• Net8 Software Installation

• Client Connectivity

• TNSNAMES.ORA File

• TNSPING Utility

• Using the Connection String

• Using Connection Manager

• Using External Names

NET8 SERVER CONFIGURATION

• The NET8 Listener

• LISTENER.ORA File

• Configuring Multiple Protocols

• Listener Security

Tools

• Oracle Net8 Assistant

• Local Configuration

• Profile Configuration

• Service Naming Option

• Listener Configuration

• Naming Methods Configuration

MULTI-THREADED SERVER (MTS)

• MTS Architecture

• MTS Init.ora Configuration

• Using the MTS Server

ORACLE NAMES

• Names Server Redundancy

• Dynamic Names Server Discovery

• Setting Up Oracle Names

• Configuring the Listener

• Configuring Service Names

• Configuring the Oracle Names Server

CONNECTION MANAGER

• Configuring the Connection Manager

• Connection Manager Profile

• Multi-Protocol Interchange

• Connection Concentration

• CMAN.ORA File

NET8 FAILOVER AND LOAD BALANCING

• Failover

• Load Balancing

NET8 TROUBLESHOOTING

• Testing Client/Server Connectivity

• Examining Net8 Log Files

ADVANCED SECURITY OPTION

• Identifying Network Security Risks

• Solutions for Network Security

• Authentication Techniques

ORACLE NETWORKING AND THE INTERNET

• Web-Based Architecture

• Web/Application Server

• Development Tools

PL/SQL PACKAGES FOR THE DBA

• UTL_HTTP

• UTL_INADDR

• UTL_SMTP

• UTL_TCP

A DAY IN THE LIFE OF A DBA

Course Labs:

1. Configure Oracle Client

2. Configure Oracle Listener

3. Net8 Configuration

4. MTS Configuration

5. PL/SQL Packages