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 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
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.
Assists with In-Memory
for tables, partitions and sub-partitions for a given In-Memory size
and performance data to prioritize objects
Takes into account
differences in disk and memory footprint, as well as compression ratios
estimated memory size with various compression options
estimated database time reduction metrics for workload processing
Ability to vary
In-Memory size to receive specific loading plan
scripts with all the tables/partitions/sub-partitions recommended
Wednesday February 25, 2015
8:00 a.m. PST | 11:00 a.m. EST
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.
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.
Courtney Llamas and David Wolf
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
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
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.
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.
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.
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
for more details.
new release require more disk space for the AWR Warehouse? More CPU
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.
AWR Warehouse also support Oracle Database 10g and/or 11g AWR?
A: AWR Warehouse must be installed on Oracle Database 220.127.116.11 or higher
or version 18.104.22.168 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
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
for best practices after the install is complete
plan and architect an Oracle Enterprise Manager 12c environment
Courtney Llamas, Principal Member of Technical Staff, Oracle
Webcast: Long Term and Cross-Database Performance Analysis for Oracle Databases
Using Automatic Workload Repository Warehouse
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
Jagan Athreya, Senior Director of Product Management, Oracle
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.
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.
9:00 a.m. PST | 12:00 p.m. EST | 4:00 p.m. GMT
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.
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.
Oracle Enterprise Manager for MySQL Database, customers can benefit from:
to check out the Oracle Enterprise Manager 12c general session,
Drive the Future of Self-Service IT with Oracle Enterprise Manager
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.
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
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
Scripts, the largest pharmacy benefit management organization in the United
States, automates its database services using Oracle Enterprise Manager's
centralized management solution. Watch
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.
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.
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
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
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.
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
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"
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.
Service Catalog for Database and Middleware as a Service; Enhanced Database
and Middleware Management Help Drive Enterprise-Scale Private Cloud Adoption
IT organizations are adopting private clouds as a stepping-stone to business-driven,
self-service IT. Successful implementations hinge on the ability to efficiently
deploy and manage cloud services at enterprise scale. Having a complete
cloud management solution integrated with an enterprise-class technology
stack is a fundamental requirement for IT. Oracle
Enterprise Manager 12c Release 4 meets that requirement by
helping businesses become more agile and responsive, while reducing cost,
complexity, and risk.
provide advanced technology stack management, secure database administration,
and enterprise service governance, enabling Oracle customers and partners
to maximize database and application performance and drive innovation
using self-service IT platforms.
have been driven by customers and the growing Oracle
Enterprise Manager Ecosystem, comprised of more than 750 Oracle
PartnerNetwork (OPN) Specialized partners. Oracle and its partners
and customers have built over 140 plug-ins and connectors for Oracle
Manager 12c Release 4 allows for a rapid enterprise-wide adoption
of database, middleware and infrastructure services in the private cloud,
driven by an enhanced API-enabled service catalog.
The release features
“push button” style provisioning of complete environments
such as SOA and Oracle Active Data Guard, and fast data cloning that
enables rapid deployment and testing of enterprise applications.
capabilities to detect data and configuration vulnerabilities provide
enhanced cloud service governance along with greater operational control
through a flexible and extensible showback mechanism.
A new performance
warehouse enables predictive database diagnostics and trend analysis
and helps identify database problems before they occur.
data-governance capabilities enhance security by helping systematically
discover and protect sensitive data.
of upgrades with the ability to rollback changes enables faster adoption
of Oracle Database
A new consolidated
view of Oracle
Fusion Middleware 12c deployments with a guided management
capability lets administrators apply best management practices to diverse
middleware environments and identify performance issues quickly.
A Java VM Diagnostics
as a Service feature allows governed access to diagnostics data for
IT workers across multiple disciplines for accelerated DevOps resolutions
of defects and performance optimization.
New automated provisioning
for SOA lets middleware administrators perform mass SOA provisioning
and preferred credentials have been added to Oracle Enterprise Manager
to provide additional fine-grained security for organizations with complex
access control requirements.
A new security
console provides a single point of control for managing the security
of Oracle Enterprise Manager environments.
Support for the
latest industry standard SNMP v3 protocol, including encryption, enables
more secure heterogeneous management.
adapts to observed environmental changes and adds self-management capabilities
to help Oracle Enterprise Manager run at peak performance, while demanding
less IT supervision.
Livermore National Laboratory has a strong tradition of technology breakthroughs
and leadership. As a member of Oracle’s Customer Advisory Board
for Oracle Enterprise Manager, we have consistently provided feedback
and guidance in the areas of enterprise-scale cloud, self-diagnosability,
and secure administration for the product,” said Tim Frazier,
CIO, NIF and Photon Sciences, Lawrence Livermore National Laboratory.
“We intend to take advantage of the Release 4 features that support
enterprise-scale availability and fine-grained security capabilities
for private cloud deployments.”
recent CloudTrack survey shows that most enterprises plan to adopt hybrid
cloud architectures over the next three years,” said Mary Johnston
Turner, Research Vice President, Enterprise System Management Software,
IDC. “These organizations plan to deploy a wide range of workloads
into cloud environments including mission critical database and middleware
services that require high levels of fault tolerance and disaster recovery.
Such capabilities were traditionally custom configured for each application
but cloud offers the possibility to incorporate such properties within
the service definition, enabling organizations to adopt cloud without
compromise. With the latest release of Oracle Enterprise Manager 12c,
Oracle is providing customers with an out-of-the-box experience for
delivering highly-resilient cloud services for databases and applications.”
inception, Oracle has been leading the way in innovative, scalable and
high performance solutions for the enterprise. With this release of
Oracle Enterprise Manager, we are extending this leadership by providing
enterprise-scale capabilities for planning, delivering, and managing
private clouds. We call this ‘zero-to-cloud – accelerated.’
These enhancements help our customers to expedite their adoption of
cloud computing and prepares them for the next generation of self-service
IT,” said Prakash Ramamurthy, senior vice president of Systems
and Cloud Management at Oracle.
Author: Eunjoo Lee, Principal Product Manager, Oracle
Oracle Enterprise Manager Applications Management team is pleased to announce
the release of their latest whitepaper (available here)
and associated screenwatch (available here)
on configuration management for Siebel.
task of managing configuration parameters in a dynamic, multi-target environment
can be extremely challenging. A large, production scale environment can
have dozens of unique targets, and each target can have several hundred
different configuration parameters.
Enterprise Manager 12c, with the Siebel Plug-in, provides advanced,
out-of-the-box tools to manage the complexity of Siebel configuration
management. Oracle Enterprise Manager has advanced configuration capture,
change detection, and comparison reporting capabilities that can dramatically
reduce the amount of time that System Administrators spend on configuration
purpose of the whitepaper and screenwatch is to provide customers with
details on Oracle’s Best Practices for managing Siebel Configurations.
It addresses several key areas including;
comparison templates in Oracle Enterprise Manager
configuration templates for Siebel servers, components groups, and components
configuration templates to compare Siebel servers
of configuration comparison results
configuration templates for Siebel patch analysis
of using configuration templates to manage Siebel applications are substantial,
compare configuration parameters for targets within a Siebel Enterprise,
or between two different Siebel Enterprises
compare configuration parameters for a Siebel target against a gold
standard or baseline.
comparison reports once and re-run multiple times
this white paper and screenwatch help to provide you with a good starting
point to manage your Siebel Application configurations more efficiently
is a great article from resident Oracle ACE, Arup
Nanda, who details insight into predicting the impact of consolidating
separate database workloads into one. The article outlines a typical consolidation
scenario and explains how Oracle Real Application Testing's Consolidated
Database Replay capabilities can help measure the impact of the workload
must read for those considering a consolidation project in the near future.
10 — 7:00 a.m. PT | 10:00 a.m. ET | 4:00 p.m. CET
April 24 — 10:00 a.m. PT | 1:00 p.m. ET
May 8 — 7:00 a.m. PT | 10:00 a.m. ET | 4:00 p.m. CET
May 22 — 10:00 a.m. PT | 1:00 p.m. ET
Since the demands
from the business for IT services is non-stop, creating copies of production
databases in order to develop, test and deploy new applications can be
labor intensive and time consuming. Users may also need to preserve private
copies of the database, so that they can go back to a point prior to when
a change was made in order to diagnose potential issues. Using Snap Clone,
users can create multiple snapshots of the database and “time
travel” across these snapshots to access data from any point
Join us for an in-depth
technical webcast and learn how Oracle Cloud Management Pack for Oracle
Database's capability called Snap Clone, can fundamentally improve the
efficiency and agility of administrators and QA Engineers while saving
CAPEX on storage. Benefits include:
(~ 2 minutes to provision a 1 TB database)
Over 90% storage
overhead from integrated lifecycle management
CIO, Munhowen, explains: “Implementing Oracle Real Application Clusters,
Oracle Enterprise Manager, and Oracle ZFS Storage Appliance helped us
to significantly increase our IT environment’s availability, scalability,
and manageability—providing superior support, tailored to our business
needs, while helping us to reduce maintenance costs.” Read the