provisioning of crs / asm / rac with oracle enterprise …...many oracle dba, oracle development...

Rob ZoeteweijCopyright – 2009 Zoeteweij Consulting

Rob Zoeteweij◦ Working with Oracle technology since 1985

(Oracle 3)◦ Many Oracle DBA, Oracle Development projects◦ Last 6 Years Oracle Expert Services

RAC/ASM

OEM Grid Control

Independent Consultant Primary Focus

OEM Grid Control / RAC/ASM /HA

Rabobank, Shell

ING Bank

Copyright 2009 (c) - Zoeteweij Consulting 2

Concepts

Framework

Out of the Box

Customize

Wrap Up

Q & A

17-11-2009Copyright 2009 - Zoeteweij Consulting 3

Concepts

Framework

Out of the Box

Customize

Wrap Up

Q & A


OEM 10.2.0.5 is the way to go◦ Many fixes

◦ Stable release

If using older release◦ Check Metalink for (many) fixes


Task automation◦ Reduction of complexity

Usage of simple Wizards

◦ Reduction of costs

Use highly skilled DBA’s for more complex tasks

◦ Time to Market

Configure Clusters, Servers in matters of hours instead of days

◦ Standardization

Standardized Components (SWL), Baselines etc.

Standardized Procedures


Software Library◦ Provisioning Backbone

◦ Partially in Repository

MGMT_PAF…

MGMT_SWLIB…


Software Library◦ Partially on OMS file system

At configuration time

SWL configuration that is...

If multiple OMS’s are used

SWL needs to be located on a shared file system


Components◦ Files◦ Golden Images Oracle Clones, CRS, ASM, DB

◦ Baselines◦ (Ingredients)

Directives◦ Logic Scripts: Perl - shell

◦ What to do with … (Component)◦ (Recipes)


Networks◦ Network definitions - BMP

Images◦ Bundle of Components, Directives◦ Used for BMP

Suites◦ Collection of heterogeneous components,

grouped together◦ Example: Oracle Collaboration Suite (database,

application server, Web server, and an Identity server )


Suite Instances◦ Group of Hardware Servers that will run each of

these components (Suites)

Assignments◦ Provisioning of an Image or a Suite of Images on a

Server

Hardware◦ Hardware specification


Cluster◦ Specification of Hardware Servers in a Cluster◦ BMP

Administration◦ Configuration of Software Library


Concepts

Framework

Out of the Box

Customize

Wrap Up

Q & A


Deployment Procedures◦ Constructed out of Components

Directives

◦ Procedure Steps◦ Error logic What to do in case of error…

Stop on Error

Continue on Error

Skip Target


Deployment Procedures◦ Type 1

RAC Provisioning Procedures

Static GUI (Current release)

◦ Type 2

Database Patching Procedure

Customizable GUI

Ideal for customization


Concepts

Framework

Out of the Box

Customize

Wrap Up

Q & A


Several Oracle delivered Procedures◦ Database provisioning

◦ Application Server provisioning

◦ RAC Provisioning

◦ Patching

◦ And others...


All together◦ AS Provisioning – 4

◦ RAC Provisioning – 4

◦ Patching Solaris Hosts – 1

◦ Patching Windows Hosts – 1

◦ Patching Linux Hosts -1

◦ Patch Pre-Requisites – 4

◦ BPEL Process Provisioning – 1

◦ Linux Staging Server – Setup – 1

◦ Database Provisioning – 2


◦ Forms and Reports Provisioning – 1

◦ Coherence Node Provisioning – 1

◦ Patch Oracle Software – 6

◦ Virtualization Provisioning – 11

◦ Oracle Service Bus Resource Provisioning – 1


Concepts

Framework

Out of the Box

Customize

Wrap Up

Q & A


Use Case◦ Setup Cluster (Let’s pretend we have...)

Installed OS

Configure based on Best Practice / Pre-Requisites

Installed Agent

◦ Setup Oracle Software

Installed CRS Software + Configuration

Installed ASM Software + Creation of ASM Instance

Installed DB Software


◦ ... and this what we want to do (Requirements)

◦ Create RAC Database

Nodes to create Instance on based on user input

Apply CPU

Apply Company specific settings

Register in OEM

Create some default RAC Services

Register in OID (Oracle Internet Directory)

Assign privilege to Administrators via Role in OEM

Apply Monitoring Template (< 10.2.0.5)

Setup TMS (Tape Management System)

Perform 1st Backup


Use Case◦ Run “Out of Box” Procedure

Oracle Clusterware / RAC Provisioning

Used to do the CRS / ASM / DB Software part

◦ Characteristics Starter (RAC) Database – 1 Instance in each node

Listener Port 1521 (Want Port 39000)

Uses Disk group DATA (Want this to be variable)

Missing requirements previously mentioned


Use Case◦ Solution:

Customize “Out of Box” ProcedureOracle Clusterware / RAC Provisioning

Create custom Procedure to create RAC Database


Create custom Procedure:Create RAC Database

Base on “Patch Oracle Database”◦ Type 2, so customizable GUI

Create like…◦ Unable to modify “Out of Box” procedures

Need one Directive ◦ Related to script that will create the database


Need one Directive◦ From scratch or,

Based on existing script

runDatabaseConfigTools.pl (Out of Box)


Upload the custom Perl script to the Directive


Activate the Directive


Create like…


Delete all steps…


Insert new Step… (Phase)


hostForCustomSteps


Insert new Step…


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 – <oid server>


◦ At the same time:

Latest CPU got applied

Registration in OEM completed

Groups, Services

Some default RAC Services created

Database, Instances, Services registered in OID

Privileges were assigned to Administrators

Monitoring Template were applied (< 10.2.0.5)

TMS Setup completed (Tape Management System)

1st Backup has been run


Concepts

Framework

Out of the Box

Customize

Wrap Up

Q & A


Start with OEM 10.2.05

Get training◦ OEM Provisioning

◦ Perl

Start with “Out of Box” Procedure◦ Testing

◦ Just start using them

◦ Get familiar with Framework, Software Library, Components, Directives


Questions: [email protected]

OTN http://otn.oracle.com

Linkedin Group: http://www.linkedin.com/groups?gid=1776007&trk=hb_side_g

Blog: http://oemgc.wordpress.com◦ Will contain this Presentation

◦ … and several others on OEM


mailto:[email protected]

http://otn.oracle.com/

http://www.linkedin.com/groups?gid=1776007&trk=hb_side_g

http://www.linkedin.com/groups?gid=1776007&trk=hb_side_g

http://oemgc.wordpress.com/

December 10th – 2009 - Berlin◦ Special Interest Group meeting

◦ Enterprise Manager

◦ Theme "Oracle Enterprise Manager, Security, High Availability".

◦ http://www.doag.org/sig/


http://www.doag.org/sig/

provisioning of crs / asm / rac with oracle enterprise …...many oracle dba, oracle development...

Documents