Oracle Net8

This course will teach Oracle database administrators the features of Oracle's Net8. Setting up networking, configuration, management, security, debugging, and tracing will be covered. Students will learn the how to configure the Oracle Internet platform for Net8, IIOP, and HTTP.

Audience: Oracle database administrators.

Prerequisites: Oracle8i Database Administration. Previous working experience in Oracle database administration is required.

Understanding the Oracle8i Server Architecture

What is an Oracle Server?
Oracle Versioning
Server Architectural Overview
Operating System Environment
Important Subdirectories in ORACLE_HOME
Oracle Product Subdirectories
Oracle Instance Components
Database, Control and Redo Log Files
Logical Storage Structures
Blocks, Extents and Segments
Different Types of Segments
Tablespaces
Logical Structural Design
System Change Numbers
Oracle8i JVM
Aurora and MTS
Oracle8.0 - The Object-Relational Release
Oracle8 Size Ceilings
Oracle8i - The Internet Release
Oracle Architectures
Optimal Flexible Architecture
DBA Management Pack

Introduction to Net8

What is Net8?
Net8 Fundamental Characteristics
The Dedicated Server
The Multi-Threaded Server Option
Connection Manager (CMAN)
The Communication Stack
he OSI Communication Stack Model
Standard Communication Stack
Internet Inter-ORB Protocol (IIOP) Stack
The Java Database Connectivity Stack
The Oracle JDBC Thin Client Stack
The JDBC Server Stack
Name Resolution
Net8 Management and Configuration Tools

Server Side Configuration

Oracle Network Terminology
The Role of the Listener
Server Processes
Different Types of Listeners
The LISTENER.ORA File
Section One, The Header Section:
Section Two, The Listener Address
Section three, the SID_LIST
Section Four, The Control Parameters
The TNSNAMES.ORA File
The Automatic Service Registration Feature
Methods for Configuring the LISTENER.ORA File
The LSNRCTL Utility
LSNRCTL Operational Commands
LSNRCTL Modifiers
LSNRCTL Informational Commands
LSNRCTL Command Utility Operational Commands
Troubleshooting the Listener
Error Messages
NET8 Log and Trace Files

Net8 Client Configuration

Terminology
Client Configuration Files
Configuration Files: TNSNAMES.ORA
Configuration Files: SQLNET.ORA
Installing Net8 on the Client Machine
Troubleshooting

The Multithreaded Server

The Multithreaded Server Architecture
Connecting to a Multithreaded Server
Connecting to an MTS instance
Request and Response Queues
MTS Initialization Parameters
Setting up the Multithreaded Server
Setting MTS_DISPATCHERS
Setting MTS_MAX_DISPATCHERS
Managing MTS Servers
Data Dictionary Views
Connection Pooling
Setting up Connection Pooling

Network Security

Network Security Risks
Oracle's ASO Architecture
Oracle's ASO Layers
Oracle's ASO Features
Privacy Security Breach
Integrity Security Breach
Authentication Breach
Authorization Breach
Encryption and Integrity
How Cryptography Works
Managing the Encryption Key
Authentication Key Fold-in Encryption
Supported Encryption Algorithms
Cryptographic Checksumming
Enabling Encryption and Integrity Negotiation
Configuring Encryption
Configuring Integrity
How Oracle Chooses the Encryption Method
Centralized Authentication
Supported Authentication Methods
Setting up Authentication

Oracle Enterprise Manager (OEM)

OEM - One Great Big GUI tool!
The Intelligent Agent
Architecture
Features
Applications
Intelligent Agent
Using OEM
Troubleshooting Windows
Troubleshooting Unix

Connection Manager

What is Connection Manager?
Components of Connection Manager
Connection Concentration
Multi-protocol Support
Access Control
Configuring Connection Manager
Profile Settings
Access Control Rules
The CMCTL Utility

Managing the Internet Platform

The JServer Architecture
Aurora and MTS
300% Java
Java Database Programs
Using JDBC for Database Connectivity
JDBC versus SQLJ
Loading Java Programs into Oracle
Loadjava
Library Units and the Resolver Spec
Publishing Java to SQL
Creating a Java Database Trigger
Setting the Network for Java Stored Procedures
Oracle's Enterprise Java Engine
Features of Oracle's EJE
Oracle's Distributed Architecture
IIOP
Configuring IIOP for Dispatcher Access
Configure IIOP using SSL
The sess_sh Tool
Security Policies Overview
More on Security Policies
Application Context Overview
Implementing a Security Policy
Defining Packages for Enforcing Security Policies
Implementing an Application Context
Security package (HR_SEC)
Defining a CONTEXT
Unique Schemas
Shared Schema
Enterprise User Management
Oracle Wallets
Radius Authentication Dial-In User Service
Oracle Security Management
N-tier Authentication/Authorization

Oracle Internet Directory

Directories
Entities
What is LDAP?
Oracle Internet Directory
LDAP, Net8, OID and the Database
Object Classes
LDAP Syntax
Cipher Suites
Installing and Setting up LDAP
Installing the Oracle Internet Directory
Creating an Administrative Context
Creating an LDAP User
Configuring the LDAP Client
Defining an LDAP Server for the Client
Defining a Default Administrative Context