Oracle 10G DBA course contents

Introduction :
Installing oracle database 10g software
Create an oracle database :
Controlling the database :
Storage Structures :
Administering users :
Managing schema objects :
Managing Data :
PL/SQL :
Oracle Database Security :

Oracle Net Services :
Oracle Shared Server :
Performance Monitoring :
Proactive Maintenance: Objectives
Undo Management :
Monitoring and Resolving Lock Conflicts :
Backup and Recovery :
Database backups :
Monitoring and Managing Memory :
RAC Course :
Course Contents:

Day 1
Introduction and installation
Advantages of using RAC
Architecture of RAC
Cache fusion
Multi instance transaction behavior
Extra background process in RAC
Pre-requisite before installation

Day 2
Oracle RAC 10G installation
Clusterware installation
ASM installation
Oracle database 10G software installation
Install EM agent on cluster nodes
Cluster database creation
Post-installation task
RAC Administration
Redo log files
Control files
Data files
Initialization Parameter Files
Alert log files
Undo management
Temporary tablespace
Starting and stopping of RAC instances
ASM overview
Management of ASM using SRVCTL

Day 3
Oracle Clusterware Administration & Diagnosing
What is oracle clusterware
Oracle clusterware registry
Voting disk
VIP Address
Maintenance of Clusterware log files
Cluster verify utility CLUVFY
Node addition & deletion
Different method
Prerequisites before addition n deletion
Steps for deletion and addition

Day 4
Service Management
Advantage of using service
Possible service configuration
Creation and maintenance of services using SRVCTL, DBCA,EM
Statistics gathering and tracing to check performance of Services
Service performance views
Workload distribution
Fast application notification
Transparent application failover
Load balancing advisory


Day 5
Backup and Recovery
Flash recovery area
Configure backup setting with RMAN
Performance monitoring
Analyzing Cache Fusion Impact in RAC
Wait events and wait events views
Session and system statistics
Database locks
AWR snapshots & reports in RAC
ADDM analysis

Day 6
Design for High Availability
Maximum availability architecture
RAC and Dataguard
Comparison between different storage hardware
Workshop and case studies
Single instance to RAC conversion
No archive log to Archive log conversion
Patching OPatch for RAC
Conversion from non-ASM to ASM