Friday Jan 08, 2016

Enterprise Manager 13c: What’s New in Database Lifecycle Management

Enterprise Manager 13c: What’s New in Database Lifecycle Management

A month back, we announced the release of Enterprise Manager 13c. Enterprise Manager 13c includes several improvements over Enterprise Manager 12c, which was itself had witnessed pretty successful adoption over the last four years. Enterprise Manager 12c rested on the key themes of enterprise grade management, stack management and cloud lifecycle management. The 13c version simply bolsters those pillars.

In the area of database lifecycle management, we have delivered some key features that span both the depth and the width of the data center. In terms of depth, it leverages the unification of hardware and software management to manage Exadata better. In terms of width, it offers simpler and more scalable cloud management. Over the next few paragraphs, I will touch upon few features that highlight the above.

Exadata Patching:

The patching of Exadata has been laborious process for our key customers. It involves multiple components across multiple nodes and often multiple administrators in the process. In Enterprise Manager 13c, some of the important hardware management features have been assimilated into the Cloud Control product. In course of developing the hardware aka the infrastructure management features, we have modeled the infrastructure target types: servers, storage, network, VMs in Enterprise Manager. This also enables us to have a more sophisticated management of Engineered Systems. For example, Enterprise Manager can now patch an Exadata stack- storage servers , Infiniband drivers, compute nodes, grid infrastructure and as before, the databases on top. The patching application offers the facility to run the pre-flight checks and monitor the logs from a single place (imagine having to manually monitor the patch execution logs for grid infrastructure, operating system, storage for all the compute and storage cells in a rack).

Enhancements in Database Compliance Management:  

There have been some significant enhancements in database compliance management. These include:

a) Integration of Oracheck: A long-standing requirement that should thrill Exadata customers is the integration of Oracheck (including Exacheck) into the Compliance framework of Enterprise Manager. Exacheck had formerly existed as a standalone utility, but customers have asked for at-scale execution over all the Exa’s in a data center, with the ability to flag, suppress or escalate any violation. They can also generate reports on overall health and share with other administrators and IT Managers.

b) Integration with corrective action: Another much sought-after feature has been to integrate the compliance violations with corrective action. For example, a DBA may want to lock an account with default username and password. Enterprise Manager 13c makes this a reality.

Configuration Drift and Consistency Management:

When it comes to managing a cloud horizontally at scale, the configuration comparison feature of Enterprise Manager has always been a DBA’s favorite. The new configuration drift management feature evolves the feature further by enabling administrators to proactively spot the “needle in the haystack” among the hundreds and thousands of members that can be a part of a cloud or even span multiple clouds (example, on-prem and Oracle Cloud). The DBA can set up a golden standard with a selected list of configuration parameters and make sure that all the members of a cloud or a pool of databases subscribe to that standard. In case of any deviation, the DBA will be automatically notified. The consistency management can be applied across the different phases of lifecycle (for example, the test database should be the same as production) or across the different members of a system (for example, all the nodes of an Exadata should be exactly alike).

Additional Info

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

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

Reporting

  • 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

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 12.1.0.2 or higher or version 11.2.0.4 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

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

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

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

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

Monday Jun 23, 2014

Patch automation of Data Guard Databases takes a leap with EM12cR4


Patching has always been one of the many joys (or dreads) of Oracle DBAs. 
The effort compounds as the Database sprawl grows and the architecture complexity increases.  Additionally,  there is an increasing pressure to patch the systems with minimal or zero downtime. EM12c's Database patch automation functionality provides  an end-to-end management starting with proactive patch recommendations (like quarterly PSUs and CPUs), complete pre-flight checker to ensure predictable patching during maintenance window and  automation for patching the comprehensive list of products under the Oracle Database family.  ( EM12c Patch Automation overview

Patching has always been one of the many joys (or dreads) of Oracle DBAs. The effort compounds as the Database sprawl grows and the architecture complexity increases. Additionally, there is an increasing pressure to patch the systems with minimal or zero downtime. 

EM12c's Database patch automation functionality provides an end-to-end management starting with proactive patch recommendations (like quarterly PSUs and CPUs), complete pre-flight checker to ensure predictable patching during maintenance window and  automation for patching the comprehensive list of products under the Oracle Database family.  ( EM12c Patch Automation overview)

With the introduction of "Out of Place" patching in EM12c, the automation feature got a complete overhaul. Over the past 3 years I have seen customers moving to this mode to achieve their automation goals.  ( What is Out of Place?)

Patching Data guard environments (read as Primary and its corresponding Standby Databases) has always been a challenging task for the DBAs. 
In addition to handling the differences in steps needed for the configuration, the very nature of its distributed environment and incorporating any additional custom tasks makes it more demanding. Till now in EM we only supported automation in disparate steps and in “In Place” mode.

Starting 12.1.0.4 (EM12c R4), the support is enhanced to be more tighter, can be done in 'Out of Place' mode, and has new supplemental features to manage the process along with its additional tasks.

In this post we will take a closer look of the data guard stand by patching feature and then dive into a use case, you could try out in your environment.

[Read More]

Tuesday Jun 03, 2014

Oracle Delivers Latest Release of Oracle Enterprise Manager 12c

Richer Service Catalog for Database and Middleware as a Service; Enhanced Database and Middleware Management Help Drive Enterprise-Scale Private Cloud Adoption

News Summary
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.

News Facts

  • Oracle Enterprise Manager 12c Release 4, available today, lets organizations rapidly adopt Oracle-based, enterprise-scale private clouds.
  • New capabilities 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.
  • The enhancements 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 Enterprise Manager.
  • Watch the video highlights.

Automation for Broader Cloud Services

  • Oracle Enterprise 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.
  • Out-of-the-box capabilities to detect data and configuration vulnerabilities provide enhanced cloud service governance along with greater operational control through a flexible and extensible showback mechanism.

Enhanced Database Management

  • A new performance warehouse enables predictive database diagnostics and trend analysis and helps identify database problems before they occur.
  • New enterprise data-governance capabilities enhance security by helping systematically discover and protect sensitive data.
  • Step-by-step orchestration of upgrades with the ability to rollback changes enables faster adoption of Oracle Database 12c.

Expanded Fusion Middleware Management

  • 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 with ease.

Superior Enterprise-Grade Management

  • Private roles 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.
  • “Smart monitoring” adapts to observed environmental changes and adds self-management capabilities to help Oracle Enterprise Manager run at peak performance, while demanding less IT supervision.

Supporting Quotes

  • “Lawrence 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.”
  • “IDC's most 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.”
  • “Since its 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.

Supporting Resources

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

Thursday May 15, 2014

Whitepaper: Best Practices for Managing Siebel Configurations

Contributing Author: Eunjoo Lee, Principal Product Manager, Oracle

The 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.

The 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.

Oracle 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 management.

The 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;

  • Understanding comparison templates in Oracle Enterprise Manager
  • Creating configuration templates for Siebel servers, components groups, and components
  • Using configuration templates to compare Siebel servers
  • Analysis of configuration comparison results
  • Using configuration templates for Siebel patch analysis

The benefits of using configuration templates to manage Siebel applications are substantial, and include:

  • Easily compare configuration parameters for targets within a Siebel Enterprise, or between two different Siebel Enterprises
  • Easily compare configuration parameters for a Siebel target against a gold standard or baseline.
  • Define comparison reports once and re-run multiple times

We hope this white paper and screenwatch help to provide you with a good starting point to manage your Siebel Application configurations more efficiently and pro-actively.


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

Tuesday Apr 08, 2014

Consolidated Database Replay: Playing Nice Together

Here 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 consolidation. A must read for those considering a consolidation project in the near future. Read the article.


Database work load patterns of two applications.


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

Friday Apr 04, 2014

Webcast: Database Cloning in Minutes using Oracle Enterprise Manager 12c Database as a Service Snap Clone

April 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 in time.

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:

  • Agile provisioning (~ 2 minutes to provision a 1 TB database)
  • Over 90% storage savings
  • Reduced administrative overhead from integrated lifecycle management

Register Now!


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

Wednesday Apr 02, 2014

Cloud Odyssey in London

The Cloud Odyssey event happened in London recently. Here is the Storify from the event. Enjoy!

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

Tuesday Apr 01, 2014

Managing Pluggable Database as a Service: Questions and Answers

Since the launch of Oracle Enterprise Manager 12c Release 3, we have received tons of questions around managing Oracle Multitenant, an Oracle Database 12c Enterprise Edition option, and pluggable databases (PDBs)—more specifically; questions about pluggable database as a service (PDBaaS). In this blog, we provide answers to some of the common questions from people.

Question: What qualifies a database to be pluggable?
Answer: A pluggable database must be a current Oracle Database 12c database, configured for multitenant through a new enterprise edition option called Oracle Multitenant. It delivers a new architecture that allows a multitenant container database (CDB) to hold many pluggable databases (PDBs). An Oracle Database in the old architecture (a “non-CDB”) may be upgraded to the multitenant architecture via a simple process known as “adopting the non-CDB as a PDB”. A PDB is a self-contained, fully functional Oracle Database, and includes its own system, sysaux and user tablespaces. You can learn more about Oracle Multitenant and pluggable database in this whitepaper.

Can the pluggable databases be plugged and unplugged across multiple platforms such as Solaris, AIX, and Linux?
The pluggable database must be endian compatible. Cross endian operations require OGG, Data pump or restore from backup.

In terms of database consolidation, what are the differences between using VMs, dedicated schemas and pluggable databases?
To describe the advantages of using pluggable database vs. other consolidation methods, it can be best illustrated in a simply comparison table.


Comparison of Database as a Service Consolidation Models

Pluggable database combines the best of all the other models and offers excellent consolidation, isolation, manageability and is suitable for any application that is certified to run on Oracle Database 12c. With the other models, we see certain shortcomings. For example, server virtualization offers good isolation but creates compliance and administrative headaches. Schema based consolidation offers ease of management and patching, but limited isolation.

How do you track configuration drift with a pluggable database? I certainly understand drift in the container database, but in what ways would a pluggable database drift from its standard baseline?
This pertains to Configuration Drift Tracking via Oracle Enterprise Manager 12c. One can compare any two Enterprise Manager targets or a complete system such as an Oracle Exadata Database Machine. When you compare at the PDB level, they can differ in the tablespace names, the storage settings of tablespace with same name, or users, etc. Using Oracle Enterprise Manager to track drift, it is particularly useful in comparing difference in your development, testing, and production environments. It is even useful for comparing your standby systems to set standards for compliance requirements.

What is a zone? Is it physical? Regional?
The Oracle Enterprise Manager 12c Cloud resource model involves pooling the same target types where it’s combining similar hosts, databases, hardware or other similar resources in to a zone. Zones can therefore be defined by the boundary of the Cloud and exposed through Oracle Enterprise Manager 12c’s self-service portal. In terms of the pluggable database as a service model, you can create Oracle Multitenant container databases and group them to form a database pool that users can then draw from. When the self-service user provisions a pluggable database, they need to simply specify the Zone where they want to deploy. Internally, Oracle Enterprise Manager uses load or configuration driven algorithms to place the PDB in the right CDB.

What will be the DBA and SYSADMIN role in the pluggable DBaaS environment?
With pluggable databases you have common users and local users as well as common roles and associated privileges and local roles and associated privileges. You can isolate user/role/privilege to the PDB by defining only local user/role/privilege. To leverage the manage many as one, you would define common user/role/privilege to act on all PDBs or a subset of PDBs where the common user has create session privileges within the PDB. You would define DBA roles and SYSADMIN roles based on common and/or local user roles.

What if you need custom configurations on a pluggable database? Once the database is deployed via self-service how do you make changes?
Some parameters are modifiable at the PDB level. You would check v$parameter ISPDB_MODIFIABLE value to determine what can be changed. Some customization can be done at the CDB level; however, they would affect all PDBs for that CDB. Oracle Enterprise Manager’s self-service provides a TNS Connect string to connect to the PDB with the right privilege and execute “ALTER SYSTEM” for the parameters that are permissible to change.

If I'm an application developer and I request a database with a certain pre-defined service level, what level of permissions should I expect with that database? Am I getting DBA or SYSDBA privileges with that request?
It depends on what was negotiated as part of the service definition and associated user/role/privileges defined for that service.

Are the pluggable database as a service capabilities for Oracle Database 12c included in Oracle Enterprise Manager 12c? Do we need a plug-in? Do we need to license Oracle Enterprise Manager 12c Database Management Packs?
You need the Oracle Enterprise Manager 12c database and cloud plug-ins. License-wise; the self-service provisioning from Oracle Enterprise Manager is licensed as part of Cloud Management Pack for Database. The Oracle Multitenant option must be licensed if two or more PDBs are plugged into a single CDB.
Watch this short demo called “Using Pluggable Database as a Service (PDBaaS) Self-Service Portal” for a better understanding of deploying PDBaaS using Oracle Enterprise Manager 12c.

Which Oracle Enterprise Manager 12c Management Packs are required to be able to provide DBaaS?
You need the Oracle Enterprise Manager 12c Cloud Management Pack for Database and Oracle Enterprise Manager 12c Lifecycle Management Pack for Database to do database as a service. Both of which must be licensed.

If you have shared memory and background processes in the container database, how do you allocate server resources to a particular pluggable database? Can you assign specific amount of CPU cycles, RAM and IOPS for a given pluggable database?
SQL execution is scoped to the PDB as identified by the con_id created during session create. In Oracle Database 12c, Resource Manager (RM) has been extended to include support for Oracle Multitenant. Policies may be defined at the PDB level in terms of the simple-yet-powerful concepts of “caps” and “shares” to determine the allocation of resources between PDBs. In this way, resource manager can control allocation of CPU, sessions and parallel execution servers. Additionally, on Oracle Exadata, Resource Manager can also manage IO and network. Memory management currently is implicitly managed through SGA LRU algorithms and CPU share management.

What is the largest number of pluggable databases you can deploy on Oracle Exadata?
Currently the PDB limit per CDB is 252 PDBs. In Oracle Real Application Clusters environments such as Oracle Exadata, the density of PDB consolidation greatly increases as you may have multiple CDBs per physical server and 252 PDBs per CDB. The maximum limit would be bound by compute resource constraints/limits. And as mentioned in the question on Zone, Oracle Enterprise Manager gives an ability to combine multiple CDBs into a Pool and handle transparent placement. The Oracle Enterprise Manager self-service user therefore won’t be exposed to the underlying limit.

Can I use pluggable database as a service if the target database is 9i or 10g?
You would need to migrate the Oracle Database 9i, 10g and 11g databases to Oracle Database 12c non-CDB and convert them into pluggable databases. The architectural changes within Oracle Database 12c are not backward compatible.

Can Active Data Guard be configured for selective pluggable databases from a container database? I do not want all pluggable databases to have a standby.
In the current release, Oracle Active Data Guard operates at the container level, however, PDB annotations are tagged in the redo stream, so PDB operations on the primary are reflected on the standby.

Does RMAN support pluggable databases?
Scheduled backups are at the CDB layer and include all PDBs. Ad-hoc backups can be executed on individual PDBs. Individual PDBs can be restored from backup.

For complete details of managing pluggable database as a service, be sure to watch this webcast: Delivering Pluggable Database as a Service

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

Monday Mar 31, 2014

Munhowen to Reduce Maintenance Costs and TCO by More Than 50 Percent

Munhowen, a leading Luxembourg beverage distributor, decided to replace its existing IT environment. By selecting Oracle technology, including Oracle Real Application Clusters, Oracle Enterprise Manager, Oracle Linux and Oracle ZFS Storage Appliances, the company was able to enhance system performance and reduce maintenance costs associated with sustaining an optimal hardware environment.

Jean-Pierre Rasquin, 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 press release.

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

Latest information on Oracle Enterprise Manager and Oracle Management Cloud.

Related Blogs




Search

Archives
« June 2016
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