Tuesday Aug 20, 2013

Short Demo Video : Deliver Database as a Service with Oracle Enterprise Manager

This demo provides an overview of various use cases and benefits of delivering database as a service using Oracle Enterprise Manager.

Stay Connected:

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

Wednesday Aug 07, 2013

VIDEO: Managing Oracle Database 12c

Learn about all the new manageability capabilities in Oracle Database 12c. Watch the video.

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

Tuesday Aug 06, 2013

Secure, Subset and Self-Service Database provisioning in Cloud

One-step inline data masking and data subsetting is a very innovative solution in Oracle Enterprise Manager 12c that enables enterprises to provision secure and reduced size test systems directly from the production or standby database without the need for a full production database copy. So you are able to create reduced size copies of production database keeping the referential integrity of data set intact saving on storage costs and more importantly also ensure your sensitive database never creeps into any of your development or test systems in compliance with data privacy policies.

With Oracle Enterprise Manager 12c Release 3 customers have now started adopting this one-step on-the-fly masking and subsetting solution along with Database-as-a-Service(DBaaS) self-service provisioning capabilities and the outcome is one of the most comprehensive and unique solution to realize self-service provisioning of secured, subset copies of production like databases for all of testing and development needs in a private cloud model.

In this blog post I will walk through the steps required to achieve this comprehensive solution for test and development systems provisioning in enterprise private cloud.

1) Prepare source database

One of the ideal option in case customer has physical standby is to convert physical standby into a snapshot standby for one-step data subsetting and masking operation. A snapshot standby receives and archives but does not apply redo from primary until converted back to physical standby. So once you have created subsetted and secure dump from snapshot standby you can convert snapshot standby back to physical standby using Oracle Enterprise Manager. Refer to Oracle Data Guard guide for considerations in using snapshot standby.  In-line data subsetting and masking can also be performed on production database in case there is no physical standby.

2) Perform Inline data subsetting and masking workflow

Here are the steps :

a) Create Application Data Model(ADM)
ADM is a knowledge base entity in Oracle Enterprise Manager that captures application metadata, referential relationships, sensitive columns and is used by both test data management and data masking. There are pre-defined drivers to capture data relationships from application metadata tables for Oracle Applications such as Fusion Apps and eBusiness Suite. Security Administrator requires EM_ALL_OPERATOR privilege to create ADM and Data Masking and Subsetting definition.

b) Create Masking and Subsetting definition

As a best practice, Security Administrator can create masking formats for all regulated information in the enterprise. There are out-of-box Oracle supplied default masking formats also that can be used from format library. Next step is to create masking definition that includes information regarding table columns and the format for each column. You can choose which columns to mask. Data Masking workflow can be referred here.
Next step is to create Data subset definition and use the same ADM and database used in creating the masking definition. In this step you can define the table rules,rule parameters, include 'Ancestor and Descendant tables' or 'Ancestor tables only' option this ensuring referential integrity is maintained. At this step Space estimates can also be reviewed and depending on the result, you can modify or add new rules and review back on space estimates value. Pre/Post subset scripts can also be included in definition.

c) Generate subset using export option

Using the definition subset can be created by writing the subset data to export file. Specify directory where to save the export dump and schedule the subset job. Once the job is complete, the subset Data pump file of production data with sensitive data masked is ready. The overall flow is described here
Some key tips -
- Parallel degree can be used for faster export. Start with twice the number of CPUs and tune from there
- %U and max file size parameter can be used to ensure optimum use of parallelism
- Rule parameter in where clause can be used for actual subset generation with different values
- Column rules can be used to set large-sized columns to null or fix value to reduce database size further

3) Prepare secure test/reference database

Once the Data pump export file is generated it can be imported in a test/staging database . For details refer here.This test database can be used as a reference for all development and testing copies and hosted in Self-Service portal for end users to request from service catalog.

4) Self-Service Portal Setup

Following two options are available to cloud-enable this secure reference database for self-service provisioning of future copies of this database via Oracle Enterprise Manager 12c Database-as-a-Service (DBaaS) solution :

a) Snap Clone option that leverages storage level copy-on-write technologies for cloning and is suited best for functional testing requirements and for short lived databases.With this option you can clone terabytes of data in few minutes and storage saving is enormous with this option. you need to review the supported storage options for this method. As of time of writing the post Netapp and ZFS is supported though there are plans to support more storage options in near future.

b)  RMAN based cloning from backup is one of the favorite option for DBAs. The restore process is completely automated with EM 12c DBaaS and this option is best suited for performance and load testing, development requirements and for databases used for significant updates.
Once you decide on the option, steps to follow are documented in one of my recent blog post around Planning Database as a Service Implementation Project

Refer to Private Cloud Setup and Administration guide here for details on DBaaS Setup and Snap Clone, RMAN Profile options. The secure database prepared in previous step will be used as reference target by SSA Administrator while creating database provisioning profile using RMAN backup or Snapshot option. Please also ensure you have reviewed this MOS Note for DBaaS related patches -
"Enterprise Manager Cloud Control 12c Recommended Plug-Ins and Patches for Database as a Service (DBaaS) (Doc ID 1549855.1)"

5) Self-Service database provisioning in Cloud

End users can now request for secure subset copies of production database via Self-service portal for all kind of functional QA, load and performance testing, development requirements. All the databases provisioned from this approach are also enabled by default with EM 12c powered monitoring and diagnostics, lifecycle and cloud management capabilities.

Solution References

1) Oracle Enterprise Manager 12c Packs
Oracle Test Data Management Pack
Oracle Data Masking Pack
Oracle Database Lifecycle Management Pack
Oracle Database Cloud Management Pack

2) Oracle Enterprise Manager 12c Platform and Plug-ins
Enterprise Manager Cloud Control 12c Release 3 Base Platform (
Enterprise Manager for Oracle Database (DB) plug-in
Enterprise Manager for Oracle Virtualization (VT) plug-in
Enterprise Manager Storage Management Framework (SMF) plug-in
Enterprise Manager for Oracle Cloud (SSA) plug-in

Additional information

Stay Connected:

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

Friday Aug 02, 2013

Managing Oracle Database 12c

Oracle recently announced new management capabilities for Oracle Database 12c, providing customers with even more enhancements to improve productivity and manageability. The new Oracle Enterprise Manager 12c features are supported out-of-the-box with Oracle Database 12c. So whether you want to take advantage of the new Data Redaction capabilities at the security layer, or whether you want to take a look at some of the heat map capabilities in our Information Lifecycle Management or leverage the new performance management features, such as, Database Operations Monitoring or Enhanced Real-Time ADDM, you can use Oracle Enterprise Manager 12c to manage them all.

These new capabilities can be integrated with your standard monitoring and management that you already have in your environment without having to undertake any additional tools or any additional training. Simply install or upgrade to Oracle Enterprise Manager 12c and Oracle Database 12c and together these two products will let you plug into the Cloud.

Here is a quick summary of all the new Oracle Enterprise Manager 12c capabilities for Oracle Database 12c:

  • Complete lifecycle management of multitenant databases: Support for the entire lifecycle operations of multitenant databases that comprise migration, creation, cloning, patching and tracking for compliance
  • Consolidated database replay: Allows customers to test and plan their consolidation using Oracle’s multitenant container and pluggable database technology
  • At-source data masking: Allows customers to maximize compliance and security by masking data in-flight as it is being copied from production
  • Enhanced diagnostics: Improvements to Automatic Database Diagnostic Monitor (ADDM) for real-time and proactive problem detection, especially designed for catching short, transient performance issues
  • Real-time business operations monitoring: Monitors composite business operations such as; batch jobs and ETL operations, providing real-time reports on all SQLs and PL/SQLs executed inside the job
  • Performance hub: Newly redesigned performance home page that provides administrators with a single, at-a-glance view of all performance data and advisors
  • New Oracle Enterprise Manager Database Express 12c: An out-of-the-box, lightweight, easy-to-use web-based management solution for managing individual databases
  • Schema as a Service: This ultimate consolidation of databases lets administrators host multiple application schemas within a single database and offer database as a service to hundreds of application users without creating database sprawl
  • Snap Clone: Instant database cloning allows administrators to create fully functional copies of databases using the copy-on-write capabilities of the underlying storage layer

To learn more about all the latest capabilities, be sure to register for our upcoming webcast: Managing Oracle Database 12c with Oracle Enterprise Manager 12c.

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

Wednesday Jul 31, 2013

IOUG SIG Webcast on August 7th : SQL Monitoring and ASH Analytics

The Oracle Enterprise Manager Special Interest Group (SIG) growing body of IOUG members who manage or are interested in all aspects of Enterprise Manager. This IOUG SIG is managed by volunteers and supported by Oracle EM product managers and developers. The purpose of the SIG is to bring relevant information and education through webcasts, discussions and networking to users interested in learning more about the product, and to share user experiences.

On August 7th at 10 AM pacific time, Oracle Enterprise Manager SIG is hosting a webcast on SQL monitoring and ASH analytics. In this webcast, Edward Whalen, Chief Technologist, Performance Tuning Corporation will provide a tutorial on how to take advantage of two of the powerful performance monitoring and debugging tools; SQL Monitoring and ASH Analytics.

After attending the session, the attendee should have a better understanding of:

1. Oracle Enterprise Manager Cloud Control 12c and how to take advantage of some of the key performance monitoring features.

2. The usage and basic properties of SQL Monitoring; how to invoke it and how to use it to identify long running SQL statements.

3. What ASH Analytics is, what is ASH data and how to use ASH Analytics for determining which sessions, modules or SQL statements are consuming system resources.

Stay Connected:

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

Monday Jun 10, 2013

Private Cloud Benefits : Different Strokes for Different Folks

Register Today

Private Cloud Survey Findings from Five Key Industries

Are you feeling the pressure to deploy private cloud but lack the real-world data to support its benefits from early adopters in your industry? You are not alone. A recent survey of the cloud computing field by IDG Research Services uncovered very little in the way of industry-specific guidance for private cloud.

In this Webcast, you will learn the results of the IDG survey that reveals stark differences in the use cases, benefits, and challenges reported by industry—specifically banking and financial services, healthcare, telecommunications, high tech, and the public sector.

Attend this Webcast to learn about the key aggregate findings of this IDG survey on private clouds with added detail around the five industry sectors. Hear the survey results regarding:

  • Private cloud investment in your industry
  • The range of benefits being reported
  • Challenges to cost benefits realization and what early adopters have done to address them

Webcast attendees will receive a complimentary white paper summarizing the survey results. Register now for the Webcast.

Featured Speakers:

Janet King
General Manager/VP of Research
IDG Research Services
Anand Akela
Senior Principal Product Marketing Director

Register Today

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

Thursday Apr 11, 2013

Qualcomm Deploys Application Changes Faster with Oracle Enterprise Manager

Listen in as Qualcomm talks about saving time and energy by making application changes faster through Oracle Enterprise Manager.

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

Thursday Mar 28, 2013

IOUG Webcast: Oracle Enterprise Manager 12c Metrics Monitoring and Management Repository Views: Tips & Tricks

IOUG Oracle Enterprise Manager Special Interest Group (SIG)    presents webcast "Oracle Enterprise Manager 12c Metrics Monitoring and Management Repository Views: Tips & Tricks".  Suzanne Strasser will be sharing he real-life experience with Oracle Enterprise Manager metrics monitoring and management.

Date : April 2nd, 2013
Time : 12:00 PM - 1:00 PM CDT
Featured Speaker: Suzanne Strasser
Register herehttps://www1.gotomeeting.com/register/612927881

Oracle Enterprise Manager 12c provides a rich set of metrics for monitoring database health and alerting when problems are encountered. In this educational webcast we will demonstrate the steps needed to set up and customize metrics monitoring in EM to meet the needs of your business. We will also cover the use of management repository views to access historical metrics data for performing additional analyses and graphics presentation outside of EM. Join this webcast to learn how to:

• Identify and describe the steps needed to implement administration groups / template collection associations in order to customize monitoring requirements for various targets based on the needs of your business;

• Build queries using the EM management repository views to extract metric data for historical analysis, trending, and graphing; and

• Identify how EM uses rollup tables to summarize metric data on an hourly and daily basis.

Wednesday Mar 27, 2013

Using Advanced Notifications in Oracle Enterprise Manager 12c

When using an enterprise monitoring tool such as Oracle Enterprise Manager 12c, one of the most critical components is notification. Once an alert or issue has been identified, how do you tell the right people at the right time? Most enterprises use e-mail or open a trouble ticket. As you can imagine, no two enterprises are the same when it comes to their tools and processes. Many customers use one of the more common and well known trouble ticketing systems but quite a few use non-standard or custom (homegrown) trouble ticketing systems. Some customers have special routing requirements or corporate standards and have custom applications which handle all emailing functions instead of directly emailing using an SMTP server.

Oracle Enterprise Manager 12c can handle all of these situations by utilizing one of the various notification methods provided: E-mail, 3rd party connectors and advanced notification methods. There are three types of advanced notifications: SNMP, OS Command or PL/SQL. This blog will introduce you to the OS Command and PL/SQL notification methods available in EM 12c and provide an example of using a custom OS script for notifications.

[Read More]

Tuesday Mar 26, 2013

Get OPN certified on Oracle Enterprise Manager and other Oracle Technologies at Collaborate

A rare opportunity to get your OPN Certified Specialist credentials at the Collaborate 13 event and at times your staff is not in the booth! Register now.

At Collaborate 13, Oracle Partners have a unique opportunity to become Oracle Certified Specialists in their chosen Oracle solution area from exams available at the event site. Understanding there are times the Exhibit Hall is closed to your staff, special hours and an onsite location have been arranged to make it as easy as possible for OPN Partners to take advantage.

OPN certification differentiates Oracle Partners in the marketplace by providing a competitive edge through proven expertise. Earning these certifications will also contribute to increasing your company's level in the OPN Specialization Program. Oracle Specialized partners are recognized by Oracle, and preferred by customers. Make sure you check the exams available at the event site and register early as there is a limited number of FREE vouchers enabling partners to take exams at no charge.

This is an excellent way for Oracle partners already attending the Collaborate event or have staff exhibiting at Collaborate, to easily get away when the Exhibit Hall is closed and take the Oracle Enterprise Manager 12c exam 1Z0-457

Best of all is there are a limited number of FREE vouchers available, so the first partners to register and use them save $195 for each person that takes the exam. As you  have already invested in travel for staff to be at the event, why not get more out of that investment and take advantage while staff is already out of the office to get it done.

Tuesday Mar 12, 2013

WEBCAST: Delivering Database as a Service with Oracle Enterprise Manager 12c

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

Join us for a live Webcast to find out about the recently released Oracle Enterprise Manager 12c plug-ins that deliver new capabilities and support for managing database cloud services with schema as a service for extreme database consolidation and quick efficient database cloning through Snap Clone or RMAN Backups. These new capabilities provide an optimum utilization of development and database resources giving customers more flexibility and control during application development, leading to a faster time-to-market for delivering IT services.

Register Now!

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

Friday Mar 08, 2013

Schema as a Service for Extreme Consolidation

As we deal with Database as a Service use cases, we often find that consumers do not need dedicated databases of their own. Developers of a home-grown application, for example, might be satisfied with a logical slice of the database. This logical slice, leads us to the concept of Schema as a Service—a new capability offered in the latest release of Oracle Enterprise Manager 12c Release 2 Plug-in Update 1.

Schema as a service is the ultimate and extreme in consolidating multiple schemas in a shared database model. Cloud users can request one or more schemas, with or without seed data, from Oracle Enterprise Manager 12c’s out-of-the-box self service portal. It offers excellent manageability, not only for its fast efficient provisioning, but because administrators only need to manage a small number of databases.

Schema as a Service: Consolidate Multiple Schemas in a Shared Database Cloud Services Model

However, consolidation comes at the expense of isolation, because the operating system and database are not isolated among the database consumers. While enabling Schema as a Service, it’s important to isolate the workloads as much as possible to make sure that one user doesn't run away with all the database resources. Administrators can guarantee this does not happen by using Oracle Enterprise Manager 12c’s CPU monitoring capabilities built in to Oracle Database Resource Manager to maintain service levels.

For security, the more consolidated you get, the more concerns administrators have about data isolation and security. Using Oracle Data Vault can help resolve these issues. It is integrated with Oracle Enterprise Manager 12c, and administrators can use Oracle Data Vault to enable fine grain control based on roles and privileges within the database cloud service.

For reporting purposes, metering and chargeback capabilities can be implemented to help IT organizations gain in-depth visibility into resource consumption and expenses incurred with each schema as a service deployment. This is useful for regulatory compliance requirements as well.

Schema as a Service at a Glance:

  • Consolidate multiple application schemas in a shared database deployment model
  • Each application user (i.e. developers or testers) can provision one or more database schema(s) with a dedicated database cloud service
  • Automated placement can be based on workload characteristics and specifications
  • Service levels are guaranteed through Oracle Database Resource Manager
  • Service governance is done through quotas, retirement policies and chargeback plans
  • Integrated with Oracle Data Vault for security isolation and control
  • De-provision schemas when needs change


  • Save resources through ultimate consolidation of multiple database applications
  • Boost administrator productivity and increase efficiency with automated provisioning
  • Deploy schema as a service implementations consistently using self-service profiles and templates
  • Metering and chargeback helps keep track of resource consumption and usage for accountability and reporting
  • Minimize administrative overhead and compliance challenges by preventing database sprawl

How To:
There are several steps involved when setting up and deploying database schema as a service in Oracle Enterprise Manager’s self service portal. Here is a quick summary of what’s involved. For more details be sure to review the resources below.

1. Setting up Platform as a Service Zones

  • Before deploying your schema as a service, you first need to create a Platform as a Service (PaaS) infrastructure using Oracle Enterprise Manager 12c’s self-service portal. A PaaS Zone comprises multiple hosts, i.e. servers with Oracle Enterprise Manager 12c agent installed.
  • Use the portal to create a PaaS zone and organize it by function type (i.e. based on geography, line of business (sales, development) or application lifecycle. (i.e. dev, test, QA, production)
  • Next expose the PaaS zone to the self-service cloud users in the portal. For example, developers can now have the option to select a development PaaS zone or testers can select a QA zone.
  • Visibility of each zone can be restricted based on the self-service user's credentials.

2. Setting up Database Pools

  • Database pools are a collects of databases used to host schema as a service.
  • To create a new database pool, you can use a portion of resources that are available to the zone. Keep in mind that all members of the database pool need to be the same target type. For example, a single database instance or database cluster; platform, or same database version. This ensures provisioning consistency during deployment.
  • Next configure placement constraints and policies for the database pool. For placing databases within the pool and controlling how resources are utilization, you need to first create a placement constraint and set its policies. This provides protection for the database members within the pool for resource consumption. For example, a production database pool might enforce more conservative constraints whereas a development pool might allow liberal limits.
  • You can set a constraint for each database in the pool by services or by workload associated with the service request based on CPU and memory. You can also enable Oracle Database Resource Manager for the database pool to control your CPU usage and the underlying service levels.

3. Request Settings

  • During this part of the schema as a service set up, future reservations, archive retention and duration of request can all be enabled.

4. Quotas

  • Controlling quotas and setting limits for users based on role level can be assigned in this step of the process. Oracle Enterprise Manager supports quota based on CPU, memory and number of database services.

5. Profiles and Service Templates

  • A service template is standardized definition that is offered to self-service users to create a database or schemas within the deployment. A service template defines the workload characteristics and schema details that can be generated with or without seed data.
  • To create a service template with seed data, you need to create a profile. A profile is an entity that captures source database information for provisioning purposes. Once you create your service template it becomes part of a collection which makes up the service catalog. This catalog is then exposed to cloud users in the self-service portal.
  • Next, you can either export the seed data from the source database or export the schema definitions without the data. Once you decide, a Data Pump Export job will be created.
  • You can now map your newly created profile and service templates to the required zone(s) and database pools.

6. Chargeback

  • The final step in deploying schema as a service is to configure resource metering and chargeback.
  • Setting up metering and chargeback can easily be done in order to track resource usage within the schema as a service implementation.
  • For more information on how to set up chargeback we recommend reading this white paper.


Product Info:
  • Oracle Cloud Management
  • Zero to Cloud Resource Center
  • Demos:
  • Oracle Cloud Management
  • Setting up Database Clouds for Schema as a Service
  • Whitepapers:
  • Delivering Database as a Service using Oracle Enterprise Manager 12c
  • Best Practices for Database Consolidation in Private Clouds
  • Oracle Enterprise Manager 12c: Metering and Chargeback
  • Cloud Management for Oracle Database

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

    Tuesday Mar 05, 2013

    Webcast: New Cloud Management Plug-Ins Provide Enhanced Capabilities for Deploying and Managing Clouds

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

    Join us for this presentation to learn about Oracle Enterprise Manager 12c's recent release of new and updated Management Plug-ins that provide optimum utilization of compute resources, ultimately leading to faster time-to-market for IT services delivery. In addition to providing enhanced cloud management support, the Plug-ins extend Oracle Enterprise Manager 12c's capabilities for Database as a Service (DBaaS) and Infrastructure as a Service (Iaas), as well as introduce new features for Testing as a Service (TaaS).

    Register Now!

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

    Friday Mar 01, 2013

    Oracle's TaaS: Spend More Time Testing (and Less on the Other Stuff)

    Recently we asked a group of testers what percentage of their testing time was spent on peripheral activities such as: 
    • procuring hardware  
    • deploying the application under test  
    • deploying a test tool  
    • find/detect/log issues/bugs  and/or 
    • patching an application
    Two thirds of those testers indicated they spent between 40% to 70% of their time on these peripheral activities. 

    When asked what the right solution could be to solve that enormous time consumption, the majority selected testing cloud solutions that combine capabilities for Infrastructure as a Service (IaaS) and Software as a Service. Let's look at each one :

    Infrastructure as a Service ( IaaS ) based testing cloud : This solution is typically based on provisioning of virtual machines on provided infrastructure . This will only resolve the provisioning of applications under test and test tools which is only 10-15% of the total solution.

  • Software as a Service ( SaaS ) based testing cloud : This is Software ( for test automation ) as a service solution. This only addresses the test execution and ( possibly ) issue/bottleneck identification. It does not offer provisioning for applications under test . In many cases, it does not offer monitoring of internal applications.

  • The brand new Oracle Enterprise Manager 12c Testing as a Service (TaaS) solution (.pdf) offers that combination and helps software development and QA organizations to spend more time on actual testing and less on peripheral activities, while significantly enhancing testing efficiency and reducing the duration of testing projects.

    Oracle's TaaS is a platform for delivering automated application testing services. It is a self-service solution designed for private clouds that orchestrates the testing process end-to-end by: 
    • Automating the provisioning of test labs including application under test and test tools. 
    • Executing load and/or functional test scripts against the application. 
    • Providing rich application monitoring and diagnostics data for analysis.
    • Sophisticated chargeback facility for metering and charging the usage of the testing cloud by end-users. 
    It's built with semantic understanding of testing artifacts like testing tools, applications, test scripts, it is not just VMs.

    All this information and more was discussed in a recent webcast we ran in cooperation with the online StickyMinds.com community. We uploaded the replay on Youtube for you to watch at your convenience.

    Happy testing!

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

    Wednesday Feb 27, 2013

    Oracle Enterprise Manager Cloud Control 12c Release 2 Plug-In Update 1 Installation and Upgrade Overview

    Oracle Enterprise Manager Cloud Control 12c Release 2 Plug-In Update 1 Installation and Upgrade Overview

    Friday, March 01, 9:00 a.m. PT

    Register Now

    Join us for this live technical presentation to learn about Oracle Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1 release and how it impacts you. This webcast is a must-attend event for users who have EM 12.1.0.x in their environment or are planning to deploy EM 12.1.0.x or upgrade to EM 12.1.0.x from older Enterprise Manager versions.

    Oracle has recently released new and updated Enterprise Manager Plug-ins which enables optimum utilization of compute resources giving customers more flexibility and control during application development, leading to faster time-to-market for delivering IT services. These plug-in provide enhanced support and extend EM's capabilities for Database as a Service (DBaaS), Infrastructure as a Service (IaaS), and introduce new features for Testing as a Service (TaaS).

    During this presentation we will review the following topics:

    • Overview of Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1
      • Does it have new features or bug fixes?
      • How do I get EM 12c Release 2 Plug-in Update 1 binaries?
      • Various Install/Upgrade/Additional OMS Usecases
      • What happens to Agent Binaries?
      • Go over Install/Upgrade FAQ on EM 12c Release 2 Plug-in Update 1
    • Quick overview of new version /revision of plug-ins
    • How to deploy new plug-in in your existing EM 12.1.0.x environment
      • In Offline or Online mode
      • Using emcli to reduce OMS downtime
    • Documentation
    • Q&A

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

    Tuesday Feb 12, 2013

    SquareTwo Financial uses Oracle Data Masking for Compliance and Improves Performance by 96%

    Watch as leading financial services firm, SquareTwo Financial, talks about maintaining compliance while increasing IT productivity and performance by replacing in-house data masking with Oracle Data Masking solution.

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

    Friday Feb 08, 2013

    Gartner Positions Oracle in Leaders Quadrant for Data Masking

    Gartner recently announced that Oracle Data Masking Pack, part of Oracle Enterprise Manager’s quality management and Oracle Database Security defense-in-depth solution, has been named a leader in the first Magic Quadrant for Data Masking Technology report.

    Oracle Data Masking strengths highlighted in the report include:

    • High performance data masking in Oracle Databases
    • Integration into Oracle Enterprise Manager 12c resulting in easy adoption
    • Availability of pre-built templates for popular packaged systems such as, Oracle E-Business Suite
    • Database security expertise and strong DBMS security portfolio

    About Oracle Data Masking
    Oracle Data Masking ensures privacy by transforming sensitive data before it is transferred to test, QA, and other non-production environments, addressing regulatory compliance for both Oracle and non-Oracle Databases.

    Oracle Data Masking Pack: Production data is cloned and masked before being copied to Test.

    Key Features:

    • Application data discovery
    • Centralized extensible format library
    • Comprehensive mask techniques
    • High performance masking with role-based security
    • Optimized for Oracle and non-Oracle databases
    • Integrated with Oracle testing products
    • Integrated with data subsetting

    Oracle Data Masking completely replaces sensitive information such as; names, account numbers, SSNs, financial results, purchasing transactions, etc. in your development, test and QA systems with data that cannot be “reverse engineered” to reveal its original source. This allows production data to be safely used for development, testing, or sharing with out-source or off-shore partners for other non-production purposes. The Pack provides extensive search capabilities to scan enterprise databases for sensitive data discovery based on established data patterns and models.

    The solution allows masking of all the related data elements automatically while preserving referential relationships combining the sensitive data columns and associated relationships in an Application Data Model. Oracle Data Masking can detect data dependencies, such as foreign key constraints and replaces sensitive information transparently. This ensures that the referential integrity necessary for applications to work and function properly will continue be in place, even on development systems.


    • Administrators will save time and eliminate risk by replacing individual scripts and routines written by DBAs with centrally managed and deployed libraries of masking processes.
    • Provides secure, scalable and automated solution to create test environments from production data using bulk masking.The solution enables faster time-to-market by speeding up the development process while helping organizations comply with privacy regulations and confidentiality policies.
    • Enables rapid DBA productivity through the use of application masking templates.
    • Supports custom data masks that are defined once and can be used every time that set of data needs to be masked.
    • Data security is integrated within the application management lifecycle, meaning that DBAs can provide realistic-masked production data to developers or testing groups for accurate application testing while reducing their storage costs by not having to provision an entire production environment for each developer or project.
    • Oracle Data Masking Pack is built into and installed with Oracle Enterprise Manager 12c.

    Data Masking for Security and Compliance
    Oracle Data Masking offers a comprehensive and customizable library of masking formats, templates and policies that can be used to replace sensitive information with realistic simulated values—all with just a few mouse clicks. The sensitive data never has to leave the Oracle Database or the production environment. This maintains data security and compliance through privacy and confidentiality polices on shared production data. The solution helps protect against unauthorized access to data that is being shared with off-shore developers, partners or 3rd party vendors.

    Oracle Data Masking Pack: Centralized Extensible Format Library.

    In addition, Oracle Data Masking allows organizations to enforce compliance with regulatory requirements such as; Sarbanes-Oxley, Payment Card Industry Data Security Standards, Health Insurance Portability and Accountability Act, as well as numerous other laws and regulations that restrict the use of actual customer data.

    Oracle Data Masking continues to gain strong adoption, check out the latest customers to see how they are benefiting from the solution:


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

    Wednesday Jan 30, 2013

    Coles Deploys Oracle Exadata and Oracle Enterprise Manager 12c

    Read the latest news about Coles Supermarkets, one of Australia's largest grocery chains with more than 100,000 employees and 2,000 stores country-wide. Learn how Coles completely revamped their data warehouse with Oracle Exadata and Oracle Enterprise Manager 12c . The new system improved Coles's processes and critical reporting by as much as 3 to 4x out-of-the-box with a 4 to 6x faster query performance. The result, higher quality of service for the business and for customers during peak seasonal spikes.


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

    Tuesday Jan 29, 2013

    WEBCAST: Protect Your Sensitive and Confidential Data Using Oracle Data Masking Solution

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

    Join us for a live and interactive webcast on how to comply with regulatory requirements and data protection policies by protecting sensitive data in non-production Oracle Databases as well as non-Oracle databases using Oracle Data Masking Pack, a part of Oracle Enterprise Manager 12c quality management and Oracle Database Security defense-in-depth solution. Topics include:

    • Automatically discovering sensitive data
    • Standard and advanced masking techniques made easy
    • Eliminate the need for a staging database using At-source masking
    • Secure your Oracle Applications (Oracle E-Business Suite, Oracle Fusion Applications) data quickly using masking templates
    • Seamless masking integration with Oracle's data subsetting solution
    Register today
    Stay Connected:
    Twitter |
    Facebook | YouTube | Linkedin | Newsletter
    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Thursday Jan 24, 2013

    HDFC Bank Deploys Database-as-a-Service with Oracle Enterprise Manager 12c

    Listen in as one of India’s largest banks discusses the benefits of using Oracle Enterprise Manager 12c to manage their database-as-a-service deployment.

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

    Tuesday Jan 15, 2013

    Answers to Your Common Database Performance Questions

    An Interview with Oracle Database Manageability Expert, Deba Chatterjee

    Throughout the year we hear from lots of customers and get many questions about managing Oracle Database. In this blog, I thought I would try and provide some answers to common diagnostics and tuning questions with the help of our product manager and residence expert for Oracle Database Manageability, Deba Chatterjee. Deba has a wealth of database performance tuning experience both inside and outside of Oracle managing large data warehouses. Deba is responsible for Oracle Diagnostics Pack for Database and Oracle Tuning Pack for Database. I recently sat down with Deba and had a chat about database manageability.

    Scott McNeil: Deba, we get many people asking questions about database performance—many still don't know about all the deep diagnostics capabilities Oracle Enterprise Manager 12c has to offer for Oracle Database. Capabilities such as; Compare Period ADDM, Real-Time ADDM, Active Session History (ASH) Analytics Real-Time SQL Monitoring, using Metric Extensions, and SQL Tuning Advisor—how do customers get all these capabilities for their database?

    Deba Chatterjee: We recently ran a webcast: Maximize Oracle Database Performance with Oracle Enterprise Manager 12c: Top 10 Tips and Tricks that explains how many of these features work. I highly recommend people watch the webcast to get a better understanding of the capabilities you mentioned. But the short answer is: for Compare Period ADDM, Real-Time ADDM, Metric Extensions you need to license Oracle Enterprise Manager 12c Diagnostics Pack for Database. For Real-Time SQL Monitoring, SQL Tuning Advisor, you will need the Oracle Tuning Pack for Database.

    Scott McNeil: Another question customers repeatedly ask is around Cloud Control and Database Control. Deba, can you explain the difference between Oracle Enterprise Manager Cloud Control 12c (formerly Grid Control) and Database Control.

    Deba Chatterjee: Although they belong to the same family of products there is a fundamental difference between the two. Database Control can be used to manage only a single database with which it has been configured, while Oracle Enterprise Manager Cloud Control 12c allows you to manage all your databases under the same centralized management console. Plus Cloud Control lets you manage not only all your databases but your entire application and technology stack too, whether it's in a private cloud or in a traditional environment.

    How do you modify the Metric Value History retention in Enterprise Manager? For example; Enterprise Manager only shows the last 7 days, how do you display longer than 7 days?

    Deba Chatterjee: There are various retention times based on the type of metric data:

    • Raw metric data: default retention time is 7 days
    • Hourly aggregated metric data: default retention is 31 days
    • Daily aggregated metric data: default retention is 12 months

    Refer to the documentation here, if you want to change the default retention time.

    For Compare Period ADDM, how do you relate that in the context of system load?

    Deba Chatterjee: In the resource usage tab, you can check the system CPU, Memory, I/O and interconnect (for RAC databases) utilizations across the 2 comparison periods in the same database.

    Does Compare Period ADDM take into account the average read and average write in order to identify why the variance is happening in performance?

    Deba Chatterjee: Compare Period ADDM uses database time to compare the performance across two periods. It does not compare based on average read or write times.

    Does Enterprise Manager have the ability to create customized performance graphs? For example; can you create a graph for CPU usage in the last 24 hours on a given Host?

    Deba Chatterjee: This is possible through the information publisher or BI publisher reports. As for the CPU usage, the chart is available out-of-the box in the target page for hosts.

    How do you connect to the database itself when it’s hung and won't allow any extra connections? Do you use command line? Can you use ADDM even though the database is hung?

    Deba Chatterjee: When the database is hung, you can connect to it using the diagnostic connection mode in Real-Time ADDM. The agent that is used to monitor the database makes the connection. No, command line is used. You have to use Real-Time ADDM for the connection.

    Is Oracle Enterprise Manager 12c compatible with older versions of the database?

    Deba Chatterjee: You can use Oracle Enterprise Manager 12c to monitor Oracle Database versions:,,,,,,, and

    Is SQL Performance Analyzer part of Oracle Database 11g or do you need to use Oracle Enterprise Manager 12c?

    Deba Chatterjee: SQL Performance Analyzer is built into the database and provides command line APIs. However, Oracle Enterprise Manager 12c provides the complete orchestration needed to capture the SQL tuning set, run the performance trials, and then to create a performance comparison report.

    How do you enable Enterprise Manager to monitor and send alerts to the DBAs for a "Runaway Query?”

    Deba Chatterjee: You can use EM to monitor runaway queries and send alerts using Metric Extensions which rely on the data captured in SQL Monitoring. The method was explained in this webcast presentation.

    How do you create a report for all the SQL running in an instance during a 30 minute timeframe? Can you export this to a spreadsheet?

    Deba Chatterjee: ASH stores sampled (1 seconds in memory or 10 seconds on-disk) SQL. However ASH is meant to capture the high load SQL statements so it won’t have all SQL statements.

    Do you recommend enabling automatic gathering of SQL baselines as a preventative measure of SQL regression?

    Deba Chatterjee: No. This would be overkill. Identify the queries that frequently change plans and then create SQL plan baselines.

    If a server has multiple database instances, what is the best way to effectively do resource allocation?

    Deba Chatterjee: There is no silver bullet. Carefully study your database load and decide on use of services, instance caging and resource managers to manage load on servers.

    When using SQL Performance Analyzer, do you create the baseline first before the code change is deployed or at peak DB time?

    Deba Chatterjee: These are two different problems. While testing for Code change, the baseline should be created before the code is deployed. While testing for an upgrade scenario the baseline needs to be created at a peak DB time.

    Is there a metric to monitor ASM disk group utilization at the cluster level?

    Deba Chatterjee: Yes. ASM Disk Group Usage metric is what you can use. (See image below)

    Can Oracle Enterprise Manager’s alerts be configured to monitor elements in the audit trail such as table creation or table drop?

    Deba Chatterjee: Yes, these type of alerts can be configured using Metric Extensions.


    Have a database manageability question? Ask us on Twitter or Facebook.

    Stay Connected:

    Twitter |
    Facebook | YouTube | Linkedin | Newsletter

    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    Friday Dec 21, 2012

    Oracle-validated NetApp Storage Plug-in for Enterprise Manager 12c

    The following is a Guest Blog, contributed by Anand Ranganathan, Product Manager for Oracle Products and Solutions at NetApp

    As a DBA managing databases running on storage systems, some of your major challenges are how do you:

    • Pinpoint storage related problems in a timely manner
    • Proactively respond to problems
    • Map a database file to its underlying storage component
    • Reduce your dependency on the storage admin
    • Solve these problems using an Oracle product that you use everyday

    If you are planning to or are currently running your Oracle databases on NetApp storage systems then the NetApp Storage System Plug-in for Oracle Enterprise Manager 12c resolves the above challenges by:

    • Consolidating information about Oracle on NetApp environments into the Enterprise Manager Cloud Control Console providing one interface to monitor databases and storage systems
    • Correlating and pinpointing storage related database problems by mapping database components like tablespaces, datafiles to storage components like aggregates, volumes using built-in reports and automating collecting a comprehensive set of availability, performance and usage metrics with pre-defined thresholds.  Alerts are automatically sent out when thresholds are breached helping you to respond proactively to problems before they occur.  You can also ensure routine responses to alerts are automatically executed using corrective actions
    • Increasing operational efficiencies by allowing you to standardize optimal Monitoring settings into a template and apply them to one or more NetApp Storage systems, report on historical metrics data for trend analysis & planning database storage needs, compare multiple storage system configurations to ensure they are deployed as per standards and prevent unnecessary alerts during scheduled downtimes with Blackout Periods

    The plug-in was built by NetApp using the Enterprise Manager 12c Extensibility Kit that not only helped us develop screens that have a rich look and feel but also helped enrich the plug-in by allowing us to leverage Cloud Control’s powerful monitoring and event management features for monitoring of NetApp storage systems. 

    The NetApp Storage System Plug-in for Oracle Enterprise Manager 12c is free and is listed at the Enterprise Manager Extensibility Exchange.  The plug-in has achieved Oracle Validated Integration, which provides customers the confidence knowing that it:

    • is designed and built in a reliable, standardized way
    • has been tested as functionally and technically sound
    • operates and performs as documented

    Here is a screenshot of the dashboard of a NetApp storage system monitored with Enterprise Manager 12c via the NetApp plug-in.

    Customers and partners can visit the NetApp Communities site to watch a demo and download the plug-in.  If you are a partner, visit the Oracle PartnerNetwork Validated Integration Knowledge Zone to learn more about the validation program.

    Tuesday Dec 11, 2012

    Epsilon : An Oracle Customer Profile

    ZDNet published an article today based on the interview of Jeff White, vice president, technology, strategic database services at Epsilon. Jeff discussed Oracle Exadata Database Machine and Oracle Enterprise Manager with the ZDNet writer

    Read the article  Epsilon : An Oracle Customer Profile .

    Jeff White, Epsilon VP, was honored with Oracle’s Data Warehouse Leader of the Year for Innovative Data Warehouse Deployment of Oracle Exadata and Oracle Enterprise Manager earlier this year.

    In one of the videos earlier this year, Jeff mentioned that Epsilon has streamlined IT administration, monitoring, and engineered systems maintenance with Oracle Enterprise Manager. Having gained in operational efficiencies, Epsilon is now providing greater efficiencies to its customers.

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

    Twitter | Facebook | YouTube | Linkedin | Newsletter

    Monday Nov 12, 2012

    Answers to Your Common Oracle Database Lifecycle Management Questions

    We recently ran a live webcast on Strategies for Managing Oracle Database's Lifecycle. There were tons of questions from our audience that we simply could not get to during the hour long presentation. Below are some of those questions along with their answers. Enjoy!

    Question: In the webcast the presenter talked about “gold” configuration standards, for those who want to use this technique, could you recommend a best practice to consider or follow? How do I get started?

    Gold configuration standardization is a quick and easy way to improve availability through consistency. Start by choosing a reference database and saving the configuration to the Oracle Enterprise Manager repository using the Save Configuration feature. Next create a comparison template using the Oracle provided template as a starting point and modify the ignored properties to eliminate expected differences in your environment. Finally create a comparison specification using the comparison template you created plus your saved gold configuration and schedule it to run on a regular basis. Don’t forget to fill in the email addresses of those you want to notify upon drift detection. Watch the database configuration management demo to learn more.

    Question: Can Oracle Lifecycle Management Pack for Database help with patching an Oracle Real Application Cluster (RAC) environment?

    Yes, Oracle Enterprise Manager supports both parallel and rolling patch application of Oracle Real Application Clusters. The use of rolling patching is recommended as there is no downtime involved. For more details watch this demo.

    Question: What are some of the things administrators can do to control configuration drift? Why is it important?

    Configuration drift is one of the main causes of instability and downtime of applications. Oracle Enterprise Manager makes it easy to manage and control drift using scheduled configuration comparisons combined with comparison templates.

    Question: Does Oracle Enterprise Manager 12c Release 2 offer an incremental update feature for "gold" images? For instance, if the source binary has a higher PSU level, what is the best approach to update the existing "gold" image in the software library? Do you have to create a new image or can you just update the original one?

    Provisioning Profiles (Gold images) can contain the installation files and database configuration templates. Although it is possible to make some changes to the profile after creation (mainly to configuration), it is normally recommended to simply create a new profile after applying a patch to your reference database.

    Question: The webcast talked about enforcing in-house standards, does Oracle Enterprise Manager 12c offer verification of your databases and systems to those standards? For example, the initial "gold" image has been massively deployed over time, and there may be some changes to it. How can you do regular checks from Enterprise Manager to ensure the in-house standards are being enforced?

    There are really two methods to validate conformity to standards.

    The first method is to use gold standards which you compare other databases to report unwanted differences. This method uses a new comparison template technology which allows users to ignore known differences (i.e. SID, Start time, etc) which results in a report only showing important or non-conformant differences. This method is quick to setup and configure and recommended for those who want to get started validating compliance quickly.

    The second method leverages the new compliance framework which allows the creation of specific and robust validations. These compliance rules are grouped into standards which can be assigned to databases quickly and easily. Compliance rules allow for targeted and more sophisticated validation beyond the basic equals operation available in the comparison method. The compliance framework can be used to implement just about any internal or industry standard. The compliance results will track current and historic compliance scores at the overall and individual database targets. When the issue is resolved, the score is automatically affected. Compliance framework is the recommended long term solution for validating compliance using Oracle Enterprise Manager 12c. Check out this demo on database compliance to learn more.

    Question: If you are using the integration between Oracle Enterprise Manager and My Oracle Support in an "offline" mode, how do you know if you have the latest My Oracle Support metadata?

    In Oracle Enterprise Manager 12c Release 2, you now only need to download one zip file containing all of the metadata xmls files. There is no indication that the metadata has changed but you could run a checksum on the file and compare it to the previously downloaded version to see if it has changed.

    Question: What happens if a patch fails while administrators are applying it to a database or system?

    A large portion of Oracle Enterprise Manager's patch automation is the pre-requisite checks that happen to ensure the highest level of confidence the patch will successfully apply. It is recommended you test the patch in a non-production environment and save the patch plan as a template once successful so you can create new plans using the saved template.

    If you are using the recommended ‘out of place’ patching methodology, there is no urgency because the database is still running as the cloned Oracle home is being patched. Users can address the issue and restart the patch procedure at the point it left off.

    If you are using 'in place' method, you can address the issue and continue where the procedure left off.

    Question: Can Oracle Enterprise Manager 12c R2 compare configurations between more than one target at the same time?

    Oracle Enterprise Manager 12c can compare any number of target configurations at one time. This is the basis of many important use cases including Configuration Drift Management. These comparisons can also be scheduled on a regular basis and emails notification sent should any differences appear. To learn more about configuration search and compare watch this demo.

    Question: How is data comparison done since changes are taking place in a live production system?

    There are many things to keep in mind when using the data comparison feature (as part of the Change Management ability to compare table data). It was primarily intended to be used for maintaining consistency of important but relatively static data. For example, application seed data and application setup configuration. This data does not change often but is critical when testing an application to ensure results are consistent with production. It is not recommended to use data comparison on highly dynamic data like transactional tables or very large tables.

    Question: Which versions of Oracle Database can be monitored through Oracle Enterprise Manager 12c?

    Oracle Database versions:,,,,,,,

    Watch the On-Demand Webcast

    Stay Connected:

    Twitter |
    Facebook | YouTube | Linkedin | Newsletter

    Download the Oracle Enterprise Manager Cloud Control12c Mobile app

    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

    Thursday Oct 04, 2012

    Oracle Enterprise Manager sessions on the last day of the Oracle Open World

    Hope you had a very productive Oracle Open World so far . Hopefully, many of you attended the customer appreciation event yesterday night at the Treasures Islands. 

     We still have many enterprise manager related sessions today on Thursday, last day of Oracle Open World 2012.

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

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

    Time Title Location
    11:15 AM - 12:15 PM Application Performance Matters: Oracle Real User Experience Insight Palace Hotel - Sea Cliff
    11:15 AM - 12:15 PM Advanced Management of JD Edwards EnterpriseOne with Oracle Enterprise Manager InterContinental - Grand Ballroom B
    11:15 AM - 12:15 PM Spark on SPARC Servers: Enterprise-Class IaaS with Oracle Enterprise Manager 12c Moscone West - 3018
    11:15 AM - 12:15 PM Pinpoint Production Applications’ Performance Bottlenecks by Using JVM Diagnostics Marriott Marquis - Golden Gate C3
    11:15 AM - 12:15 PM Bringing Order to the Masses: Scalable Monitoring with Oracle Enterprise Manager 12c Moscone West - 3020
    12:45 PM - 1:45 PM Improving the Performance of Oracle E-Business Suite Applications: Tips from a DBA’s Diary Moscone West - 2018
    12:45 PM - 1:45 PM Advanced Management of Oracle PeopleSoft with Oracle Enterprise Manager Moscone West - 3009
    12:45 PM - 1:45 PM Managing Sun Servers and Oracle Engineered Systems with Oracle Enterprise Manager Moscone West - 2000
    12:45 PM - 1:45 PM Strategies for Configuring Oracle Enterprise Manager 12c in a Secure IT Environment Moscone West - 3018
    12:45 PM - 1:45 PM Using Oracle Enterprise Manager 12c to Control Operational Costs Moscone South - 308
    2:15 PM - 3:15 PM My Oracle Support: The Proactive 24/7 Assistant for Your Oracle Installations Moscone West - 3018
    2:15 PM - 3:15 PM Functional and Load Testing Tips and Techniques for Advanced Testers Moscone South - 307
    2:15 PM - 3:15 PM Oracle Enterprise Manager Deployment Best Practices Moscone South - 104

    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


    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

    IOUG and Oracle Enterprise Manager User Community Twitter Chat and Sessions at OpenWorld

    Like last many years, we will have annual Oracle Users Forum on Sunday, September 30th, 2012 at Moscone West, Levels 2 & 3 . It will be open to all registered attendees of Oracle Open World and conferences running from September 29 to October 5, 2012 .

    This will be a great  opportunity to meet with colleagues, peers, and subject matter experts to share best practices, tips, and techniques around Oracle technologies. You could sit in on a special interest group (SIG) meeting or session and learn how to get more out of Oracle technologies and applications.

    IOUG and Oracle Enterprise Manager team invites you to join a Twitter Chat on Sunday, Sep. 30th from 11:30 AM to 12:30 PM.  IOUG leaders, Enterprise Manager SIG contributors and many Oracle Users Forum speakers will answer questions related to their experience with Oracle Enterprise Manager and the activities and resources available for  Enterprise Manager SIG members.

    You can participate in the chat using hash tag #em12c on Twitter.com or by going to  tweetchat.com/room/em12c      (Needs Twitter credential for participating).  Feel free to join IOUG and Enterprise team members at the User Group Pavilion on 2nd Floor, Moscone West.

    RSVP by going http://tweetvite.com/event/IOUG  .

    Here is the complete list of Oracle Enterprise Manager sessions during the Oracle Users Forum :


    Session Title



    8:00AM - 8:45AM

    UGF4569 - Oracle RAC Migration with Oracle Automatic Storage Management and Oracle Enterprise Manager 12c

    VINOD Emmanuel -Database Engineering, Dell, Inc.
    Wendy Chen - Sr. Systems Engineer, Dell, Inc.

    Moscone West - 2011

    8:00AM - 8:45AM

    UGF10389 -  Monitoring Storage Systems for Oracle Enterprise Manager 12c

    Anand Ranganathan - Product Manager, NetApp

    Moscone West - 2016

    9:00AM - 10:00AM

    UGF2571 - Make Oracle Enterprise Manager Sing and Dance with the Command-Line Interface

    Ray Smith - Senior Database Administrator, Portland General Electric

    Moscone West - 2011

    10:30AM - 11:30AM

    UGF2850 - Optimal Support: Oracle Enterprise Manager 12c Cloud Control, My Oracle Support, and More

    April Sims - DBA, Southern Utah University

    Moscone West - 2011

    11:30AM - 12:30PM

    IOUG and Oracle Enterprise Manager Joint Tweet Chat 

    Join IOUG Leaders, IOUG's Enterprise Manager SIG Contributors and Speakers on Twitter and ask questions related to practitioner's experience with Oracle Enterprise Manager and the new IOUG 's Enterprise Manager SIG.

    To attend and participate in the chat, please use hash tag #em12c on twitter.com or your favorite Twitter client. You can also go to tweetchat.com/room/em12c to watch the conversation or login with your twitter credentials to ask questions.

    User Group Pavilion

    2nd Floor,

    Moscone West


    UGF5131 - Migrating from Oracle Enterprise Manager 10g Grid Control to 12c Cloud Control   

    Leighton Nelson - Database Administrator, Mercy

    Moscone West - 2011


    UGF6511 -  Database Performance Tuning: Get the Best out of Oracle Enterprise Manager 12c Cloud Control

    Mike Ault - Oracle Guru, TEXAS MEMORY SYSTEMS INC
    Tariq Farooq - CEO/Founder, BrainSurface

    Moscone West - 2011


    UGF4556 - Will It Blend? Verifying Capacity in Server and Database Consolidations

    Jeremiah Wilton - Database Technology, Blue Gecko / DatAvail

    Moscone West - 2018


    UGF10400 - Oracle Enterprise Manager 12c: Monitoring, Metric Extensions, and Configuration Best Practices

    Kellyn Pot'Vin - Sr. Technical Consultant, Enkitec

    Moscone West - 2011

    Stay Connected:

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

    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)

    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

    Database Performance Testing, Data Masking, and Subsetting
    (session ID# HOL10720)

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

    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

    Thursday Aug 30, 2012

    Oracle collaborates with leading IT vendors on Cloud Management Standards

    During the last couple of days, two key specifications for cloud management standards have been announced. Oracle collaborated with leading technology vendors from the IT industry on both of these cloud management specifications. One of the specifications focuses "Infrastructure as a Service" ( IaaS )  cloud service model , while the other specification announced today focuses on "Platform as a Service" ( PaaS ) cloud service model. Please see The NIST Definition of Cloud Computing to learn more about IaaS and PaaS .

    Earlier today Oracle , CloudBees, Cloudsoft, Huawei, Rackspace, Red Hat, and Software AG   announced the Cloud Application Management for Platforms (CAMP) specification that will be submitted to Organization for the Advancement of Structured Information Standards (OASIS) for development of an industry standard, in an effort to help ensure interoperability for deploying and managing applications across cloud environments.

     Typical PaaS architecture - Source : CAMP specification

    The CAMP specification defines the artifacts and APIs that need to be offered by a PaaS cloud to manage the building, running, administration, monitoring and patching of applications in the cloud. Its purpose is to enable interoperability among self-service interfaces to PaaS clouds by defining artifacts and formats that can be used with any conforming cloud and enable independent vendors to create tools and services that interact with any conforming cloud using the defined interfaces. Cloud vendors can use these interfaces to develop new PaaS offerings that will interact with independently developed tools and components.

    In a separate cloud standards announcement yesterday, the Distributed Management Task Force ( DMTF ), the organization bringing the IT industry together to collaborate on systems management standards development, validation, promotion and adoption, released the new Cloud Infrastructure Management Interface (CIMI) specification. Oracle collaborated with various technology vendors and industry organizations on this specification.

    CIMI standardizes interactions between cloud environments to achieve interoperable cloud infrastructure management between service providers and their consumers and developers, enabling users to manage their cloud infrastructure use easily and without complexity. DMTF developed CIMI as a self-service interface for infrastructure clouds ( IaaS focus ) , allowing users to dynamically provision, configure and administer their cloud usage with a high-level interface that greatly simplifies cloud systems management.

    Mark Carlson, Principal Cloud Strategist at Oracle provides more details about CAMP  and CIMI his blog .

    Stay Connected:

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


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

    Related Blogs


    « November 2015