Transcript One Command Install How to Install the Grid in ~30 minutes

1
<Insert Picture Here>
One Command Install
How to Install the Grid in ~30 minutes
Philip Newlan
Consulting Member Technical Staff
RAC Pack
Vitor Pacheco Moreira
Manager DB Services
Amadeus
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into any
contract. It is not a commitment to deliver any
material, code, or functionality, and should not be
relied upon in making purchasing decisions.
The development, release, and timing of any
features or functionality described for Oracle’s
products remains at the sole discretion of Oracle.
3
Agenda
• The Goal
• Install Methods & Challenges
• Rapid install tools
• Customer Perspective
• Benefits
4
The Goal
Silent, repeatable install
• Install
– Validate : Hardware, Configure: Operating System
– Oracle Grid Infrastructure
– Oracle Real Application Clusters
• Grid Infrastructure
–
–
–
–
Clusterware
ASM and Diskgroup(s)
Patching: Patchset, Bundle Patch, One Off
SCAN/VIP listeners
• RAC Home
– Patching: Patchset, Bundle Patch, One Off
• Database(s)
5
Installation Methods
• Oracle Universal Installer (OUI, runInstaller)
– GUI based
– Silent with response file
– Allows for software only (no configuration)
• Cloning (clone.pl)
– Uses OUI in silent mode under the covers
• OEM Provisioning Pack
6
The Challenges
• Ensuring all nodes meet minimum requirements
– OS packages, kernel parameters, etc.
– Users, groups, devices, directories, etc.
• Requirement to run some commands as root OS user
• Silent Install
– Separate Configuration from Build
7
OneCommand
• What is it ?
– A solution to the automated – silent install request
• Where can I use it ?
– Linux
– porting to other Unix platforms
• Solaris
• AIX
• HP-UX
8
OneCommand
Demonstration - Start
9
Sweet spot
• What is the target market for OneCommand
– Customers that need to ‘repeat build’ RAC Clusters
– Have a cookie cutter approach to deployment
– Build more than 1 cluster
• If all you need to build….
– … is 1 cluster
• Then maybe OneCommand is not for you
10
One Command
• Two major phases when building the cluster database
Configure
onecommand.params
Build
11
One Command
Configuration Phase
• Key to correctly building a cluster using
OneCommand
• Create a file with name/value pairs that describes the
cluster
• The key to repeatable builds
12
One Command
Configuration File
#######################
# CLUSTER DETAILS
#######################
CLUSTER_PREFIX=strrac
#######################
# NODE DETAILS
#######################
# An associated array of node names, node ip's etc.
NODE_NAMES=(strrac15 strrac16 )
NODE_IPS=(144.25.246.92 144.25.246.93)
VIP_NAMES=(strrac15-vip strrac16-vip)
VIP_IPS=(144.25.246.115 144.25.246.116)
PRIV_NAMES=(strrac15-priv strrac16-priv)
PRIV_IPS=(10.10.10.15 10.10.10.16)
DNS_SERVERS=(130.35.249.41)
NTP_SERVERS=(152.68.120.1 139.185.249.114 10.204.32.1)
.
.
View demo
13
One Command
Build Phase
• Use OneCommand to read the configuration File
# ./OneComand.sh -i –r 0-13
• Steps 0 – 13
–
–
–
–
0 is Validate Environment
.
.
13 is DbcaDB – Build the RAC Database
14
One Command
Build Phase – Individual Steps
•
•
•
•
•
•
•
•
•
•
•
•
•
•
ValidateEnv
UnzipFiles
WriteNodelists
UpdateEtcHosts
SetupNTP
CreateUsers
SetupStorage
SetupSSHusers
GridSwInstall
GridRootScripts
DbSwInstall
CreateASMDiskgroups
CreateListener
DbcaDB
–
-
Validate configuration file
Unzip Oracle software
Create list of nodes
Update /etc/hosts for node connectivity
Configure NTP correctly
Create required users
Setup udev, and permissions for storage
Setup ssh for required users
Install Grid Infrastructure on all nodes
Run root scripts for Grid Infrastructure
Install database software on all homes and nodes
Create ASM instance
Create ASM Listener
Create all databases based on best practices
15
One Command
Build Phase Methodology
• Uses standard Oracle tools
– OUI, CVU, OPatch
• Becomes root for administrative tasks:
–
–
–
–
–
Create users
Update /etc/hosts
Setup udev
Configure ntpd.conf
Run root.sh for install and configuration
16
One Command
• Build Phase
onecommand.params
Build
grid_infrastructure.zip
rdbms_software_1.zip
rdbms_software_2.zip
17
OneCommand
Tracking Installation status
• Log file for every step is written
– including comprehensive timing
• Each command is logged to a separate file
– Allows detailed examination of the install process
View demo
18
Real-world Examples
Where do we use One Command ?
• General case RAC
– Uses silent Install
• Install and Configuration of Database Machine
– Automatically install/configures RAC on DB Machine
– Uses silent install
• Oracle RAC in Oracle VM templates
– Automatically deploys Grid Infrastructure and Oracle RAC
within VM templates
– Uses cloning technology
19
Database Machine – The Basics
One Command – Used to build every Database Machine
• 8 Compute Nodes
• 14 Storage Nodes [Cells]
• One or more
– Clusters
– Databases
– Diskgroups
• End to End Provisioning for the complete Database
Machine
20
Database Machine
Configuration Phase
• OS/Hardware Setup – First Boot
– IP addresses, dns,ntp,/etc/hosts,users,ssh
– Validation
• Storage Setup
– Cell disks
– Grid disks
• Oracle Software Setup
– Grid Infrastructure
– Database(s)
21
Database Machine
Sample build log overview
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
Step
4576
1
CreateWorkDir
-took
0 minutes
0 seconds
2
setupSSHroot
-took
2.20 minutes
132 seconds
3
etchostupd
-took
3.51 minutes
211 seconds
4
CreateCellipnitora
-took
.15 minutes
9 seconds
5
OraSetup
-took
.30 minutes
18 seconds
6
SetupSSHora
-took
1.06 minutes
64 seconds
7
ValidateCell
-took
.33 minutes
20 seconds
8
CreateGridDisks
-took
3.80 minutes
228 seconds
9
GridSwInstall
-took
9.10 minutes
546 seconds
10 GiRootScripts
-took 11.43 minutes
686 seconds
11 112DBSwInstall
-took
7.30 minutes
438 seconds
12 RunAsmCa
-took
1.86 minutes
112 seconds
13 112CreateListener
-took
.40 minutes
24 seconds
14 DoUnlock
-took
1.36 minutes
82 seconds
15 RelinkRDS
-took
.61 minutes
37 seconds
16 ApplyASMPatches
-took
.46 minutes
28 seconds
17 ApplyRDBMSPatches
-took
0 minutes
0 seconds
18 LockUpGI
-took
2.55 minutes
153 seconds
19 DbcaDB
-took 29.80 minutes 1788 seconds
seconds, 76.26 minutes in total and sum minutes is 76.22 minutes...:)
22
One Command – The Tool
• Results
–
–
–
–
–
–
–
–
Repeatable
Consistent
Complete
Updateable
Uniform
Less errors
Documented
Less human keystrokes
23
Helpful Tools
Use alongside One Command
• Check RAC Technology Matrix on OTN: linux, Unix,
Windows and inside My Oracle Support
• Cluster Verification Utility
• Cluster Health Monitor
• Use oracle-validated rpm to set/install kernel
rpms/parameters (Note: 728346.1)
24
Installation Methods
• Oracle Universal Installer (OUI, runInstaller)
– GUI based
– Silent with response file
– Allows for software only (no configuration)
• Cloning (clone.pl)
– Uses OUI in silent mode under the covers
• OEM Provisioning Pack
25
11.2 Install Improvements
Automatic SSH configuration
26
11.2 Install Improvements
OUI Integrated with CVU
27
11.2 Install Improvements
CVU Fixups
28
11.2 Install Improvements
Save Response File
• Also auto saved to Oracle Home/inventory/response
• For 11gR1 use the –record flag with runInstaller
29
Amadeus
Vitor Pacheco Moreira,
Manager DB Services
September 2010
An essential industry provider for
distribution in 2009
95%
103,000+
of world’s scheduled
network airline seats
40
Over 260
Low Cost Carriers
21%
Online booking
Travel agency locations
Airline websites
145
Hosted airlines
503 million
Bookings processed
85,000+
Hotel properties
150 million
Lines of written
Program code
Operations excellence
 The worlds no 1
processor of travel
transactions
 High Security Facility
 Computer center
concept ensuring
uninterrupted service
 Uninterrupted power
supply
 No single Point of
Failure
 Multiple power and
network connections
Vision Statement
 More than 30 DB Clusters in Production
 About 15 Clusters in Test
 On average we deploy a new cluster per month in Production
 On average we perform a cluster change per week
 What we want to achieve:
 Deployment best practices
 Favoring availability and reliability
 Identify appropriate times for deployment
 Consistent deployment in all platforms
 Automation and minimization of manual processes
 Documentation and automated feed to the CMDB
 Deployment inventory
 Reference to configurations
OneCommand - First impressions
Positives
 Configure first and then deploy is very appealing
 Good fit to the Operational Processes
 Favors revision and reuse
 Silent installer enables automation and time
adaptation
 I.e., configure during working hours, deploy outside of
peak hours
 Platform independent
 Same process in HP-UX and Linux
 Flexible, adaptable
OneCommand - First impressions
Existing constraints
 Limited adaptation to customer standards
 Demands manual changes
 Constrained to the first deployment phase
 Other aspects of the deployment are not covered by the tool
 Different tools needed for patching, reconfigurations,
extensions of the clusters, etc
 Missing a central repository of configurations/deployments
 Comparison between different deployments
 Reutilization and cloning of deployments
 Reverse engineering
What we would like to have
 Repository of deployments/configurations
 Extensions to other areas of deployment
 Adding new nodes to a Cluster
 Changing a cluster configuration
 Process to transform a configuration in an online manner
 Based on a previous deployment
 Fallback included
 Alternative to UI deployment processes
 Ex.: Patch Management provided by OEM
 Rehearse/deploy process
 Rehearse in a Test environment
 Deploy in Production
OneCommand in three bullet points
 Light weight
 Configure and deploy
 Addresses only one part of the deployment
One Command – Going forward…
• Cloned software images – posssibly
– Allows updates to Grid, ASM and RAC
• Latest patches and bundle patches
• Recommended parameters
• Bake in the latest and greatest patchset
• Add / Delete Node
– Attend Next Session in this room
• Install and Configuration become a non-event…
39
OneCommand
Demonstration - Status
40
One Command
Feature Summary
• Automate and control your RAC Install
• Repeatable, Error Free install
• Bake in Best Practices
• Do it RIGHT every time
41
QUESTIONS
ANSWERS
42
Next Session here at OOW 2010
S317077 - Oracle RAC on Oracle VM: Best Practices
Running today’s non-critical business applications in virtualized environments
has proven to be efficient and cost-saving. However, highly available
applications are typically incompatible with commonly used software
virtualization solutions. With the combination of Oracle VM and Oracle Real
Application Clusters (Oracle RAC), Oracle now offers a highly available, gridready virtualization solution for the datacenter. This session reviews
configuration best practices and deployment examples of Oracle RAC in Oracle
VM environments. It introduces templates that automatically create a cluster
with all recommended patches and best practices. The session will interest
architects, DBAs, and system administrators.
43
44
© 2009 Oracle Corporation
45