Oracle RAC Online Training and Placement H1B VISA and H1 transfer in Indiana (IN), Fort Wayne

Oracle RAC Online Training and Placement

We are leading top IT Consulting Company Worldwide. We are providing online training in Oracle RAC with Experienced Faculties with Real-time Examples. You can do LIVE online training from anywhere at your convenience. We also undertake H1B VISA Processing and H1 transfer.

Slake Software Solutions Success formula:
We have dedicated and Experienced Marketing team to place the People in the IT. Our team has excellent track record of providing excellent career Counseling and Placements in the shortest time.

We are IT Consulting and Online Training Company.
We have in-depth knowledge of all IT Softwares, strong leadership and communication skills, knowledge of best practices, business and industry experience, and technical knowledge. They provide business expertise and ensure the delivered product meets the defined requirements.

Online Training, our mission is quite simple:
To be a supplier of personalized training solutions that respond to our Students overall needs in order to generate a real impact on employee performance and ensure a real return on investment.

OUR TEAM
Our training experts are industry professionals, working with leading edge corporate training methods and practices. The strength of this team is its ability to adapt training to the particular requirements of the markets our clients serve and the specific needs of their personnel.

Unique Things about us:
pert advice we ll help you find the right course to meet your career goals
Simplified enrolment we ll help you get started quickly and easily
Real-time Examples
Technology Infrastructure
Customized Courses
Experienced Faculty / Trainers
Regular Tracking of Classes
Project Support

Oracle RAC Configuration

Introduction to RAC

The Dynamic Business Environment
The Explosive Growth of Business Data
Online and Real-Time Access to Corporate Data
Data Warehousing, Packaged Applications, E-Commerce Operations
Dependence on Database Management Systems
High Performance Systems
Introduction to Cluster Technology
Benefits of Real Application Clusters (RAC)
What is a DB Cluster?
Architectures of DB Clusters
What is a Cluster Interconnect?
Problems with Other Architectures
The IBM Shared-Nothing Configuration
Microsoft Federated Servers Database
Seeing the High Availability Spectrum
Real Application Clusters
Processing Prior to Cache Fusion
Oracle Real Application Clusters
Attributes of an Oracle RAC Cluster
Building an Oracle RAC Cluster
RAC Performance and Scalability

High Performance and Highly Available Databases
High Performance

Growth of Powerful Processors
Why Parallel Processing?
Opportunities for Parallelism
Scalability
Parallel Databases
Types of Parallelism
High Performance Computing Cluster HPCC
Clusterize Applications
How Do You Clusterize Applications?
Highly Available Databases
Need for Highly Available Data
Failure
Availability
Reliability and Serviceability
Fault-tolerant Systems
Database Availability
Clustered Systems
Databases Issues
Oracle RAC High Performance and Highly Available Database

Database Clusters

Overview of the Cluster Technology
How Clusters Differ from Distributed Systems
Clusters are Different from Fault-tolerant Systems
Database Clusters
Why Clusters?
Types of Clusters
Failover Clusters
Scalable High Performance Clusters
Application Server Clusters
Other Types of Clusters
Components of a Cluster
Cluster Nodes
Emerging Server Cluster Architectures
Cluster Interconnect
Essentials for Parallel Database Clusters
Cluster Interconnect Products
Infiniband Interconnect
ClusterWare
Concurrent Database Access
Failover Database Clusters
Resources, Resource Type
Resource Groups
The Concept of a Virtual Server
Failover Process
Examples
Failover Cluster Architecture
Oracle Database Service in HA Cluster
Issues with FO Clusters Hidden Risks
Parallel Database Clusters
Shared-Nothing Model
Shared-Disk Model
Microsoft SQL Server Federated Database
IBM Offerings
Requirements for Parallel Clusters
Oracles Instance Membership Recovery
Cache Coherency and Lock Management

Real Application Cluster Architecture

Overview of Oracle Real Application Clusters
RMAN for RAC
RAC Workload Management
RAC Scalability
High Availability
Architecture
Oracle10g Basic Processes
Oracle10g Basic Internal Structures
Oracle10g RAC Additional Processes
Oracle10g RAC Additional SGA Areas
RAC Server Components
GCS Resource Modes and Roles
Accessing RAC

RAC Server and Disk Technology
Overview

Oracle10g 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
Host Bus Adapter (HBA)
Storage Redundancy Components
Multiple RAID Controllers and Storage Processors
Power Management
High Availablity with SAN
RAID and RAID Administration
Multiple Access Paths to Host
Logical Volume Manager
Cluster File System
Oracle10g RAC and CFS
Context Dependent Symbolic Link CDSL
Veritas CFS
PolyServe Matrix Server (MxS)
HP Tru64 CFS
Oracle Cluster File System (OCFS)
Other CFS Solutions
Oracle Managed Files
Oracle Disk Manager
Server Redundancy
Necessity of Server Redundancy
Redundancy Features

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
Sun Solaris
Hardware / System Details
Creating the Cluster Using Sun Cluster 3.0
Install the Volume Manager
Install the Clusterware (OSD) for RAC
Configure Shared Storage
Veritas Cluster Volume Management
UNIX Pre-Installation Steps
Using Veritas DBE / Advanced Cluster
Communication Stack
Shared Storage Configuration
VCS Framework and Service Groups
Veritas I/O Fencing and SCSI 3 Persistency
Install DBE / AC and Configure Service Groups First Stage
Install DBE / AC and Configure Service Groups Second Stage
Using HP Tru64 UNIX
Hardware / System Details
Set up Disks
Creating Installation and Database Creation
Using HP UX Clusters
Hardware / System Details
Creating the Cluster
Shared Storage Configuration
Configure HP ServiceGuard Cluster
UNIX Pre-Installation Tasks
Using IBM AIX
Hardware / System Details
What is VSD|?
Configure using HACMP / ES
General Parallel File System GPFS
Oracle Installation
Using Windows Cluster
Hardware / System Details
Creating the Cluster
Configure Shared Storage
Using Linux
Hardware / System Details
Interconnect & Cluster Software
Shared Storage Volumes
Oracle Cluster File System (OCFS)
PolyServe Matrix Server
Oracle Installation and Creation of Database
Oracle Software Installation
Database Creation using DBCA
Database Creation Manually

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

SGA Components and Locking
SGA System Global Area
Program Global Area (PGA)
Buffer Cache Management
What is a Dirty Block?
Multi Version Consistency Model
RAC Components
Global Cache Service
Global Enqueque Service
Row-Level Locks
Global Resource Directory
RAC Processes
Resource Coordination
Synchronization
GCS Resource Modes and Roles
Concept of Past Image
Lock Modes
Block Access Modes and Buffer States
Cache Fusion Scenarios
Block transfers using Cache Fusion Examples
Block Access, Grants, and Interrupts
Cache Fusion and Recovery
Recovery Features
Recovery Methodology and Steps
Recovery Process Re-mastering Resources


RAC Administration

Parameter Management
Overview
RAC and Initialization Parameters
UNDO Management
UNDO Management in RAC
UNDO Tablespace Features
System Rollback Segment
Concept of Thread
Thread Features
Redo Thread Maintenance
Segment Space Management
Automatic Segment Space Management
Manual Space Management
Oracle Managed Files
Oracle Disk Manager
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

RAC Backup and Recovery

Overview of RAC backup and Recovery
Export
Cold Backup using Scripts
Hot Backups using Scripts
RMAN (Recovery Manager)
Third Party Solutions
Backup of RAC Database
Using RMAN for Backups
Backup Procedures RMAN and RAC
Recovery in the RAC Environment
Media Recovery in RAC Instances
Using RMAN to Recover a RAC Environment
Recovery in an OCFS Environment
Recovery in a Raw File System Environment
Parallel Recovery
Standby Databases in RAC Configuration
Setting up a Standby Database for a RAC Cluster to a Single-Instance (One Node)
Configuration when the Standby Database is a Single Node System
Cross-Instance Archival
Archive Log Gap Resolution and FAL

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
Using Instance Role for Configuring the Primary and Secondary Instance
Connection to Instance Role Type
Establishing a Connection to a Specific Instance
Using BACKUP with TSF Pre-Establishing a Connection
Using OCI Driver

RAC Performance Monitoring and Tuning

Analysis of Performance Issues
Monitoring RAC Cluster Interconnect Performance
Use of the cache_transfer Views
Monitoring the GES Processes
Monitoring and Tuning using OEM
Configuring the Oracle Intelligent Agent with RAC
Step-by-Step Setup of the Intelligent Agents on UNIX
Monitoring RAC using OEM

RAC Parallel Execution

Overview
Types of Parallelism
Parallelism in Oracle Relational Database
Parallel Execution Mechanism
Granules for Parallelism
Parallel Execution Servers
Degree of Parallelism ‚œ DOP
Parallel Query: SELECT
Parallel DML Update, Merge, Delete
Parallel DML Insert‚Select
Parallel DDL Statements
Rules for Paralleling Create Table as Select (CTAS)
SQL*LOADER Parallel Load
Other Parallel Operations
Initialization Parameters at a Glance
Monitoring and Diagnosing the Parallel Execution

RAC Design Consideration

Designing Equipment for Real Application Clusters
What are the Effects of Component Failure?
Provide Redundancy at Each Level
Designing for High Performance
Compartmenting Transactions to Specific Nodes
Creating Efficient RAC Data Objects
Proper Sequence Usage
Tablespace Design in Real Application Clusters
Extent Management and Locally Managed Tablespaces
Minimizing Table Locks to Optimize Performance
Performance for Object Creation in Real Application Clusters

RAC Application Deployment

Overview
Database Consolidation
E-business Applications
RAC Suitability
Advantages of the RAC Database
Scalability
Unpredictable Loads
High Availability
Application Deployment Issues
OLTP Applications using exclusive or Specific Data
RAC Suitability for Packaged Applications
SAP and Real Application Clusters
Siebel and RAC
Oracle eBusiness Suite
Middleware Software
JDBC Connectivity
WebLogic and RAC Database

Migration to RAC Databases

Overview
Migration Methodology
Moving a Single Instance to RAC
Upgrading Oracle 8.1.7 to 9.2.0.2
Moving HA Cluster to a RAC Cluster
Packaged Applications
In Case of SAP Applications
In Case of Oracle eBusiness Suite

Using RAC Cluster Guard

Examining the Basics of Cluster Guard Technology
Oracle Real Application Clusters Guard Packs
The RAC Guard PFSCTL Control Utility
The Real Application Clusters Guard Monitors
Oracle Real Application Clusters Guard Configuration Templates
PFSSETUP Utility
Concepts of Oracle Real Application Clusters Guard
Primary and Secondary Instance Roles
Preferred Primary and Secondary Nodes
Definition of the Home and Foreign Nodes
Architecture of Oracle Real Application Clusters Guard
Oracle Real Application Clusters Guard Packs
Resources
Using the RAC Cluster Guard Command Line Utility
Recovering from an Unplanned Outage on One Node
Recovering from Unplanned Outages on Both Nodes
Configuring the Call-Home Feature
Enhancing Application Failover with Role Change Notification
ORATAB File Entries for Oracle RAC Guard
Using dbms_libcache to Warm the Secondary Cache
Overview of Warming the Library Cache
Set Up of DBMS_LIBCACHE
Use of the dbms_libcache Package
Managing the Oracle Real Application Clusters Guard Log Files
What if a Failover Occurs While Datafiles are in Backup Model