Oem - Ogh - 9 Juli 2009
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 Oem - Ogh - 9 Juli 2009 as PDF for free.
More details
- Words: 2,333
- Pages: 107
OEM Provisioning An Introduction
Rob Zoeteweij 14-10-2009
1
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
2
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
3
Introduction • • • •
Rob Zoeteweij Working with Oracle since 1985 Oracle DBA (Release 3 .. 11g) Development Designer, Forms, Reports, PL/SQL, Portal…
14-10-2009
Copyright 2009 - Zoeteweij Consulting
4
Introduction • Last 5 years – Oracle Consulting – Expert Services • RAC/ASM – OEM GRID Control
– FreeIT • Rabobank - Shell – OEM GRID Control
– 5 Hart • Trainer OEM GRID Control
14-10-2009
Copyright 2009 - Zoeteweij Consulting
5
Introduction - OEM • Successor of OEM 9i – Java Client
• EM Database Control – Local • EM Application Server Control - Local • OEM GRID Control 10g – Current Release 10.2.0.5 – GUI synchronize • EM DB Control • EM AS Control 14-10-2009
Copyright 2009 - Zoeteweij Consulting
6
Introduction - OEM
14-10-2009
Copyright 2009 - Zoeteweij Consulting
7
OEM – Key Features • • • • •
System Monitoring Groups Job System Information Publishing Compliance Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
8
OEM – Targets • • • • • •
Databases Middleware Hosts & Third Party Oracle Beehive Virtualization Many non Oracle
14-10-2009
Copyright 2009 - Zoeteweij Consulting
9
System Monitoring
14-10-2009
Copyright 2009 - Zoeteweij Consulting
10
Database Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
11
Performance Monitoring
14-10-2009
Copyright 2009 - Zoeteweij Consulting
12
Service Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
13
Service Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
14
Change Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
15
Change Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
16
Middleware Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
17
Host Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
18
Host Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
19
System Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
20
Virtualization Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
21
and… Provisioning
14-10-2009
Copyright 2009 - Zoeteweij Consulting
22
Introduction - Provisioning • In general, provisioning means "providing" or making something available. The term is used in a variety of contexts in IT. For example, in grid computing, to provision is to activate a grid component, such as a server, array, or switch, so that it is available for use... Internet – What is? 14-10-2009
Copyright 2009 - Zoeteweij Consulting
23
Introduction - Provisioning • Management perspective: – Reduction of complexity • Task automation • Every time exact same sequence of actions… • Standardization
– Reduction of costs • DBO • Less training
– Time to market 14-10-2009
Copyright 2009 - Zoeteweij Consulting
24
Introduction - Provisioning – Time to market • Less time needed to have infrastructure available • Have a fully configured database cluster – In hours instead of days / weeks
• Managers just love it … ;-)
– Increase of quality • Availability
14-10-2009
Copyright 2009 - Zoeteweij Consulting
25
Introduction - Provisioning • Another one for Management... – Oracle Enterprise Manager Delivers 124% ROI – An independent multi-customer study conducted by Forrester Consulting reveals customers gain significant benefits and cost savings from OEM Configuration Management Pack and OEM Provisioning and Patch Automation Pack… 14-10-2009
Copyright 2009 - Zoeteweij Consulting
26
Introduction - Provisioning • The sample organization in Forrester Consulting's study shows (over 3 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. 14-10-2009
Copyright 2009 - Zoeteweij Consulting
27
Introduction - Provisioning • Report Forrester Research – http://www.oracle.com/webapps/dialogue/dlgp age.jsp?p_ext=Y&p_dlg_id=7535983&src=66 42151&Act=242
14-10-2009
Copyright 2009 - Zoeteweij Consulting
28
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
29
Concepts
14-10-2009
Copyright 2009 - Zoeteweij Consulting
30
Concepts
14-10-2009
Copyright 2009 - Zoeteweij Consulting
31
Concepts – Golden Image • Baselines – Standards – Pre-cooked – Reusability – Examples • CRS 11.1.0.7 – Baseline Clusterware • ASM 11.1.0.7 – Baseline ASM • DB 10.2.0.4 – Baseline Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
32
Concepts – Software Library
14-10-2009
Copyright 2009 - Zoeteweij Consulting
33
Concepts – Software Library • Components – Files – Golden Images • Oracle Clones, CRS, ASM, DB.... – Baselines – (Ingredients)
• Directives – Logic • Scripts: Perl - shell – What to do with … (Component) – (Recipes)
14-10-2009
Copyright 2009 - Zoeteweij Consulting
34
Concepts – Software Library • 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 ) 14-10-2009
Copyright 2009 - Zoeteweij Consulting
35
Concepts – Software Library • 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
14-10-2009
Copyright 2009 - Zoeteweij Consulting
36
Concepts – Software Library • Cluster – Specification of Hardware Servers in a Cluster – BMP
• Administration – Configuration of Software Library
14-10-2009
Copyright 2009 - Zoeteweij Consulting
37
Concepts – Software Library • Software Library – Partially in Repository • MGMT_PAF… • MGMT_SWLIB…
14-10-2009
Copyright 2009 - Zoeteweij Consulting
38
Concepts – Software Library • Software Library – Partially on OMS file system • At configuration time • If multiple OMS’s, shared file system
14-10-2009
Copyright 2009 - Zoeteweij Consulting
39
Concepts – Software Library
14-10-2009
Copyright 2009 - Zoeteweij Consulting
40
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
41
Framework
14-10-2009
Copyright 2009 - Zoeteweij Consulting
42
Framework • 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
14-10-2009
Copyright 2009 - Zoeteweij Consulting
43
Framework
14-10-2009
Copyright 2009 - Zoeteweij Consulting
44
Framework • Deployment Procedures – Type 1 • RAC Provisioning Procedures • Static GUI
– Type 2 • Database Patching Procedure • Customizable GUI
14-10-2009
Copyright 2009 - Zoeteweij Consulting
45
Procedure - Status
14-10-2009
Copyright 2009 - Zoeteweij Consulting
46
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
47
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
48
Out of the Box • Several Oracle delivered Procedures – Database provisioning – Application Server provisioning – RAC Provisioning – Patching
14-10-2009
Copyright 2009 - Zoeteweij Consulting
49
Out of the Box
14-10-2009
Copyright 2009 - Zoeteweij Consulting
50
Out of the Box
14-10-2009
Copyright 2009 - Zoeteweij Consulting
51
Out of the Box • 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
14-10-2009
Copyright 2009 - Zoeteweij Consulting
52
Out of the Box – – – – –
Forms and Reports Provisioning – 1 Coherence Node Provisioning – 1 Patch Oracle Software – 6 Virtualization Provisioning – 11 Oracle Service Bus Resource Provisioning – 1
14-10-2009
Copyright 2009 - Zoeteweij Consulting
53
Provisioning - CRS / ASM / DB • After Server is provisioned with OS and Agent – Bare Metal Provisioning (Linux)
• Provisioning of – Clusterware software + configuration – ASM software + ASM Instance creation – DB software (Creation of starter database provided) 14-10-2009
Copyright 2009 - Zoeteweij Consulting
54
14-10-2009
55
Provisioning - CRS / ASM / DB • Using Clones / Golden Images from SW Library: – To standardize – To work with Baselines – As part of Release Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
56
Provisioning - CRS / ASM / DB • Baseline Examples: – Baseline 1 • CRS 11.1.0.7 • ASM 11.1.0.7 • DB 10.2.0.4
– Baseline 2 • CRS 11.1.0.7 • ASM 11.1.0.7 • DB 11.1.0.7 14-10-2009
Copyright 2009 - Zoeteweij Consulting
57
58
59
60
Out of Box – DP Procedure • We don’t use Create Starter Database (See next slide) • We use a separate DP Procedure for this – Create RAC Database on configured Stack
61
62
• ASM Disk String – No use of wildcards (OEM 10.2.0.4) • Fixed in OEM 10.2.0.5
63
64
65
66
67
68
69
Provisioning – Create RAC Database • Out of Box – Single Instance Database creation – No RAC Database creation • OK, included in Oracle Clusterware / RAC Provisioning • Not a usable scenario
• Need to create your own
14-10-2009
Copyright 2009 - Zoeteweij Consulting
70
Provisioning – Create RAC Database • Create a custom Deployment Procedure – Based on Patching Oracle Database • Type 2
14-10-2009
Copyright 2009 - Zoeteweij Consulting
71
Provisioning – Create RAC Database • Possible Use Case – Create RAC Database • 1..n Instances on 1..n nodes in Cluster
– Create entries in OMS – Include in monitoring Groups – Include in Role – Create RAC Services – Register entries in OID • Database, Instances, RAC Services 14-10-2009
Copyright 2009 - Zoeteweij Consulting
72
Provisioning – Create RAC Database • Possible Use Case (Continue) – Application of Monitoring Templates • No need to in 10.2.0.5 (Default Templates)
– Configure Tape Backup – Perform 1st Backup – Etc.
14-10-2009
Copyright 2009 - Zoeteweij Consulting
73
14-10-2009
Copyright 2009 - Zoeteweij Consulting
74
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
75
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
76
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
77
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
78
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
79
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
80
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
81
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
82
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
83
14-10-2009
Copyright 2009 - Zoeteweij Consulting
84
14-10-2009
Copyright 2009 - Zoeteweij Consulting
85
Provisioning – Remove RAC Database • No Out of Box procedure available • So, need to create your own • Based on Patching Oracle Database procedure – Type 2
14-10-2009
Copyright 2009 - Zoeteweij Consulting
86
Provisioning – Remove RAC Database • Remove entries from OMS – EMCLI
• Remove the database – DBCA
• Remove files – $ORACLE_HOME/dbs
• Remove entry from /etc/oratab 14-10-2009
Copyright 2009 - Zoeteweij Consulting
87
Provisioning – Remove RAC Database • Remove files from ASM (DBCA won’t delete all) • Etc.
14-10-2009
Copyright 2009 - Zoeteweij Consulting
88
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
89
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
90
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
91
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
92
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
93
Provisioning – Remove RAC Database
14-10-2009
94
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
95
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
96
Provisioning – Other useable procedures • One Click Extend Cluster Database – Rather have Extend Cluster – Need to use dummy Database for this – Include 1..n servers in cluster – Installs • CRS + Re-configuration • ASM + Instance creation • DB + Instance creation (dummy)
14-10-2009
Copyright 2009 - Zoeteweij Consulting
97
Provisioning – Other useable procedures • Delete/Scale down Oracle RAC – Removes instance – Removes server from cluster
14-10-2009
Copyright 2009 - Zoeteweij Consulting
98
Provisioning – Wrap up • Out of Box Procedures – Can do the job in some Use Cases – A good base to start customizing
• Customize Procedures – Based on Patching Oracle Database • Most flexible but still limitations
– Anything can be done
14-10-2009
Copyright 2009 - Zoeteweij Consulting
99
Provisioning – Wrap up • Perl – Multi Platform – Need to train your staff
• Standardization – Baselines
• Task automation
14-10-2009
Copyright 2009 - Zoeteweij Consulting
100
Provisioning – Wrap up • Reduction of – Costs – Complexity – Time to Market
14-10-2009
Copyright 2009 - Zoeteweij Consulting
101
Provisioning – Wrap up • Start thinking about: – Training – Organization – Lifecycle – Change of DBA Job description…?
14-10-2009
Copyright 2009 - Zoeteweij Consulting
102
Provisioning – Wrap up • Easy to start working with? – Working with 10.2.0.4? • Start upgrading to 10.2.0.5
– 10.2.0.5 • Major improvements
– Documentation • Still a problem • But improving!
14-10-2009
Copyright 2009 - Zoeteweij Consulting
103
Provisioning – Wrap up • Easy to start working with? (Continued) – Start getting Out of Box procedures to work • Should not be a problem
– Next, start doing customization – Take a good training • 5-Hart • Oracle University • Zoeteweij Consulting ;-)
–… 14-10-2009
Copyright 2009 - Zoeteweij Consulting
104
Provisioning – Wrap up • OTN – http://www.oracle.com/technology/products/oe m/mgmt_solutions/provisioning.html
• Linkedin.com – Group OEM GRID Control • http://www.linkedin.com/groups?gid=1776007&trk= hb_side_g
• [email protected] • OOW 2009 14-10-2009
Copyright 2009 - Zoeteweij Consulting
105
Agenda • • • • •
Introduction Concepts Framework Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
106
Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
107
Rob Zoeteweij 14-10-2009
1
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
2
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
3
Introduction • • • •
Rob Zoeteweij Working with Oracle since 1985 Oracle DBA (Release 3 .. 11g) Development Designer, Forms, Reports, PL/SQL, Portal…
14-10-2009
Copyright 2009 - Zoeteweij Consulting
4
Introduction • Last 5 years – Oracle Consulting – Expert Services • RAC/ASM – OEM GRID Control
– FreeIT • Rabobank - Shell – OEM GRID Control
– 5 Hart • Trainer OEM GRID Control
14-10-2009
Copyright 2009 - Zoeteweij Consulting
5
Introduction - OEM • Successor of OEM 9i – Java Client
• EM Database Control – Local • EM Application Server Control - Local • OEM GRID Control 10g – Current Release 10.2.0.5 – GUI synchronize • EM DB Control • EM AS Control 14-10-2009
Copyright 2009 - Zoeteweij Consulting
6
Introduction - OEM
14-10-2009
Copyright 2009 - Zoeteweij Consulting
7
OEM – Key Features • • • • •
System Monitoring Groups Job System Information Publishing Compliance Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
8
OEM – Targets • • • • • •
Databases Middleware Hosts & Third Party Oracle Beehive Virtualization Many non Oracle
14-10-2009
Copyright 2009 - Zoeteweij Consulting
9
System Monitoring
14-10-2009
Copyright 2009 - Zoeteweij Consulting
10
Database Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
11
Performance Monitoring
14-10-2009
Copyright 2009 - Zoeteweij Consulting
12
Service Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
13
Service Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
14
Change Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
15
Change Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
16
Middleware Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
17
Host Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
18
Host Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
19
System Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
20
Virtualization Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
21
and… Provisioning
14-10-2009
Copyright 2009 - Zoeteweij Consulting
22
Introduction - Provisioning • In general, provisioning means "providing" or making something available. The term is used in a variety of contexts in IT. For example, in grid computing, to provision is to activate a grid component, such as a server, array, or switch, so that it is available for use... Internet – What is? 14-10-2009
Copyright 2009 - Zoeteweij Consulting
23
Introduction - Provisioning • Management perspective: – Reduction of complexity • Task automation • Every time exact same sequence of actions… • Standardization
– Reduction of costs • DBO • Less training
– Time to market 14-10-2009
Copyright 2009 - Zoeteweij Consulting
24
Introduction - Provisioning – Time to market • Less time needed to have infrastructure available • Have a fully configured database cluster – In hours instead of days / weeks
• Managers just love it … ;-)
– Increase of quality • Availability
14-10-2009
Copyright 2009 - Zoeteweij Consulting
25
Introduction - Provisioning • Another one for Management... – Oracle Enterprise Manager Delivers 124% ROI – An independent multi-customer study conducted by Forrester Consulting reveals customers gain significant benefits and cost savings from OEM Configuration Management Pack and OEM Provisioning and Patch Automation Pack… 14-10-2009
Copyright 2009 - Zoeteweij Consulting
26
Introduction - Provisioning • The sample organization in Forrester Consulting's study shows (over 3 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. 14-10-2009
Copyright 2009 - Zoeteweij Consulting
27
Introduction - Provisioning • Report Forrester Research – http://www.oracle.com/webapps/dialogue/dlgp age.jsp?p_ext=Y&p_dlg_id=7535983&src=66 42151&Act=242
14-10-2009
Copyright 2009 - Zoeteweij Consulting
28
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
29
Concepts
14-10-2009
Copyright 2009 - Zoeteweij Consulting
30
Concepts
14-10-2009
Copyright 2009 - Zoeteweij Consulting
31
Concepts – Golden Image • Baselines – Standards – Pre-cooked – Reusability – Examples • CRS 11.1.0.7 – Baseline Clusterware • ASM 11.1.0.7 – Baseline ASM • DB 10.2.0.4 – Baseline Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
32
Concepts – Software Library
14-10-2009
Copyright 2009 - Zoeteweij Consulting
33
Concepts – Software Library • Components – Files – Golden Images • Oracle Clones, CRS, ASM, DB.... – Baselines – (Ingredients)
• Directives – Logic • Scripts: Perl - shell – What to do with … (Component) – (Recipes)
14-10-2009
Copyright 2009 - Zoeteweij Consulting
34
Concepts – Software Library • 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 ) 14-10-2009
Copyright 2009 - Zoeteweij Consulting
35
Concepts – Software Library • 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
14-10-2009
Copyright 2009 - Zoeteweij Consulting
36
Concepts – Software Library • Cluster – Specification of Hardware Servers in a Cluster – BMP
• Administration – Configuration of Software Library
14-10-2009
Copyright 2009 - Zoeteweij Consulting
37
Concepts – Software Library • Software Library – Partially in Repository • MGMT_PAF… • MGMT_SWLIB…
14-10-2009
Copyright 2009 - Zoeteweij Consulting
38
Concepts – Software Library • Software Library – Partially on OMS file system • At configuration time • If multiple OMS’s, shared file system
14-10-2009
Copyright 2009 - Zoeteweij Consulting
39
Concepts – Software Library
14-10-2009
Copyright 2009 - Zoeteweij Consulting
40
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
41
Framework
14-10-2009
Copyright 2009 - Zoeteweij Consulting
42
Framework • 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
14-10-2009
Copyright 2009 - Zoeteweij Consulting
43
Framework
14-10-2009
Copyright 2009 - Zoeteweij Consulting
44
Framework • Deployment Procedures – Type 1 • RAC Provisioning Procedures • Static GUI
– Type 2 • Database Patching Procedure • Customizable GUI
14-10-2009
Copyright 2009 - Zoeteweij Consulting
45
Procedure - Status
14-10-2009
Copyright 2009 - Zoeteweij Consulting
46
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
47
Agenda • • • • • •
Introduction Concepts Framework Break Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
48
Out of the Box • Several Oracle delivered Procedures – Database provisioning – Application Server provisioning – RAC Provisioning – Patching
14-10-2009
Copyright 2009 - Zoeteweij Consulting
49
Out of the Box
14-10-2009
Copyright 2009 - Zoeteweij Consulting
50
Out of the Box
14-10-2009
Copyright 2009 - Zoeteweij Consulting
51
Out of the Box • 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
14-10-2009
Copyright 2009 - Zoeteweij Consulting
52
Out of the Box – – – – –
Forms and Reports Provisioning – 1 Coherence Node Provisioning – 1 Patch Oracle Software – 6 Virtualization Provisioning – 11 Oracle Service Bus Resource Provisioning – 1
14-10-2009
Copyright 2009 - Zoeteweij Consulting
53
Provisioning - CRS / ASM / DB • After Server is provisioned with OS and Agent – Bare Metal Provisioning (Linux)
• Provisioning of – Clusterware software + configuration – ASM software + ASM Instance creation – DB software (Creation of starter database provided) 14-10-2009
Copyright 2009 - Zoeteweij Consulting
54
14-10-2009
55
Provisioning - CRS / ASM / DB • Using Clones / Golden Images from SW Library: – To standardize – To work with Baselines – As part of Release Management
14-10-2009
Copyright 2009 - Zoeteweij Consulting
56
Provisioning - CRS / ASM / DB • Baseline Examples: – Baseline 1 • CRS 11.1.0.7 • ASM 11.1.0.7 • DB 10.2.0.4
– Baseline 2 • CRS 11.1.0.7 • ASM 11.1.0.7 • DB 11.1.0.7 14-10-2009
Copyright 2009 - Zoeteweij Consulting
57
58
59
60
Out of Box – DP Procedure • We don’t use Create Starter Database (See next slide) • We use a separate DP Procedure for this – Create RAC Database on configured Stack
61
62
• ASM Disk String – No use of wildcards (OEM 10.2.0.4) • Fixed in OEM 10.2.0.5
63
64
65
66
67
68
69
Provisioning – Create RAC Database • Out of Box – Single Instance Database creation – No RAC Database creation • OK, included in Oracle Clusterware / RAC Provisioning • Not a usable scenario
• Need to create your own
14-10-2009
Copyright 2009 - Zoeteweij Consulting
70
Provisioning – Create RAC Database • Create a custom Deployment Procedure – Based on Patching Oracle Database • Type 2
14-10-2009
Copyright 2009 - Zoeteweij Consulting
71
Provisioning – Create RAC Database • Possible Use Case – Create RAC Database • 1..n Instances on 1..n nodes in Cluster
– Create entries in OMS – Include in monitoring Groups – Include in Role – Create RAC Services – Register entries in OID • Database, Instances, RAC Services 14-10-2009
Copyright 2009 - Zoeteweij Consulting
72
Provisioning – Create RAC Database • Possible Use Case (Continue) – Application of Monitoring Templates • No need to in 10.2.0.5 (Default Templates)
– Configure Tape Backup – Perform 1st Backup – Etc.
14-10-2009
Copyright 2009 - Zoeteweij Consulting
73
14-10-2009
Copyright 2009 - Zoeteweij Consulting
74
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
75
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
76
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
77
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
78
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
79
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
80
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
81
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
82
Provisioning – Create RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
83
14-10-2009
Copyright 2009 - Zoeteweij Consulting
84
14-10-2009
Copyright 2009 - Zoeteweij Consulting
85
Provisioning – Remove RAC Database • No Out of Box procedure available • So, need to create your own • Based on Patching Oracle Database procedure – Type 2
14-10-2009
Copyright 2009 - Zoeteweij Consulting
86
Provisioning – Remove RAC Database • Remove entries from OMS – EMCLI
• Remove the database – DBCA
• Remove files – $ORACLE_HOME/dbs
• Remove entry from /etc/oratab 14-10-2009
Copyright 2009 - Zoeteweij Consulting
87
Provisioning – Remove RAC Database • Remove files from ASM (DBCA won’t delete all) • Etc.
14-10-2009
Copyright 2009 - Zoeteweij Consulting
88
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
89
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
90
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
91
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
92
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
93
Provisioning – Remove RAC Database
14-10-2009
94
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
95
Provisioning – Remove RAC Database
14-10-2009
Copyright 2009 - Zoeteweij Consulting
96
Provisioning – Other useable procedures • One Click Extend Cluster Database – Rather have Extend Cluster – Need to use dummy Database for this – Include 1..n servers in cluster – Installs • CRS + Re-configuration • ASM + Instance creation • DB + Instance creation (dummy)
14-10-2009
Copyright 2009 - Zoeteweij Consulting
97
Provisioning – Other useable procedures • Delete/Scale down Oracle RAC – Removes instance – Removes server from cluster
14-10-2009
Copyright 2009 - Zoeteweij Consulting
98
Provisioning – Wrap up • Out of Box Procedures – Can do the job in some Use Cases – A good base to start customizing
• Customize Procedures – Based on Patching Oracle Database • Most flexible but still limitations
– Anything can be done
14-10-2009
Copyright 2009 - Zoeteweij Consulting
99
Provisioning – Wrap up • Perl – Multi Platform – Need to train your staff
• Standardization – Baselines
• Task automation
14-10-2009
Copyright 2009 - Zoeteweij Consulting
100
Provisioning – Wrap up • Reduction of – Costs – Complexity – Time to Market
14-10-2009
Copyright 2009 - Zoeteweij Consulting
101
Provisioning – Wrap up • Start thinking about: – Training – Organization – Lifecycle – Change of DBA Job description…?
14-10-2009
Copyright 2009 - Zoeteweij Consulting
102
Provisioning – Wrap up • Easy to start working with? – Working with 10.2.0.4? • Start upgrading to 10.2.0.5
– 10.2.0.5 • Major improvements
– Documentation • Still a problem • But improving!
14-10-2009
Copyright 2009 - Zoeteweij Consulting
103
Provisioning – Wrap up • Easy to start working with? (Continued) – Start getting Out of Box procedures to work • Should not be a problem
– Next, start doing customization – Take a good training • 5-Hart • Oracle University • Zoeteweij Consulting ;-)
–… 14-10-2009
Copyright 2009 - Zoeteweij Consulting
104
Provisioning – Wrap up • OTN – http://www.oracle.com/technology/products/oe m/mgmt_solutions/provisioning.html
• Linkedin.com – Group OEM GRID Control • http://www.linkedin.com/groups?gid=1776007&trk= hb_side_g
• [email protected] • OOW 2009 14-10-2009
Copyright 2009 - Zoeteweij Consulting
105
Agenda • • • • •
Introduction Concepts Framework Out of the Box Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
106
Q&A
14-10-2009
Copyright 2009 - Zoeteweij Consulting
107
Related Documents
Oem - Ogh - 9 Juli 2009
June 2020 3
Oem
May 2020 16
Oem
December 2019 37
Jherh Ogh
May 2020 1
2009 Juli
May 2020 26
2009 Quad Oem Catalog
December 2019 11More Documents from ""
Oem - Ogh - 9 Juli 2009
June 2020 3
