Provisioning Of Rac Database On Configured Stack - Sig

  • Uploaded by: Rob Zoeteweij
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Provisioning Of Rac Database On Configured Stack - Sig as PDF for free.

More details

  • Words: 658
  • Pages: 41
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

Related Documents


More Documents from ""