Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Oracle Network Topology and Administration

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

 

 

Key Features

* Identify networking log and trace files.

* Describe the Oracle*Net features.

* Develop a network topology.

* De-bug Oracle connections issues with ping and tnsping.

* Create a tnsnames.ora, protocol.ora and sqlnet.ora file.

* Configure and manage the listener using the listener.ora file.

* Set up multiple listeners using the Oracle Multi-threaded server (MTS).

* Install and manage Oracle*Net clients.

* Define remote connectivity between Oracle databases within SQL.

  

This Oracle Networking course introduces Oracle*Net features and covers all areas of Oracle Network Administration including tnsnames.ora, Oracle database links.

N/A

This Oracle network topology and administration training course is designed for the working  Oracle professional and the amount of previous experience with Oracle is incidental.

Previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites.
 

 

This Oracle network topology and administration training course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle Networking training.



Oracle Network Topology and Administration
Syllabus

© 2007-2016 by Donald K. Burleson

Overview of Oracle networking

 

History of networking

Objective: Explain the evolution from centralized to decentralized computers.

 Centralized data, centralized processing (no networking)

 Distributed data, distributed processing (Oracle parallel server)

 Distributed data, centralized processing (Oracle networking)

 Distributed data, distributed processing (OPS with Net8)

 

Evolution of network topologies

Objective:  Describe how topologies have evolved across generations

 

Networks of networked computers

Objective: Describe the fifth-generation architecture

 Evolution toward distributed databases

Quiz: The evolution of Oracle networking

 

The changing attitudes regarding distributed data

Objective: Explain why replication and distribution are now accepted

 

Distributed databases

Objective: List the features of a distributed database

 Local autonomy

 No reliance on a central site

 Continuous operation

 Location independence

 Fragmentation independence

 Replication independence

 Distributed query processing

 Distributed transaction management (update processing)

 Hardware independence

 Operating-system independence

 Network independence

 Database independence

 

Overview of Oracle's topology solution, part 1

Objective: Describe the role of service names in establishing database connectivity.

 

Overview of Oracle's topology solution, part 2

Objective: Describe the role of database links in establishing database connectivity.

 

Overview of Oracle's topology solution, part 3

Objective: Explain how to join tables from remote sites in a SQL query.

Exercise: Define some database links

 

The transparent network substrate (TNS)

Objective: Describe Oracle's TNS architecture

 Inter-database communication

 

Application connection with SQL*Net

Objective: Describe the two ways to connect to remote databases.

Quiz: Oracle TNS

Exercise: Power-user exercise (optional)

 

Features of SQL*Net version 1, part 1

Objective: Explain how SQL*Net handles connections

 

Features of SQL*Net version 1, part 2

Objective: Explain how SQL*Net is unique.

 

SQL*Net version 2 features

Objective: Describe the enhancements built into SQL*Net version 2

Exercise: Course project, step 1

 

Managing distributed database connectivity

Objective: Explain how SQL*Net & Net8 manage database connections.

 Managing incoming connections

 

Quiz: Oracle networking

 

 

Basic Oracle*Net Architecture

 

The Net8 parameter files

Objective: Describe the function of Net8 parameter files

 

SQL*Net and Net8 components

Objective: Define the components of Oracle network tools.

 

The tnsnames.ora file

Objective: Describe the components and functions of the tnsnames.ora file.

 Establishing a remote connection

 

The protocol.ora file, part 1

Objective: Explain how the protocol.ora file works

Quiz: Review of lessons 2­–4

 

The protocol.ora file, part 2

Objective: Describe the use of the TCP NODELAY option.

Quiz: Net8 components

 

The sqlnet.ora file, part 1

Objective: Describe the location and general use of the sqlnet.ora file

 

The sqlnet.ora file, part 2

Objective: Describe the characteristics of the sqlnet.ora file for an Oracle server.

Exercise: Working with sqlnet.ora and tnsnames.ora files

 Contents of the sqlnet.ora logs

 

Process-level inter-database connections

Objective: Establish Net8 connections at the process level

 

Creating a database link

Objective: Explain the purpose & syntax of Oracle database links

 

Connecting with a database link

Objective: Establish connections over database links

 

Quiz: Basic Net8 and SQL*Net architecture

 

 

Basic Server-side Configuration

 

Oracle server components for SQL*Net and Net8

Objective: Identify the main server components of SQL*Net & Net8

 

The Oracle listener

Objective: Explain how the listener manages incoming connections

 

Configuring the Oracle listener

Objective: Identify the relevant listener parameters and how they effect operations

 

Listener operation

Objective: Describe the interaction between listener.ora and LSNRCTL.

Exercise: Create a listener.ora file

 

Using the Net8 Assistant, part 1

Objective: Describe the uses of the Net8 Assistant

 

Using the Net8 Assistant, part 2

Objective: Use the Net8 Assistant to choose naming methods

 

Using the Net8 Assistant, part 3

Objective: Use the Net8 Assistant to define trace levels for the listener

Exercise: Defining trace levels for the listener

 

Using the Net8 Assistant, part 4

Objective: Use Net8 Assistant to configure the client log-on procedure.

Exercise: Configuring the client log-on procedure

 

Using the Net8 assistant, part 5

Objective: Use the Net8 Assistant to route connection requests from the client.

Exercise: Routing connection requests from the client.

 

Using the Net8 assistant, part 6

Objective: Use the Net8 Assistant to set the TNS TIMEOUT value.

 

Setting a listener password

Objective: Explain where the password is stored and how to specify the password

 

The Listener Control Utility (LSNRCTL)

Objective: Identify the basic listener control functions.

 

The LSNRCTL help utility

Objective: Find the listener command syntax.

 

Starting the listener

Objective: Start the listener using the Listener Control Utility.

Exercise: Describe the functions of the listener

 

Stopping the Net8 listener

Objective: Use LSNRCTL to stop the listener.

 

Setting up multiple protocol listeners on the same node

Objective: Run three types of listeners on the same server

 

Quiz: Listener concepts

 

 

Basic Client-side Configuration

 

 

The Windows client architecture

Objective: Identify the Net8 file locations on a Windows computer

 Net8 file locations

 

Using SQL*Net Easy

Objective: Manage the tnsnames.ora file with SQL*Net Easy.

Proper tnsnames.ora management for large sites

Exercise: Using the Service Name Wizard

 

Running the Oracle installer

Objective: Use the Oracle installer to install the client software

 The Oracle installer

 

Creating and maintaining the tnsnames.ora file

Objective: Develop a strategy to create, test, and maintain the tnsnames.ora file

Quiz: Windows client architecture

 

Managing the tnsnames.ora file on a network

Objective: Describe methods for editing and distributing the tnsnanes.ora file on a network

Exercise: Managing large installations

 

Testing your Net8 connectivity

Objective: Describe the Oracle tools used to test connectivity.

Exercise: Testing your connection to the database

 

Using and Configuring Oracle Names

 

Overview of Oracle names

Objective: Describe the architecture of Oracle Names.

 

How Oracle Names resolves requests

Objective: Describe how a request is resolved through Oracle Names

 

When to use Oracle Names

Objective: Explain when it is not appropriate to use Oracle Names

 

Store the network configuration in a local filesystem

Objective: Store the overall topology

Sample names.ora file

Quiz: Oracle Names concepts

 

Overview of the Names Control Utility

Objective: Use the Names control utility

 

Start and stop the Names Server

Objective: Use the basic names control commands

 

Quiz: Oracle Names

 

 

 

 

Using and Configuring Oracle Intelligent Agent for OEM

 

Overview of Oracle Enterprise Manager (OEM)

Objective: Describe the capabilities of the Oracle Enterprise Manager.

 

The OEM console screens

Objective: Describe the features of the OEM console screens

The OEM console

 

Overview of Oracle agents

Objective: Explain how Oracle agents work on remote servers.

 Creating customized events in the Event Manager

 

Communicating with the Event Manager

Objective: Describe how Oracle establishes communication between the Intelligent Agents and the Event Manager.

 

Installing the OEM agents on remote servers

Objective: Define remote intelligent agents on remote servers.

 The installer process

Quiz: Identify the console windows of OEM

 

Start and stop the OEM agents on remote servers

Objective: Start and stop remote Intelligent Agents.

 

Configuring the OEM Intelligent Agent

Objective: Set the configuration parameters for the Intelligent Agent.

 

Customizing the OEM Intelligent Agent

Objective: Customize Oracle alerts and reactions.

 More about Tcl

 More about OraTcl

 

Customizing Oracle alerts

Objective: Identify database events to be monitored by the OEM console.

 

Quiz: The Oracle Enterprise Manager

 

 

Using and Configuring the Multi-threaded Server

 

Overview of the types of Oracle listeners

Objective: Explain how MTS differs from a dedicated listener

 Show incoming MTS connection

When to define the MTS

 

Review of the dedicated listener

Objective: Explain how dedicated listener spawns connections

 Show dedicated listener spawning process

 

Overview of the Multi-threaded Server

Objective: Identify components of the MTS

 

Identify the components of the Multithreaded Server (MTS)

Objective: Explain how the MTS spawns a connection

Exercise: Show dispatcher pipes

Exercise: Define a MTS listener – tutor graded -

 

The architecture of the MTS

Objective: Identify the pieces of the MTS

Show init.ora parms and listener.ora pieces interact with MTS

 

Configuring the dispatchers for the MTS (using init.ora)

Objective: Identify the dispatcher parameters

 Show entering the init.ora parameters.

 

Configuring shared servers (using init.ora)

Objective: Configure shared servers

Exercise:  Show congiguration process

Exercise: Specify relevant parms for shared MTS servers – tutor graded -

 

Set up connection pooling using the Multithreaded Server

Objective: Pool dispatcher connections

Exercise:  show how multiple dispatchers function

 

Monitoring the MTS

Objective: Use UNIX & Oracle tools to monitor MTS connections

Exercise: show UNIX scripts to display MTS connections

 

Module wrap-up

Quiz:  Overall MTS concepts (Multiple choice)

 

Using and configuring the Connection Manager (CMAN)

 

The Connection Manager’s programs

Objective: Examine the function of the Connection Manager’s three server programs.

 

Features of the Connection Manager

Objective: Discuss the features of the Connection Manager.

 

The cman.ora file

Objective: Describe the structure and function of the cman.ora file.

Quiz: CMAN basics

 

Connection concentration with CMAN

Objective: Use CMAN’s connection concentration feature.

Exercise: Routing client connection requests

 

Network Access Control Rules with CMAN

Objective: Configure the Connection Manager to control access to your database server.

 

Using the Connection Manager Control Utility (CMCTL)

Objective: Use CMCTL to start and control Oracle Connection Manager.

 

Starting and stopping the Connection Manager

Objective: Start and stop the Connection Manager.

Quiz: Configure network access

 

Using SQL*Net with multi-protocol functionality

Objective: Use SQL*Net with connections to multiple protocols.

MouseOver/Exercise: Show lsnrctl help overview

 

Quiz: Using and configuring the Connection Manager (CMAN)

 

 

Using Logging and Tracing to Troubleshoot the Network Environment

 

An overview of log and trace files

Objective: Compare log files and trace files.

 

Configuring the Oracle log and trace files

Objective: Modify the trace and log file parameters.

 

Oracle tracing parameters

Objective: Describe the functions of the Oracle trace parameters.

 Standard Oracle log and trace files

Quiz: Logging and Tracing

 

Turning on Net8 logging and tracing

Objective: Turn on logging and tracing for Net8

 

Enable tracing for Oracle Net8 components

Objective: Invoke tracing for all Oracle components.

 

Identify the location of log and trace files on any Oracle server

Objective: Find the location of log and trace files

Exercise: Log and trace parameters (tutor scored)

 

Using log and trace files

Objective: Analyze and troubleshoot network problems.

Exercise: Network problems

 

Using Trace Assistant

Objective: Format traces using Trace Assistant.

 

Quiz: Logging and Tracing

 

 

Security in the Network Environment

 

Identifying network security areas

Objective: Identify Oracle entry points

 

Security risks of external authentication and ops$ users, part 1

Objective: Explain how external authentication works on an Oracle server

 

Security risks of external identification and ops$ users – part 2

Objective: Describe the implications of external authentication on Oracle security

Exercise: Describe security (tutor scored)

 

Security risks with ops$ users

Objective: Explain how the init.ora parameters can affect remote connections

 The origin of ops$

 

Security risks with ops$ users – an example

Objective: Define an ops$ user and connect

Quiz: Identify problems with Net8 security

 

Auditing the Net8 architecture

Objective: Run a script to show database security

 

Security and database links, part one

Objective: Use a script to display internal database links

 

Security and database links, part two

Objective: Use a script to display public database links

Exercise: Auditing and database links

 

The Advanced Networking Option, part 1

Objective: Describe the utility of encryption and checksumming

 

The Advanced Networking Option, part 2

Objective: Describe the utility of single sign-on

 

The components of the Advanced Networking Option

Objective: Configure components of the Advanced Networking Option

 Profile screens

 

Configuring settings in the sqlnet.ora files

Objective: Configure components of the Advanced Networking Option in the sqlnet.ora files

 The Kerberos Authentication Adapter

 

Configuring settings in the listener.ora files

Objective: Configure components of the Advanced Networking Option in the listener.ora files

 

 

As with all BC courses, this Oracle Network Topology and Administration training course is fully customizable.  BC trainers will work directly with your team to ensure that you receive the Oracle Network Topology and Administration training course that meets your specific needs.

Please note that while the knowledge gained from this Oracle training may be valuable when preparing for Oracle certification exams, the content of this course is not for Oracle Certification, including the Certified Professional (OCP) or Oracle Certified Associate (OCA) programs.

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.