Provisioning Of Rac Database On Configured Stack - Sig

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