Provisioning of RAC Database on configured Stack Rob Zoeteweij Copyright 2009 – Zoeteweij Consulting 1
This Presentation… • • • •
Is pretty technical Includes several (many) Screen dumps Covers OEM 10.2.0.4 – 10.2.0.5 Gives you an insight overview of: How to … / How it works • Is about how we do this at Rabobank
2
Agenda • • • • • • •
Previously at Rabobank… Requirements Database in ECO Out of the Box procedures Customize Directive Customize Deployment Procedures In the meantime, think about… Q&A 3
Previously at Rabobank • “Manual” Database creation • • • • • • • •
Run Database creation script Configure TSM – File System Discovery of Database in OEM Assignment to Monitoring Group Assignment of Monitoring Templates Assignment to Role Configure Backup Include in Backup Job
4
Previously at Rabobank • 2 – 3 Hours to complete • High risk of Human Errors • Very hard to force Standards
5
Requirements Database in ECO • On pre-configured Stack • Provisioning of Clusterware – ASM – DB
• 1..n Nodes • Standardized – 1 Preferred – 2 Available
• Specific Disk Group to be used • Development – Test • 1 “Large” Disk Group • Production • Based on Security Category • 1 per Application 6
Requirements Database in ECO • Application of EM Monitoring Templates • Cluster Database • Database Instance
• Assign access Privilege – Role • All necessary Target Privileges are assigned to Role
• Inclusion in Backup Job • By assignment to Group
• Creation of 2 default RAC Services • SRVORA • SRVRMN 7
Requirements Database in ECO • Registration with OID • • • •
Database Unique Name Database Instances RAC Services Listeners were registered in earlier phase
• Registration with OMS • Cluster Database • Database Instances • RAC Services
8
Out of Box Procedures • Oracle Database Provisioning • Single Instance Database • Hard to customize / to modify GUI • (Use EMCLI to execute DP)
• Oracle Clusterware – RAC Provisioning for Unix • • • •
Starter Database Not very efficient Hard to customize / to modify GUI (Use EMCLI to execute DP) 9
Customize Deployment Proc • 2 Types of Procedures (Database Deployment) • RAC Provisioning Procedures • Patch Procedures
• RAC Provisioning Procedures • Impossible to modify GUI
• Patch Procedures • Impossible to modify GUI, except for one…. • Patch Oracle Database 10
Customize Deployment Proc • General Structure • Software Library • Components • Deploy Software Library Component and associated Directive • Directives • Logic • Scripting • Shell • Perl 11
Customize Deployment Proc • Create custom Directive • Upload customized script
• Start with Patch Oracle Database Procedure • Delete all Steps • Create „Rolling‟ type Phase • Creation Database initiated from 1st Node
• Create Step within the Phase • Create RAC Database and Instances
• Map Properties • Run Procedure 12
Customize Directives • Contains • Arguments • Static value • Entered by User at runtime • Script • Containing the actual logic
13
14
15
16
17
18
• Next • Customize the Deployment Procedure
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
In the meantime, think about… • Development / Test Environment • Production Environment • Deployment of Deployment Procedures ;-) •
$ORACLE_HOME/bin/PARDeploy -action export -guid 5B5D0C224D73C29CE04048914E0A3375 -file exportedDP.par -displayName “Rabo - CRS / ASM / DB Provisioning - v1.0" -description "This procedure assists in installing/cloning and configuring a cluster database (a Real Application Cluster - RAC database) on a selection of hosts as specified by the Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide.“
• Perl knowledge
35
36
37
38
39
Wrap Up • Creation of RAC Database and completion of all necessary tasks in 20 Minutes instead of 2-3 Hours • Task automation • Fully standarized • Multiple executions at the same time
40
Q&A
41