ADVANCED DBA

Oracle9i Real Application Clusters

Regular Track - 3 Days
 
ARCHITECTURE

  1. Cluster hardware components

  2. Nodes

  3. Interconnect

  4. Shared disk subsystem

  5. Cluster software

  6. Cluster manager

  7. Inter process communication software

  8. RAC components

  9. Disk Acess

  10. Global service daemon

  11. Background Processes

  12. Global enqueue service monitor

  13. Global engueue service daemon

  14. Global cache service processes

  15. LCK process

  16. Diagnosability Daemon

INSTALLATION & CONVERSION

  1. Objectives

  2. Preliminary cluster preparations

  3. Cluster files or partitions for default database

  4. Global services daemon

  5. Information repository for the database server configuration

  6. Installations options

  7. OUI database configuration types

  8. Addditional installation considerations

  9. Migrate to Oracle9i RAC

  10. Convert a single instace to RAC

  11. Configure hardware

  12. Evaluate Tablespace Requirements

  13. Evaluate logfile Requirements

  14. Create shared file systems or raw devices

  15. Extract data from old database

  16. Installation steps

  17. Create the database

  18. Load data into the new database

  19. Adjust parameters

  20. Start database

  21. Additional migration considerations

MANAGEMENT & CONFIGURATION TOOLS

  1. Objectives

  2. GSD management

  3. Server control utility

  4. SRVCTL command syntax

  5. SRVCTL cluster database configuration tasks

  6. Add & delete databases

  7. Add & delete instances

  8. Move & rename instances

  9. Store & remove environment data

  10. SRVCTL cluster database configuration tasks

  11. Starting databases & instances

  12. Stopping databases & instances

  13. Inspect status of cluster database

  14. Inspect database configuration information

  15. Enterprise manager & cluster databases

  16. Displaying objects in navigator pane

  17. Starting a database cluster

  18. Stopping a database cluster

  19. Status details tab

  20. Viewing cluster database status

  21. Job management for a cluster database or instance

  22. Registering cluster database events

  23. Parameter files in cluster databses

  24. Create & manage server parameter parameter file

  25. Parameter file search order

SCALABILITY & CACHE FUSION

  1. Objectives

  2. Levels of scalability

  3. Scaleup & speedup

  4. Speedup & scaleup for different types of workloads

  5. Load balancing with oracle net services

  6. Client load balancing

  7. Connection load balancing

  8. Service & instance names

  9. Adaptive parallel query

  10. Cache fusion

  11. Cache fusion model

  12. Global cache service resource modes

  13. Global cache service resource roles

  14. Cache fusion block transfers:Example overview

  15. Example 1 : Read with no transfer

  16. Example 2 : Read to write transfer

  17. Example 3 : Write to write transfer

  18. Example 4 : Write to read transfer

  19. Block transfers in real application clusters

  20. Configuring multiblock locks

  21. Notes on using multiblock locks
 
   
     
   
   
 
     
 
Training Portfolio
 
 
Courses
Course material designed by experts
Tutorial
Certification Guidance
 
 
—————————————————
 
 
Course Schedule - July-Sept 2008
 
 
July 2008 Bangalore Region
Mumbai Region
August 2008 Bangalore Region
Mumbai Region
September 2008 Bangalore Region
Mumbai Region
 
     
 
 
     
© 2004, qsoftindia.com, All Rights Reserved
`