Oracle Database Administration Fundamentals II Training - FREE Tutorials

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON CD

Oracle Net Services Architecture
Net Services Architecture
The Open Systems Interconnection (OSI) Model
Oracle OSI Model
Protocols
Net Services Communication
Dedicated and Shared Connections
Shared Server Processes and Dispatchers

Configuring a Simple Connection
Listener Configuration File
The TNS Names Configuration File
The Profile Parameters File
Basic Database Configuration Parameters - Tuition 1
Basic Database Configuration Parameters - Tuition 2
Using the Net Configuration Assistant - Tuition 1
Using the Net Configuration Assistant - Tuition 2

The Listener
What is the Listener? - Tuition 1
What is the Listener? - Tuition 2
Basic Listener Configuration
The Listener Control Utility
Service Registration
Listener Queue Size
Switching Off Listener Logging and Tracing
Timeouts
Multiple Listeners - Tuition 1
Multiple Listeners - Tuition 2
Connection Load Balancing and Failover
The Session Data Unit Buffer (SDU)
Connection Profile Configuration

Connection Strings and Naming Methods
Connection Strings
Naming Methods
Local Naming Using TNS
Host Naming
External Naming
Directory Naming - Tuition 1
Directory Naming - Tuition 2
Oracle Names Server

Oracle Shared Servers
Multithreaded Server
Introducing Dispatchers
Dispatchers and Connection Pooling
Other Shared Server Parameters
Overriding Shared Servers

Connection Manager
What is Connection Manager?
Connection Concentration
Multiple Protocol Support
Configuring Connection Manager

Other Oracle Net Services Utilities
Other Oracle Net Services Utilities

Oracle Net Services Advanced Features
What is TAF?
TAF Parameters
Configuring TAF
Non-Oracle Database Connections

Oracle Net Services Metadata
Performance Views

Backup and Recovery
What is Backup and Recovery?
Why Backup and Recovery?
Things to Remember
Things to Consider with Datafiles
Redo Logs
Controlfiles
Archive Logs
More Things to Consider
Yet More Things to Consider
Importance of Backup and Recovery
Points of Failure 1312 Backup Strategy

How Backup and Recovery Works
Processes/Memory Structures/Checkpoints
All the Files
SCNs
Restore and Recovery

Archive Configuration
Basic Archive Configuration Parameters
Archive Log Mode Configuration - Tuition 1
Archive Log Mode Configuration - Tuition 2
Multiple Archiving Processes
Multiple Archive Destinations
Standby Archiving - Tuition 1
Standby Archiving - Tuition 2

Logical Backups Using Exports
Full Exports and Imports
Schemas
Multiple Schemas
Importing to a Different Schema
Tables
The Parameter File
Export and Import Options

Physical Backup/Restore/Recovery
Cold Backups
Hot Backups
Verify Backups Using DBVERIFY
Recovering using Offline Physical Backups
Recovering using Online Physical Backups
Read Only Tablespaces
Incomplete Recovery
Scripting Hot Backups

RMAN (Recovery Manager)
What is RMAN?
Repository and Catalog
The Recovery Catalog
RMAN Architecture
What is a Channel?
Allocating and Releasing Channels
Creating an RMAN Database
Creating a Repository
Connecting to RMAN
Registering Databases with the Repository
Viewing the Repository
Backup Sets
Types of Backups
Controlfile Backups
Datafile Backups
Tablespace Backups
Archive Log Backups
Binary Parameter File Backups
Database Backups
Incremental Backups
Restore and Recovery
Restore and Recovery in Action
Scripts and RMAN
Deleting RMAN Backups

Oracle Enterprise Manager Backup and Recovery
Configuring Oracle Enterprise Manager
Communications
Win2K Log on as Batch Job
Export
Import
Backup and Recovery

Backup and Recovery Metadata
Performance Views

Transportable Tablespaces
What are Transportable Tablespaces?
Uses of Transportable Tablespaces
Limitations
Tablespace Sets
Tablespace Set Verification
Transporting a Tablespace Set
Plug In

SQL*Loader
What is SQL*Loader?
The Control File and Complexity
Input Data File
Input Data File Structures
How Rows are Loaded
Multiple Tables and Formats
Column Delimiters
NULL Values
Load Filtering
Filler Fields
Data Types
Conditional Replacement
Using SQL
Generating Data Not in Input Files
Executing SQL*Loader
Conventional Versus Direct
The Parameter File
A Simple Example Load - Tuition 1
A Simple Example Load - Tuition 2
Oracle Enterprise Manager

CLICK HERE TO BUY THIS TUTORIAL ON CD