Putting America Back to Work, through advance industry specific education, providing the tools necessary to hold the knowledge force in America, is our mission.
OverView
• RAC on Linux Overview
• Identify components requiring configuration
• Identify the proper Oracle revision to use
• Identify supported Linux vendors and revisions
Application Tiers
• Preparing the Operating System
• Implement dynamic shared memory
• Install Oracle Cluster File System
Introduction To Modules
• Oracle Cluster Management System
• Prepare Linux for Oracle Cluster Management System (OCMS)
• Install OCMS using the Oracle Universal Installer
• Configure and start the cluster
AD Utilities
• Installing Oracle on Linux
• Install Oracle using Oracle Universal Installer
• Configure RAC options
File System
• Build the RAC database
• Identify database requirements
• Identify the raw partitions to be used
• Create the database using Database Configuration Assistant (DBCA)
• Add second instance
Data Model
• Managing RAC on Linux
• Effectively use the cluster database server manager
• Manage the SPFILE
• Modify the Linux environment to automatically start and stop the cluster
• Manage tablespaces, segments, and extents
• Monitor cache fusion statistics
• Use Enterprise Manager to monitor the RAC environment
Install Decisions
• Advanced Deployment Topics
• Add additional instances
• Plan and configure raw partitions
• Configure RAC failover
• Use multiple interconnects
• Execute inter-node parallel queries
Unix Sizing for Application
• Architecture
• Cluster architecture: nodes, interconnect, shared disks
• Real Application Clusters architecture
• Shared files
• Global Resource Directory
• Services and background processes
• Global Enqueue Service
• Enqueue Resources
• Global Cache Service
RAID and Oracle Application
• Management and Configuration Tools
• Installation Issues
• Configuration Issues
• Upgrade Issues
• Modifying a single-instance database to support multiple instances
• SRVCTL Commands
• OEM Interface
• Parameter Files and Shared Parameter Files (SPFILE)
• Cache Fusion
Auditing Applications
• High Availability Considerations
• High Availability Features
• Fast Problem Detection and Instance Reconfiguration
• Fast Real Application Clusters Reconfiguration
• Dynamic Resource Remastering
• Dynamic Resource Remastering: Example
• Instance Transition and Recovery Domains
• Global Resource Directory Reconfiguration and Cache Recovery
• Overview of Fusion Resource States
OS Commands for Apps DBA
• Backup and Recovery
• Archiving in a Real Application Clusters Database
• Archive Log File Destinations
• Recovery Manager
• Operating System Backup and Recovery Issues
Locating Apps issues from OS Side
• Monitoring and Tuning
• Collecting Performance Statistics
• Evaluating Performance Statistics
• Dynamic Performance Tables
• Statspack
• OEM
• Tuning Strategy
RAID for Applications
• Plan the migration
• Do the migration from ANY platform to LINUX
• Show demo from SUN to LINUX
VMSTAT details
• Install RED HAT on 2 nodes
• Enable 2 nodes for Firewire
• Explain DAS/NAS/SAN
• Two Node Architecture, Unprotected
• Two Node Architecture, Protected Apps tier and unprotected DB tier
• Two Node Architecture, Protected Apps tier and DB tier
• FAILOVER CLUSTER OFFERINGS
• Rac Architecture
• Failover Rac Architecture
• Real Application Cluster
• RAC Building Blocks
• CLUSTERINTER CONNECT
• INTERCONNECT PRODUCTS
• INTERCONNECT PROTOCOL
• IO CHANNEL HBA Products
• FACRIC SWITCHES
• CLUSTER NODES
• CLUSTER TYPES
• Shared Storage Options
• Decide RAC architecture
• Install oracle provided RPM’s
Connection management
• Online Transaction Processing Considerations
• Tablespace Management
• Dictionary Management and Mapping Extents to Instances
• Local Management and Automatic Extent Management
• Segment Free Space Management
• Free Lists and Free List Groups
• Automatic Segment Free Space Management
Instance Management
• Online Analytical Processing, DSS, and Data Warehousing Considerations
• Temporary Tablespaces
• Intra- and Inter- Instance Parallelism
• Performing Data Extract, Load, and Transformation
Utilities for Apps DBA
• Scalability Considerations
• Speedup and Scaleup
• Automatic Resource Remastering
• Load Balancing |