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