Sunday Sep 09, 2012

Extending Database-as-a-Service to Provision Databases with Application Data

Oracle Enterprise Manager 12c Database as a Service (DBaaS) empowers Self Service/SSA Users to rapidly spawn databases on demand in cloud. The configuration and structure of provisioned databases depends on respective service template selected by Self Service user while requesting for database. In EM12c, the DBaaS Self Service/SSA Administrator has the option of hosting various service templates in service catalog and based on underlying DBCA templates.

Many times provisioned databases require production scale data either for UAT, testing or development purpose and managing DBCA templates with data can be unwieldy. So, we need to populate the database using post deployment script option and without any additional work for the SSA Users. The SSA Administrator can automate this task in few easy steps. For details on how to setup DBaaS Self Service Portal refer to the DBaaS Cookbook

In this article, I will list steps required to enable EM 12c DBaaS to provision databases with application data in two distinct ways using: 1) Data pump 2) Transportable tablespaces (TTS). The steps listed below are just examples of how to extend EM 12c DBaaS and you can even have your own method plugged in part of post deployment script option.

Using Data Pump to populate databases

These are the steps to be followed to implement extending DBaaS using Data Pump methodolgy:

  1. Production DBA should run data pump export on the production database and make the dump file available to all the servers participating in the database zone [sample shown in Fig.1]

    -- Full export
    expdp FULL=y DUMPFILE=data_pump_dir:dpfull1%U.dmp, data_pump_dir:dpfull2%U.dmp PARALLEL=4 LOGFILE=data_pump_dir:dpexpfull.log JOB_NAME=dpexpfull

    Figure-1:  Full export of database using data pump

  2. Create a post deployment SQL script [sample shown in Fig. 2] and this script can either be uploaded into the software library by SSA Administrator or made available on a shared location accessible from servers where databases are likely to be provisioned

    -- Full import
        h1   NUMBER;
    -- Creating the directory object where source database dump is backed up.
        execute immediate 'create directory DEST_LOC as''/scratch/nagrawal/OracleHomes/oradata/INITCHNG/datafile''';
    -- Running import
        h1 := (operation => 'IMPORT', job_mode => 'FULL', job_name => 'DB_IMPORT10');
        dbms_datapump.set_parallel(handle => h1, degree => 1);
        dbms_datapump.add_file(handle => h1, filename => 'IMP_GRIDDB_FULL.LOG', directory => 'DATA_PUMP_DIR', filetype => 3);
        dbms_datapump.add_file(handle => h1, filename => 'EXP_GRIDDB_FULL_%U.DMP', directory => 'DEST_LOC', filetype => 1);
        dbms_datapump.start_job(handle => h1);
        dbms_datapump.detach(handle => h1);

    Figure-2: Importing using data pump pl/sql procedures

  3. Using DBCA, create a template for the production database – include all the init.ora parameters, tablespaces, datafiles & their sizes
  4. SSA Administrator should customize “Create Database Deployment Procedure” and provide DBCA template created in the previous step.
  5. In “Additional Configuration Options” step of Customize “Create Database Deployment Procedure” flow, provide the name of the SQL script in the Custom Script section and lock the input (shown in Fig. 3). Continue saving the deployment procedure.

    Figure-3: Using Custom script option for calling Import SQL

  6. Now, an SSA user can login to Self Service Portal and use the flow to provision a database that will also  populate the data using the post deployment step.

Using Transportable tablespaces to populate databases

Copy of all user/application tablespaces will enable this method of populating databases. These are the required steps to extend DBaaS using transportable tablespaces:

  1. Production DBA needs to create a backup of tablespaces. Datafiles may need conversion [such as from Big Endian to Little Endian or vice versa] based on the platform of production and destination where DBaaS created the test database. Here is sample backup script shows how to find out if any conversion is required, describes the steps required to convert datafiles and backup tablespace.
  2. SSA Administrator should copy the database (tablespaces) backup datafiles and export dumps to the backup location accessible from the hosts participating in the database zone(s).
  3. Create a post deployment SQL script and this script can either be uploaded into the software library by SSA Administrator or made available on a shared location accessible from servers where databases are likely to be provisioned. Here is sample post deployment SQL script using transportable tablespaces.
  4. Using DBCA, create a template for the production database – all the init.ora parameters should be included. NOTE: DO NOT choose to bring tablespace data into this template as they will be created
  5. SSA Administrator should customize “Create Database Deployment Procedure” and provide DBCA template created in the previous step.
  6. In the “Additional Configuration Options” step of the flow, provide the name of the SQL script in the Custom Script section and lock the input. Continue saving the deployment procedure.
  7. Now, an SSA user can login to Self Service Portal and use the flow to provision a database that will also populate the data using the post deployment step.

More Information:

Stay Connected:

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

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

Friday Aug 24, 2012

Managing Oracle Exalogic Elastic Cloud with Oracle Enterprise Manager Ops Center

Oracle Enterprise Manager Ops Center 12c now comes out-of-the-box  with the latest release of Oracle Exalogic Elastic Cloud 2.0.1 software. It allows Customer to manage and monitor all components inside the Exalogic rack, including provisioning and management of physical and virtualized server. Ops Center will allow Customers to easily get started with creating and managing Private Clouds using the Exalogic components.

Here is a snaphot of the Assets view showing the managable components of a Quarter Rack with 8 Compute Nodes:

A colleague has recently posted an interesting series of "Exalogic 2.0.1 Tea Break Snippets" which will guide you through the initial steps to get started with setting up your Exalogic environment:

Exalogic 2.0.1 Tea Break Snippets - Creating Cloud Users

Exalogic 2.0.1 Tea Break Snippets - Creating Networks

Exalogic 2.0.1 Tea Break Snippets - Allocating Static IP Addresses

Exalogic 2.0.1 Tea Break Snippets - Creating Accounts

Exalogic 2.0.1 Tea Break Snippets - Importing Public Server Template

Have fun reading these very useful postings !

Dr. Jürgen Fleischer , Oracle Enterprise Manager Ops Center Engineering

Stay Connected:

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

Monday Aug 20, 2012

Oracle's Jointly Developed x86 Servers and System Management Software

Earlier this year, Oracle launched its latest x86 servers with the M3 generational refresh. In this video listen to David Simmons, Sr. Director, Oracle Servers Marketing talk about Oracle's latest x86 servers and Steve Wilson, VP, Oracle Systems management software, talk about Oracle's Systems management solution that manages the servers as well as entire IT stack from application software to storage disks.

Stay Connected:

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

Thursday Aug 02, 2012

Oracle Cloud Builder Summit—Your Fast Track to the Enterprise Private Cloud

Remember Felix and Ed from the Enterprise Manager video series ?

They are now coming to a city near you, as part of the Oracle Cloud Builder Summit starting August 3, 2012, to show you how to build—in only two hours—an enterprise cloud environment.

Watch as we introduce you to Vulcan International, a fast-growth company that’s taking the world by storm, delivering new innovate products to the market faster than their competition. Vulcan’s CIO, Felix Drummond, facing a challenge when the CMO informs him that a new product, which will be launched early next week, is expecting a much higher than anticipated demand and the CMO wants IT to prepare for 25x more customer activations.

At the heart of it all is Ed Muntz, Vulcan’s intrepid cloud architect. Ed rises up to the impossible challenge and leads the company’s transformation to the cloud using the latest solutions from Oracle—including, Oracle Database, Oracle Fusion Middleware, Oracle VM and Oracle Enterprise Manager, as well as Oracle’s full range of engineered systems.

At this event, we'll show you how to:

  • Build and operate clouds
  • Efficiently consolidate onto shared, scalable cloud platforms and infrastructure
  • Secure and integrate clouds

This content-rich event will feature multiple demonstrations. You’ll learn how to fast-track your applications to the cloud with Oracle, and support every aspect of planning, deploying, monitoring, and managing enterprise clouds.

Click on the banner below to learn about the nearest city where you could attend the event.

Stay Connected:

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

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

My Favourite Features of Enterprise Manager Cloud Control 12c - Today’s topic: Incident Management

Enterprise Manager Cloud Control 12c (EM12c) is a huge release, both in terms of its adoption rate (that is, its uptake in the market) and the amount of functionality included in the product. For those of us that have been around for a long time, it’s very reminiscent of the massive functionality leap from Oracle RDBMS version 6 to version 7 – a quantum leap that makes it difficult to even grasp the breadth of the product now.

To try and make the new features a bit more understandable, I’ll be writing a number of blog entries over the coming months to highlight just some of my favourite new features for EM12c. From an administrator’s perspective, one of those standout features (and the subject of today’s entry) has to be incident management.

The goal of incident management is to enable administrators to monitor and resolve service disruptions that may be occurring in their data centre as quickly and efficiently as possible. Instead of managing the numerous discrete individual events that may be raised as the result of any of these service disruptions, we want to manage a smaller number of more meaningful incidents, and to manage them based on business priority across the lifecycle of those incidents.

To do this, Enterprise Manager now provides a centralized incident console called Incident Manager that will enable the administrator to track, diagnose, and resolve incidents, as well as providing features to help rectify the root causes of recurrent incidents. Incident Manager also directly leverages Oracle’s own expertise via My Oracle Support knowledge base articles and documentation to enable administrators to accelerate the process of diagnosing and resolving incidents and problems. Finally, Incident Manager also offers the ability to do lifecycle operations for incidents, so you can assign ownership of an incident to a specific user, acknowledge an incident, set priority for an incident, track an incident’s status, escalate an incident or suppress it so you can defer it to a later time. You can also raise notifications on an incident or open a helpdesk ticket via the helpdesk connectors.


Enterprise Manager continues to be the primary tool for managing and monitoring the Oracle data center, so it manages and monitors Oracle applications as well as the application stack from presentation layer to middleware, databases to hosts and the operating system, as well as non-Oracle technology. When Enterprise Manager detects issues in any of this infrastructure, it raises events. Sample events might be:

1. Metric alerts (for example, CPU utilization or tablespace usage alerts) where a critical threshold you set has been crossed

2. Job events – events are raised by the job system for job statuses that you specify, for example an event is raised to signal the failure of a job.

3. Standards violations – if you are using compliance standards and any of the targets that are being monitored violate any of the compliance standards, then a standards violation event could be raised.

4. Availability events – if a target is down and Enterprise Manager detects that, an availability event that the target is down can be raised

5. Other events – there are other types of events that occur as well

All these events signal particular issues have occurred in the managed data centre. As an administrator, you really want to be able to determine which of these events are significant. From these significant events, you then want to be able to correlate discrete events that are related to the same underlying issue, so you in fact have to manage a smaller number of significant incidents.


An incident could then be defined as an object containing a significant event (such as a target being down, for example) or it could be a combination of events that all relate to the same issue (for example, running out of space could be detected by Enterprise Manager as separate events raised from the database, host and storage target types). For example, you may have a performance incident that amalgamates a number of performance events, another incident related to space, and a different incident based on availability problems.

Sound good? OK, so how do we do this? Well, events are significant occurrences in your IT infrastructure and that Enterprise Manager detects and raises. Each event has a set of attributes– what type of event it is, the severity (fatal, critical and so on), the object or entity on which the event is raised (typically a target but it can also be a job or some other object), the message associated with the event, the timestamp at which it occurred, as well as the functional category (such as availability, security etc.)

Some examples of the different types of events include:

· Target availability: raised when a target is down or has gone into an agent unreachable state.

· Metric alert: raised when a metric crosses its threshold.

· Job status change: raised, for example, when a job fails.

· Compliance standard rule: raised when a compliance standard rule is violated.

· Metric evaluation: raised when there is an error with the evaluation of a metric.

· Other events such as SLA Alert, High Availability and Compliance Standard Score violation can also be raised, and of course, users can cause an event to be raised.

Associated with these event types are event severities. The first of these, “Fatal”, is a new severity level in Enterprise Manager specifically associated with the target availability event type for when the target is down. Critical and warning events have the same meaning as they had in previous releases, and then we have the Advisory level. Typically, this is associated with non-service-impacting events such as compliance standard violation events. The informational level is an event severity used to indicate simply that an event has occurred, but there is no need to do anything about it.

As we discussed previously, an actual incident will contain one or more events. Let’s look at the details of an incident with one event. For example, Figure 1 shows us an availability event:

Figure 1: Incident with one event

The event signals that the database DB1 is down and includes a timestamp of when the event was raised. Because this is a target availability event and the database is down, the severity is marked as Fatal. An incident can be created for that event, so the incident contains only one event. In order to manage and track the resolution of the incident, the incident has other attributes such as owner (the Enterprise Manager user that is working on the incident), status, incident severity (which is based on the event severity), priority and a comment field.

Many incidents will instead contain multiple events, where those events are related and pointed to the same underlying cause. In the example shown in Figure 2, we have two metric alert events on a host target -- a memory utilization metric alert event and a CPU utilization metric alert event because the host is starting to suffer from heavy load. We have a warning severity memory utilization metric alert event, and a short time later a critical severity CPU utilization metric alert event.

Figure 2: Incident with multiple events

An incident can be created containing both events in order to manage and track the resolution of the incident. In the current release, the administrator needs to manually combine events into an incident in the Enterprise Manager console (the automatic grouping of related events into an incident is a future enhancement). Again, we have additional attributes associated with the incident like we had in the previous example. Enterprise Manager automatically assigns the incident severity, based on the worst case event severity of all the events contained in the incident. Since the worst event severity is Critical, the incident severity is also set to Critical. Finally, the incident has a summary which is a short description of what the incident is about. The individual events are indicating the machine load is high so you can set the summary to that. Alternatively, you can set the incident summary to be the same as the event messages.

If you are using one of the helpdesk connectors to interface to a helpdesk system, an incident might also result in a helpdesk ticket which can allow the helpdesk analyst to work on the ticket. Within Enterprise Manager, we’ll be able to track both the ticket number and the status of that particular ticket.


A problem is the underlying root cause of an incident. In Enterprise Manager terms, a problem is specifically related to either an Automatic Diagnostic Repository (ADR) incident or Oracle software incident. Enterprise Manager will automatically create a problem whenever it detects an ADR incident has been raised. An ADR incident can be thought of as a critical Oracle software problem where the resolution of the software problem typically involves contacting Oracle Support, opening a service request and possibly receiving a patch for that problem.

Whenever an ADR incident is raised, we generate one incident in Enterprise Manager for that ADR incident, and we also automatically generate a problem as well. All the ADR incidents that have the same problem signature (that is, the same root cause) will be linked into a single problem object. The administrator can manage the problem in Incident Manager in the same way as you would manage an incident, so you can assign an owner to the problem, track the resolution and so on. In addition, there are in-context links to Support Workbench functionality which allows the administrator to package the diagnostic material, open a service request and view the status of diagnostic activity such as the SR number and ultimately bug number (if one is generated) within the user interface.

Figure 3 shows a diagrammatic example of how incidents and problems are related. Two ADR incidents have occurred, in this example two ORA-600 errors have occurred in my database. Both of these incidents are of critical severity. Enterprise Manager automatically creates a problem containing those incidents. Within the Incident Manager interface you can link to the Support Workbench to open a service request which you can then track from Incident Manager.

Figure 3: Incidents and problems

So now you have an understanding of the terminology and relationships between these terms, what’s next? Well, the next thing to understand is just how you deal with these incidents. That will be the topic of my next blog, so stay tuned for more!

Contributed by Pete Sharman , Principal Product Manager, Oracle Enterprise Manager

Stay Connected:

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

Monday Jul 23, 2012

Oracle Enterprise Manager Ops Center 12c Update 1 - Additional Information and Best Practices

Oracle Enterprise Manager Ops Center 12c Update 1 was released earlier this month. Eran Steiner , Technical Architect, Oracle Enterprise Manager, adds some additional information and best practices about upgrading to Ops Center 12c Update 1 in this blog.

Eran hosted a call to provide an overview of Oracle Enterprise Manager Ops Center 12c Update 1 and answer any questions.The recording of this call is available here and the presentation can be downloaded here.

[Read More]

Friday Jul 06, 2012

Oracle Enterprise Manager Ops Center 12c Update 1 is available now

Following the announcement of Oracle Enterprise Manager Ops Center 12c on April 4th, we are happy to announce the release of Oracle Enterprise Manager Ops Center 12c update 1. This is a bundled patch release for Oracle Enterprise Manager Ops Center. 

Here are the key features of the Oracle Enterprise Manager Ops Center 12c update 1 :

  • Oracle VM SPARC Server Pool HA Policy 
  • Automatically Upgrade from Ops Center 11g update 3 and Ops Center 12c 
  • Oracle Linux 5.8 and 6.x Support 
  • Oracle VM SPARC IaaS (Virtual Datacenters)
  • WANBoot Improvements with OBP Handling Enhancements
  • SPARC SuperCluster Support
  • Stability fixes

This new release contains significant enhancements in the update provisioning, bare metal OS provisioning, shared storage management, cloud/virtual datacenter, and networking management sections of the product.  With this update, customers can achieve better handling of ASR faults, add networks and storage to virtual guests more easily, understand IPMP and VLAN configurations better, get a more robust LDAP integration, get  virtualization aware firmware patching, and observe improved product performance across the board.  Customers can now accelerate Oracle VM SPARC and T4 deployments into production .

Oracle Enterprise Manager Ops Center 11g and Ops Center 12c customers will now notice the availability of new product update under the Administration tab within the  Browser User Interface (BUI) .  Upgrade process is explained in detail within the Ops Center Administration Guide under “Chapter 10: Upgrading”.  Please be sure to read over that chapter and the Release Notes before upgrading. 

During the week of July 9th,  the full download of the product will be available from the Oracle Enterprise Manager Ops Center download website.  Based on the customer feedback, we have changed the updates to include the entire product. Customers no longer need to install Ops Center 12c and then upgrade to the update 1 release.  The can simply install Ops Center 12c update 1 directly. 

Here are some of the resources that can help you learn more about the Oracle Enterprise Manager Ops Center and the new update 1.

Watch the recording of Oracle Enterprise Manager 12c launch webcast by clicking the following banner.

Stay Connected:

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

Wednesday Jul 04, 2012

Oracle support note for Leap Second Hang problem that may result into 100% CPU utilization in Linux environment

On or around July 1, 2012, Oracle has become aware of an issue on Linux distributions resulting from the introduction of the leap second; this is causing problems for some customers.  Leap seconds may be introduced at the end of June or December in a calendar year, like 2012, as necessary to maintain time standards. Servers hosting Oracle products which are clients of an NTP server (Network Time Protocol) may be particularly susceptible to this issue as the NTP server is updated.

Linux distributions which may be affected include Oracle Enterprise Linux, Red Hat Enterprise Linux, Oracle VM and Oracle Unbreakable Enterprise Kernel. Asianux 2 and 3, based on RHEL 4 and 5, may also be affected. One report of correction to high agent CPU using Note 1472421.1 on SLES11 has also been reported.

Not all customers will be affected, but those, who are affected, may observe higher than normal CPU consumption on their Linux environments where JVM's are utilized.  In Oracle Enterprise Manager ( EM ) , this problem can manifest itself as high CPU consumption with the EM Agent process (which runs on a JVM in EM 12c, for instance).  It is possible that the OMS is also affected.

We would advise customers to review the description of this problem in MOS Note 1472651.1 and take action if they observe that their environment is affected.

Contributed by Andrew Bulloch , Director, Application Systems Management Products

Stay Connected:

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

Database-as-a-Service on Exadata Cloud

Note – Oracle Enterprise Manager 12c DBaaS is platform agnostic and is designed to work on Exadata/non-Exadata, physical/virtual, Oracle/non Oracle infrastructure(hardware and OS) platforms and it’s not a mandatory requirement to use Exadata as the base platform.

Database-as-a-Service (DBaaS) is an important trend these days and the top business drivers motivating customers towards private database cloud model include constant pressure to reduce IT Costs and Complexity, and also to be able to improve Agility and Quality of Service.
The first step many enterprises take in their journey towards cloud computing is to move to a consolidated and standardized environment and Exadata being already a proven best-in-class popular consolidation platform, we are seeing now more and more customers starting to evolve from Exadata based platform into an agile self service driven private database cloud using Oracle Enterprise Manager 12c.

Together Exadata Database Machine and Enterprise Manager 12c provides industry’s most comprehensive and integrated solution to transform from a typical silo’ed environment into enterprise class database cloud with self service, rapid elasticity and pay-per-use capabilities.


In today’s post, I’ll list down the important steps to enable DBaaS on Exadata using Enterprise Manager 12c. These steps are chalked down based on a recent DBaaS implementation from a real customer engagement -

  • Project Planning - First step involves defining the scope of implementation, mapping functional requirements and objectives to use cases, defining high availability, network, security requirements, and delivering the project plan. In a Cloud project you plan around technology, business and processes all together so ensure you engage your actual end users and stakeholders early on in the project right from the scoping and planning stage.
  • Setup your EM 12c Cloud Control Site – Once the project plan approval and sign off from stakeholders is achieved, refer to EM 12c Install guide and these are some important tips to follow during the site setup phase -
    • Review the new EM 12c Sizing paper before you get started with install
    • Cloud, Chargeback and Trending, Exadata plug ins should be selected to deploy during install
    • Refer to EM 12c Administrator’s guide for High Availability, Security, Network/Firewall best practices and options
    • Your management and managed infrastructure should not be combined i.e. EM 12c repository should not be hosted on same Exadata where target Database Cloud is to be setup
  • Setup Roles and Users – Cloud Administrator (EM_CLOUD_ADMINISTRATOR), Self Service Administrator (EM_SSA_ADMINISTRATOR), Self Service User (EM_SSA_USER) are the important roles required for cloud lifecycle management. Roles and users are managed by Super Administrator via Setup menu –> Security option. For Self Service/SSA users custom role(s) based on EM_SSA_USER should be created and EM_USER, PUBLIC roles should be revoked during SSA user account creation.
  • Configure Software Library – Cloud Administrator logs in and in this step configures software library via Enterprise menu –> provisioning and patching option and the storage location is OMS shared filesystem. Software Library is the centralized repository that stores all software entities and is often termed as ‘local store’.
  • Setup Self Update – Self Update is one of the most innovative and cool new features in EM 12c framework. Self update can be accessed via Setup -> Extensibility option by Super Administrator and is the unified delivery mechanism to get all new and updated entities (Agent software, plug ins, connectors, gold images, provisioning bundles etc) in EM 12c.
  • Deploy Agents on all Compute nodes, and discover Exadata targets – Refer to Exadata discovery cookbook for detailed walkthrough to ensure successful discovery of Exadata targets.
  • Configure Privilege Delegation Settings – This step involves deployment of privilege setting template on all the nodes by Super Administrator via Setup menu -> Security option with the option to define whether to use sudo or powerbroker for all provisioning and patching operations.
  • Provision Grid Infrastructure with RAC Database on Compute Nodes – Software is provisioned in this step via a provisioning profile using EM 12c database provisioning. In case of Exadata, Grid Infrastructure and RAC Database software is already deployed on compute nodes via OneCommand from Oracle, so SSA Administrator just needs to discover Oracle Homes and Listener as EM targets. Databases will be created as and when users request for databases from cloud.
  • Customize Create Database Deployment Procedure – the actual database creation steps are "templatized" in this step by Self Service Administrator and the newly saved deployment procedure will be used during service template creation in next step. This is an important step and make sure you have locked all the required variables marked as locked as ‘Y’ in this table.
  • Setup Self Service Portal – This step involves setting up of zones, user quotas, service templates, chargeback plan. The SSA portal is setup by Self Service Administrator via Setup menu -> Cloud -> Database option and following guided workflow. Refer to DBaaS cookbook for details. You also have an option to customize SSA login page via steps documented in EM 12c Cloud Administrator’s guide
  • Final Checks – Define and document process guidelines for SSA users and administrators. Get your SSA users trained on Self Service Portal features and overall DBaaS model and SSA administrators should be familiar with Self Service Portal setup pieces, EM 12c database lifecycle management capabilities and overall EM 12c monitoring framework.
  • GO LIVE – Announce rollout of Database-as-a-Service to your SSA users. Users can login to the Self Service Portal and request/monitor/view their databases in Exadata based database cloud.

    Congratulations! You just delivered a successful database cloud implementation project!

    In future posts, we will cover these additional useful topics around database cloud –

    • DBaaS Implementation tips and tricks – right from setup to self service to managing the cloud lifecycle
    • ‘How to’ enable real production databases copies in DBaaS with rapid provisioning in database cloud
    • Case study of a customer who recently achieved success with their transformational journey from traditional silo’ed environment on to Exadata based database cloud using Enterprise Manager 12c.

    More Information –

    Stay Connected:

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

    Monday Jun 04, 2012

    Oracle Enterprise Manager Ops Center 12c : Enterprise Controller High Availability (EC HA)

    Contributed by Mahesh sharma, Oracle Enterprise Manager Ops Center team

    In Oracle Enterprise Manager Ops Center 12c we introduced a new feature to make the Enterprise Controllers highly available. With EC HA if the hardware crashes, or if the Enterprise Controller services and/or the remote database stop responding, then the enterprise services are immediately restarted on the other standby Enterprise Controller without administrative intervention.

    In today's post, I'll briefly describe EC HA, look at some of the prerequisites and then show some screen shots of how the Enterprise Controller is represented in the BUI. In my next post, I'll show you how to install the EC in a HA environment and some of the new commands.

     Join live webcast on more about EC HA on Thursday, June 21, 2012 at 11:00 am, Eastern Daylight Time (New York, GMT-04:00).

    Recording available at here.         Presentation available here.

    What is EC HA?

    Enterprise Controller High Availability (EC HA) provides an active/standby fail-over solution for two or more Ops Center Enterprise Controllers, all within an Oracle Clusterware framework. This allows EC resources to relocate to a standby if the hardware crashes, or if certain services fail. It is also possible to manually relocate the services if maintenance on the active EC is required. When the EC services are relocated to the standby, EC services are interrupted only for the period it takes for the EC services to stop on the active node and to start back up on a standby node.

    What are the prerequisites?

    To install EC in a HA framework an understanding of the prerequisites are required. There are many possibilities on how these prerequisites can be installed and configured - we will not discuss these in this post. However, best practices should be applied when installing and configuring, I would suggest that you get expert help if you are not familiar with them.

    Lets briefly look at each of these prerequisites in turn:

    Hardware : Servers are required to host the active and standby node(s). As the nodes will be in a clustered environment, they need to be the same model and configured identically. The nodes should have the same processor class, number of cores, memory, network cards, for example.

    Operating System : We can use Solaris 10 9/10 or higher, Solaris 11, OEL 5.5 or higher on x86 or Sparc

    Network : There are a number of requirements for network cards in clusterware, and cables should be networked identically on all the nodes. We must also consider IP allocation for public / private and Virtual IP's (VIP's).

    Storage : Shared storage will be required for the cluster voting disks, Oracle Cluster Register (OCR) and the EC's libraries.

    Clusterware : Oracle Clusterware version or later is required. This can be downloaded from:

    Remote Database : Oracle RDBMS 11.1.0.x or later is required. This can be downloaded from:

    For detailed information on how to install EC HA , please read :

    For detailed instructions on installing Oracle Clusterware, please read :

    For detailed instructions on installing the remote Oracle database have a read of:

    The schematic diagram below gives a visual view of how the prerequisites are connected.

    When a fail-over occurs the Enterprise Controller resources and the VIP are relocated to one of the standby nodes. The standby node then becomes active and all Ops Center services are resumed.

    Connecting to the Enterprise Controller from your favourite browser.

    Let's presume we have installed and configured all the prerequisites, and installed Ops Center on the active and standby nodes.

    We can now connect to the active node from a browser i.e. http://<active_node1>/, this will redirect us to the virtual IP address (VIP). The VIP is the IP address that moves with the Enterprise Controller resource.

    Once you log on and view the assets, you will see some new symbols, these represent that the nodes are cluster members, with one being an active member and the other a standby member in this case.

    If you connect to the standby node, the browser will redirect you to a splash page, indicating that you have connected to the standby node.

    Hope you find this topic interesting. Next time I will post about how to install the Enterprise Controller in the HA frame work.

    Stay Connected:

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

    Friday Jun 01, 2012

    Oracle Enterprise Manager Cloud Control 12c: Contributing to emerging Cloud standards

    Contributed by Tony Di Cenzo, Director for Standards Strategy and Architecture, and Mark Carlson, Principal Cloud Architect, for Oracle's Systems Management and Storage Products Groups .

    As one would expect of an industry leader, Oracle's participation in industry standards bodies is extensive. We participate in dozens of organizations that produce open standards which apply to our products, and our commitment to the success of these organizations is manifest in several way - we support them financially through our memberships; our senior engineers are active participants, often serving in leadership positions on boards, technical working groups and committees; and when it makes good business sense we contribute our intellectual property. We believe supporting the development of open standards is fundamental to Oracle meeting customer demands for product choice, seamless interoperability, and lowering the cost of ownership.

    Nowhere is this truer than in the area of cloud standards, and for the most recent release of our flagship management product, Oracle Enterprise Manager Cloud Control 12c (EM Cloud Control 12c).

    There is a fundamental rule that standards follow architecture. This was true of distributed computing, it was true of service-oriented architecture (SOA), and it's true of cloud. If you are familiar with Enterprise Manager it is likely to be no surprise that EM Cloud Control 12c is a source of technology that can be considered for adoption within cloud management standards. The reason, quite simply, is that the Oracle integrated stack architecture aligns with the cloud architecture models being adopted by the industry, and EM Cloud Control 12c has been developed to manage this architecture. EM Cloud Control 12c has facilities for managing the various underlying capabilities of the integrated stack in IaaS, PaaS, and SaaS clouds, and enables essential characteristics such as on-demand self-service provisioning, centralized policy-based resource management, integrated chargeback, and capacity planning, and complete visibility of the physical and virtual environment from applications to disk.

    Our most recent contribution in support of cloud management standards to come out of the EM Cloud Control 12c work was the Oracle Cloud Elemental Resource Model API. Oracle contributed the Elemental Resource Model API to the Distributed Management Task Force (DMTF) in 2011 where it was assigned to DMTF's Cloud Management Working Group (CMWG). The CMWG is considering the Oracle specification and those of several other vendors in their effort to produce a best practices specification for managing IaaS clouds. DMTF's Cloud Infrastructure Management Interface specification, called CIMI for short, is currently out for public review and expected to be released by DMTF later this year. We are proud to be playing an important role in the development of what is expected to become a major cloud standard.

    You can find more information on DMTF CIMI at You can find the work-in-progress release of CIMI at . The Oracle Cloud API specification is available on the Oracle Technology Network. You can find more information about the Oracle Cloud Elemental Resource Model API on the Oracle Technical Network (OTN), including a webcast featuring the API engineering manager Jack Yu (see TechCast Live: Inside the Oracle Cloud Resource Model API). If you have not seen this video we recommend you take the time to view it. Simply hover your cursor over the webcast title and control+click to follow the embedded link.

    If you have a question about the Oracle Cloud API or want to learn more about Oracle's participation in cloud management standards efforts drop us a line. We'd love to hear from you.

    The Enterprise Manager Standards Blogs are written by Tony Di Cenzo, Director for Standards Strategy and Architecture, and Mark Carlson, Principal Cloud Architect, for Oracle's Systems Management and Storage Products Groups. They can be reached at Tony.DiCenzo at and Mark.Carlson at respectively.

    Stay Connected:

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

    Wednesday May 30, 2012

    Changing the Game: Why Oracle is in the IT Operations Management Business

    Next week, in Orlando, is the annual Gartner IT Operations Management Summit. Oracle is a premier sponsor of this annual event, which brings together IT executives for several days of high level talks about the state of operational management of enterprise IT. This year, Sushil Kumar, VP Product Strategy and Business Development for Oracle’s Systems & Applications Management, will be presenting on the transformation in IT Operations required to support enterprise cloud computing.

    IT Operations transformation is an important subject, because year after year, we hear essentially the same refrain – large enterprises spend an average of two-thirds (67%!) of their IT resources (budget, energy, time, people, etc.) on running the business, with far too little left over to spend on growing and transforming the business (which is what the business actually needs and wants). In the thirtieth year of the distributed computing revolution (give or take, depending on how you count it), it’s amazing that we have still not moved the needle on the single biggest component of enterprise IT resource utilization.

    Oracle is in the IT Operations Management business because when management is engineered together with the technology under management, the resulting efficiency gains can be truly staggering. To put it simply – what if you could turn that 67% of IT resources spent on running the business into 50%? Or 40%? Imagine what you could do with those resources. It’s now not just possible, but happening.

    This seems like a simple idea, but it is a radical change from “business as usual” in enterprise IT Operations. For the last thirty years, management has been a bolted-on afterthought – we pick and deploy our technology, then figure out how to manage it. This pervasive dysfunction is a broken cycle that guarantees high ongoing operating costs and low agility.

    If we want to break the cycle, we need to take a more tightly-coupled approach. As a complete applications-to-disk platform provider, Oracle is engineering management together with technology across our stack and hooking that on-premise management up live to My Oracle Support. Let’s examine the results with just one piece of the Oracle stack – the Oracle Database.

    Oracle began this journey with the Oracle Database 9i many years ago with the introduction of low-impact instrumentation in the database kernel (“tell me what’s wrong”) and through Database 10g, 11g and 11gR2 has successively added integrated advisory (“tell me how to fix what’s wrong”) and lifecycle management and automated self-tuning (“fix it for me, and do it on an ongoing basis for all my assets”).

    Oracle Database Manageability Evolution

    "> " class=" ">

    When enterprises take advantage of this tight-coupling, the results are game-changing. Consider the following (for a full list of public references, visit this link):

    Or the recent Database Manageability and Productivity Cost Comparisons: Oracle Database 11g Release 2 vs. SAP Sybase ASE 15.7, Microsoft SQL Server 2008 R2 and IBM DB2 9.7 as conducted by independent analyst firm ORC.

    Oracle Database Manageability Comparison 2011-2012 Study Summaries

    In later entries, we’ll discuss similar results across other portions of the Oracle stack and how these efficiency gains are required to achieve the agility benefits of Enterprise Cloud.

    Stay Connected:

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

    Oracle User Communities and Enterprise Manager

    Contributed by Joe Diemer, Senior Business Development Manager, Oracle Enterprise Manager

    Heightened interest and adoption of Oracle Enterprise Manager has led to keen interest in “manageability” within the user group community.  In response, user groups are equipping their membership with the right tools for implementation and use manageability through education opportunities and Special Interest Groups.  Manageability is increasingly viewed not only as a means to enable the Oracle environment to become a competitive business advantage for organizations, but also as a means to advance the individual careers of those who embrace enterprise management. 

    Two Oracle user groups – the Independent Oracle User Group (IOUG) and the United Kingdom Oracle User Group (UKOUG) – each have Special Interest Groups where manageability is prominently featured.  There are also efforts underway to establish similarly charted SIGs that will be reported in future blogs. 

    The good news is, there’s a lot of news!

    First off, the IOUG will be hosting a Summer Series of live webcasts:

    •  “Configuring and Managing a Private Cloud with Enterprise Manager 12c” by Kai Yu of Dell, Inc.

                 Wednesday, June 20th from Noon – 1 PM CDT , Click here for details & registration

    • “What is User Experience Monitoring and What is Not? A case study of Oracle Global IT’s implementation of Enterprise Manager 12c and RUEI” by Eric Tran Le of Oracle

               Wednesday, July 18th from Noon – 1 PM CDT , Click here for details & registration

    • “Shed some light on the ‘bumps in the night’ with Enterprise Manager 12c” by David Start of Johnson Controls

               Wednesday, August 22nd from Noon – 1 PM CDT, Click here for details & registration

      In addition, the UKOUG Availability and Infrastructure Management (AIM) SIG is hosting its next meeting on Tuesday, July 3rd at the Met in Leeds where EM 12c Cloud Management will be presented.  Click here for details & registration.

     In future posts from Joe, look for news related to the following:

    ·         IOUG Community Page and Newsletter devoted to manageability

    ·         Full day of manageability featured during Oracle OpenWorld 2012 “SIG Sunday”

    ·         Happenings from other regional User Groups that feature manageability

    Stay Connected:

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

    Wednesday May 23, 2012

    Difference Between Oracle’s Application Testing Suite and HP’s QTP?

    If you are a testing software solution provider, one of the questions that prospects are asking our partners and sales reps, is the difference between our solution and HP's QTP. Since we are only an expert in our own products, we usually provide our own key capabilities and let the prospect decide how that compares to the product they're using/considering. 

    With the release of Oracle Application Testing Suite 12.1 earlier this month, we have plenty of new capabilities to talk about. And that's exactly what we're going to do today, May 23rd at 08:00 PST or 17:00 CET, in a live Webcast led by our Lead PM for Application Testing Suite:

    Oracle Enterprise Manager Webcast Series
    Introducing Oracle Application Testing Suite 12.1

    Wednesday, May 23, 8 a.m. PT

    Register Now

    This webcast introduces the latest version or Oracle Application Testing Suite, the centerpiece of Oracle Enterprise Managers application quality management solutions.  Learn about what Oracle Application Testing Suites different components: Oracle Test Manager, Oracle Functional Testing and Oracle Load Testing offers and how you can benefit from them during the testing of your Oracle Applications. 

    You will also learn about the new features added in the latest version and why they will make a difference to your testing. Oracle Application Testing Suite can help you to cut testing time and to minimize the risks for upgrades or new deployments. 

    We hope you can join us. 

    To close off, there is a nice, but unfortunately outdated and incomplete, comparison between the two products on this blog post at Ask QTP. Maybe we need to write our own comparison after all. Please give us your vision on the difference between the two in the comments?

    Stay Connected:

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

    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

    Epsilon Gains Efficiency with Oracle Enterprise Manager

    With Oracle Enterprise Manager, Epsilon has streamlined IT administration, monitoring, and engineered systems maintenance. 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

    Oracle delivers keynote and many sessions as Platinum Plus sponsor of Cloud Expo East 2012, NY

    Recent IDC research shows that worldwide spending on cloud services will grow almost threefold, reaching $44.2 billion by 2013. And a recent Gartner report predicts that the volume of enterprise data overall will increase by a phenomenal 650% over the next five years.

    These two unstoppable enterprise IT trends, Cloud Computing and Big Data, will converge in New York at 10th Cloud Expo – being held June 11 - 14, 2012, at the Javits Convention Center In New York City.

    Oracle is a Platinum Plus sponsor for 10th Cloud Expo. Oracle will be delivering a keynote , a general session and various other cloud sessions at the event.  Here is an overview of Oracle sessions at the event :

    Mohamad Afshar, VP Product Management

    Focus Lunch Keynote | A Pragmatic Journey to the Cloud

    As enterprise adoption of cloud computing accelerates, organizations must have a strategy and roadmap for moving to the cloud. Faced with different options including building a private cloud, subscribing to public clouds, or leveraging a hybrid cloud, organizations need a rational and pragmatic approach. This session explores the emerging trends in cloud computing and offers best practices for how organizations can successfully navigate a journey to the cloud. 

    Sandeep Banerjie, Sr. Director of Product Management, Oracle Public Cloud 

    General Session | Oracle Public Cloud - An Enterprise Cloud for Business-Critical Applications

    For enterprise class cloud services, companies need a broad, comprehensive and flexible platform for their applications. The Oracle Public Cloud, which offers a broad set of best-in-class, integrated services that are secure, elastic, and 100% open standards-based, offering organizations choice in development and deployment of business critical applications. Attend this General Session to learn about how these subscription-based services can speed your application development and deployment time, offer the flexibility of application portability, and the ease with which you can access, use, and manage them. 

    Anand Akela, Sr. Principal Product Director, Oracle Enterprise Manager

    Accelerate Enterprise Cloud Deployment and Gain Total Cloud Control
    Track: Moving to the Cloud in Practice

    According to a 2011 survey by the Independent Oracle User Group, over 50% of Oracle’s customers have deployed or are considering deploying private clouds. Most private clouds today support non-production workloads because enterprises are unable to deploy mission-critical applications in their private cloud. In this session, you will learn how the same Oracle technology that powers the Oracle Public Cloud enables you to deploy mission-critical applications in your cloud.

    Jean-Pierre Dijc,   Sr. Principal Product Manager

    Integrating Big Data into Your Data Center: A Big Data Reference Architecture
    Track: Big Data Techniques & Technologies

    Weblogs, social media, smart meters, sensors and other devices generate high volumes of low density information that isn’t readily accessible in enterprise data warehouses and business intelligence applications today. But, this data can have relevant business value, especially when analyzed alongside traditional information sources. In this session we will outline a reference architecture for big data that will help you maximize the value of your big data implementation.

    Adam Hawley, Sr. Director of Product Management, Oracle VM

    Sahil Goel, Director Product Management

    Borderless Applications in the Cloud with Oracle VM and Oracle Virtual Assembly Builder
    Track: Cloud Storage Virtualization APIs

    As virtualization adoption progresses beyond server consolidation, this is also transforming how enterprise applications are deployed and managed in an agile environment. The traditional method of business-critical application deployment where administrators have to contend with an array of unrelated tools, custom scripts to deploy and manage applications, OS and VM instances into a fast changing cloud computing environment can no longer scale effectively to achieve response time and desired efficiency.

    Oracle VM and Oracle Virtual Assembly Builder allow applications, associated components, deployment metadata, management policies and best practices to be encapsulated into ready-to-run VMs for rapid, repeatable deployment and ease of management. Join us in this Cloud Expo session to see how Oracle VM and Oracle Virtual Assembly Builder allow you to deploy complex multi-tier applications in minutes and enables you to easily onboard existing applications to cloud environments. 

    Ayalla Goldschmidt , Sr. Director, Fusion Middleware & Java Platform

    Building a Private, Public, or Hybrid Cloud? Simplify Your Cloud with Oracle’s Complete Cloud Solution
    Track: Cloud Action Points / Best Practices / Case Studies

    Whatever your course, meet Cloud complexity head on with a unified approach to handle extreme performance, reliability, availability, and simplicity. In this session hear industry experts reveal the underpinnings for the Oracle Public Cloud as well as technology best-practices for developing private and hybrid cloud architectures using Oracle’s Engineered Systems together with Oracle Fusion Middleware. Oracle Fusion Middleware is a complete array of technologies enabling you to embrace the paradigm shift of Cloud computing and take full advantage of the cost savings and improved agility they promise. Together with Oracle Exalogic and Oracle Exadata provide the world’s first and only integrated engineered system, which provide enterprises the best possible foundation for running enterprise applications with the performance, elasticity, reliability, and scale characteristics expected for cloud-based applications. 

    Arun Gupta, Java Evangelist

    The Java EE 7 Platform: Developing for the Cloud
    Track: Hot Topics

    This session introduces the Java EE 7 platform, the latest revision of the Java platform for the enterprise. The focus of Java EE 7 is on the cloud, and specifically it aims to bring Platform-as-a-Service providers and application developers together so that portable applications can be deployed on any cloud infrastructure and reap all its benefits in terms of scalability, elasticity, multitenancy, etc. The existing specifications in the platform such as JPA, Servlets, EJB, and others will be updated to meet these requirements. 

    Stay Connected:
    Twitter |
    Face book | You Tube | Linked in | Newsletter

    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

    Thursday Apr 26, 2012

    Oracle Enterprise Manager Ops Center 12c – Building a Virtual Data Center

    One of the great new features in Ops Center 12c is the ability to create a virtual data center which abstracts the compute, storage and networking resources you have managed and allows you to segment those resources into accounts. You can then make those physical resources available to distinct audiences who can self-provision virtual resources as needed within the resource constraints or quotas you defined. I'll walk you through a simple scenario to create a virtual data center (vDC) that consists of a pair of Oracle Solaris 10 servers, a NAS share and a group of VLAN tagged networks. We will then set aside a portion of those resources for a QA Testing group and show how a user within that group can create a virtual server connected on a virtual private network.

    Learn more about this in the Ops Center expert call on May 10 at 9:30AM PST.

    [Read More]

    Tuesday Apr 24, 2012

    Demo Series : Gain Total Cloud Control of Systems with Enterprise Manager Ops Center 12c

    Earlier this month, at Oracle Enterprise Manager Ops Center 12c launch, we published a series of demos of Oracle Enterprise Manager Ops Center 12c  managing various Oracle solutions from applications to hardware . You could see all of those demos by clicking the graphic below.  Following the graphics below, I have a brief overview of an enterprise customer scenario and various demos highlighting the management of various systems .

    Demo Series - Explore Oracle Enterprise Manager Ops Center 12c

    A Step-by-Step Journey to Enterprise Clouds

    A large global financial company serving millions of customers worldwide has decided to investigate a private cloud infrastructure. They have multiple business units and are located in multiple regions worldwide.

    Their enterprise applications include Oracle Siebel CRM, Oracle E-Business Suite Financials, and PeopleSoft HCM. They have recently added several Oracle Fusion Applications modules to enhance their CRM and HCM capabilities. Over time, they have also deployed a number of Java and web-based applications. They use Oracle Solaris/SPARC environments for their E-Business Suite applications. Their web servers, some of their application servers, and a number of the home grown applications run on Oracle Enterprise Linux and Oracle x86 servers. They have deployed Oracle virtualization solutions for x86 servers and SPARC.

    This company is transitioning their IT to a private cloud environment to support the CEO’s new corporate strategy to increase operational efficiency by 10% while growing the top line by 30% in two years. The IT organization, led by their CIO, considered various options and concluded that achieving the CEO’s objectives would require them to transition their enterprise applications to the cloud, thereby creating real differentiation in how they service their customers. They reviewed several vendors and concluded that their private cloud solutions were adequate for small applications but too risky for enterprise applications. They decided to go with the an Oracle solution because only Oracle was able to demonstrate a proven solution to power enterprise applications while also leveraging SPARC and x86 virtualization for a complete cloud management solution.

    They have already started to deploy Database-as-a-Service and Fusion Middleware-as-a-Service clouds using Oracle Enterprise Manger Self Service Application Portal. They plan to deploy Infrastructure-as-Service cloud based on both SPARC and x86 servers with Oracle virtualization solutions and manage them through Oracle Enterprise Manager Ops Center. They have recently deployed many ExaData systems. They are starting to deploy ExaLogic and Super Clusters Engineered systems as well to accelerate performance and time to market.

    Integrated Linux Management in the Cloud

    Linux Management functionality is available as part of Oracle Enterprise Manager 12c and is available to Oracle Linux Basic and Premier Support customers at no cost. The solution provides an integrated and cost-effective solution for complete Linux server lifecycle management and delivers comprehensive provisioning, patching, monitoring, and administration capabilities via a single, web-based user interface thus significantly reducing the complexity and cost associated with managing Linux operating system environments.

    Using these rich Linux management features along with the complete Oracle Enterprise Manager product solution, the global financial company takes advantage of enterprise-scale service level management, automated change and configuration management, and comprehensive system and application performance management.

    Integrated Lifecycle Management for Physical and Virtual Servers in the Cloud

    Oracle VM offers server virtualization for both x86 and SPARC architectures that enable the deployment of agile cloud infrastructures. Virtualized server environments integrated with Oracle Enterprise Manager Ops Center allow you to easily create, deploy, clone virtual servers, and live migrate workloads while dynamically controlingcompute resources. Integrated lifecycle management of both physical & virtual servers with Ops Center simplifies the daily workflowneeded to control cloud infrastructures. This is one of the key reasons why this company decided power their private cloud with Oracle virtualization technologies.

    Oracle Solaris 11 – The First Cloud OS

    With its new and improved features, Oracle Solaris brings mission-critical enterprise class computing to cloud scale environments. These features include extremely agile, no overhead virtualization, simplified software lifecycle management, and built-in security across all layers. Oracle Enterprise Manager Ops Center understands all these new technologies, and therefore is the perfect tool to manage Oracle Solaris deployments at data center and cloud scales.

    Manage Mission Critical Applications in the Cloud

    Deploying and managing mission critical applications in cloud are one of the key strategic interests of the enterprises. Oracle SPARC based Infrastructure-as-a-Service ( IaaS ) offers the scale, reliability, and performance needed for those mission critical applications. In this demo, you will learn about how to manage SPARC server platforms, which is the foundation of the enterprise cloud this global financial company wants to deploy The Oracle SPARC technologies offers an extreme thread count and memory density in a small and eco-friendly form factor. This company wanted to insure they could leverage their existing SPARC population with not excluding new growth into the T4 chassis models. They found Ops Center offered them complete coverage of where they were the most invested.

    Private PaaS and IaaS Cloud with Oracle Enterprise Manager

    Oracle Enterprise Manager provides complete lifecycle management for cloud - from automated cloud setup, to delivery, to cloud operations. Learn how Oracle Enterprise Manager Cloud Control 12c and Oracle Enterprise Manager Ops Center 12c work together to provide an end-to-end solution to take you from zero to cloud in a day, whether the goal of your private cloud is Infrastructure as a Service (IaaS) or Platform as a Service (PaaS).

    Managing DBaaS and MWaaS Cloud Services Delivery with Oracle Enterprise Manager

    This demo showcases Engineered Systems Management capabilities of Oracle Enterprise Manager Cloud Control and Ops Center 12c. You can now manage all components of Oracle Exadata Database Machine, from databases to cell storage to network swicthes, from a single console. Similarly, you can now manage all aspects of Oracle Exalogic, including software and hardware, from a single console. Learn how Oracle Enterprise Manager is engineered systems-aware and provides insight into the performance, configuration and physical health of these highly performance machines.

    Simplify Your Data Center with Exalogic Elastic Cloud

    Oracle Exalogic Elastic Cloud is the industry’s Best Foundation for Cloud. It is hardware and software engineered together to provide extreme performance for Java applications, Oracle Applications, and other enterprise applications. Exalogic offers fully integrated compute nodes, storage and networking, fully integrated ZFS network attached storage appliance with 40TB of SAS disk storage, QDR InfiniBand IO Fabric, with 40 Gb/second throughput and microsecond latencies, Data center service network integration with 10 GbE, Scalable, open standard grid architecture. That means less effort spent by you on putting the pieces together and more time spend on extending the business value of your applications.

    Check out this demonstration to learn more about Exalogic and the right configuration that meets your needs.

    Oracle Software Runs Best on Oracle Hardware

    Oracle Enterprise Manager offers the right amount of information across the stack, breaking down isolated IT organizations and helps make a stronger connection between the business services and the server assets they utilize.

    To learn more, please go to Oracle Enterprise Manager  web page and stay connected with us at  :

    Twitter | Facebook | YouTube | Linkedin | Newsletter

    Tuesday Apr 10, 2012

    A new version of Oracle Enterprise Manager Ops Center Doctor (OCDoctor ) Utility released

    In February,  we posted a blog of Oracle Enterprise Manager Ops Center Doctor aka OCDoctor Utility. This utility assists in various stages of the Ops Center deployment and can be a real life saver. It is updated on a regular basis with additional knowledge (similar to an antivirus subscription) to help you identify and resolve known issues or suggest ways to improve performance.

    A new version ( Version 4.03 ) of the OCDoctor is now available . This new version adds full support for recently announced Oracle Enterprise Manager Ops Center 12c including prerequisites checks, troubleshoot tests, log collection, tuning and product metadata updates. In addition, it adds several bug fixes and enhancements to OCDoctor Utility.

    To download OCDoctor for new installations:

    For existing installations, simply run:
    # /var/opt/sun/xvm/OCDoctor/ --update

    Tip : If you have Oracle Enterprise Manager Ops Center12c EC installed, your OCDoctor will automatically update overnight.

    Stay connected with  Oracle Enterprise Manager   : 

    Twitter | Facebook | YouTube | Linkedin | Newsletter

    Tuesday Apr 03, 2012

    British Telecom Automates Cloud Management with Oracle Enterprise Manager

    British Telecom delivers scalable and reliable Cloud services using Oracle Enterprise Manager’s automated management capabilities.

    Don't miss the on Oracle Launch Webcast : Total Cloud Control for Systems on April 12th at 9 AM PST .

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

    Twitter | Facebook | YouTube | Linkedin | Newsletter

    Friday Mar 16, 2012

    Oracle Enterprise Manager 12c Integration With Oracle Enterprise Manager Ops Center 11g

    In a blog entry earlier this year, we announced the availability of the Ops Center 11g plug-in for Enterprise Manager 12c. In this article I will walk you through the process of deploying the plug-in on your existing Enterprise Manager agents and show you some of the capabilities the plug-in provides. We'll also look at the integration from the Ops Center perspective. I will show you how to set up the connection to Enterprise Manager and give an overview of the information that is available.

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

    [Read More]

    Oracle Enterprise Manager content at Collaborate 12 - the only user-driven and user-run Oracle conference

    From April 22-26, 2012, Oracle takes Las Vegas. Thousands of Oracle professionals will descend upon the Mandalay Bay Convention Center for a weeks worth of education sessions, networking opportunities and more, at the only user-driven and user-run Oracle conference - COLLABORATE 12.

    This is one of the best opportunities for you to learn more about Oracle technology including Oracle Enterprise Manager. Here is a summary of an impressive line-up of Oracle Enterprise Manager related content at COLLABORATE 12.

    Customer Presentations

    Oracle Presentations

    Stay connected with  Oracle Enterprise Manager   : 

    Twitter | Facebook | YouTube | Linkedin | Newsletter

    Tuesday Mar 06, 2012

    How to use Oracle Enterprise Manager Ops Center to patch your Solaris Systems ?

    Oracle Enterprise Manager Ops Center allows you to update your Solaris systems with patches available from My Oracle Support (MOS).

    Like always in life, there are multiple ways to perform a given task and the same is true for Ops Center.

    Juergen Fleischer, Senior IT/Product Architect , Oracle Enterprise manager Ops center provided the content for this blog to guide you through different ways to perform Oracle Solaris patching depending on deployment scenarios.

    Scenario 1 - Applying a single Patch to an Asset

    Let's start with installing just a single patch to a system. To perform this task you would select the OS Asset and pick the action 'View/Modify Catalog' from the right hand side Actions panel.

    From the pop-up screen, you can search for the patchid, see which revision is already installed and select a newer one if required.

    Here is a MOS how-to document describing this in all detail:

    Scenario 2 - Applying multiple patches to several systems

    If you have to apply a list of patches to multiple systems every now and then, creating an Update Profile would be the best method, as once you have created the Profile it can be used many times ensuring the exact same patches in the list are applied each and every time.

    Update Profiles are located in the 'Plan Management' section. Update Profiles can be used in two ways: either you select a single or a group of OS assets and pick the action 'New Update OS Job'. Or, you pick the Update Profile in the Plan Management section and select 'New Update OS Job'. The wizard will allow you to select one or more target assets or groups.

    Here is a MOS how-to with all the details:

    Scenario 3 - Regular Baseline Patching

    For regular Baseline Patching 'Update Profiles' can be based on given patchsets which are made available by the Ops Center Knowledge Base (KB).

    The KB offers two different patchsets, the monthly released Solaris Baselines (based on Oracle's internal EIS-DVD) and the current or archived versions of the "Recommended Patchset for Solaris". These are updated whenever a new critical patch gets released. Every quarter, one of these Recommended Patchsets for Solaris will be renamed as the 'Critical Patch Update' in line with standard Oracle practice. It's up to the Customer's patching policy and strategy to determine which patchsets should be used and how often they should be applied.

    Scenario 4 - Latest & Greatest patchset

    Finally, if required, Customers can select what is called "Latest & Greatest" patchset. These are all the latest available patches for all installed packages. To perform this task, use the 'Host Compliance Report' and tick the Security & Bug Fixes check box.

    More details can be found in this blog entry

    or in this MOS how-to document:

    So far, we have talked about various scenarios around applying a single patch or multiple patches.  These patches can be applied on a running system or by using LiveUpgrade (LU).  LU allows creating Alternate Boot Environment (ABE), Synchronizing boot environments, Patching the ABE and then Activating the ABE.
    For detailed examples and howto examples:

    Before using LiveUpgrade, please verify that the latest LU-Patch (sparc: 121430, x86: 121431) is  installed on the running system.

    Furthermore, when payching zones always make use of the parallel zone patching feature, independent if using LU or not. Following blog entry describes this very well :

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

    Friday Mar 02, 2012

    Application Testing in the Cloud Made Easy - Questions and Answers Series from the Oracle Enterprise Management Online Forum

    We're still continuing our blog series on sharing the Q&A from the Oracle Enterprise Management Forum. This blog post will give the integral Q&A from the "Application Testing in the Cloud Made Easy" session in the DBA/Developer track.

    Oracle Enterprise Manager delivers the only testing solution that provides testing starter-kits for Oracle applications, accelerators for SOA, and Web-based applications. The solution also includes unique application and database infrastructure testing using real production workloads.

    Before we go into the Q&A, let's start with summarizing what’s new with the application testing management with Oracle Enterprise manager 12c.
    Once you build an application, you need to test them. Over the last few years, we have invested a lot in creating a complete testing portfolio that allows you to test both application changes and the changes at the database or lower level.  A very unique aspect of our testing solution is that we allow to you to capture production data and replay in the test environment – thereby allowing you to test your application with real production workload.

    We have significantly enhanced these capabilities in this new release.  First, we have just released the latest version of Application Testing Suite which includes Oracle Functional Testing, Oracle Load Testing and Oracle Test Manager.  
    Three key enhancements in this release of Application Testing Suite that I would like to mention are:
    1. Test starter kit for Oracle’s Siebel CRM applications.  This provides you pre-built scripts for functional and load testing for easier and more efficient testing for your Siebel CRM implementations.  This complements our EBS test starter kits already available.  
    2. Deeper integration with Oracle Enterprise Manager’s middleware and database diagnostics such as ADDM and AWR reports that will improve testing efficiency and productivity by enabling testers to detect performance bottlenecks faster and with less effort.
    3. Finally, we support structured, business-driven testing based on testing industry most widely adopted methodology, TMap.  TMap is industry leading risk-based approach for structured software testing that helps you manage and standardize test processes. 
    In the area of infrastructure testing, we are announced a new solution for automated application testing called Oracle Application Replay Pack.  It complements Oracle Real Application Testing feature for Oracle Database by providing the same functionality for the middle tier. Unlike traditional application testing tools, Application Replay uses real, production workloads to generate load against applications under test and does not require any script development or maintenance.  With Application Replay you can easily reduce your testing time by more than 80%.  It provides the most efficient, optimized and highest quality testing for validating application infrastructure changes for all your  Web and packaged Oracle applications.  

    Another important part of testing, that is especially critical in a cloud environment but often gets overlooked, is that of test data management. When you allow users to provision databases/data in a self-service manner, it is all the more important that you protect the critical and sensitive data. Our data masking feature allows you to protect personally sensitive information by “masking” them.  New to this release of Oracle Enterprise Manager is Test Data Management Pack, with the ability to discover data dependency and modeling. This functionality allow you to discover data model and sensitive data in your environment so that you can protect them through Data Masking We also provide data masking templates for Oracle EBS and Fusion applications where all your sensitive columns and masking formats have been predefined.

    Additionally, you will probably want to create smaller data subset – both to protect the data but also optimize the resource utilization.  Oracle Enterprise Manager 12c includes a new data subsetting feature that lets you create smaller databases with subsets of application data that is relationally consistent so that you can perform realistic testing and development on just 1% or 5% of production data. 

    EM 12.1 is major release for our testing products and you will continue to see more innovative and cutting edge enhancements in our upcoming releases.  

    In this session we demonstrated some of these new functionalities. The recording from the Oracle Enterprise Management Online Forum is now available to watch on demand.

    Questions and Answers from "Application Testing in the Cloud Made Easy" session:

    Q. Do you support synthetic workloads for load testing?

    A. Yes. Oracle Load Testing is a load/performance test tool for synthetic load testing. Oracle Load Testing can test any web based application as well as Oracle packaged applications like Oracle EBS, Siebel, Oracle Fusion applications, JD Edwards, Peoplesoft, Hyperion and others. It is also possible to SOA/Web services based test or synthtetic database testing for Oracle databases

    Q. Does the data masking solution work for non-Oracle Databases?

    A. Yes. Heterogeneous masking is supported by way of oracle gateway

    Q. Can Sensitive Data Discovery be customized for my own data structures?

    A. If it is in a supported oracle database then yes.

    Q. What versions of Oracle Database can be subsetted?

    A. All current supported DB are supported for subsetting, We do support 10g R2 as well. There is plan to support 9i R2 but only in clone then subset and not inline subset.

    Q. What kinds of applications are supported by Application Replay?

    A. All http and nca protocol (forms) are supported.

    Q. Where can I get more information on automatic script generation from RUEI and RAT for ATS?

    A. You can find more information about the automatic script generation for ATS /Oracle Load Testing in the documentation in your installation directory of ATS ([Install directory]/docs/en) OpenScriptUserGuide.pdf - Section 3.2.7 for RUEI In case you have not installed ATS, you can download the documentation from this location:

    Q. What versions of Oracle applications do the accelerators cover?

    A. The testing accelerators for Oracle Load Testing or Oracle Functional Testing supports: EBS 11i & R12, Siebel 7.7 or higher. It also support any version of Oracle Fusion Applications

    Q. For application data model, are all releases supported?

    A. All current supported DB are supported for sub setting, We do support 10g R2 as well. There is plan to support 9i R2 but only in clone then subset and not inline subset.

    Q. Which DB versions are supported to App Testing / replay ?

    A. and above currently

    Q. When you select encrypt, what kind of protocols you can select?

    A. You cannot select your own protocols.

    Q. How do you maintain the cardinality of the values in a sensitive column that you want to mask so the data values are not skewed -- in order to match the column cardinality of the production data.

    A. We will not maintain 100 % cardinality but we will be close. and We an additional check if masking is introducing change in execution plans.

    Q. Should we use the new Application Replay or Application Testing Suite for our E-Business Suite Testing?

    A. It depends in what you are trying to archive with your testing. If you have infrastructure updates only, meaning database or application server changes, then Application Replay is a really good solution for you, but if you have changes in your application, you should use Application Testing Suite

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

    Twitter   Facebook YouTube Linkedin  Newsletter


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

    Related Blogs


    « November 2015