customer case oracle dba dag 22-6-2010

8/4/2019 Customer Case Oracle DBA Dag 22-6-2010

1/33


2/33

Agenda

Case introduction

Configuration Management

Provisioning & Automated Patching

Finally Q & A


3/33

Case introduction

Too many incidents related to Configuration changes

OS, Database / App Server Parameter changes

Not sure what we have got

What Database releases?

What Patches have been applied?

Not sure about compliancy

Database Standards

Configuration of the Database

Security

Where to improve?


4/33

Case introduction

Any direct threads?

Are there any known issues that might relate to one of ourdatabases and is a fix available?


5/33

Case introduction

High demand for:

Standardization

Task automation

Reduction of complexity

Reduction of costs

Improvement of Time to Market

It takes too long to startup projects

Configuration of Clusters, Databases, Application Servers


6/33

Case introduction

Customer choice was implementation of:

OEM GC including:

Configuration Management Pack

Provisioning and Automated Patching Pack


7/33

Agenda

Case introduction



Finally Q & A


8/33


Based on CMDB(Configuration Management Database)

SYSMAN schema

Implicitly available after installation of OEM GC

After discovery of Targets (Databases, Servers, ApplicationServers, Listeners, Clusters, ASM, Hardware, Storage, etc.)

Analytics & Reports

Change detection

Compliancy assessments


9/33



10/33


Saved Configuration

Take a Picture of current Configuration

To be used as:

Blueprint

Baselines

Base for detecting Configuration drifting


11/33


Comparing Configurations

One Configuration with another

One Configuration with several others (Job)


12/33



13/33


14/33


15/33


Complete control on:

all Configurations

Licenses

Changes

History

Compliancy

Company Rules

The Hague, Brussels, Dutch Bank

Need for Role in Organization Weekly check of any Configuration Drift

15 minutes a week


16/33

Agenda

Case introduction



Finally Q & A


17/33

System LifecycleInstall Software

Patch

Configure

Monitor

Administer

Remove

VirtualMachines

OperatingSystem

Databases

Middleware

Applications


18/33

Installing the software with OEM

Create ReferenceSystem

Stage as GoldenImage inSoftware Library

DeployProductionSystem


19/33

Patch Software with OEMStage Patch in

Software LibraryDownloadPatch

Deploy on

multiple Systems


20/33

Configuring Systems with OEM

Identify

Systems

Create

DirectivesandComponents

Deploy

Configuration

Stage in

Software Library


21/33

Software Library

Software Library

DirectivesScripts (Perl or Bash)to be executed on thetarget

ComponentsAll kind of filesthat can be usedby a directive

Deployment Procedures

Orchestration of Directivesand Components


22/33

Provisioning and Automated Patching

Customer Case

Provisioning of

Operating System Bare Metal Provisioning

Cluster infrastructure

Multiple Node Clusters Software installation and Cluster configuration

ASM

Software installation and ASM Instance creation oneach Node

DB

Software installation on each Node

Creation of Cluster Database (RAC) 1 3 Instances


23/33


Software Library

Golden Images

OS

Oracle Software

Cluster Infrastructure ASM Software

DB Software

Etc.

Network specifications Etc.


24/33


Customer Case

Oracle Clusterware / RAC Provisioning For UNIX



25/33

Provisioning and Automated PatchingClusterware / RAC

ClusterwareASM Software

Database Software

Shared Storage

ClusterConfiguration

ASM Instancecreation(Optional)

Databasecreation(Optional)

Installed:- Clusterware- ASM Software

- DB Software

Software Library


26/33


Customer Case

Extending the Cluster


27/33

Provisioning and Automated PatchingExtending the Cluster

ClusterwareASM Software

Database Software

Shared Storage

Installed:

- Clusterware- ASM Software

- DB Software

Cluster

Re-configuration

ASM InstancecreationDatabase

Instancecreation

Software Library


28/33


WRAP UP

Full configuration of Oracle Database Cluster Clusterware ASM DB

ASM Instance creation / DB Creation

Fully operational

Customers Project shows:

Provisioning of a 3 node Cluster in only 2 hours

OEL 5, CRS 11.1.0.7, ASM 11.1.0.7, DB 11.1.0.7

HP Blade Servers

Instead of several days

Based on Best Practice (Oracle / Customer) Standardized

Fully compliant to Customer rules

Security (European Law, Dutch Law, Dutch NationalBank)


29/33


Patching as part of Release Management

4 / Year CPU

4 x 400 DB x 1 hr = 1600 hrs per year (manually)

4 x 400 DB x 00:10 hr = 266 hrs per year (OEM GC)

Patching thousands as one

Based on connection between OMS andupdates.oracle.com

Via Company proxy

Patch advisories

Patches downloaded in Patch Cache (SoftwareLibrary)


30/33



31/33

Agenda

Case introduction



Finally Q & A


32/33

Finally

http://otn.oracle.com

Linkedin Groups:

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

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

hb_side_g

http://oemgc.wordpress.com

[email protected]
http://otn.oracle.com/http://www.linkedin.com/groups?gid=1776007&trk=hb_side_ghttp://www.linkedin.com/groups?gid=1776007&trk=hb_side_ghttp://www.linkedin.com/groups?gid=2688744&trk=hb_side_ghttp://www.linkedin.com/groups?gid=2688744&trk=hb_side_ghttp://oemgc.wordpress.com/mailto:[email protected]:[email protected]://oemgc.wordpress.com/http://oemgc.wordpress.com/http://www.linkedin.com/groups?gid=2688744&trk=hb_side_ghttp://www.linkedin.com/groups?gid=2688744&trk=hb_side_ghttp://www.linkedin.com/groups?gid=1776007&trk=hb_side_ghttp://www.linkedin.com/groups?gid=1776007&trk=hb_side_ghttp://otn.oracle.com/


33/33

Q & A

customer case oracle dba dag 22-6-2010

Documents