|
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
|
