Tuesday Oct 20, 2015

Oracle Enterprise Manager @ Oracle OpenWorld 2015

With Oracle OpenWorld less than a week away, we wanted to highlight all the exciting Oracle Enterprise Manager events and activities at this year's conference. The Oracle Enterprise Manager team put together a snapshot of what's happening—from general sessions to hands-on labs—here is a quick summary:


  • Oracle Management Cloud General Session, featuring 3 brand new services—Real-Time Monitoring, Log, and IT Operations Analytics. Save your seat, pre-register today
  • Unprecedented number of sessions delivered by Oracle experts and customers at this year's conference. See full session list
  • Oracle Enterprise Manager at the SIG Sunday User Group Forum. Session details
  • Dedicated Oracle Enterprise Manager demopods in the Oracle DEMOgrounds. Search Oracle OpenWorld demos
  • Oracle Enterprise Manager Hands-on Labs, providing a deep-dive experience led by Oracle experts. See full list

For the complete list of sessions, demos and hands-on labs, read the Oracle Enterprise Manager Focus on Doc for more.

We look forward to seeing you there!

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager Mobile app

Friday Oct 16, 2015

Oracle OpenWorld Sneak Preview: Oracle’s Newest PaaS Offerings for IT Operations Management – Oracle Management Cloud

OpenWorld is always a very exciting time for Oracle and our customers, and every year we reveal some of our newest offerings. We sat down with Prakash Ramamurthy, Senior Vice President of Oracle Management Cloud, to discuss this year’s conference.

Q: Tell us about what’s happening this year at OpenWorld for Oracle Management Cloud?

PR: This year, we have a rare and fantastic opportunity to introduce an entirely new category of systems management cloud services for Oracle customers – the Oracle Management Cloud. Oracle Management Cloud is a suite of next-generation, integrated monitoring, management and analytics solutions delivered as a service on Oracle Cloud. It is designed for today’s heterogeneous environments across on-premises, Oracle Cloud and third-party cloud services.

Q: Why will Oracle Management Cloud be so valuable to customers?

PR: Customers today are struggling with the need to reduce time-to-market for new applications, even as those applications are getting more and more complex and distributed. Whereas a new offering five years ago might have been supported by a monolithic, on-premises infrastructure, today that offering may be composed of half a dozen cloud services from several different providers. Oracle Management Cloud was purpose-built to provide the new level of operational efficiency and visibility that these rapidly-changing environments require.

Q: What services will be available in the Oracle Management Cloud?

PR: We will be offering three services out of the gate focused on some of the highest pain points for customers today. Oracle Application Performance Monitoring Cloud Service provides development and operations teams with the information that they need to find and fix application issues fast, via deep visibility into your application performance from end user experience, through application server requests, and down to application logs. Oracle Log Analytics Cloud Service monitors, aggregates, indexes, and analyzes all log data from applications and infrastructure – enabling users to search, explore, and correlate this data to troubleshoot problems faster, derive operational insight and make better decisions. And finally, Oracle IT Analytics Cloud Service provides 360-degree insight into the performance, availability, and capacity of applications and IT investments, enabling line-of-business executives, analysts, and administrators to make critical decisions about their IT operations based on comprehensive system and data analysis.

Q: Where can customers go to learn about these new offerings?

PR: The single best place to experience the power of these new offerings will be in the Oracle Management Cloud Launch General Session, which is titled GEN9778 - Oracle Management Cloud: Real-Time Monitoring, Log, & IT Operations Analytics and takes place on Tuesday, October 27 at 11AM in Moscone South Room 102. Oracle OpenWorld attendees should pre-register for the session as there is limited space and attendees will be receiving a gift from Oracle. In addition to the General Session, there will be several dedicated track sessions, demonstration stations and hands-on labs throughout the remainder of the week. It’s going to be a very exciting time.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Friday May 08, 2015

Vote for Oracle Enterprise Manager 12c

Voting for the 2015 Database Trends and Applications (DBTA) Readers' Choice Awards is now open.

In last year's DBTA Readers’ Choice Awards, Oracle Enterprise Manager 12c won two awards for "Best Database Administration Solution" and "Best Database Performance Solution."

This year Oracle Enterprise Manager 12c has been nominated again in the same two categories; Best Database Administration Solution and Best Database Performance Solution.

Be sure to cast a vote for your favorite management tool, Oracle Enterprise Manager 12c.

The voting will close on May 22nd.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Monday Mar 16, 2015

Discover and Promote Oracle Homes as EM Targets

Typically, Oracle Homes are discovered and promoted as targets automatically along with guided flows for addition of primary targets like databases, weblogic domains, etc, but there might be instances (not very often) where you need to discover the Homes standalone.

There are two ways to do this – from the GUI and using EMCLI verbs.

Read More

Friday Mar 06, 2015

Oracle Database In-Memory Advisor

Recently, Oracle announced the general availability of the Oracle Database In-Memory Advisor—a new capability built into Oracle Enterprise Manager 12c Tuning Pack. With this release, Oracle introduces new and extensive capabilities for managing Oracle Database In-Memory, an Oracle Database 12c Enterprise Edition option.

Oracle Database In-Memory can be used to improve queries on a variety of OLTP and/or data warehouse operations. The In-Memory Advisor helps to optimize performance with recommendations to run analytics processing faster. It gives customers insight into the sizing of the workload and offers actionable recommendations for running workloads at peak performance. The Advisor analyzes workloads and related objects making specific recommendations to which objects would give you the greatest benefit and performance if they were placed In-Memory.

Key Capabilities:

  • Assists with In-Memory size selection
  • Recommendations for tables, partitions and sub-partitions for a given In-Memory size
  • Uses workload and performance data to prioritize objects
  • Takes into account differences in disk and memory footprint, as well as compression ratios

Actionable Recommendations

  • Workload based cost/benefit analysis
    • Cost: Offers estimated memory size with various compression options
    • Benefit: Offers estimated database time reduction metrics for workload processing
  • In-memory area population plan


  • Ability to vary In-Memory size to receive specific loading plan
  • Generates DDL scripts with all the tables/partitions/sub-partitions recommended
  • Top SQL benefits from any given configuration

For more information, visit the Oracle Database In-Memory Advisor page on the Oracle Technology Network. You can download the In-Memory Advisor, via MOS note 1965343.1.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Friday Feb 27, 2015

Oracle Private Database Cloud REST APIs

While we spend a lot of time developing GUI for our private cloud features – like the self service portal, setup screens, etc, a large percentage of our customers use these features via our APIs, both EMCLI and REST based.

Q: So why would anyone not use the out of the box cloud (self service) portal and use the APIs instead?

A: Well, there are many reasons:

  1. You already have a custom cloud portal that you use to deploy non-Oracle products and now you would like Oracle products to be part of it
  2. You want cloud related actions to be part of a larger orchestration flow. For example, prior to provisioning, you want to integrate an approval workflow, and then post-provision update your asset management system with the service details.
  3. You want to integrate the cloud actions with our IT service desk or ticketing systems
  4. Integrate actions like cloning of databases (Snap Clone), or provisioning of middleware and applications with your continuous integration or devops process.

Read More

Monday Feb 23, 2015

Webcast: Database Provisioning in Minutes: Using Oracle Enterprise Manager 12c DBaaS Snap Clone and EMC Storage

Live Webcast
Wednesday February 25, 2015
8:00 a.m. PST | 11:00 a.m. EST

Oracle Enterprise Manager 12c Database as a Service Snap Clone allows administrators to create fully functional copies of databases using the capabilities of the underlying storage layer. Users can request databases from the self-service console and have them provisioned within minutes instead of hours while keeping storage needs to a minimum.

Attend this presentation to learn more about the features and benefits of Oracle Enterprise Manager 12c DBaaS Snap Clone using EMC storage and to view a live demo.

This webcast is specifically targeted for DBAs, storage administrators and cloud administrators interested in saving time and effort implementing enterprise grade DBaaS.

Register Now!

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Monday Feb 09, 2015

Take the IOUG Database Manageability Survey

The Independent Oracle Users Group (IOUG), is conducting its annual database manageability survey. If you are a database professional responsible for managing and operating your organization's database applications and systems, then the IOUG wants to hear from you.

Take the next few minutes to answer simply questions around your common manageability practices and challenges. Share your experience and insight with the IOUG and Oracle communities and you'll be entered into a draw for a chance to win an Apple iPad from the IOUG. You will also receive a free copy of the final report.

Take the 2015 IOUG Database Manageability Survey

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Tuesday Jan 27, 2015

Top Oracle Enterprise Manager 12c Questions

Guest contributors: Courtney Llamas and David Wolf

What are the steps involved for upgrading from Oracle Enterprise Manager 12c Release 3 to Release 4? Is it an upgrade in place or a new install/migration
Answer: Yes, Oracle Enterprise Manager 12c R3 to R4 is an out-of-place upgrade, which means the installer will install in a new Oracle Home and migrate the application over. You will need the additional space for a new Oracle Home. You can reduce downtime of the upgrade by performing a “Software Only Install”, and then upgrade later. See the upgrade documentation here.

Do the patch and upgrade functionality work on Oracle Database 11g targets or only on Oracle Database 12c targets?
A: Yes, patching and upgrading can be performed on any certified target version. For more details on database patching and lifecycle management visit this page.

Where can I find a full list of new enhancements compared to Release 3?
A: The new features are listed in Oracle Enterprise Manager Cloud Control Introduction Guide.

Is there a list available of new features by management pack?
A: The new features are listed in Oracle Enterprise Manager Cloud Control Introduction Guide. They are listed by plug-in, not management pack. For the license information read this page.

What are the best hardware configuration and setup in order to provide high availability capabilities for database as a service (i.e. Oracle RAC, Oracle Exadata)?
A: The more you rely on Oracle Enterprise Manager, the more you need to think about high availability. The best recommendation is to have a multi-OMS system with a standby for disaster recovery. You can scale up to this as the environment grows, but starting with a multi-OMS system will give you the availability and scalability you need. A standby database with Oracle Data Guard and a software replicated standby OMS would be the next step. Please read this whitepaper Deploying a Highly Available Oracle Enterprise Manager 12c Cloud Control for more information.

Can Snap Clone be used with EMC storage or is Oracle ZFS storage required?
A: Yes. Snap Clone can be used with either EMC VMAX and/or VNX Block Storage, both are supported. More details can be found on this page under the section: Database Cloning and Dynamic Data Refresh.

Does Oracle Enterprise Manager support monitoring of hypervisors?
A: Oracle Enterprise Manager supports monitoring of Oracle VM natively and VMWare via a Blue Medora third party plug in. More details on managing physical and virtual host can be found here.

Is the metering and chargeback functionality part of the base product or does it requires an additional management pack?
A: Metering and Chargeback for Oracle Database is part of the Oracle Cloud Management Pack for Oracle Database. Metering and Charge back for guest virtual machines (VMs) and hosts are included with the base product and does not require a separate license. Read this whitepaper for more on Metering and Chargeback with Oracle Enterprise Manager.

Does Enterprise Data Governance require additional licensing?
A: Use of the Enterprise Data Governance capabilities within Oracle Enterprise Manager requires an Oracle Database Lifecycle Management Pack license.

How is the new AWR Warehouse feature different from the existing AWR report in Oracle Enterprise Manager 12c Release 3?
A: The existing AWR report in Oracle Enterprise Manager pulls AWR data from the source database and relies on the AWR retention setting of that database. This is typically only saved for 8 days. There’s been a big demand for saving this data for 30-60 days and even longer. AWR Warehouse, automates the extract of the source AWR data and loading to a warehouse database so that data can be retained without affecting the performance and storage of the source database. The reports are the same, it just allows you to dig back further in time. Read this article for more details.

Does this new release require more disk space for the AWR Warehouse? More CPU and memory?
A: Not for the OMS. The recommendation is to setup the AWR Repository in a separate database, outside of the Oracle Enterprise Manager repository database. Hosting on the same server would be fine, so long as there is sufficient memory and CPU for both instances. Read this article on AWR Warehouse for more details.

Does AWR Warehouse also support Oracle Database 10g and/or 11g AWR?
A: AWR Warehouse must be installed on Oracle Database or higher or version with the appropriate patch. It also must be an equal or higher database version of the source databases it accommodates. Check out this demo to understand AWR Warehouse. Read the AWR Warehouse documentation.

Is there a list of 3rd party technologies that can be managed by Oracle Enterprise Manager 12c?
A: Check out the Oracle Enterprise Manager Extensibility Exchange for a list of the available 3rd party plug-ins and connectors.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Friday Jan 16, 2015

Webcast: Zero to Manageability in One Hour—Build a Solid Foundation for Oracle Enterprise Manager 12c

Wednesday, January 21, 2015
1:00 p.m. EST | 10:00 a.m. PST

The goal in every Oracle Enterprise Manager 12c rollout is to take it from zero to manageability in the shortest possible time. This presentation will show you how to accomplish this feat. Oracle experts will demonstrate how to properly architect and deploy Oracle Enterprise Manager 12c, including designing a highly available and scalable environment. Through this demonstration a list of essential techniques and tips compiled from Oracle Enterprise Manager Development’s Strategic Customer Programs team will also be shared. Topics such as; users, roles, groups, templates, and incidents will be discussed, plus key architectural decisions.

By attending this webinar, you will learn how to:

  • Organize targets, notifications and users properly
  • Configure for best practices after the install is complete
  • Properly plan and architect an Oracle Enterprise Manager 12c environment

Featured Speaker: Courtney Llamas, Principal Member of Technical Staff, Oracle

Registered Now

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Thursday Jan 15, 2015

IOUG eBrief: News for the Oracle Enterprise Manager User Community

IOUG eBrief: January Edition Now Available

Check out January's issue of the IOUG eBrief featuring all the latest news and highlights from IOUG and the Oracle Enterprise Manager 12c Special Interest Group (SIG).

Read the newsletter

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Friday Jan 09, 2015

Innovating to Optimize: Creating Room in the IT budget for Initiatives that Boost Business

Read the latest Economist Intelligence Unit whitepaper called Innovating to Optimize: Creating Room in the IT budget for Initiatives that Boost Business. The paper outlines new ways executives can use technology to improve IT operational processes in order to drive innovation and optimize their business. The Economist interviews industry experts and thought leaders, revealing candid insights and new emerging trends.

Download the whitepaper

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Wednesday Jan 07, 2015

Webcast: Oracle Database 12c Performance Analysis

IOUG Webcast: Long Term and Cross-Database Performance Analysis for Oracle Databases Using Automatic Workload Repository Warehouse

Thursday, January 15, 2015
1:00 p.m. EST | 11:00 a.m. PST

The Automatic Workload Repository (AWR) feature in Oracle Database has been the standard used by DBAs to diagnose database performance problems.

In this session, you will learn about the new AWR Warehouse capability, which enables DBAs with capacity planning and performance analysis for Oracle Databases without the constraint of the retention period and without any overhead on critical databases.

Learn how AWR Warehouse can tell why performance was slow this month compared to the same period last year or give administrators an annual report of problems in your mission-critical databases.

Featured Speaker: Jagan Athreya, Senior Director of Product Management, Oracle

Registered Now

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Friday Dec 19, 2014

Business Brief: Optimize Your Database Performance - Spend Less Time Keeping the Lights on and More Time Innovating

How are you keeping up with the challenges and demands from the business? Are you able to innovate or just keeping the lights on?

Read the latest business brief on Oracle Database Performance Management to get better insight into the challenges facing IT and find out ways to overcome them.

Read the business brief.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Thursday Dec 18, 2014

IDEXX Uses Oracle Enterprise Manager for Monitoring and Provisioning

Check out the latest SearchOracle article featuring Brett Curtis, System Administrator from IDEXX Laboratories. Read how Brett outlines how IDEXX is benefiting from using Oracle Enterprise Manager to not only monitor both middleware and database systems, but use it for provisioning as well.

Read the article.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Friday Oct 24, 2014

Get Compliant with Oracle Java VM Database PSU OCT 2014 using EM12c

Check for compliance and automate patching of Oracle Database fleet using EM12c

Oracle along with its regular Quarterly Database PSU/SPU/CPU update this October 2014 released Oracle JAVA VM PSU patch, the patch is recommended to be applied to all databases in your fleet (esp. the ones that uses JAVA).  (For more information, support Note- 1929745.1 explains it in detail).
The mandate primarily is to apply the patches against the databases that use JAVAVM option. Ideally, you would need to apply it against all databases, so in case a new database is created in the ORACLE_HOME it is covered.

Oracle Enterprise Manager 12c provides support features of Compliance Management and automated Patching of databases. Using both these features you could identify the databases in your fleet that needs the patch and automate applying them.  

To get started, download the starter kit here. It contains utilities to jump start on your compliance, the kit contains a readily importable Compliance Standard and a step-by-step guide.

[Read More]

Thursday Oct 23, 2014

Oracle Enterprise Manager 12c: In-Depth Newsletter Now Available

The latest issue of the Oracle Enterprise Manager 12c newsletter is out. Read all about the latest news and information around the award winning Oracle Enterprise Manager 12c solution. This month's edition features the Oracle Application Users Group (OAUG) survey results, new study on middleware management cost reduction, and the latest details on Oracle Enterprise Manager for MySQL Database plug-in.

Read the newsletter

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Monday Oct 20, 2014

Webcast: Trouble-Free Upgrade to Oracle Database 12c with Oracle Real Application Testing

Live Webcast: October 28
9:00 a.m. PST | 12:00 p.m. EST | 4:00 p.m. GMT

Oracle Database 12c contains many new capabilities including Oracle Multitenant, in-memory column stores and much more. Oracle Real Application Testing gives you verifiable functionality and performance testing capabilities to take advantage of all the new enhancements. Combining your database upgrade with Oracle Real Application Testing assures you that your database will perform as required, whether you’re implementing an in-memory column store, consolidating to a database as a service model, or doing an in-place upgrade—join us in this webcast to learn more.

Register Now

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Sunday Sep 28, 2014

Oracle Announces Oracle Enterprise Manager for MySQL Database

To help customers simplify management of complex IT environments, Oracle is extending Oracle Enterprise Manager capabilities to MySQL databases. With this new offering, customers can manage deployments of MySQL, either on-premises or in a cloud. Existing users of Oracle Enterprise Manager can now easily add MySQL to their environments. With this capability, customers can manage their applications and technology stack, including web and departmental applications that rely on MySQL, all from a single console.

With Oracle Enterprise Manager for MySQL Database, customers can benefit from:

  • Auto-discovery of MySQL targets
  • Availability monitoring
  • Configuration and metrics collection
  • Performance dashboards
  • Configurable thresholds

Watch the Demo:

MySQL Enterprise Edition customers can download Oracle Enterprise Manager for MySQL Database, Release 5.5 and higher, which is available on Oracle Linux and other Linux distributions, Microsoft Windows, and Oracle Solaris. Watch the demo for more details.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Wednesday Sep 17, 2014

Stay Connected at Oracle OpenWorld

Follow Oracle Enterprise Manager 12c @ Oracle OpenWorld

If you are planning to attend OpenWorld this year, make sure you maximize the full conference experience—stay connected to all the Oracle Enterprise Manager 12c activities.

For the complete list of OpenWorld events and activities, read the Oracle Enterprise Manager 12c Focus on Doc.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Tuesday Sep 16, 2014

Oracle OpenWorld: Oracle Enterprise Manager 12c General Session

Heading to Oracle OpenWorld?

Be sure to check out the Oracle Enterprise Manager 12c general session, Drive the Future of Self-Service IT with Oracle Enterprise Manager 12c [GEN8250].

Session Abstract:

Successful strategies for cloud computing and self-service IT demand a unified management solution that provides visibility, insight, and control across the IT landscape. In this session, key representatives from Oracle Enterprise Manager Product Development will discuss customer and partner experiences in deploying and managing large-footprint private cloud environments encompassing Oracle Applications, Oracle Fusion Middleware, Oracle Database, and Oracle Engineered Systems. In the second part of the session, attendees will get a sneak preview of several exciting new offerings in the Oracle Enterprise Manager family. Don’t miss this opportunity to glimpse the future of Oracle’s systems management offerings.

For the complete list of OpenWorld sessions, demos and hands-on labs, read the Oracle Enterprise Manager 12c Focus on Doc for more.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Monday Sep 15, 2014

The Countdown is on—12 Days to Go!

Oracle Enterprise Manager 12c @ Oracle OpenWorld 2014

Oracle Enterprise Manager 12c, in its fourth year, has seen record levels of customer adoption. We are excited to showcase many of these customers throughout our OpenWorld activities, sessions, hands-on labs and DEMOgrounds this year.

With Oracle Enterprise Manager's large presence at OpenWorld, we've provided a variety of resources that you can use to follow all the Oracle Enterprise Manager activities and events.


  • Unprecedented number of customer sessions with over 50 presenting or co-presenting this year.
  • Full-day track on Oracle Enterprise Manager 12c at the Sunday User Group Forum sponsored by the IOUG.
  • General Session and over 40 Oracle-authored track-sessions on Oracle Enterprise Manager.
  • 19 Dedicated Oracle Enterprise Manager demopods in the Oracle DEMOgrounds.
  • 13 Oracle Enterprise Manager 12c hands-on labs providing deep-dive experience led by Oracle experts.

For the complete list of sessions, demos and hands-on labs, read the Oracle Enterprise Manager 12c Focus on Doc for more.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Tuesday Sep 09, 2014

Express Scripts Automates IT with Oracle Enterprise Manager

Express Scripts, the largest pharmacy benefit management organization in the United States, automates its database services using Oracle Enterprise Manager's centralized management solution. Watch the video.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Wednesday Aug 27, 2014

Demo: Consolidation Planner

Oracle Enterprise Manager 12c Consolidation Planner is a great tool that helps you plan and consolidate multiple targets on to a single machine such as Oracle Exadata. This solution helps you visualize what you have running in your environment and where you can take advantage of consolidation in order to maximize resources and lower IT operational costs. Watch the demo below to get a better understand of how Consolidation Planner works.

Want to learn more, read the Consolidation Planner documentation.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Tuesday Aug 26, 2014

Q&A: Oracle's Andrew Sutherland on Managing the Entire Oracle Stack with Oracle Enterprise Manager 12c

As senior vice president of middleware for Oracle in Europe, Dr. Andrew Sutherland has more than 20 years’ experience in emerging technologies and their application to business problems. Currently, he manages a team of architects, business development managers, and technical specialists who help customers make the best use of their investments in Oracle technologies.

Given his breadth and depth of experience, we decided to ask Sutherland how Oracle Enterprise Manager 12c Release 4 is helping the Oracle customers he works with.

Q. What makes Oracle Enterprise Manager 12c different from competitors' offerings?
A. Oracle Enterprise Manager's approach is unique in that it manages across the entire Oracle stack, from applications, middleware, and the database all the way down to servers and storage. That means it can truly unlock the value of the entire Oracle stack.

Q. What is the payoff for organizations that adopt such a comprehensive approach?
A. Our customers are able to manage the entire Oracle estate in the most cost-effective way possible by automating many of their day-to-day tasks. To give you an idea of its scope, many of our customers have made sure that Oracle Enterprise Manager 12c’s dashboard is available to their senior IT management team. They use it to ensure that all parts of their IT stack are delivering what they should be delivering, when they should be delivering it.

Perhaps most important of all, Oracle Enterprise Manager 12c enables organizations to move beyond the old paradigm of multiple independent IT stacks to offer infrastructure as a service and platform as a service.

Q. As someone who helps customers make the most of their investment in Oracle technology, what do you find most promising about Oracle Enterprise Manager 12c Release 4?
A. There are three key areas that are especially exciting. First, it provides an accelerated path to the cloud. Whether you are building a small, medium, or large private cloud within your organization, it provides the tools you need to make it happen, from designing the cloud to provisioning and testing.

Secondly, this release provides monitoring and management tools that go both deeper into the stack and wider across components within the stack. That means an even more comprehensive dashboard.

Finally Oracle Enterprise Manager 12c Release 4 offers true enterprise-grade management. With the growth of social and mobile connectivity, the need for a highly performant and robust stack is more prominent than ever. And Oracle Enterprise Manager 12c is there to do exactly that: manage true, enterprise-grade IT deployments.

Q. What should Oracle customers do if they want to learn more about the latest release of Oracle Enterprise Manager 12c?
A. First, speak to your Oracle contact, whether it is a partner or Oracle representative, to get more complete information. Also consider coming to an Oracle Day event in your area, especially if you can attend one dedicated to cloud computing. And in the meantime, you can always head to the Oracle Enterprise Manager pages on oracle.com to get started.

Find out more about Oracle Enterprise Manager 12c Release 4.

Watch a short video featuring Sutherland.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Monday Aug 25, 2014

Aramark Streamlines IT with Oracle Enterprise Manager

Aramark, a global leader in the food services industry, facilities management, and uniform services business, delivers world-class application SLAs consistently using Oracle Enterprise Manager.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Wednesday Aug 20, 2014

Oracle OpenWorld 2014 Preview: Don't-Miss Sessions, Hands-on Labs, and More

Check out all the latest Oracle Enterprise Manager 12c sessions at this year's Oracle OpenWorld. Organizers of the event, taking place in San Francisco from September 28 to October 2, expect heavy turnout at sessions, hands-on labs, and customer panels devoted to Oracle Enterprise Manager 12c. Find out who is participating and which sessions are most recommended by the Oracle Enterprise Manager team.
Read More

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Wednesday Aug 13, 2014

Oracle Enterprise Manager 12c Wins 2 DBTA Readers’ Choice Awards

In the first annual 2014 Readers’ Choice Awards, Database Trends and Applications (DBTA) magazine announced that Oracle Enterprise Manager 12c has won two awards for "Best Database Administration Solution" and "Best Database Performance Solution."

More than 22,000 votes were cast across 31 different database categories, from Best Relational Database to Best Database Appliance, DBTA called the contest a tight race and was "often neck and neck" between nominees.

"Oracle has a longstanding commitment to superior manageability for our products. Oracle Enterprise Manager's continued success and innovations in providing the leading solution for managing Oracle Database is a prime example of this commitment. These awards are a further testament to the importance customers place on Oracle Enterprise Manager." says Moe Fardoost, Senior Director, Product Marketing for Oracle Enterprise Manager.

You can see the complete list of winners here: Database Trends and Applications magazine—2014 Readers’ Choice Awards

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Wednesday Jul 30, 2014

Reducing Downtime While Patching Multi-OMS Environments

Enterprise Manager has now been released for a few weeks, as well as the OMS Bundle patches (also known as System patches). If you plan to apply these bundle patches to your OMS, and you are concerned about the downtime, then, you can reduce the downtime by referring to this whitepaper that contains patching instructions to reduce downtime. 

This whitepaper covers various Enterprise Manager High Availability (EM HA)  usecases (level 1, 2, 3, 4), and contains instructions on how to reduce downtime while applying patches to each of these usecases. It also clearly defines the steps that require downtime and those that do not.

If you have a multi-OMS setup, you can also refer to this whitepaper which covers script creation using the opatchauto command, which automates the substeps and further reduces downtime.During our internal testing of this whitepaper on an EM HA setup, we have noticed a significant reduction in downtime. 

If your customer plans to do an Enterprise Manager Upgrade to, then as a post upgrade recommendation, they should patch their OMS with the latest bundle patches by following the instructions outlined in this whitepaper.

White paper on OTN:

MOS note for the latest Bundle Patches:
Enterprise Manager (PS3) Master Bundle Patch List (Doc ID 1900943.1)

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Tuesday Jun 17, 2014

EM12c Release 4: Job System Easter Eggs - Part 2

This is part 2 of my two part blog post on Job System Easter Eggs (hidden features). The two features being covered are:

  1. New Job progress tracking UI
  2. Import/Export of job definitions

In the previous post, I talked about the new UI while in this post I will cover import and export for job definitions. 

2.  Import/Export of job definitions

The ability to export and import job definitions across EM environments has been a popular enhancement request for quite some time. There are 3 primary drivers:

  • Test to Production: Moving active and library job definitions from test site to production
  • Migration: Move job definitions across EM versions. This is often used as an alternative to upgrade.
  • As Failsafe: For that extra protection, in addition to repository backups. This can be useful for selective restoration of job definition.

In the first iteration, we are exposing these functions as emcli verbs.  Since these emcli verbs are not formally supported in the release, no documentation is included in the EMCLI Reference Guide. So to learn more about them, we will have to look at emcli help. The two verbs are called export_jobs, and import_jobs.

>> ./emcli help | grep _jobs

Some salient points about the import & export verbs are.


  • Rich filter criteria to form the list of jobs to export
  • Active and Library jobs can be exported
  • Preview mode, to view results before exporting them
  • Job definitions are exported as zip files for ease of transfer
  • Contextual information like targets, credentials, access settings, etc is exported, but not imported. In future, we may be able to support import for this information as well.
  • System jobs and nested jobs are not exported


  • Special Preview mode to view contents of the exported file, and to determine possible conflicts during import
  • Rich filter criteria to selectively import job definitions from the exported file
  • Job definitions are imported to the library ONLY. This is true even if an active job was exported
  • Two failure modes - skip on error, and rollback on error
  • Import only works on same or higher version of EM12c. The patch set number matters.

Export Job Definitions

Let's walk through an example.

1. We start with export_jobs. The help for this verb will show you all the available options. Most of the filters are self explanatory, so i will skip the explanation. The most important option of all is the -preview flag. This when used in conjunction with other filters, will show results without exporting the job definitions.

>> ./emcli help export_jobs

emcli export_jobs
   [-name="job name1;job name2;..."]
   [-type="job type1;job type2;..."]
  -export_file=<Zip filename that will be created>"

2.  Now lets play with this verb. If we invoke the verb with just the -preview flag, it will list all job definitions that can be exported both that are active, and from the library. Note: system jobs and nested jobs are skipped from this output.

>> ./emcli export_jobs -preview

Not all job types are exportable. To determine the list of job types supported via the import and export verbs, use the get_job_types verb.

>>  ./emcli get_job_types

Currently, there are over 50 job types supported, and this list will continue to grow with every release.

3. From the list above, I am primarily interested in jobs that are created by the user AFULAY. So I apply the -owner filter.

>> ./emcli export_jobs -owner=AFULAY -preview

In this output i see 2 jobs, 'Library Job' which is a simple OS command job stored in the job library, while the 'Test Job' is an active OS command job scheduled against a bunch of targets.

Note: if multiple options are specified, like -name and -owner, then these are ANDed together.

4. Since i am the lazy kind, i would rather export every thing and then later decide what i wish to import. So here it goes. The -export_file option takes the location and file name for the export file. Note the actual output file is an xml that contains job metadata, but the export file is always archived and stored in a zip format. At this time, I am sure most would instinctively unzip the file and start perusing through its contents, but doing so would be analogous to removing the warranty void sticker of your new TV or Blue Ray player. Basically, attempts to manually modify the contents of the exported zip file is highly discouraged.

>> ./emcli export_jobs -export_file=/tmp/afulay_alljobs.zip

Note how the status column reports success or failure for each job being exported. With the file exported, we now move on to the import verb.


Import Job Definitions

In the previous section, we exported a file with all job definitions in it. Now lets say we share this file with bunch of other admins and ask them to import whatever job definitions that make sense or are relevant to their environment.

1. To understand the capabilities of the import verb, we take a look at the help content.

>> ./emcli help import_jobs

emcli import_jobs
   [-name="job name1;job name2;..."]
   [-type="job type1;job type2;..."]
   -import_file=<Zip filename that contains job definitions>"

 Most of the options are quite similar to export_jobs barring a few. The -force flag allows the admin to update an existing job definition. Typically, you will run into these situations when a conflicting job is found in the new environment, and you want to either update its definition with the new version in the import file or overwrite the localized changes. The -stoponerror flag, when specified, will stop the import process on first encountered failure, and then rollback all jobs imported in the session. We will likely change this label to rollbackonerror to correctly represent its behavior. The default behavior is to skip failed jobs and continue importing others.

2. Before our admins import job definitions, they first need to view the contents of the exported file. This again can be done using the -preview option.

>> ./emcli import_jobs -preview -import_file=/tmp/afulay_alljobs.zip

The -preview option in the import verb is very special. It not only just lists the contents of the exported file, but also connects to the new EM environment and looks for potential conflicts during import. So this is a deep validation test. As seen in the above screenshot, there are two sections in the output, first is just a listing of all job definitions from the import file, while the second is a list of all conflicts. Note: for demo sake, i am exporting and importing to the same EM site, and hence every job shows up as a conflict. To address this issue, i will eventually delete the 'Library Job' from my job library, and import it from the import file.


In the interest of full disclosure, i should mention that there are few known bugs for the import verb, hence the rationale for not releasing these verbs formally with EM12c R4. Some bugs i ran into when writing this blog were:

  • you cannot export an active job, delete it, and import it back to the same EM environment, this currently is only possible with library jobs.  This is an obscure case though.
  • The -force flag is a little flaky, so sometimes it wouldn't force import even if you want it to
  • The -owner flag does not work on the import file, it instead will throw an exception

That said, when the job does get imported, it does so properly, so there is never any risk of metadata corruption.

3. If i try to import the 'Library Job', the verb will fail and give me an error message.

>> ./emcli import_jobs -name='LIBRARY JOB' -import_file=/tmp/afulay_alljobs.zip

The Status column reports Error, while the Notes column gives the reason as 'job already exists'.

4. Now lets delete the library job and try to import it.

>> ./emcli delete_library_job -name='LIBRARY JOB'

>> ./emcli import_jobs -name='LIBRARY JOB' -import_file=/tmp/afulay_alljobs.zip

Success!!We were able to delete the library job, and import it back from the import file.

In summary, there two very useful enhancements made in EM12c R4. Unfortunately, due to time constraints and our inability to meet the set quality standards, we decided to ship these features in disabled state. This ensures that production sites and users are not impacted, while still giving the few brave souls the opportunity to test these features. In my assessment, i have found the new UI to be fairly robust as i have been using this exclusively for a while. On the other hand, there are few known bugs with the import and export emcli verbs, so use these with caution.

-- Adeesh Fulay (@adeeshf)  


Latest information and perspectives on Oracle Enterprise Manager and Oracle Management Cloud.

Related Blogs


« November 2015