Thursday Sep 22, 2011

Update on some interesting new or recently updated Exadata related MOS notes and the Oracle Database Appliance

A quick blog update on some interesting new or recently updated Exadata related MOS notes:
  • Dedicated and Global Hot Spares for Exadata Compute Nodes in 11.2.2.3.2 (Doc ID 1339647.1)
  • How to Expand Exadata Compute Node File Systems (Doc ID 1357457.1)
  • Tool for Gathering I/O Resource Manager Metrics: metric_iorm.pl (Doc ID 1337265.1)
  • Scripts and Tips for Monitoring CPU Resource Manager (Doc ID 1338988.1)
  • Configuring Resource Manager for Mixed Workloads in a Database (Doc ID 1358709.1)
Also wanted to mention the announcement of the Oracle Database Appliance, checkout this paper

From now on smaller post will primarily be done using my twitter account: @rene_kundersma. The larger items will still be posted to this blog.

Rene Kundersma

Friday Sep 09, 2011

Software Updates, Best Practices and Notes

With a very busy time behind and ahead of me, I still like to make mention of a couple of documents recently we published.

OPlan is now available for Linux as well as Solaris X86-64 for the Oracle Exadata Database Machine. The current version of OPlan is 11.2.0.2.5. For more details, see my previous post


The two notes mentioned below explain about how OPlan can be used and demo how OPLan works to clone the Grid Infrastructure on the Database Machine, patch the cloned home and switch to it. This is called out-of-place patching.

  • MOS Note 1306814.1 - Oracle Software Patching with OPLAN
  • MOS Note 1136544.1 - Minimal downtime patching via cloning 11gR2 ORACLE_HOME directories


Supported software versions for Exadata are still listed in MOS note 888828.1, this is where you will find a reference to the latest Exadata Storage Server software release: 11.2.2.3.5, available via patch 12849110. Please see note 1334254.1 for the details.


For the Database Server, the latest patch made available for 11.2.0.2 is Bundle Patch 10, available via Patch 12773458 (Linux version). Please know that BP's can be applied by EM, which makes patching more easy.

For ASR we now have release version 3.3 Released. Details can be found in Note 1185493.1.
The latest PDU metering unit firmware is 1.04 and available as patch 12871297.

For MAA Best pracitces releated to the database machine we released a real good document called "Oracle Exadata Database Machine Consolidation: Segregating Databases and Roles", which you can find here

Also releated to best practices is the document "MAA Best Practices for Oracle Exadata Database Machine", you can find that here


Rene Kundersma

Wednesday Sep 07, 2011

OOW Sessions Related to Database High Availability

A quick one on OOW 2011: this link lists all database HA related sessions !

Monday Jul 04, 2011

Failover capability for plugins Exadata & EMGC Rapid deployment

With this entry two items around Exadata management:

First: a pointer to My Oracle Support note 1110675.1. This is note is called "Oracle Database Machine Monitoring Best Practices" and has a lot of information on Exadata management. In this note you will read about the plugins we have to monitor the various Exadata components and how to configure them, also you will read about creating a 'Dashboard'.

The topic I like to cover here is about the steps to take to setup automated fail-over of targets. This is, because by default a target monitored using a plug-in in Enterprise Manager Grid Control is bound to the agent used during the initial installation.
So, what you basically want to do is make sure another agent (on another node) is available to take over the monitored targets when the first agents fails; providing HA for your monitoring.

For this I like to mention two items:

  1. "Package to add failover capabiity for Plug-ins"   (bottom of note 1110675.1.)
  2. OEM_Exadata_Dashboard_Deployment_v104.pdf

In the file 'OEM_Exadata_Dashboard_Deployment' you read about the following steps:
  • adding the PL/SQL package into the EM repository (package mentioned above)
  • registering the package
  • setting up of agents the target can use for fail-over
  • create failover method and notification rule
  • create fail-back method and notification rule

Once you have executed the steps above, the second agent should be able to take over the targets initially assigned to the first agent when the first fails.

You can test this by stopping the first agent; in Grid Control you will find the targets under the second agent. Making sure the monitored targets can failover to a surviving agent is recommended, but it going that route, it would make sense to also make sure Grid Control (OMS) and database are both also HA.

Second topic for this entry is the "EM 11GC Setup automatic kit" for Exadata.

With the latest Oracle Exadata Database Machine Configurator a new output file (em.param) is generated. This file can be used as input for installing Oracle Enterprise Manager Grid Control Agents on Oracle Exadata Database Machine

With this kit, Exadata customers, having an existing Oracle Enterprise Manager Grid Control environment can have setup agents rapidly by the Oracle or partner teams doing the Exadata deployment. For the sake of completeness: Oracle Enterprise Manager Grid Control is not a requirement for Exadata but a recommendation.

References:

Rene Kundersma

Thursday Jun 09, 2011

Applying bundle patches on Exadata using Enterprise Manager Grid Control

With this post a small first note on applying Exadata Bundle Patches using Enterprise Manager Grid Control 11g.

Did you know:
  • Exadata BP's can be applied in a rolling fashion using Grid Control comparable to 'opatch auto'
  • The patching procedure always updates Opatch to the latest version automatically
  • To some extend conflicts are checked to prevent you from problems using patching
  • Before applying a patch you could run 'analyze' only and verify if the BP patch can be applied.
  • When a SQL script has to run as part of the BP, that's also taken care off

Interested ? Here some resources to help you forward:

More important, check first for required patches and what BP's are tested:
  • Grid Control OMS and Agent Patches required for setting up Provisioning, Patching and Cloning (Doc ID 427577.1)
  • Patch Oracle Exadata Database Machine via Oracle Enterprise Manager 11gR1 (11.1.0.1) (Doc ID 1265998.1)
  • Patch Requirements for Setting up Monitoring and Administration for Exadata (Doc ID 1323298.1)

Still, there's only one single source of truth when it comes to which patches are recommended for Exadata:

  • Database Machine and Exadata Storage Server 11g Release 2 (11.2) Supported Versions (ID 888828.1)

A small demo of a comparable 'RAC Rolling patch' can be found on OTN:

Rene Kundersma

Tuesday May 24, 2011

New papers: DR for Exalogic and Exadata + Oracle GoldenGate on Exadata

Recently an updated version of to the MAA whitepaper "Oracle GoldenGate on Oracle Exadata Database Machine Configuration" has been made available. With this update new information is added regarding:

  • DBFS performance configuration
  • Details of DBFS configuration for node failover
  • GoldenGate Replicat commit behavior configuration
  • The agent failover script for clean start-up of GoldenGate

Also a new document is published called "Disaster Recovery for Oracle Exalogic Elastic Cloud with Oracle Exadata Database Machine". This document discusses :

  • Oracle Fusion Middleware Disaster Recovery architecture and strategy for deployments on Oracle Exalogic with Oracle Exadata Database Machine
  • Detailed deployment and configuration steps for the Oracle Fusion Middleware Disaster Recovery solution on Oracle Exalogic and Oracle Exadata Database Machine.
  • Best practices for the Oracle Fusion Middleware Disaster Recovery solution with Exalogic and Exadata
Rene Kundersma

Thursday May 19, 2011

exachk: healtcheck for Exadata

With this entry I like to handle exachk. Exachk is made available via MOS Doc Id. 1070954.1. The tool is designed to audit various important configuration settings
within an Oracle Database Machine Exadata System - Database Servers, Storage Servers and Infiniband Switches. It verifies key components of the Exadata Database Machine against supported version levels, recommended Oracle RAC settings and Exadata best practices. At the moment we support version 11gR2 for V2 & X2-2.

The tool is non-intrusive, when it completes it's collection and analysis it produces two reports, summary and detailed. If an SR needs to be logged the output can be supplied to Oracle for further analysis . The detailed report will contain Benefit/Impact, Risk and Action/Repair information. In many cases it will also reference publicly available documents with additional information about best practices and how to implement them.

For more and detailed information please see MOS Doc Id. 1070954.1

Rene Kundersma


Sunday May 08, 2011

Exadata Storage Server software 11.2.2.3.1 released

Since some days we have added Patch 12400152 (Exadata Storage Server software 11.2.2.3.1) to the list of Database Machine and Exadata Storage Server supported versions. The main enhancement in 11.2.2.3.1 is support for Solaris 11 Express  for x64 on the compute nodes on both X2-2 and X2-8 systems in addition to Linux. New Exadata Database Machines will ship with both Linux and Solaris installed on the compute nodes by default, and the customer can decide which OS to use at install time.

See note 888828.1 for supported patches

See the patch 12400152 README for more details on the enhancements.

 Rene Kundersma

Wednesday Dec 22, 2010

ASR / SNMP on Exadata

[Read More]

Tuesday Oct 20, 2009

More power under the SUN

[Read More]
About

Blog of Rene Kundersma, Principal Member of Technical Staff at Oracle Development USA. I am designing and evaluating solutions and best practices around database MAA focused on Exadata. This involves HA, backup/recovery, migration and database consolidation and upgrades on Exadata. Opinions are my own and not necessarily those of Oracle Corporation. See http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today