Provisioning Of Rac Database On Configured Stack - Oow 2009 - Session S309102

Rob Zoeteweij Zoeteweij Consulting

 Is

pretty technical  Contains quite some slides  Shows you: • Why and how?  Starts

right now

Copyright 2009 - Zoeteweij Consulting

12-10-2009

2

 Introduction

• Speaker • Provisioning and Automated Patching Pack  Use

Case  “Out of Box” Procedures  Customizing Q & A

Copyright 2009 - Zoeteweij Consulting

12-10-2009

3

Copyright 2009 - Zoeteweij Consulting

12-10-2009

4



Working with Oracle Technology since 1985 • Oracle 3/ Oracle11g • DBA, Developer (Designer, Forms, Reports, PL/SQL,

Portal) • Last 6 years

 Oracle Consulting Services (Netherlands)  Oracle10g RAC / ASM  OEM GRID Control

 As independent  Rabobank Netherlands – Implementation of OEM GRID Control 10.2.0.5 (Monitoring, Configuration Management, Provisioning)  Shell – OEM GRID Control  Currently ING Bank – Amsterdam – Implementing OEM GRID Control

 OEM GRID Control Trainer Copyright 2009 - Zoeteweij Consulting

12-10-2009

5

Copyright 2009 - Zoeteweij Consulting

12-10-2009

6

Use Case is based on experiences at Rabobank - Netherlands

Copyright 2009 - Zoeteweij Consulting

12-10-2009

7

 Let’s

say we have a configured Stack  Cluster • n Nodes • CRS Software installed and configured on all

Nodes • ASM Software installed on all Nodes • ASM Instance created on all Nodes • DB Software installed on all Nodes

Copyright 2009 - Zoeteweij Consulting

12-10-2009

8

Copyright 2009 - Zoeteweij Consulting

12-10-2009

9

 Next, we

want to create a Database  Requirements • RAC Database • ASM Managed Storage •

• • •

 Enter Disk Group to be used at runtime Use TCP/IP Port 39000 (instead of 1521) – One Listener per Server Create default RAC Services Apply CPU Register with OID  Database, Instances, Services Copyright 2009 - Zoeteweij Consulting

12-10-2009

10

 Requirements

(continued…)

• Create Target in OEM • Include Target in several Groups (for • • • •

monitoring) Assign access privileges via Role to Administrators Apply Monitoring Templates (< 10.2.0.5) Configure the Tape Management System Perform 1st Backup Copyright 2009 - Zoeteweij Consulting

12-10-2009

11

 Out

of Box Procedures to create Database

• Oracle Database Provisioning  Single Instance Database • Oracle Clusterware – RAC Provisioning for Unix  Starter Database  Created starter database was to “basic” for the project’s requirements

Copyright 2009 - Zoeteweij Consulting

12-10-2009

12

 As

the created “Starter” database did not meet the project’s requirements 100%, we needed to start customizing the “Out of the Box Procedure”  Oracle Clusterware – RAC Provisioning for Unix

Copyright 2009 - Zoeteweij Consulting

12-10-2009

13

Copyright 2009 - Zoeteweij Consulting

12-10-2009

14

 2 Types

of Procedures (Database Deployment) 1. RAC Provisioning Procedures 2. Patch Procedures  RAC Provisioning Procedures • Not possible to modify (in the current release)  Patch Procedures • Not possible to modify (in the current release), except for one….  Patch Oracle Database Copyright 2009 - Zoeteweij Consulting

12-10-2009

15

 As

in the current Release Procedure “Patch Oracle Database” gives us most flexibility, we used it as the Base for the Custom Procedure…

Copyright 2009 - Zoeteweij Consulting

12-10-2009

16

Software Library

Copyright 2009 - Zoeteweij Consulting

12-10-2009

17

 Custom

Procedure focus

• Components  Files, Baselines, Golden Images  (Ingredients) • Directives  Logic  Scripts (Shell, Perl)  What to do with…  (Recipes)

Copyright 2009 - Zoeteweij Consulting

12-10-2009

18

 Create

custom Procedure: Create RAC Database  Based on “Patch Oracle Database” • Type 2, so customizable GUI  Create

like…  Need one Directive • Related to Script that will create the Database

Copyright 2009 - Zoeteweij Consulting

12-10-2009

19

 Need

one Directive

• From scratch or,  Based on existing Script  runDatabaseConfigTools.pl (Out of Box)

Copyright 2009 - Zoeteweij Consulting

12-10-2009

20

Copyright 2009 - Zoeteweij Consulting

12-10-2009

21

Copyright 2009 - Zoeteweij Consulting

12-10-2009

22

Copyright 2009 - Zoeteweij Consulting

12-10-2009

23

Copyright 2009 - Zoeteweij Consulting

12-10-2009

24

Copyright 2009 - Zoeteweij Consulting

12-10-2009

25

 Upload

the custom Perl Script to the Directive

Copyright 2009 - Zoeteweij Consulting

12-10-2009

26

Copyright 2009 - Zoeteweij Consulting

12-10-2009

27

Copyright 2009 - Zoeteweij Consulting

12-10-2009

28

 Activate

the Directive

Copyright 2009 - Zoeteweij Consulting

12-10-2009

29

 Next

we need to create the custom Procedure • Based on “Patch Oracle Database” • Include a Step that will call the created custom

Directive

Copyright 2009 - Zoeteweij Consulting

12-10-2009

30

Copyright 2009 - Zoeteweij Consulting

12-10-2009

31

 Create

like…

Copyright 2009 - Zoeteweij Consulting

12-10-2009

32

 Delete

all steps…

Copyright 2009 - Zoeteweij Consulting

12-10-2009

33

 Insert

new Step…

Copyright 2009 - Zoeteweij Consulting

12-10-2009

34

Copyright 2009 - Zoeteweij Consulting

12-10-2009

35

 hostForCustomSteps

Copyright 2009 - Zoeteweij Consulting

12-10-2009

36

Copyright 2009 - Zoeteweij Consulting

12-10-2009

37

 Insert

new Step…

Copyright 2009 - Zoeteweij Consulting

12-10-2009

38

Copyright 2009 - Zoeteweij Consulting

12-10-2009

39

Copyright 2009 - Zoeteweij Consulting

12-10-2009

40

Copyright 2009 - Zoeteweij Consulting

12-10-2009

41

DB_HOME_LOCATION

– RAC Database Oracle Home Location – Enter RAC Database Oracle Home Location – Ask User at Run Time DB_ORACLE_HOME_NAME – Set Value PUB_NODELIST_ALIAS_VALUE – Node List – Enter comma seperated Node List – Ask User at Run Time AGENT_HOME – Set Value - %emd_root% DB_TYPE – Set Value – RAC IS_ASM_SELECTED – Set Value – true DB_SID – Database Name – Enter Database Name – Ask User at Run Time ASM_DISK_STRING – Set Value ASM_DISK_LIST – Set Value ASM_RED – Set Value CLUSTER_ENABLED – Set Value ORACLE_BASE_FOR_DB – Set Value - /u01/app/oracle CRS_ORACLE_HOME_LOC – Set Value - /U01/app/crs ORACLE_BASE – Set Value - /u01/app/oracle TEMPLATE_FILE – DBCA Template File – Enter DBCA Template File – Ask User at Run Time ADD_PARAMS – Set Value IS_RECOVERY_FILE_SYSTEM – Set Value REPONSE_FILE_LOC – Set Value RECOVERY_AREA_LOC – Set Value ENABLE_BACKUP – Set Value BACKUP_USERNAME – Set Value NOTMAL_PASSWORDS – Set Value – true DG_NAME – Disk Group Name – Enter Disk Group Name – Ask User at Run Time DBA_ROLE – DBA Role – Enter DBA Role – Ask User at Run Time DB_UNIQUE_NAME – Database Unique Name - Enter Database Unique Name – Ask User at Run Time ORCL_ADM_USER - Set Value - ORCLADMIN OID_HOST - Set Value –

Copyright 2009 - Zoeteweij Consulting

12-10-2009

42

Copyright 2009 - Zoeteweij Consulting

12-10-2009

43

Copyright 2009 - Zoeteweij Consulting

12-10-2009

44

Copyright 2009 - Zoeteweij Consulting

12-10-2009

45

 That’s

all there is…  Created a customized Deployment Procedure • Based on existing (Out of Box)

• Created custom Perl Script (taking care of

Business) • Created custom Directive • Created custom Procedure  Next, we

can execute the Procedure Copyright 2009 - Zoeteweij Consulting

12-10-2009

46

Copyright 2009 - Zoeteweij Consulting

12-10-2009

47

Copyright 2009 - Zoeteweij Consulting

12-10-2009

48

Copyright 2009 - Zoeteweij Consulting

12-10-2009

49

Copyright 2009 - Zoeteweij Consulting

12-10-2009

50

Copyright 2009 - Zoeteweij Consulting

12-10-2009

51

Copyright 2009 - Zoeteweij Consulting

12-10-2009

52

Copyright 2009 - Zoeteweij Consulting

12-10-2009

53

Copyright 2009 - Zoeteweij Consulting

12-10-2009

54

Copyright 2009 - Zoeteweij Consulting

12-10-2009

55

Copyright 2009 - Zoeteweij Consulting

12-10-2009

56

Copyright 2009 - Zoeteweij Consulting

12-10-2009

57

 Out

of the Box Procedures

• YES, they do work • They do allow you to use DBCA Template Files  Allows you to control the process • You might however have some reasons to

customize:  To meet Organization's Requirements  Disk Groups, Security, Identity Management, Monitoring Templates, etc.

 Fully automate tasks Copyright 2009 - Zoeteweij Consulting

12-10-2009

58

 Start

using 10.2.0.5

• Contains many fixes in the Provisioning area • Several new Deployment Procedures • Default Monitoring Templates

• And many other New Features…  Start

• Figure out your Requirements • Working with Out of Box Procedures • Training • And… Copyright 2009 - Zoeteweij Consulting

12-10-2009

59

 Gaining

enormous benefit, while using the “Provisioning and Automated Patching” Management Pack…

Copyright 2009 - Zoeteweij Consulting

12-10-2009

60

 During

the Rabobank Project

• Instead of a 2 week Procedure to install and

configure the OS, configure and install the Oracle Software and (manually) create ASM Instances and finally creating the RAC Database and manually configure it, perform several manually tasks within OEM, with high risk of Human Errors…

Copyright 2009 - Zoeteweij Consulting

12-10-2009

61

 During

the Rabobank Project (cont)

• Setup of a multi Node Cluster, installation of OS

+ OMA (Bare Metal Provisioning) installation of CRS, ASM, DB + setup of ASM Instances on each of the Cluster Nodes, full RAC Database creation and configuration, full configuration of the new Targets within OEM, ending up with full Company Standards compliance in just 4 Hours….

Copyright 2009 - Zoeteweij Consulting

12-10-2009

62

 OTN

• http://www.oracle.com/technology/products/oem/

mgmt_solutions/provisioning.html  Linkedin.com

• Group OEM GRID Control  http://www.linkedin.com/groups?gid=1776007&trk=hb_ side_g  Mailto: [email protected]

Copyright 2009 - Zoeteweij Consulting

12-10-2009

63

 During

the Rabobank Project we gave our input to an independent study conducted by Forrester Consulting

Copyright 2009 - Zoeteweij Consulting

12-10-2009

64

 Oracle

Enterprise Manager Delivers 124% ROI

 An

independent multi-customer study conducted by Forrester Consulting reveals customers gain significant benefits and cost savings from Oracle Enterprise Manager Configuration Management Pack and Oracle Enterprise Manager Provisioning and Patch Automation Pack. Copyright 2009 - Zoeteweij Consulting

12-10-2009

65

 The

sample organization in Forrester Consulting's study was shown to achieve the following benefits (all figures are risk-adjusted, over three years): * Positive 124% ($4,916,781) return on investment (ROI) * 20% ($862,500) reduction in capital spending on servers * Business productivity savings of $2,555,556 from a reduction in system downtime avoidance and a corresponding increase in availability. Copyright 2009 - Zoeteweij Consulting

12-10-2009

66

http://www.oracle.com/corporat

e/analyst/reports/infrastructure/ em/forrester-tei-em-configprovision.pdf

Copyright 2009 - Zoeteweij Consulting

12-10-2009

67

Enjoy

your stay here in San Francisco Enjoy your OOW 2009

Copyright 2009 - Zoeteweij Consulting

12-10-2009

68

Q&A

Copyright 2009 - Zoeteweij Consulting

12-10-2009

69