Learn Oracle by professional working in MNC

I am having 11+ years of working experience in TOP MNC's as Database Administrator. Working on Oracle , SQL Server and Hadoop

Real time experience will be shared with iSCSI storage.

Note:- Additional Classes will be there for the students who are not aware of LINUX

http://manpreet-dba.blogspot.in/

DAY 1

Introduction to RAC
Benefits of Real Application Clusters (RAC)
What is a DB Cluster?
Architectures of DB Clusters
What is a Cluster Interconnect?
Building an Oracle RAC Cluster
RAC Performance and Scalability

DAY 2

RAC Server and Disk Technology
Overview
Oracle RAC Disk System
RAW Partitions and Cluster File System
Raw Partitions
Cluster File System
Storage Technology and Redundancy
Storage Disk System
Understanding I/O Path
High Availablity with SAN
RAID and RAID Administration
Multiple Access Paths to Host
Logical Volume Manager
Cluster File System

DAY 3

RAC Installation and Configuration
Architecture and Components
Servers and Operating System
Interconnect
cluster_interconnect parameter
Cluster Software
Shared Storage
General Steps
Phase 1
Phase 2
Phase 3
Oracle Installation and Creation of Database
Oracle Software Installation
Database Creation using DBCA
Database Creation Manually

DAY 4

Internals of Real Application Clusters

Overview of Cache Fusion
Evolution of Cache Fusion
Nature of Cache Fusion
Benefits of Cache Fusion
Concurrency and Consistency
Cache Coherency
Global Cache Service

DAY 5

RAC Administration
Server Control Utility
srvctl add
srvctl config
srvctl getenv
srvctl setenv
srvctl start
srvctl status
srvctl stop
GSD daemon
GSD Services
Using SQL*Plus
Starting the Database in Cluster Mode
Using Oracle Enterprise Manager
Configuration of OEM with RAC

DAY 6

Failover with TAF
Overview of Transparent Application Failover
Load Balancing
Example listener.ora
Example TAF Configuration
TAF with Connect-Time Failover and Client Load Balancing
Configuring TAF to Retry a Connection
Configuring TAF for Pre-Establishing Connections
Verifying TAF Configurations