Oracle RAC 10g: Manage Your Cluster Without It Managing You

1
Oracle RAC 10g Manage Your Cluster Without It
Managing You
Session id 40132

• Michael Salinas
• Senior Product Manager
• Oracle Corporation

2
Agenda

• Todays Realities
• Whats new
• Flexible Computing
• Benefits

3
Today
4
Today Business and IT

• The Good
• IT is seen as on the critical path to business
  success
• The Bad
• DBAs and System administrators face increasingly
  complex environments

5
Today Business and IT

• The Ugly
• Administrators are extremely over utilized
• Systems are under utilized
• My storage is 30 utilized and growing by 50 a
  year
• 15 utilization of CPU is normal

6
Business Challenges

• Managing the environment
• Meeting the workload
• Doing it efficiently with existing resources

7
Oracle9i Real Application Clusters

• Changed the game for the database
• Scale Up and Scale Out
• Highly Available
• Off the shelf applications
• Only clustered database that runs real
  applications and scales both DSS and OLTP
• Proven
• Hundreds of production customers
• Certified by leading applications vendors
• SAP, Oracle, PeopleSoft

8
Oracle Database 10g
9
Real Application Clusters 10g

• Raises the bar
• Extends Availability and Flexibility to your
  applications
• Manage your environment, not each piece
• Automate Management

10
Simplify
11
Current Cluster Stack

• Life today is complicated and costly
• Many vendors are slapped together for Clustering
  
• Management is complicated
• Uneven quality functionality
• Mostly fail over
• Costly
• Complicated support picture

12
Real Application Clusters 10g Complete,
Integrated Clusterware

• Complete Oracle cluster software solution
• Single-vendor support
• Extends clusterware from Oracle and HP
• Low Cost
• No need to purchase additional software
• Easy to install manage
• High quality and functionality across all
  platforms
• Common event and management support
• Multi-tier HA minimal MTTR
• Support for third-party clusterware

13
Manage
14
Where do DBAs spend their time?
Installation 6
Others 15
Creation Configuration 12
Software Maintenance 6
DataLoading 6
Ongoing System Management 55
Source IOUG 2001 DBA Survey
15
RAC 10g Scalable Installation and Upgrade

• Fast, Lightweight Install
• One install
• Smaller size
• Automatic Pre Post Install Validations
• Configures all administration tools components
• Silent mode for Embedded ISVs
• Pre upgrade checks
• Post upgrade status checks

16
RAC 10g Scalable Creation and Configuration

• 90 fewer initialization parameters to set
• Out-of-box database management with Enterprise
  Manager DB Control
• Automatic setup of common tasks, e.g. backups,
  optimizer statistics
• Best practice configuration recommendations
• Parameter Usage
• Space
• New features

17
RAC 10g Management

• Single software stack allows simplified
  management
• Designed to address largest time hits for DBAs
• Choice of management model
• Centralized Management Enterprise Manager Grid
  Control
• Database Management Enterprise Manager DB
  Control
• Improved tools are integrated to simplify
  management
• Performance Availability
• Ongoing management (55 of DBA time)

18
Enterprise Manager Cluster Home Page
19
Enterprise Manager Cluster HW Performance

• Cluster view
• Shows hardware utilization
• CPU
• Memory
• Disk

20
Enterprise Manager Database Home Page
21
Enterprise Manager Database Performance Page

• Database view
• Drill down for instance info
• Shows
• Service wait times
• Throughput
• Alerts
• Host run queue/paging

22
Automate
23
RAC 10g Management

• Self-Managing, Self-Tuning, Self-Learning
  Database
• EM provides Environment-wide operations
• Scale to 100s of databases or nodes

24
Built-In Intelligent Infrastructure

• Automatic Workload Repository
• Automatically collects statistics, SQL workload,
  Feature usage
• Base-lining capability
• Automatic Maintenance Tasks
• Pre-packaged, resource controlled

25
RAC 10g Services

• Policy based behavior
• Performance
• Availablility
• Uses Automatic Workload Repository Statistics
• Created and managed with existing tools

26
Automatic SGA Management
Instance 1

• Only 2 memory parameters
• Advisor helpsset parameters
• Automatically resizes with changes in workload
• Each instance according to usage

Large Batch Jobs
Large Pool
27
Automatic Storage Management 10g

• New capability from Oracle
• Provides integration of the file system and
  volume manager for simplified management of
  database files
• Spreads database files across all available
  storage for optimal performance
• Enables simple and non-intrusive resource
  allocation with automatic rebalancing
• Virtualizes the storage resources

28
ASM Benefits

• Enables non-disruptive storage deployment
• Eliminates manual performance tuning tasks
• Increases DBA productivity

29
RAC 10g and ASM Synergy

• Simplified Cluster Environment
• Easier Management
• Higher Availability
• Smoother Growth
• Adaptable Resources

30
Flexible
31
Automatic Service Provisioning

• Hands-free allocation and re-allocation of
  servers to workloads (services) based on rules
• Automated routing of service requests to
  appropriate server with lowest load
• On server failure, automated re-allocation of
  surviving servers to services
• Works across all platforms

32
Enterprise Grid - Automatic Service Provisioning
Order Entry
Supply Chain
HR
Financials
Normal Server Allocation
33
Enterprise Grid - Automatic Service Provisioning
Financials
HR
Order Entry
Supply Chain
End of Quarter
34
Enterprise Grid - Automatic Service Provisioning
Order Entry
Supply Chain
HR
Financials
Normal Server Allocation
35
Enterprise Grid - Automatic Service Provisioning
Financials
Order Entry
Supply Chain
HR
Server Fails
36
Enterprise Grid - Automatic Service Provisioning
Financials
Order Entry
Supply Chain
HR
Reallocate HR server to Order Entry
37
Enterprise Grid - Automatic Service Provisioning
Financials
Order Entry
Supply Chain
HR
Order Entry on Two Servers
38
Summary

• Real Application Clusters 10g
• Preserves your investment
• Is simpler to manage
• Is easier to support
• Brings reliability to your applications
• Scales for the most demanding business
  environments
• RAC makes it easier to succeed!

39
Next Steps.

• Recommended sessions
• Tues, 9/9 1600 Oracle RAC 10g Running Mixed
  Workloads - G. Smith (Rm 104)
• Wed, 9/10 1100 Oracle RAC 10g Application
  Continuous Services for a Grid - B. Kehoe (Rm
  104)
• Wed, 9/10 1300 Oracle RAC 10g Best Practices on
  Linux - K. McGowan (Rm 104)
• Wed, 9/10 1630 Oracle RAC 10g Customer Round
  Table - G. LeMay (Rm 104)
• Visit the DEMOgrounds to see RAC in action
• Visit the RAC web sites for more information
• http//otn.oracle.com/products/database/clustering
  /content.html

40
Reminder please complete the OracleWorld
online session surveyThank you.
41
(No Transcript)