Monday October 3rd – Database performance tuning: Getting the best out of Oracle EM

Tariq Farooq

an Oracle ACE en founder of BrainSurface

During the presentation a clear explanation if given of the Database performance process using Oracle Enterprise Manager Grid Control. Showing several examples from the Database Performance Tab and showing the advantage of several linked features like Top Activity, Blocking Sessions.

The presentation next focuses on the three A’s for Database Performance Tuning:

• ASH  (Activity Summery History)
• AWR (Activity Workload Repository)
• ADDM (Automatic Data Diagnostic Monitoring)

Realizing AWR is the successor of the former statspack feature, several examples are given of how to interpret some of the output.

I think a very good and solid presentation, focusing merely on novice users of which there are a lot in the OEM GC arena.

Filed under: Events, Grid Control 11.1, OOW 2011, Oracle Enterprise Manager 10 - 11g - 12c, Cloud Control, em 12c, enterprise manager cloud control, oem 12c, oem cc 12c, oem gc 12c

Install Oracle Enterprise Manager 11gR1 on Oracle Virtual Machine

Just read a perfectly detailed description of the installation of OEM GC 11.1 on OracleVM.

It was written by a friend of my Hans Camu who posted it on his blog http://camoraict.wordpress.com

Checkout the document Install Oracle Enterprise Manager 11gR1 on Oracle Virtual Machine

Also find some interesting posts on OracleVM.

 

Filed under: Grid Control 11.1, Installation, Oracle Enterprise Manager 10 - 11g - 12c

During the installation of OEM GC 11.1 on AIX, there was no auto discovery of the Middleware Components

While doing the installation of OEM GC 11.1 on AIX 6.1, I noticed that there was no automatic discovery of the Middleware targets.

This is due to bug 9969664.

The solution provided in MOS Note:

Error when discovering and monitoring secured weblogic domains on AIX platforms (using t3s/iiops protocols) in EMGC11.1 (Doc ID 1208874.1)

did the trick for me and discovered the 8 additional Middleware targets.

 

Filed under: Grid Control 11.1, Installation, Oracle Enterprise Manager 10 - 11g - 12c

Creating a Physical Standby Database using OEM GC

This Paper is about the creation of a physical Stanby Database using OEM GC.

You will see that there is really nothing to it and using the Data Guard Broker, performing a switchover is as easy as 1,2,3,.

BTW, this works in both OEM GC 10.2.0.5 and 11.1

Creation of a physical Standby Database using OEM GC

Filed under: Grid Control 11.1, High Availability, Oracle Enterprise Manager 10 - 11g - 12c, White Papers

Oracle Grid Infrastructure / RAC Provisioning

Using the OEM GC Provisioning and Automated Patching Pack, you are able to provision a complete Oracle RAC Cluster, including the Grid Infrastructure and creation of an ASM Instance and a RAC Database.

In this paper I show an example of how I was able to do the provisioning of Grd Infrastructure and Oracle RAC on a 2 node OracleVM Cluster.

Oracle Grid Infrastructure – RAC Provisioning – Using OEM GC 11.1

Filed under: Grid Control 11.1, Oracle Enterprise Manager 10 - 11g - 12c, Provisioning, White Papers

New feature – Provisioning Profiles

New in OEM GC 11.1 – Provisioning is the ability to save your input in a Provisioning Profile.

If you then use this Profile a next time you schedule a Deployment Procedure, most of the input variables are filled based on the saved values in the Profile.

Read about how to use this feature in:

Saving your input to a Provisioning Profile

Filed under: Grid Control 11.1, Oracle Enterprise Manager 10 - 11g - 12c, Provisioning, White Papers

Link to OEM GC 11.1 on Sun SPARC – Republished

OK guys, the link to OEM GC 11.1 on Sun SPARC is republished on http://www.oracle.com/technology/software/products/oem/index.html

Filed under: Grid Control 11.1, Oracle Enterprise Manager 10 - 11g - 12c

Link to download OEM GC 11.1 Sun Sparc republished soon

I have been tolds that the link to download OEM GC 11.1 for Sun Sparc is going to be republished one of the coming weeks.

So we still need to be a little patience here guys.

Filed under: Grid Control 11.1, Oracle Enterprise Manager 10 - 11g - 12c

OEM GC 11.1 SPARC Solaris available for download

As of today, Oracle Enterprise Manager Grid Control 11.1 is available for SPARC  Solaris.

You can download from http://www.oracle.com/technology/software/products/oem/index.html

Filed under: Grid Control 11.1, Oracle Enterprise Manager 10 - 11g - 12c

Upgrading Agent 10.2.0.5 to 11.1 as easy as 1,2,3…

After the upgrade of OMS 10.2.0.5 to 11.1 in my test environment, I started upgrading some of the remote agents.

OEM GC 11.1 includes an Upgrade Agent feature that allows you to upgrade the 10.2.0.5 Agent to 11.1 on multiple nodes at once.

Check out this document to see what I did and how easy it is.

Upgrading Agents OEM Grid Control 11.1

Filed under: Agents, Grid Control 11.1, Oracle Enterprise Manager 10 - 11g - 12c, Upgrade