Thursday Oct 25, 2012

WEBCAST: Strategies for Managing the Oracle Database Lifecycle


Thursday November 1
10:00 a.m. PST / 1:00 p.m. EST

Join us for a live Webcast and see how Oracle Enterprise Manager 12c makes database lifecycle management easier. You’ll learn how to:

  • Simplify database configurations thanks to extensive automation for discovery and change detection
  • Improve IT service levels with Oracle’s next-generation database patching and provisioning automation
  • Ensure consistency and compliance with comprehensive database change management
Register today.


Stay Connected:

Twitter |
Facebook | YouTube | Linkedin | Newsletter

Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Tuesday Oct 09, 2012

Private Cloud: Putting some method behind the madness

Finally, I decided to join the blogging community. And what could be a better time to start than the week after OpenWorld 2012. 50K+ attendees, demonstrations, speaker sessions and a whole lot of buzz on Oracle Cloud..It was raining clouds in this year's Openworld. I am not here to write about Oracle's cloud strategy in general, but on Enterprise Manager's cloud management capabilities. This year's Openworld was the first after we announced the 12c Cloud Control and we were happy to share the stage with quite a few early adopters. Stay tuned for videos from our customers and partners, I will post them as they get published.

I met a number of platform administrators in Oracle-DBAs, Middleware Admins, SOA Admins...The cloud has affected them all, at least to the point where it beckoned more than just curiosity..Most IT infrastructure are already heavily virtualized (on VMWare and on others including Oracle VM), and some would claim they are already on “cloud” (at least their Sysadmins told them so). But none of them were confident of the benefits because their pain points continued to grow.. Isn't cloud supposed to ease those? Instead, they were chasing hundreds of databases running on hundreds of VMs, often with as much certainty propounded by Heisenberg. What happened to the age-old IT discipline around administration, compliance, configuration management?

VMs are great for what they are. I personally think they have opened the doors to new approaches in which an application stack gets provisioned and updated. In fact, Enterprise Manager 12c is possibly the only tool out there that can provision full-fledged application as VM Assemblies. In this year's Openworld, customers talked on how they provisioned RAC and Siebel assemblies, which as the techies out there know, are not trivial (hearing provisioning time for Siebel down from weeks to hours was gratifying indeed). However, I do have an issue with a "one-size fits all" approach to cloud. In a week's span, I met several personas:

  • Project owners requiring an EC2 like VM instance for their projects

  • Admins needing the same for Sparc-Solaris.

  • DBAs requiring dedicated databases for new projects

  • APEX Developers needing just a ready-to-consume schema as a service

  • Java Developers looking for a runtime platform

  • QA engineers needing a fast clone of their production environment

If you drill down further, you will end up peeling more layers of the details. For example, the requirements for Load testing and Functional testing are very different. For Load testing the test environment should ideally be the same as the production. You shouldn't run production on Exadata and load test on a VM; they will just not be good representations of one another. For Functional testing it does not possibly matter.

DBAs seem to be at the worst affected of the lot. It seems they have been asked to choose between agile provisioning and  faster runtime performance. And in some cases, it is really a Hobson's choice, because their infrastructure provider made no distinction between the OLTP application and the Virtual desktop! Sad indeed.

When one looks at the portfolio of services that we already offer (vanilla IaaS, VM Assembly based PaaS, DBaaS) or have announced (Java PaaS, Instant Cloning, Schema-aaS), one can possibly think that we are trying to be the "renaissance man" ! Well I would have possibly digested that had it not been for the various personas that I described above.

Getting the use cases right is very important for an application such as cloud management. We iterate and iterate over these over and over again and re-validate them in CABs (Customer Advisory Boards). We consider over the major aspects of tenancy: service placement, resource isolation (can a tenant execute an expensive SQL and run away with all the resources), quota and security. We, in Engineering, keep reminding ourselves that we are dealing with enterprise clouds. We owe it to our customer base !

In the coming posts, I will drill down more into each of the services. In the meanwhile, here are some collateral and  demos for starters with EM 12c.

http://www.oracle.com/technetwork/oem/cloud-mgmt/index.html

Sudip Datta

The views expressed here are my own and do not necessarily reflect the views of Oracle.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Tuesday Oct 02, 2012

Today at Oracle OpenWorld 2012

We have another full day of great Oracle OpenWorld keynotes, sessions, demos and customer presentations in the Seen and Be Heard threater. Here's a quick run down of what's happening today with Oracle Enterprise Manager 12c:

Download the Oracle Enterprise Manager 12c OpenWorld schedule (PDF)

Oracle Enterprise Manager Cloud Control 12c (and Private Cloud)

General Session

Time Title Location
11:45 AM - 12:45 PM General Session: Using Oracle Enterprise Manager to Manage Your Own Private Cloud Moscone South - 103*
1:15 PM - 2:15 PM General Session: Breakthrough Efficiency in Private Cloud Infrastructure Moscone West - 3014

Conference Session

Time Title Location
10:15 AM - 11:15 AM Oracle Exadata/Oracle Enterprise Manager 12c: Journey into Oracle Database Cloud Moscone West - 3018
10:15 AM - 11:15 AM Bulletproof Your Application Upgrades with Secure Data Masking and Subsetting Moscone West - 3020
10:15 AM - 11:15 AM Oracle Enterprise Manager 12c: Architecture Deep Dive, Tips, and Techniques Moscone South - 303
11:45 AM - 12:45 PM RDBMS Forensics: Troubleshooting with Active Session History Moscone West - 3018
11:45 AM - 12:45 PM Building and Operationalizing Your Data Center Environment with Oracle Exalogic Moscone South - 309
11:45 AM - 12:45 PM Securely Building a National Electronic Health Record: Singapore Case Study Westin San Francisco - Concordia
1:15 PM - 2:15 PM Managing Heterogeneous Environments with Oracle Enterprise Manager Moscone West - 3018
1:15 PM - 2:15 PM Complete Oracle WebLogic Server Management with Oracle Enterprise Manager 12c Moscone South - 309
1:15 PM - 2:15 PM Database Lifecycle Management with Oracle Enterprise Manager 12c Moscone West - 3020
1:15 PM - 2:15 PM Best Practices, Key Features, Tips, Techniques for Oracle Enterprise Manager 12c Upgrade Moscone South - 307
1:15 PM - 2:15 PM Enterprise Cloud with CSC’s Foundation Services for Oracle and Oracle Enterprise Manager 12c Moscone South - 236
5:00 PM - 6:00 PM Deep Dive 3-D on Oracle Exadata Management: From Discovery to Deployment to Diagnostics Moscone West - 3018
5:00 PM - 6:00 PM Everything You Need to Know About Monitoring and Troubleshooting Oracle GoldenGate Moscone West - 3005
5:00 PM - 6:00 PM Oracle Enterprise Manager 12c: The Nerve Center of Oracle Cloud Moscone West - 3020
5:00 PM - 6:00 PM Advanced Management of Oracle E-Business Suite with Oracle Enterprise Manager Moscone West - 2016
5:00 PM - 6:00 PM Oracle Enterprise Manager 12c Cloud Control Performance Pages: Falling in Love Again Moscone West - 3014

Hands-on Labs

Time Title Location
10:15 AM - 12:45 PM Managing the Cloud with Oracle Enterprise Manager 12c Marriott Marquis - Salon 5/6
1:15 PM - 2:15 PM Database Performance Tuning Hands-on Lab Marriott Marquis - Salon 5/6

Scene and Be Heard Theater Session

Time Title Location
10:30 AM - 10:50 AM Start Small, Grow Big: Hands-On Oracle Private Cloud—A Step-by-Step Guide Moscone South Exhibition Hall - Booth 2407
12:30 PM - 12:50 PM Blue Medora’s Oracle Enterprise Manager Plug-in for VMware vSphere Monitoring Moscone South Exhibition Hall - Booth 2407

Demos

Demo Location
Application and Infrastructure Testing Moscone West - W-092
Automatic Application and SQL Tuning Moscone South, Left - S-042
Automatic Fault Diagnostics Moscone South, Left - S-036
Automatic Performance Diagnostics Moscone South, Left - S-033
Complete Care for Oracle Using My Oracle Support Moscone South, Left - S-031
Complete Cloud Lifecycle Management Moscone North, Upper Lobby - N-019
Complete Database Lifecycle Management Moscone South, Left - S-030
Comprehensive Infrastructure as a Service via Oracle Enterprise Manager Moscone South, Left - S-045
Data Masking and Data Subsetting Moscone South, Left - S-034
Database Testing with Oracle Real Application Testing Moscone South, Left - S-041
Identity Management Monitoring with Oracle Enterprise Manager Moscone South, Right - S-212
Mission-Critical, SPARC-Powered Infrastructure as a Service Moscone South, Center - S-157
Oracle E-Business Suite, Siebel, JD Edwards, and PeopleSoft Management Moscone West - W-084
Oracle Enterprise Manager Cloud Control 12c Overview Moscone South, Left - S-039
Oracle Enterprise Manager: Complete Data Center Management Moscone South, Left - S-040
Oracle Exadata Management Moscone South, Center -
Oracle Exalogic Management Moscone South, Center -
Oracle Fusion Applications Management Moscone West - W-018
Oracle Real User Experience Insight Moscone South, Right - S-226
Oracle WebLogic Server Management and Java Diagnostics Moscone South, Right - S-206
Platform as a Service Using Oracle Enterprise Manager Moscone North, Upper Lobby - N-020
SOA Management Moscone South, Right - S-225
Self-Service Application Testing on Private and Public Clouds Moscone West - W-110

Oracle OpenWorld Music Festival
New this year is Oracle’s first annual Oracle OpenWorld Musical Festival, featuring some of today's breakthrough musicians from around the country and the world. It's five nights of back-to-back performances in the heart of San Francisco—free to registered attendees.
See the lineup

Not Heading to OpenWorldWatch it Live!


Stay Connected:

Twitter |
Facebook | YouTube | Linkedin | Newsletter

Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Thursday Sep 20, 2012

OpenWorld 2012—Is Almost Here!

With OpenWorld fast approaching, I thought I would take this opportunity to look at some of the “must see” database manageability activities and sessions happening this year. Here's a quick run down:

Oracle Database Manageability:
Download all the details for sessions, hands-on-labs, and demos (PDF)

Keynotes:
Sunday, September 30
Hardware and Software, Engineered to Work Together: Why It’s A Different Approach
Larry Ellison, CEO, Oracle

Monday, October 1
Shift Complexity
Hosted by Mark Hurd, President, Oracle
Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle

IOUG SIG Sunday:
Database Performance Tuning: Getting the Best out of Oracle Enterprise Manager Cloud Control 12c
(session ID# CON6511)

Oracle DEMOgrounds:
Floor plan – Moscone South

  • Automatic Application and SQL Tuning
  • Automatic Performance Diagnostics
  • Complete Database Lifecycle Management
  • Data Masking and Data Subsetting
  • Database Testing with Oracle Real Application Testing
  • Oracle Enterprise Manager Cloud Control 12c Overview
  • Oracle Exadata Management

Hands-on-Labs:
Database Performance Testing, Data Masking, and Subsetting
(session ID# HOL10720)

Database Performance Tuning Hands-on Lab
(session ID# HOL10393)

Sessions:
What’s Next for Oracle Database?
(session ID# GEN8259)

Building and Managing a Private Oracle Database Cloud
(session ID# GEN11421)

Using Oracle Enterprise Manager to Manage Your Own Private Cloud
(session ID# GEN11423)

Extreme Database Management with the Latest Generation of Database Technology
(session ID# CON9547)

Oracle OpenWorld Music Festival
New this year is Oracle’s first annual Oracle OpenWorld Musical Festival, featuring some of today's breakthrough musicians from around the country and the world. It's five nights of back-to-back performances in the heart of San Francisco—free to registered attendees.
See the lineup

Not Heading to OpenWorldWatch it Live!


Stay Connected:

Twitter |
Facebook | YouTube | Linkedin | Newsletter

Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Monday Jul 30, 2012

On-Demand Webcast: Managing Oracle Exadata's Lifecycle—Now Available

Learn from our product experts how to manage Oracle Exadata's lifecycle for extreme performance. This on-demand webcast covers:

  • Oracle Exadata discovery
  • Monitoring and managing Oracle Exadata's components
  • Deploying applications on Oracle Exadata
  • Performance diagnostics and tuning
  • Change management
Register today.


Stay Connected:

Twitter |
Facebook | YouTube | Linkedin | Newsletter

Tuesday Jul 24, 2012

WEBCAST: Managing Oracle Exadata's Lifecycle for Extreme Performance

Thursday July 26
10:00 a.m. PST / 1:00 p.m. EST

Register Now!

Watch this live webcast and discover how Oracle Enterprise Manager 12c's unique management capabilities allow you to efficiently manage all stages of Oracle Exadata's lifecycle, from testing applications on Exadata to deployment. You'll learn how to:

  • Maximize and predict performance
  • Drive down IT operational costs through automation
  • Ensure service quality with proactive management
Register today and unlock the potential of Oracle Enterprise Manager 12c for your enterprise.


Stay Connected:

Twitter |
Facebook | YouTube | Linkedin | Newsletter

Thursday Jul 19, 2012

Oracle Enterprise Manager 12c July Newsletter is Out!

Each month the Enterprise Manager team puts together a full line-up of great articles, content and technical product information around a particular theme. This month is no different. In July, we’re focusing on lifecycle management and all the things you need to know about this important topic. Read the July newsletter to get the latest articles and content on lifecycle management. Read it now!

The July edition covers:
• Achieving Extreme Performance Across Oracle Exadata's Lifecycle

• Top 5 Database Compliance Risks—and How to Avoid Them
• Know the Best Tools to Provision and Patch Oracle Database 11g
• and much more...

So stay tuned as we bring you more feature articles, and more webcasts throughout the month.

Enjoy!

Subscribe here to receive the Oracle Enterprise Manager 12c Newsletter.


Stay Connected:

Twitter |
Facebook | You Tube | Linkedin | Newsletter

 

Wednesday Jul 18, 2012

Applying Oracle Enterprise Manager Cloud Control 12c Bundle Patch 1: Tips and Tricks

Over last few months, the Oracle Enterprise Manager team has released Enterprise Manager 12c Bundle Patch1 (a.k.a. BP1) for Oracle Enterprise Manager Cloud Control 12c (EM 12c) on all the supported platforms (Customer announcement). BP1 is a mandatory patch because all future patches will assume the presence of this patch. BP1 includes several critical fixes. Therefore this patch touches almost all the components of Enterprise Manager and applying it on existing environment is a multi step process that can be tricky. From our recent experience of applying BP1 on an internal production demo site with over a thousand targets, we would like to share following tips and tricks. 

1. Applying incremental Bundle Patch or using full install?
Unless you have an EM 12c running in production environments where you can’t afford to lose the existing management repository, it is highly recommended to re-install EM using the patched EM Base Platform 12.1.0.1 Full Installer (With BP1), instead of applying BP1. For instance, if you have a test or a “sandbox” environment even with substantial number of targets, it might be easier to reinstall EM environment instead of manually applying patches (including agent patches) and upgrading plug-ins. Note that reinstalling EM will require reinstallation of target agents as well. Therefore you’ll need to do careful consideration before choosing this option.

2.    Plan it well

  • Given that the BP1 process involves agent side changes like patching and plug-in upgrades, you might want to consider splitting the agent side changes into phases, especially in large sized environment. In such cases, it is critical to review the Compatibility Matrix and ensure that at no stage during the BP1 upgrade process, your environment is in an unsupported configuration.
  • Never break the sequence of steps given in the BP1 application guide or you may risk your entire environment. For example -- as an admin, after upgrading the plug-ins on OMS, you may be tempted to upgrade plug-ins of agents as well even before patching the agent. As the documentation says -- resist the temptation to avoid issues while patching agents later.
  • Keep sufficient free space for backup. It might be helpful to take keep multiple backups. See the next tip.

3.    EM 12c Backup is critical

  • Never underestimate the importance of environment backup during the BP1. It is must to backup your environment before any steps that involve change in repository data. e.g.  OMS patching, plug-in upgrade on OMS, etc.
  • Additionally it is recommended to take backup after every significant step to minimize rework in case of any failure. For instance in our environment a total of four backups were taken at following stages.
    • Before applying BP1 on OMS
    • After applying BP1 on OMS, JDeveloper, WSM
    • Before upgrading plug-ins on OMS
    • After upgrading first few plug-ins on OMS

4.    Upgrade plug-ins in bulk using emcli  
BP1 comes with the 12.1.0.2 release of plug-ins and it is highly recommended to upgrade plug-ins together with the application of BP1. In a typical environment you may need to upgrade more than 15 plug-ins. For some plug-ins, the upgrade process requires a restart of OMS(s) and therefore can take a good deal of time (almost fifteen minutes for single plug-in upgrade). Hence upgrading plug-ins one by one via the UI can be time consuming process requiring manual intervention after every few minutes.
Use EM command line ‘deploy_plugin_on_server’ to deploy multiple plug-ins in one go in an automated manner. Since multiple plug-ins are upgraded in single downtime window for OMS, it is a far more efficient process. In our environment, using command line we could upgrade eight plug-ins in under 30 minutes which otherwise would have taken more than two hours. Make sure to run the emcli in a pre-requisite check mode before doing the actual deployment such as shown in the screenshot below.


Also note that if your OMS is on Linux platform, you’ll need to apply one-off patch 13638422 after applying BP1 on the OMS to get the ‘deploy_plugin_on_server’ emcli verb. For BP1 on other platforms (e.g. Windows) this patch is included in BP1 itself.

5.    From Linux OMS don’t push agents on other platforms without necessary patches
A very common use case is the deployment of agents on non-Linux platform from a Linux OMS with BP1. Since you have Windows/Solaris agent software (with BP1) available via self update, you might tend to assume that, all you need to do is simply push the Windows/Solaris agents from BP1 Linux OMS but that’s not the right way to do. You have to apply few patches on OMS and plug-ins before pushing the agent, follow the instructions from the Oracle® Enterprise Manager Bundle Patch 1 Application Guide.

6.    Read the right documentation
Last but surely not the least, it is vital that you go through the Oracle® Enterprise Manager Bundle Patch 1 Application Guide, before you begin with the BP1 process. This guide provides step by step instructions for applying BP1 including pre-requisite checks, recommendations, and troubleshooting steps.
In addition to the documentation, we suggest to refer the following key resources published by Oracle.


These few simple tips can make your experience with BP1 a lot smoother. In future entries, we’ll discuss the best practices for major updates for Oracle Enterprise Manager 12c as and when those are available.



Monday May 14, 2012

Forrester Consulting: Oracle Real Application Testing Delivers 224% ROI

Leading analyst firm, Forrester Consulting has recently published a Total Economic Impact™ (TEI) Study for Oracle Real Application Testing, an Oracle Database 11g Enterprise Edition option. In the study Forrester Consulting found that Oracle Real Application Testing delivered a very favorable 224% return on investment (ROI), based on a three year risk-adjusted period with a payback of 5.9 months.

Forrester Consulting's TEI results were calculated from in-depth interviews with Oracle customers and applied to a hypothetical organization developed within their TEI financial model. The study measured both the benefits and cost savings in areas around planned and unplanned maintenance, infrastructure upgrades and database performance management. The study also looked at the benefits of Oracle Real Application Testing to enhance business system uptime as well as reducing capital expenditure.

The study concluded that organizations similar to those interviewed could achieve the following benefits and cost savings (all figures are risk-adjusted, over three years):

  • 224% ROI with a payback period of 5.9 months
  • $5.9 Million in total benefits from increased business productivity and database availability


Total Benefits of Oracle Real Application Testing Over a Three Year Risk-Adjusted Period

Oracle Real Application Testing along with Oracle Enterprise Manager 12c continues to provide industry leading database management solutions that help customers reduce testing efforts and related costs while eliminating the risks associated with change.

More Information


Stay Connected:

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

 

Thursday May 03, 2012

ON-DEMAND WEBCAST: Oracle Database Lifecycle Management with Oracle Enterprise Manager 12c, Now Available

If you missed the original live webcast, Oracle Database Lifecycle Management with Oracle Enterprise Manager 12c, the on-demand replay is now available, topics include:

  • IT asset discovery and inventory tracking
  • Database provisioning and end-to-end patch management
  • Ongoing change management including database schema changes
  • Configuration management for controlling configuration drift
  • Compliance management with out-of-box frameworks and policies for regulatory reporting
  • Site level disaster protection with built-in automation
Watch Now!


Stay Connected:

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

 

Monday Apr 30, 2012

WEBCAST: Oracle Database Lifecycle Management with Oracle Enterprise Manager 12c

Wednesday May 2
8:00 a.m. Pacific / 11:00 a.m.

Register Now!

Join us for this webcast and learn how Oracle Enterprise Manager 12c Database Lifecycle Management Pack delivers a comprehensive solution that helps database, system and application administrators automate the processes required for managing the complete Oracle Database lifecycle. Discover how Oracle Enterprise Manager 12c's unique management capabilities allow you to efficiently manage all stages of the lifecycle including:

  • IT asset discovery and inventory tracking
  • Database provisioning and end-to-end patch management
  • Ongoing change management including database schema changes
  • Configuration management for controlling configuration drift
  • Compliance management for reporting industry and regulatory compliance
  • Site level disaster protection with built-in automation

Register today and unlock the potential of Oracle Enterprise Manager 12c for your enterprise.


Stay Connected:

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

Wednesday Feb 29, 2012

Manage Oracle on the Go! Get the New Oracle Enterprise Manager 12c Mobile App for iPhone

Oracle Enterprise Manager Cloud Control 12c Mobile App for incident management with service request integration is now available for the Apple iPhone. With this release Oracle now offers the ability to track, monitor, and manage incidents directly from your smart phone. IT managers and administrators using Oracle Enterprise Manager 12c can view incident and problem details directly in the app, as well as acknowledge, assign, prioritize, escalate and annotate incidents. The app provides seamless connectivity to My Oracle Support allowing users to drill-down into any service request associated with a problem. In addition, the flexible setup screen enables users to connect to multiple Oracle Enterprise Manager 12c environments from within a single pane.

Manage incidents directly from your iPhone
View and track system issues
Provide quick status updates


Download the Oracle Enterprise Manager Cloud Control 12c Mobile app


Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

CASE STUDY: Vodafone Embraces Proactive Database Management to Ensure Reliable Mobile Communications for 391 Million Customers

Check out the latest customer case study for Vodafone, one of the world’s largest mobile communications companies. Learn how Vodafone overcame the challenge of managing 3,650 databases across its global businesses by embracing proactive database management with integrated support. The end result; response times to issues improved by 50%, leading to highly available and more reliable mobile communications for Vodafone's customers. Read the case study.


Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Tuesday Feb 28, 2012

Cerner Delivers Proactive Database-as-a-Service

Watch and learn how Cerner, one of the leading healthcare technology solution providers, efficiently manages hundreds of databases for its clients using Oracle Enterprise Manager and Database-as-a-Service.

More information
To learn more about Oracle Enterprise Manager 12c Database Management solution, please visit:

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Monday Feb 27, 2012

Why Database as a Service: Think Scalability and Agility

For those interested in delivering Database as a Service (DBaaS) for your IT, or just looking for more insight into this powerful capability—check out the latest Oracle Enterprise 12c InDepth Newsletter. This edition features a great article on why you should consider DBaaS in your IT strategy. Here's a hint, think scalability and agility!

Subscribe here to get the latest issue delivered to your mailbox.


Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Wednesday Feb 22, 2012

Oracle Enterprise Manager 12c Newsletter: February 2012 Edition Now Available

Get the latest issue of the Oracle Enterprise Manager 12c Indepth Newsletter. Read it Now!

The February edition covers:

  • Oracle Database Lifecycle Management
  • Enterprise Management Online Forum
  • Database as a Service
  • and much more...

Enjoy!

Subscribe here to receive the Oracle Enterprise Manager 12cNewsletter.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Tuesday Feb 21, 2012

Oracle Exadata Management — Diary of an Exadata DBA

I recently had the chance to sit down with Deba Chatterjee, Senior Product Manager, Database Manageability to talk about Oracle Enterprise Manager 12c and how it's making Oracle Exadata management easier for DBAs. He had a great analogy that I wanted to share. "To describe how Enterprise Manager is making Exadata management simple and less complex, is by using an approach we call, 'Exadata Aware Database Performance Analysis'. The best way to illustrate how this works, is to use real-world scenarios," Deba added. Here is one of those scenarios—an excerpt from the diary of an Exadata DBA.

November 15th, Late Evening

Database performance has suddenly dropped becoming very poor. The same reports that were running fine a couple of hours ago are now taking forever to complete. The boss just left me a message that the CRM analytics director was pretty upset and wants to know why we have a performance problem.

I checked the queries and the execution plans both look the same with lots of smart scans and cell offloading. Suddenly, the response time has gone south and I cannot figure out why?

My first step was to look at the database performance page in Oracle Enterprise Manager 12c, which now comes with built-in Oracle Exadata support. Hey, what do I have here in the I/O tab? The Exadata system health button is red, that's not good. What's happening? I clicked the button and it took me to the Exadata health triage page, this is where I can see if I have potential issues such as;

  • Load imbalance
  • ASM related problems
  • Cell software or hardware failures
  • Cell configuration issues
  • Network related failures


The red Oracle Exadata system health button indicates potential issues impacting database performance.

Next, I noticed that the network status was red, it must be a network issue, right? I quickly checked the administration screen in the Infiniband Target Home page, and saw we had a degraded port in the Port Details status section. I disabled the bad port and allowed the network traffic to automatically fail over to its peer. I'll have to look into this later, for now I just wanted to get the system up and running.


View of the degraded port in Infiniband Switch Schematic.

I quickly re-checked the Exadata system health status again, it showed all green—looks like everything was working, problem solved. I called my boss back to give him the good news that the database performance was back up. I sure am glad all these things are integrated; otherwise I would have been here all night trying to figure this out.

Oracle Database Management resources:

Stay Connected:

Twitter | Facebook | YouTube | Linkedin | Newsletter

Thursday Feb 16, 2012

Managing Oracle Database 11g—Questions and Answers from the Oracle Enterprise Management Online Forum

We received tons of questions from our recent Oracle Enterprise Manager 12c Online Forum, we wanted to continue to provide answers to the most popular ones. In this installment, we'll cover questions from the DBA and developer track.

Q. What kind of testing do you recommend for upgrading from Oracle Database 11gR1 to 11gR2?
A. Oracle Real Application Testing using Database Replay and SQL Performance Analyzer's capabilities are recommended for any Oracle Database upgrade. Check out these resources for more details: Oracle Real Application Testing datasheet and OTN for details on upgrading your database.

Q. Can I manage Oracle Exadata and traditional Oracle Databases from the same console?
A. Yes, you can manage Oracle Exadata and single instance and/or RAC databases from the same Oracle Enterprise Manager Cloud Control console, as well as WebLogic and many other targets. Check out this demo to see how.

Q. I thought Active Session History (ASH) was intended for real-time?
A. ASH can be use for both real-time and historical analysis. It is a black box that records session activities and helps to analyze across several performance dimensions. Click here to see a quick demo.

Q. What is the difference between Oracle Enterprise Manager 12c and Oracle Database Control?
A. Database Control is a subset which runs off a single database. Oracle Enterprise Manager 12c is a central repository which allows administrators to manage and monitor from a single console.

Q. How does Real-Time Automatic Database Diagnostics Monitor (ADDM) work – the database is hung right?
A. Real-Time ADDM, included in the Oracle Diagnostic Pack for Oracle Database, uses 2 different modes of connection to the database. A normal connection and a diagnostic mode that is a lock less, latch less connection which allows only few actions. Using the diagnostic mode connection Real-Time ADDM performs a hang analysis and determines any blockers in the systems. Check out this demo to see how Real-Time ADDM works.

Q. Can we achieve all the new functionality in Oracle Enterprise Manager 12c using terminal?
A. No. Features like ASH Analytics, Real-Time ADDM and Compare Period ADDM are only available using Oracle Enterprise Manager 12c's console.

Q. Is Real-Time ADDM available only in Oracle Enterprise Manager 12c?
A. Yes, Real-Time ADDM is a new feature in Oracle Enterprise Manager 12c.

Q. Can you explain the difference between Oracle Database 11g Monitor in Memory Access Mode vs. Real-Time ADDM direct access to SGA?
A. Real-Time ADDM does not use Memory attach mode. We use a proprietary connection method which connects using a lock less, latch less connection bypassing the SQL Access layer.

Q. Is there any limit on the number of days on which ASH can be used for analysis?
A. The in memory ASH data is typically available for 1 hour or till the point the memory buffer is flushed to disk. You can find out ASH retention by using: select min(sample_time), max(sample_time) from sys.WRH$_ACTIVE_SESSION_HISTORY;

From more Oracle Database Management product information check out these resources:

Stay Connected:

Twitter | Facebook | YouTube | Linkedin | Newsletter

Tuesday Feb 14, 2012

Oracle VP, Leng Tan, talks about Oracle Database Management using Oracle Enterprise Manager 12c

Listen in as Oracle Vice President, Leng Tan, talks about the new Oracle Database Management capabilities in Oracle Enterprise Manager 12c.

More information
To learn more about Oracle Enterprise Manager 12c Database Management solution, please visit:

Stay Connected:
Twitter | Facebook | YouTube | Linkedin | Newsletter

[Read More]

Thursday Feb 09, 2012

NEW STUDY: Oracle Database 11g Delivers Significant Savings over Microsoft SQL Server

ORC International: Oracle Database 11g is 49% Easier to Manage and 46% Less Complex

Oracle Database 11g Release 2 continues to outperform Microsoft SQL Server 2008 Release 2 by a substantial margin, according to a new ORC International study. In the report, "Database Manageability and Productivity Cost Comparison Study Oracle Database 11g Release 2 vs. Microsoft SQL Server 2008 Release 2," Oracle once again demonstrates its leadership in overall database self-manageability with significant productivity and complexity savings.

The study found that Oracle Database 11g Release 2 took half the amount of time and effort to complete four routine database administrator (DBA) tasks compared to Microsoft. The study measured typical tasks such as initial database setup, routine daily administrative tasks, and backup and recovery, as well as performance and tuning tasks.

In one particular scenario, the study illustrated how a DBA could perform database diagnostics and tuning tasks 143 times faster using Oracle Database 11g over Microsoft SQL Server 2008. The report concluded that Oracle allowed IT organizations and DBAs to

  • Perform administrative tasks 49% faster than Microsoft SQL Server 2008
  • Save time with 46% fewer steps for the same set of standard routine functions versus Microsoft
  • Increase productivity and save businesses up to US$58,800 per year per DBA by using Oracle Database 11g over Microsoft SQL Server 2008

This report, along with similar competitive studies ORC International conducted including one against IBM DB2 9.7, reaffirms Oracle Database 11g as an industry leader with its unique self-managing automation and performance capabilities. Oracle Database 11g, along with Oracle Enterprise Manager 12c Database Management Packs, continue to help DBAs become more productive at getting their jobs done faster and with less effort.

More information
To learn more about Oracle Database 11g and Oracle Enterprise Manager 12c, please visit:

Monday Jan 30, 2012

Questions and Answers from the Oracle Enterprise Management Online Forum Keynote: Gain Total Cloud Control

The recording of Oracle Enterprise Management Online Forum: Gain Total Control of Enterprise Clouds on January 25th is now available to view on demand. This half day, online event provided a unique opportunity to see, in one place, the full management capabilities of Oracle Enterprise Manager 12c and to learn about the new cloud management functionality . To view the recordings from the Enterprise Management Forum and download the presentations, please click at the link provided below :

Oracle Enterprise Management Online Forum - On Demand

Many of the Online Forum attendees found the live Q&A extremely valuable during the sessions and requested to share the archive of the Q&A.  We will be sharing the Q&A from the Oracle Enterprise Management Forum in a series of blogs during next few weeks. In this blog we will include the live Q&A archive for the keynote "Gain Total Cloud Control"  at the Oracle Enterprise Management Online Forum .

For more information, please go to Oracle Enterprise Manager  web page or  follow us at : 

Twitter | Facebook | YouTube | Linkedin | Newsletter

[Read More]

Wednesday Aug 03, 2011

Oracle customer talks about minimizing IT downtime - How expensive is IT downtime for you ?

We recently talked with a few of Oracle customers about their challenges in managing their IT applications & infrastructure and how moving to a private cloud infrastructure may address some of those challenges.We will be sharing some of those videos during next few weeks and encourage you to share your thoughts, feedback, application or infrastructure management challenges etc. by leaving comments to these blog entries with videos. 


How expensive is IT downtime for you ?

Thursday Jul 28, 2011

WEBCAST: Get Proactive with DBA Task Automation

Tuesday, August 16, 2011
10:00 a.m. PST / 1:00 p.m. EST
Register Now!

 

Today DBAs are being pressured to deliver database services faster and at lower operational costs, with many turning to the next-generation of database management tools and techniques to help them meet these demands head-on.

Join us for an interactive Webcast with Oracle experts who will share best practices for dealing with these database management challenges—plus tips for getting the work done quickly and efficiently. You'll learn how to:

  • Automate many routine manual DBA tasks
  • Get better performance and service quality with proactive database management
  • Overcome the explosive surge in database growth

Register now to attend this event. Attendees will receive a complimentary copy of the 2011 IOUG survey on database manageability, Managing the Rapid Rise in Database Growth.

 

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