Wednesday Aug 17, 2016

Bash script to deploy webapp to Weblogic server domain via WLST

I wrote a bash script to deploy a war file to ALL managed servers in a Weblogic domain. You should be able to modify it to work for your needs.

#!/bin/bash HOST_NAME=${1-localhost} HOST_USER=${2-weblogic} HOST_PASS=${3-welcome1} HOST_PORT=${4-7001} JAVA_BIN="/usr/bin/java" SCRIPT_HOME="$(dirname $(readlink -f $0))" WL_JAR="${SCRIPT_HOME}/middleware/wlserver_10.3/server/lib/weblogic.jar" JAM_JAR="myapp.war" function getServerList() { WLST_SERVER_LIST=$(${JAVA_BIN} -cp ${WL_JAR} weblogic.WLST <<EOF connect("${HOST_USER}", "${HOST_PASS}", "t3://${HOST_NAME}:${HOST_PORT}") cd('Servers') ls('a') EOF ) SERVER_LIST="" while read -r CURR_LINE; do if [[ ${CURR_LINE} =~ drw-* ]] then SERVER_LIST+=$(printf ${CURR_LINE#*drw-},) fi done <<< "${WLST_SERVER_LIST}" SERVER_LIST=${SERVER_LIST%,*} #echo $SERVER_LIST } function agentDeployer() { ${JAVA_BIN} -cp ${WL_JAR} weblogic.Deployer -adminurl t3://${HOST_NAME}:${HOST_PORT} -user ${HOST_USER} -password ${HOST_PASS} -targets ${SERVER_LIST} -deploy -upload ${JAM_JAR} } echo "Deploying" getServerList agentDeployer

Thursday May 05, 2016

Webcast: Ensure an Exceptional User Experience

Thursday May 12, 2016

9:00 a.m. PST (San Francisco)
12:00 p.m. EST (New York)
5:00 p.m. GMT (London)

Today, customer loyalty is about how fast you can deliver new functionality while still providing exceptional user experience. End-users rank application and website performance (such as quick-loading pages) as their top expectation and will leave any site that is too slow.

Oracle Application Performance Monitoring Cloud Service helps you monitor the performance of your applications and the experience of your end-users from a business perspective. The solution enables DevOps organizations, application owners and business analysts to respond quickly to issues that impact productivity, customer satisfaction and revenue.

Join us for a technical webcast and demo to learn how to:

  • Correlate end user and application data—cut the time it takes to resolve application issues
  • Gain deep transaction visibility with in-depth application performance diagnostics for DevOps
  • Leverage the power of log information by ingesting, normalizing and categorizing log data across the application stack for better insight

Register Now

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

Monday Apr 11, 2016

Webcast: Tear Down DevOps Barriers with Oracle Management Cloud

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

Do you have barriers between development and operations and your end-users?
Join us for a live webcast on Oracle Management Cloud, the modern solution for rapid application delivery and efficient application and operations management. This exciting new product enables business decision makers and DevOps leaders to manage technology innovations so that employees can do their jobs more effectively and business users can enjoy a superior experience.

During the webcast Oracle experts will talk about how to:

  • Cut the time it takes to resolve application issues
  • Break down barriers between Development and Operations
  • Ensure a good user experience
  • Run IT like a business

Register Now

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

Monday Apr 04, 2016

Oracle Enterprise Manager 13c: Centralized Administration and Auditing of Oracle WebLogic Server

Oracle Enterprise Manager Cloud Control 13c enables administrators to perform administration operations against Oracle WebLogic Server as well as to view the audit records for those operations.  Traditionally, administrators were required to use the WebLogic Server Administration Console or the Oracle Enterprise Manager Fusion Middleware Control console to administer their domain. However, administration and configuration operations are available directly from the Oracle Enterprise Manager Cloud Control 13c console. From the Cloud Control console, administrators can do the following:

  • Leverage Change Center to lock a domain configuration prior to making configuration changes.
  • Configure domain, cluster, server, machine – as well as multi tenancy settings.

  • Manage JDBC data sources.

  • Access the System MBean Browser to view, invoke or edit MBeans.

· Start, stop or restart middleware components.

  • Schedule and track execution of WLST scripts.

· View the audit trail of WebLogic operations performed from either the Oracle Enterprise Manager Cloud Control console or the Oracle Enterprise Manager Command Line Interface (EMCLI).

Having a single tool for monitoring, administering and viewing audit records for Oracle WebLogic Server not only simplifies an administrator’s job and increases productivity, but also maintains security of a middleware environment.

To see first-hand some of the Oracle WebLogic Server administration and auditing capabilities available from Oracle Enterprise Manager Cloud Control 13c, watch and listen to the recorded demonstration available on the Oracle Learning Library here. Additional information can also be obtained from the Oracle Enterprise Manager Cloud Control 13c Online Documentation Library:

Monday Mar 28, 2016

Oracle Enterprise Manager 13c: Track Compliance with the Oracle WebLogic Server 12c Security Technical Implementation Guide (STIG)

Oracle Enterprise Manager Cloud Control 13c enables administrators to track compliance of their WebLogic Server environments to the Defense Information Systems Agency’s Oracle WebLogic Server 12c Security Technical Implementation Guide (STIG).  The Security Technical Implementation Guide contains technical guidance to “lock down” information systems and software that might otherwise be vulnerable to a malicious computer attack. Originally published by the Defense Information Systems Agency for the Department of Defense, the STIG for Oracle WebLogic Server 12c can be used by administrators from public or private sectors to ensure their WebLogic Server environments are sufficiently secure and not vulnerable to attack.

Beginning with Oracle Enterprise Manager Cloud Control 13c Release 1 and the Fusion Middleware Plug-in Release, a predefined compliance standard named “Security Technical Implementation Guide (STIG Version 1.1) for Oracle WebLogic Server 12c“ is available from the Cloud Control console. Administrators can associate this compliance standard with their 12c WebLogic Domains to ensure that those domains adhere to strict security guidelines.

The below screenshot highlights one of the 72 predefined rules included in the Security Technical Implementation Guide (STIG Version 1.1) for Oracle WebLogic Server 12c compliance standard.

The below screenshot highlights a violation event to one of the automated rules included in the Security Technical Implementation Guide (STIG Version 1.1) for Oracle WebLogic Server 12c compliance standard.

To see first-hand how to use Oracle Enterprise Manager Cloud Control 13c to track compliance to the Oracle WebLogic Server 12c STIG, watch and listen to the recorded demonstration available on the Oracle Learning Library here.   Additional information can also be obtained from the Oracle Enterprise Manager Cloud Control 13c Online Documentation Library:

Thursday Mar 03, 2016

DBaaS RESTful API Cook Book

Having a GUI tool like Enterprise Manager Cloud Control to manage your entire data center is an imperative for most enterprises these days. But in the cloud paradigm, you must also have a uniform API that can be used to tailor the cloud to your business processes and economic models. That API is known as the REST API, and services based on that are known as RESTful services.

With the latest release of Oracle Enterprise Manager, enhancements have been made to the REST API to facilitate the administration as well as the operational use of features in the Cloud Pack for Oracle Database. You are now able to fully automate the administration of your cloud assets. The REST API also facilitates the self-service model for private cloud, enabling you to fully automate the actual request and governance of database needs by a given Line of Business (LOB). Through the use of the REST API, you can streamline the process of delivering critically needed databases to the LOBs at a fraction of the current Operational Expenses (OPEX) cost. Some critical business benefits are as follows:

Standardization – With the implementation of the DBaaS REST API you will be able to reduce OPEX by standardizing the provisioning of databases in a fully automated fashion. A database request from different parts of your organization would be self-service and based on a standard build of the database specific to the binaries, structure and data.

Centralization – With the streamlining of database provisioning via the DBaaS REST API, you can centralize the overall management and lifecycle of the entire private cloud landscape and ensure that service levels are maintained.

Simplification – With a central and standard delivery model, you will also simplify the entire configuration landscape. This will reduce OPEX by way of reducing the number of Oracle Homes (OH) and databases being managed. Consolidation of OHs and databases will also contribute to a reduction in Capital Expense (CAPEX) by ensuring that you maximize the use of existing resources in a data center or ensure that pending purchases are fully used. Finally, the simplification and consolidation will also reduce CAPEX by reducing environments in the data center itself. This translates to reduced power, A/C and a reduction in real estate required to satisfy the business needs while ensuring that IT can provide the proper environments, maintaining world-class standards for the business.

Recently, the Enterprise Manager product management team has released a cookbook that is intended to provide direction and requirements for the execution of DBaaS specific to the use of the REST API provided with the Cloud Pack for Oracle Database. That cookbook is available on OTN. If you want more information on DBaaS, you can find white papers, demonstrations, case studies and more here.

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

Friday Jan 08, 2016

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

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

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

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

Exadata Patching:

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

Enhancements in Database Compliance Management:  

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

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

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

Configuration Drift and Consistency Management:

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

Additional Info

Friday Dec 18, 2015

Oracle Enterprise Manager 13c: New and Exciting Features

Learn about all the exciting new features in the latest release of Oracle Enterprise Manager 13c.[Read More]

Tuesday Oct 20, 2015

Oracle Enterprise Manager @ Oracle OpenWorld 2015

With Oracle OpenWorld less than a week away, we wanted to highlight all the exciting Oracle Enterprise Manager events and activities at this year's conference. The Oracle Enterprise Manager team put together a snapshot of what's happening—from general sessions to hands-on labs—here is a quick summary:


  • Oracle Management Cloud General Session, featuring 3 brand new services—Real-Time Monitoring, Log, and IT Operations Analytics. Save your seat, pre-register today
  • Unprecedented number of sessions delivered by Oracle experts and customers at this year's conference. See full session list
  • Oracle Enterprise Manager at the SIG Sunday User Group Forum. Session details
  • Dedicated Oracle Enterprise Manager demopods in the Oracle DEMOgrounds. Search Oracle OpenWorld demos
  • Oracle Enterprise Manager Hands-on Labs, providing a deep-dive experience led by Oracle experts. See full list

For the complete list of sessions, demos and hands-on labs, read the Oracle Enterprise Manager Focus on Doc for more.

We look forward to seeing you there!

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

Friday Oct 16, 2015

Oracle OpenWorld Sneak Preview: Oracle’s Newest PaaS Offerings for IT Operations Management – Oracle Management Cloud

OpenWorld is always a very exciting time for Oracle and our customers, and every year we reveal some of our newest offerings. We sat down with Prakash Ramamurthy, Senior Vice President of Oracle Management Cloud, to discuss this year’s conference.

Q: Tell us about what’s happening this year at OpenWorld for Oracle Management Cloud?

PR: This year, we have a rare and fantastic opportunity to introduce an entirely new category of systems management cloud services for Oracle customers – the Oracle Management Cloud. Oracle Management Cloud is a suite of next-generation, integrated monitoring, management and analytics solutions delivered as a service on Oracle Cloud. It is designed for today’s heterogeneous environments across on-premises, Oracle Cloud and third-party cloud services.

Q: Why will Oracle Management Cloud be so valuable to customers?

PR: Customers today are struggling with the need to reduce time-to-market for new applications, even as those applications are getting more and more complex and distributed. Whereas a new offering five years ago might have been supported by a monolithic, on-premises infrastructure, today that offering may be composed of half a dozen cloud services from several different providers. Oracle Management Cloud was purpose-built to provide the new level of operational efficiency and visibility that these rapidly-changing environments require.

Q: What services will be available in the Oracle Management Cloud?

PR: We will be offering three services out of the gate focused on some of the highest pain points for customers today. Oracle Application Performance Monitoring Cloud Service provides development and operations teams with the information that they need to find and fix application issues fast, via deep visibility into your application performance from end user experience, through application server requests, and down to application logs. Oracle Log Analytics Cloud Service monitors, aggregates, indexes, and analyzes all log data from applications and infrastructure – enabling users to search, explore, and correlate this data to troubleshoot problems faster, derive operational insight and make better decisions. And finally, Oracle IT Analytics Cloud Service provides 360-degree insight into the performance, availability, and capacity of applications and IT investments, enabling line-of-business executives, analysts, and administrators to make critical decisions about their IT operations based on comprehensive system and data analysis.

Q: Where can customers go to learn about these new offerings?

PR: The single best place to experience the power of these new offerings will be in the Oracle Management Cloud Launch General Session, which is titled GEN9778 - Oracle Management Cloud: Real-Time Monitoring, Log, & IT Operations Analytics and takes place on Tuesday, October 27 at 11AM in Moscone South Room 102. Oracle OpenWorld attendees should pre-register for the session as there is limited space and attendees will be receiving a gift from Oracle. In addition to the General Session, there will be several dedicated track sessions, demonstration stations and hands-on labs throughout the remainder of the week. It’s going to be a very exciting time.

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

Tuesday Jul 07, 2015

Snap Cloning Databases on Exadata using Enterprise Manager

Historically, Exadata has mostly been deployed for heavy, production workloads, leaving cheap commodity hardware and third-party storage to perform as infrastructure for Development and Testing. From the viewpoint of Enterprise Manager, we have seen customers clone production databases running on Exadata to secondary storage such as ZFS Storage Appliance or even third-party NAS or SAN for the purpose of testing. Customers mainly used RMAN (with or without Enterprise Manager) to clone the databases. While the master clones (often referred to as Test Master) could be further cloned via storage efficient snapshots, there were significant limitations to the approach.

  • First of all, the testing on non-like systems from Exadata (both compute and storage) often yielded erroneous inferences.
  • Second, both the compute and storage on existing Exadata racks often remained underutilized.

Most surveys establish that there are several Dev/Test copies for every Production database, and leaving Dev/Test outside the realm of Exadata can only yield partial usage of engineered systems.

Two recent advancements in Exadata break this existing barrier. First of all, the compute nodes on Exadata can now be virtualized. Consolidated environments can now use Oracle Virtual Machine (OVM) on X5-2, X4-2, X3-2, and X2-2 database servers to deliver higher levels of consolidation and isolation between workloads. The Virtual machines can be configured on demand with the appropriate number of Virtual CPUs (vCPUs) for iterative testing. Second, with Oracle Database 12c Release 1 (12.1) release BP5 or later, space-efficient database snapshots can now be quickly created for test and development purposes on Exadata.

Snapshots start with a shared read-only copy of the production database (referred to as the Test Master in Enterprise Manager Parlance) that has been masked and/or cleansed of any sensitive information. Snapshot technology as deployed on Exadata is "allocate on first write", not copy on write. As changes are made, each snapshot writes the changed blocks to a sparse disk group. Multiple users can create independent snapshots from the same base database, therefore multiple test and development environments can share space while maintaining independent databases for each task. The base database must remain read-only during the usable lifespan of snapshots that are created from that base database. If there is a need to create another set of snapshots from a more recent copy of production data, a new read-only base from a production database needs to be created.

Enterprise Manager 12cR5 leverages the capabilities of Exadata to extend the Snap Clone capabilities for Exadata Sparse clones. As shown in this tutorial, with Snap Clone, Enterprise Manager can create a Test Master using either Dataguard technology or RMAN preceded by data masking. The Test Master can be created either on the same Exadata rack or on a different one. Once the Test Master has been created, snapshots can then be created on the sparse disk groups using the Deployment Procedures. The Deployment Procedures also automate the post-cloning discovery and promotion of the cloned targets, making them fully managed right from inception. Internal testing confirms that for cloning a Terabyte of database with a complete discovery of all its components takes less than a minute.

Enterprise Manager also helps DBAs track the lineage of the clones by providing a report on the production database, the Test Master and its clones. Enterprise Manager Snap Clone on Exadata supports both regular as well as pluggable databases with optional ACFS configuration. In addition to support for Exadata sparse clones, Snap Clone continues to support NAS (ZFS Storage Appliance and NetApp) and SAN (certain EMC storage arrays), in case users want to deploy these for their Dev-Test environments. 

Further Reading Resources

  • To learn more about Database as a Service visit the otn page.
  • Prerequisites for setting up Exadata Snapshots are documented here.
  • Watch the video, Snap Clone Multitenant (Pluggable Database) on Exadata here.
--Subhadeep Sengupta (@Subh_here)

Monday Jul 06, 2015

Understanding Plans, Profiles and Policies in Enterprise Manager Ops Center

Enterprise Manager Ops Center uses a combination of Plans and Profiles to maximize repeatability and reuse, while giving you the degree of flexibility to provision and update what you need to in your environment. The structured building block approach will allow reuse of many of the components instead of re-entering data each time, but does make the whole thing look very confusing until you understand the relationship between plans and profiles.

The sort activities covered by plans and profiles are:

  • OS provisioning and configuration
  • BIOS and Firmware updates
  • LDOM creation
  • Zone creation
  • Boot environment creation
  • Patching and adding packages (S10 and S11)
  • Configuration files and pre/post action scripts (S10)
  • Automation using operational plans (scripts)

The Building Blocks

So, firstly, let's look at the building blocks and see what is the difference between a Plan and a Profile.


Profiles contain the configuration information required to perform an action eg:

  • OS Provisioning plan - contains type/architecture, resourcing, OS version, software group, language, timezone, password, filesystems, name services
  • OS configuration - contains type/architecture, agent/agentless, multipathing, network configuration
  • Discovery - contains asset type, tags, IP address, credentials, grouping
  • Logical Domains - contains type, name, CPU/Cores, memory, automatic recovery, storage, networks

These are just some examples of the 16 types of profiles available in the BUI. 


Plans are objects that can be run (executed) to make something happen. Plans contain profiles, other plans, policies, or a combination of these.


In addition to these profiles, there are update and monitoring policies and credentials that can also be created and edited here.


Let's look at a couple of examples from a process prospective and how they actually look in the BUI. A side note here is the screenshots have been taken from an Ops Center 12.2.2 environment. Ops Center 12.3.0 introduces new styles of icons, but the principles are still all the same.

Process overview

For example, if we were going to provision a bare metal physical sever, you would have 2 choices:

  • A simple provision that would just lay down an operating system
  • A complex provision that
    • could update the BIOS on an X86
    • lay down the OS
    • update (patch) the OS
    • Add applications
    • Run scripts
    • Apply a non default monitoring profile
    • etc.

You choose the one that best suits what you are trying to do.

Simple OS Provisioning

If you just wanted to get an OS laid down, basic network/filesystems configured and possibly an agent installed, you would choose a "Provision OS" plan

This plan contains 2 profiles, an "OS Provisioning" profile and an "OS Configuration" profile. These profiles contain the answers to the same questions that would have been asked if you provisioned the server manually. A point to remember: it is required that you create your profiles (answering the questions that the wizard presents) before they are available to be added to a plan.

In the BUI it looks like this:

Complex OS provisioning

This plan must have the same 2 plans that the simple approach did, but has the option to add many other plans to be able to patch the deployed OS (Update OS, Update software), add software (Install, Operational plans), and further configure the OS/Application using scripts (Pre-install, Post-install, Operational plans)

In the BUI it looks like this:

The steps (profiles) you choose will be determined by what you want to achieve and if you are provisioning Solaris 10/Linux or Solaris11. 

Duplicating steps

In addition, most of these optional steps can be duplicated to allow you to execute more than one profile. To do this, add your first profile for that step, then select (highlight) that step and if it is available, the copy icon (with 1, 2 shown on it) will become active.

 Click that icon and the step will be duplicated allowing you to run more than one profile.

This makes the whole operation much more flexible, as you could have an update profile for your OS , one for web servers and one for databases. So if this plan was to build a web server, your plan would contain both the OS update profile and the web server update profile, avoiding the need to have the OS patches in 2 profiles.

 Other examples

 Another example of this would be if you wanted to build and LDOM or if you wanted to build an LDOM and deploy an OS into it (complex or simple), you would choose the appropriate plan.

Building an LDOM

Building an LDOM requires a "Create Logical Domain" plan

which only has a single step, which is a "Logical Domain" profile.

Building an LDOM and provisioning an OS

You can build the LDOM and provision the OS into it in a single action by creating a "Configure and Install Logical Domains" plan

which contains two steps, which is a "Logical Domain" profile and an "Install Server Profile"


By now, hopefully, the pattern has become clear. Plans and profiles are just the building blocks that allow you to deploy your system in the way you want. Each of the components are modular, so they can be re-used as much as possible and make it easier to maintain as you have fewer places you need to change when you want to change your configurations. There are many other types of plans offered by Ops Center that will create zones , build M-series physical domains and deploy OVM for X86 virtual machines, individually or combined with OS deployment, but they all follow the same basic structure. While how to do this is all laid out in the online documentaion, my best advice is to get yourself some test systems and try it out. There is often no substitute for having actually done it.


Rodney Lindner

    Wednesday Jun 10, 2015

    New Enterprise Manager Release Allows Customers to Manage Their Hybrid Cloud from a Single Interface

    Oracle is today announcing Oracle Enterprise Manager 12c Release 5, which simplifies the journey to the cloud.  For the first time, you will be able to manage your hybrid cloud as one, from a single pane of glass.

    According to a recent Computerworld survey, cloud consumers are struggling with security issues, integration headaches and performance concerns in public and hybrid cloud environments.

    The latest release of Oracle Enterprise Manager addresses these concerns through new enhancements that manage, migrate, test and deploy applications and databases across hybrid clouds, with 100% reuse of existing management tools and practices.  These enhancements will provide centralized visibility and control to Oracle customers on their cloud journey, while helping to ensure that their existing company-wide standards are applied across the estate.  The following set of hybrid cloud features is now available for those using Oracle Database and Oracle Java Cloud Services:

    • Workload portability & secure, bi-directional cloning: Replication of application artifacts and data across the hybrid estate with automated workload migration
    • Quality of service management: deep, expert performance management, diagnostics, tuning, leveraging the full breadth of Oracle’s extensive best practices for optimizing our stack.
    • Lifecycle and Cloud Management: automated patching and rapid provisioning of database and middleware with self-service access for agility.
    • Data governance & configuration compliance controls:  Configuration and compliance management, data masking, compliance frameworks and rich notifications for control.

    Clone database to Oracle Cloud with the click of a single button
    Migrate on-premises IT assets to Oracle Cloud, or from Oracle Cloud to on-premises, with a single click

    A simple, secure deployment architecture

    This rich functionality is exposed through an extremely simple deployment architecture.  Administrators will  install the Oracle Enterprise Manager Hybrid Cloud Gateway to manage and encrypt all required communication between their existing on-premises Enterprise Manager and the Oracle Cloud Platform...and that’s it!  With no additional network reconfiguration, Oracle customers can immediately begin to manage their hybrid estate as if it were one.

    Customers, partners and analysts welcome Oracle’s hybrid cloud management approach

    "e-DBA, an Oracle Platinum Partner and customer, has seen the benefits Oracle Enterprise Manager brings to our clients regardless of the size and complexity of their estate, which is why we also use it internally,” said Phil Brown, Global Lead for Enterprise Management Technologies, e-DBA.  “Reusing our existing skills will accelerate adoption of the Oracle Cloud Platform since our hybrid cloud will be a natural extension of our existing estate, all seamlessly managed as one." 

    “As Bridge Consulting has expanded our Oracle footprint to include Oracle Cloud Platform, we have recognized the importance of centralized management control over our entire hybrid estate,” said Marco Bettini, Co-founder and CTO of Bridge Consulting.  “The new Oracle Enterprise Manager capabilities are exactly what we need to ensure our hybrid cloud can be managed and consumed as one single environment, and we are especially glad we can leverage our existing best practices and knowledge across the entirety of our hybrid estate.” 

    “Our customers have consistently told us that they want to treat their hybrid cloud as a single unit, with workload portability as well as consistent governance across the entire estate,” said Dan Koloski, Senior Director of Product Management, Systems and Cloud Management, Oracle.  “The latest release of Oracle Enterprise Manager provides customers the ability to lift-and-shift applications from on-premises to cloud and from cloud to on-premises, while leveraging all of the rich quality of service and lifecycle management capabilities they use today.  We are excited to enable a hybrid cloud that truly functions as an extension of an on-premises data center.”   

    “IDC predicts that the majority of IT organizations will adopt a hybrid cloud strategy in the next five years.  For these companies, a key success factor is the ability to consistently support workload monitoring, management and portability across on premises IT and public cloud services,” said Mary Johnston Turner, Research Vice President, IDC.  “Oracle customers who are evaluating a hybrid cloud strategy spanning Oracle on premises and public cloud databases, web services, backup services and development resources will be well served to consider the new Enterprise Manager hybrid cloud management capabilities.”


    One of the most appealing aspects of this solution is that it is so simple to deploy and operate

    Clear benefits

    The value of Oracle Enterprise Manager has been empirically demonstrated by numerous studies from Crimson Consulting, Pique Solutions, Forrester and IDC.  Some of the recorded benefits are:

    Clear benefits Oracle Enterprise Manager

    Oracle Enterprise Manager 12c release 5 will help you simplify your journey to cloud by managing your hybrid estate as one.  A LIVE webcast with more information and Q&A will be aired on June 25, 2015.  Please register here to learn how to overcome the challenges involved with managing IT environments where public- and private clouds and on-premises infrastructure can thrive as one 


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


    Tuesday May 26, 2015

    Data to collect when logging a Service Request on Enterprise Manager Ops Center

    If you ever have to log a Service Request (SR) on your Enterprise Manager Ops Center instance, the question often arises as to what data you should include with the SR. Including the right information when you log the SR will greatly reduce your Time To Resolution (TTR).

    So, what data should you add to the SR? That will depend on what type of issue you are experiencing.

    Basic Information for All SR's

    While the My Oracle Support (MOS) portal will help by asking you relevent questions, here is a list of things to think about while answering them:

    1. A clear problem description - Tell us about what you were attempting to do when you encountered the issue, what host(s) were involved and what error message you saw. You would be surprised how many SR's get logged with "It didn't work" or just the error message as the problem description without telling us what you were actually trying to do. 
    2. Time and date - Tell us the time and date you saw the issue. The log files are time stamped, so knowing the time the issue occurred (at least approximately) will reduce the extent of searching of the log files that will need to be done.
    3. Software Version - Always tell us what version of Enterprise Manager Ops Center you are using. To find out your version, look on your Ops Center BUI under [Administration] ==> [Enterprise Controller] and at the top of the middle panel (Summary Tab) will be listed the Enterprise Controller Version. Don't forget to include if there are any IDR's (Patches) that have been applied to your Enterprise Manager Ops Center instance.

    Additional Data to include with your SR

    The most common thing to include with your SR is an OCDoctor --collectlogs output (# /var/opt/sun/xvm/OCDoctor/ --collectlogs), but it will often depend on which part of the process Ops Center was at when the issue occurred. If your issue falls under multiple sections below, please supply the data from all relevant sections.

    It should be noted that all of the Ops Center logs will rollover over time and on a busy environment that may not be a long time. So, it is important to collect any log files as soon as possible after you have seen your issue or you should reproduce the issue just before collecting the logs.

    Browser User Interface (BUI) issues

    • Collect screen shots of what you are seeing in the browser
    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on your Enterprise Controller and collect the output file

    Job related issues (Job fails)

    • Provide the job number
    • Provide the full job logs
      • In the BUI, click through to the failed task on the job and then export the logs
      • Select the radio button for "Full Job Log" and save the job log
    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on your Enterprise Controller and collect the output file

    OS provisioning issues

    • Capture the full job log (as described above)
    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on the relevant Proxy Controller and collect the output file
    • Capture any console logs of either the physical server or, if deploying to LDOMs, capture /var/log/vtnds/[LDOM name]/console.log
    • If deploying to an LDOM, run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on the relevant CDOM and collect the output file

    Patching issues

    • Capture the full job log (as described above)
    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on the system being patched and collect the output file
    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on your Enterprise Controller and collect the output file

    Discovery issues

    • Capture the full job log (as described above)
    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on your Enterprise Controller and collect the output file
    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on the relevant Proxy Controller and collect the output file

    Agent deployment issues

    • Capture the agent install output and logfile (/var/tmp/agent_install, /var/scn/install/log)
    • Capture the agent configuration output and logfile (/var/tmp/agentadm.log)
    • If the agent has actually been installed, run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on the system you are installing the agent on and collect the output file
    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs on the relevant Proxy Controller and collect the output file

    Domain Model issues

    • Run # /var/opt/sun/xvm/OCDoctor/ --collectlogs -u [EC Master Admin User] on your Enterprise Controller and collect the output file
      • This will collect the domain model information as well as the normal output from OCDoctor log collect. Note:  this can take a long time to run
      • The [EC Master Admin User] is the user that you specified as part of the initial install. On some customer systems, this will be root but it does not have to be.

    Collecting the right information and providing it as part of the initial logging of the SR will make it easier for the engineer to analyze your issue and avoid a lot of unnecessary back and forth. Overall, it will get your issue resolved quicker. I hope this information will help you if you ever have to log a SR on Enterprise Manager Ops Center.


    Rodney Lindner

    Tuesday May 12, 2015

    Data Clone and Refresh (part 1)

    In mid January we released the latest version of Enterprise Manager Cloud Control 12c, the 12cR4 Plugin Update.  This release included many enhancements in the cloud management space, making it the complete DBaaS automation solution.  The main areas of enhancement are:

    • Self Service Portal and Service Catalog, including add and remove standby capabilities, externalized database size and improved customization
    • Cloud Framework, with an improved self service portal, role and service type based access across all pages, and improved administration capabilities
    • Data Clone and Refresh, including an improved self service experience, admin flows for non-cloud cloning and refreshes, and additional storage certification
    • Fleet Maintenance, such as the ability to subscribe to database and grid infrastructure images, deploying them automatically to servers

    In this posting, I'll be focusing on the data clone enhancements.  My next post will focus on the refresh enhancements.

    Improved Self Service Experience

    Enterprise Manager ships with an out-of-box self-service portal that allows developers, testers, DBA's, and other self service users to log on and request various services. It also provides an administrative interface for DBA's to deliver one-off or special requests for services. These services include:

    • New single instance (SI) and Real Application Clusters (RAC) databases using pre-defined golden standards. This is ideal for developers asking for standard databases with or without data.
    • New SI and RAC databases along with Data Guard standby databases either within the same data-center or across different geographical regions. This is ideal for production and semi-production workloads that have high availability requirements. 
    • Schemas hosted in one or more databases, and provided as Schema-as-a-Service.
    • Pluggable databases that are hosted in one or more Oracle Database 12c Multitenant container databases provided as Pluggable Database as a Service. 
    • Database thin clones, using the Enterprise Manager 12c Snap Clone feature that leverages storage Copy-on-Write (CoW) technology on Oracle and non-Oracle storage. Snap Clone lets users, such as functional quality assurance testers, to create multiple copies of the database in minutes without consuming additional space, take private backups, and refresh data from the original source. Snap Clone supports cloning of databases on file and on Oracle Automatic Storage Management with block storage. 
    • Database full clones using RMAN backups or RMAN duplicates. This could be ideal for intense testing, such as database upgrades and performance testing on Exadata. 
    • All cloning services come integrated with masking, and ability to change configuration and software versions. 
    • Fleet maintenance allows administrators to patch and upgrade database software, with near zero or zero downtime. The subscription based model enables updates at scale, and across the entire cloud ecosystem thus significantly reducing the time required for maintenance activities. 
    Additionally, self service users can perform lifecycle operations like starting and stopping, checking the status, health monitoring, etc. on the requested databases and schemas. Provisioning can be done on both physical infrastructure using Deployment Procedures and on an Oracle VM virtualized server infrastructure using Virtual Assemblies and Virtual Templates. The portal provides access to a Service Catalog which lists various published service templates for standardized database configuration and versions. Users can review their past and outstanding requests, resource quotas, and current utilization as well as chargeback information for the databases and services they own. The portal also allows users to automatically backup their databases on a scheduled basis or take on demand backups. Users can restore the database to any of these backups. The self-service portal is the user's view into the cloud, thus it is designed to be easy to use and yet useful. The portal is also backed by both a command line interface and an API that can be used to request and manage cloud resources via scripts in lieu of the user interface.

    Admin Flows for Non-Cloud Cloning and Refreshes

    Often, people think of cloning as only important as a cloud operation, but  that’s not the only place that cloning can be important.  It’s ideal, for example, as a way to build environments for proofs of concept, test master creation, or indeed anywhere that you may need a one-off clone. With the Clone and Refresh functionality, you can clone from an existing snapshot of a database, or you can choose to clone to a particular point in time or SCN.  Not only that, you can integrate both masking and patching (for PSU’s) in this flow as well.  Once you have created a clone, you can then refresh it from the source later with a few clicks. And finally, once you’ve done cloning through the user interface, you might then decide to clone and refresh in a scripted manner, using the EM CLI verbs or REST API's that are provided for this.  You can even schedule the cloning through EM CLI to occur at a time that suits you.

    Now let’s look at the details of what can happen as part of this clone and refresh flow, based on the environment you can see in the image below:

    On the left hand side you can see our Production database.  In this example, this is an database running in a 3 node RAC environment, with some RMAN backups already taken.  So what can I do with this database when I clone it?

    Firstly, I can mask sensitive data.  Generally, when you take a copy of your Production database to another environment, you want to mask some of the data in that database, such as credit card numbers, salary details and so on.  The admin flow allows you to apply a pre-defined masking format to your data as it is cloned, or indeed execute your own custom SQL scripts to change the data as you need to.

    Secondly, I can actually test patching as part of the flow.  In the example I’m showing here, I’m cloning my Production database to an test environment.

    Thirdly, I can change the configuration as part of the admin flow as well.  Again, in the example shown here we're moving from a 3 node RAC environment in Production to a single instance test environment.

    Finally, if my underlying storage supports copy on write technology, I can also take advantage of that and take a snap or thin clone of my Production environment, where blocks are only written to my test environment as they are changed in Production.  That means I can build a lot more snap clones and still require only a very small percentage of the storage of my Production environment.

    Additional Storage Certifications

    Earlier releases of the Enterprise Manager Snap Clone functionality provided two different solutions from a storage perspective.  If you already had either Oracle's Sun ZFS Storage Appliance or NetApp, you could create a vendor specific hardware solution.  If not, you could use either the Solaris ZFS File System or the CloneDB functionality provided sine Oracle Database 11g release   More details on the EM12cR4 Snap Clone functionality is provided here.

    In the January plugin release, we added additional storage certification, so you can now also use an EMC SAN with ASM to create snap clones.  If you want more details on the Snap Clone and EMC solution, you can find details about it here.

    Further Information

    You can find more information on the material I've just covered in Part VII of the Cloud Administration Guide in the online documentation here.  You can also watch the screenwatch we recorded to show you the cloning process in action here.

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

    Friday May 08, 2015

    Vote for Oracle Enterprise Manager 12c

    Voting for the 2015 Database Trends and Applications (DBTA) Readers' Choice Awards is now open.

    In last year's DBTA Readers’ Choice Awards, Oracle Enterprise Manager 12c won two awards for "Best Database Administration Solution" and "Best Database Performance Solution."

    This year Oracle Enterprise Manager 12c has been nominated again in the same two categories; Best Database Administration Solution and Best Database Performance Solution.

    Be sure to cast a vote for your favorite management tool, Oracle Enterprise Manager 12c.

    The voting will close on May 22nd.

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

    Tuesday Apr 28, 2015

    EM Compliance ‘Required Data Available’ flag – Understanding and Troubleshooting


    Starting in release of Enterprise Manager a new column was added to the top level Compliance Standard Results page named ‘Required Data Available’. This column is meant to convey whether the data required for proper compliance evaluation of all of the rules within the Compliance Standard for each associated target is available in the repository. If the value for a given target is ‘No’ then the compliance results for that target should not be considered valid. A value of ‘Yes’ indicates the required configuration data is being collected and results valid; at least from a data availability perspective.

    One challenge facing customers is the lack of understanding of the column and how to correct the cause of the ‘No’ status. The goal of this guide is to explain how this column’s value is derived and provide some tools to correct the situation.

    Read More

    Wednesday Apr 22, 2015

    Test Drive Oracle’s Application Platform as a Service Solution

    We've just launched a new set of workshops in several U.S. cities: Oracle Platform as a Service for Application Development.

    This follows the success of the Database as a Service workshop series (see previous blog entry). It’s another opportunity to test drive new Oracle Enterprise Manager capabilities, but it goes far beyond Enterprise Manager. This time we focus on Java development and testing in the private and public cloud, and the cloud operations needed to support them.

    So bring your laptop, connect to our live environment and try it for yourself!

    The day begins with an overview of APaaS benefits and the architectural choices for building your enterprise private or public cloud (or both). You then use step-by-step workbooks that guide you through creating an application platform / middleware cloud environment. The event is perfect for application developers, IT managers and anyone developing, testing and deploying Java applications.

    The time is evenly split between private and public cloud labs. These are the workbooks we’ll go through:

    • Middleware as a Service
    • SOA as a Service
    • Fusion Middleware Provisioning
    • Creating and Exploring Java Cloud Service
    • Building and Deploying an Application with Java Cloud Service
    • Managing Java Cloud Service Operations

    Looks interesting? Register for an event near you.

    Monday Apr 13, 2015

    New Enterprise Manager STIG Compliance Standards for Oracle Database 11gR2 Now Available

    Last Friday, Oracle released new Enterprise Manager compliance standards based on DISA’s Security Technical Information Guide ( STIG ) for Oracle Database 11.2g Version 1 Release 2. These standards are specifically for use with Oracle Database 11g Release 2, both single instance and RAC.

    This is actually the second compliance content update since February. The previous one included an update to the Oracle Database 11g STIG standard bringing support from Release 8 to 11.

    Read More

    Wednesday Apr 01, 2015

    New TimesTen Plug-in for Oracle Enterprise Manager

    Co-contributor:  Simon Law, TimesTen Product Manager 

    Last Friday, Oracle released a new version of TimesTen Plug-in for Oracle Enterprise Manager 12c Cloud Control. This is a landmark release with many new features for database administrators in the enterprise.

    Besides database performance and availability monitoring; the new plug-in offers administrators the ability to manage and administer their TimesTen instances and databases, such as starting and stopping TimesTen services, loading and unloading databases to and from memory, and scheduling backups and restoring databases. Additionally, users can monitor database and replication activities, memory and disk usages, workload performance statistics, and identify longest running and most executed SQL statements.

    International users will be pleased to know that the new TimesTen plug-in was globalized with its user interface translated to nine different languages, the same languages as available in Oracle Enterprise Manager.

    TimesTen plug-in can be down-loaded through Enterprise Manager Self-Update.

    For more information, visit the Enterprise Manager Extensibility Exchange or the Oracle TechnologyNetork (OTN) TimesTen product page.

    Monday Mar 16, 2015

    Oracle Private Database Cloud: Defining Database Sizes in the Service Catalog

    Latest release of cloud plug-in (part of EM12c R4 Plug-in Update 1) brings the ability to define sizes for database cloud services (Schema and PDB services already support definition of size). Prior to this ability, customers were required to define a new template for each size – small, medium, large, etc. This will help in significantly reducing the number of templates required.

    So lets see how to use them.

    Read More

    Discover and Promote Oracle Homes as EM Targets

    Typically, Oracle Homes are discovered and promoted as targets automatically along with guided flows for addition of primary targets like databases, weblogic domains, etc, but there might be instances (not very often) where you need to discover the Homes standalone.

    There are two ways to do this – from the GUI and using EMCLI verbs.

    Read More

    Friday Mar 06, 2015

    Oracle Database In-Memory Advisor

    Recently, Oracle announced the general availability of the Oracle Database In-Memory Advisor—a new capability built into Oracle Enterprise Manager 12c Tuning Pack. With this release, Oracle introduces new and extensive capabilities for managing Oracle Database In-Memory, an Oracle Database 12c Enterprise Edition option.

    Oracle Database In-Memory can be used to improve queries on a variety of OLTP and/or data warehouse operations. The In-Memory Advisor helps to optimize performance with recommendations to run analytics processing faster. It gives customers insight into the sizing of the workload and offers actionable recommendations for running workloads at peak performance. The Advisor analyzes workloads and related objects making specific recommendations to which objects would give you the greatest benefit and performance if they were placed In-Memory.

    Key Capabilities:

    • Assists with In-Memory size selection
    • Recommendations for tables, partitions and sub-partitions for a given In-Memory size
    • Uses workload and performance data to prioritize objects
    • Takes into account differences in disk and memory footprint, as well as compression ratios

    Actionable Recommendations

    • Workload based cost/benefit analysis
      • Cost: Offers estimated memory size with various compression options
      • Benefit: Offers estimated database time reduction metrics for workload processing
    • In-memory area population plan


    • Ability to vary In-Memory size to receive specific loading plan
    • Generates DDL scripts with all the tables/partitions/sub-partitions recommended
    • Top SQL benefits from any given configuration

    For more information, visit the Oracle Database In-Memory Advisor page on the Oracle Technology Network. You can download the In-Memory Advisor, via MOS note 1965343.1.

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

    Friday Feb 27, 2015

    Oracle Private Database Cloud REST APIs

    While we spend a lot of time developing GUI for our private cloud features – like the self service portal, setup screens, etc, a large percentage of our customers use these features via our APIs, both EMCLI and REST based.

    Q: So why would anyone not use the out of the box cloud (self service) portal and use the APIs instead?

    A: Well, there are many reasons:

    1. You already have a custom cloud portal that you use to deploy non-Oracle products and now you would like Oracle products to be part of it
    2. You want cloud related actions to be part of a larger orchestration flow. For example, prior to provisioning, you want to integrate an approval workflow, and then post-provision update your asset management system with the service details.
    3. You want to integrate the cloud actions with our IT service desk or ticketing systems
    4. Integrate actions like cloning of databases (Snap Clone), or provisioning of middleware and applications with your continuous integration or devops process.

    Read More

    Oracle Enterprise Manager at Collaborate15

    April 12-16, 2015  •  Mandalay Bay Resort & Casino, Las Vegas  •  #C15LV

    Since the release of Oracle Enterprise Manager 12c, the user community has responded to the significant increased adoption of this popular product by featuring deep-dive sessions and labs in various user conferences spread all over the globe. Nowhere is this more evident than at Collaborate, a very popular user conference being held this year in Las Vegas and comprised of the respected IOUG, OAUG and Quest User Groups.  Collaborate15 has almost 50 sessions devoted to Enterprise Manager topics ranging from Private Cloud Management, Oracle technology or “stack” management and Applications Management heavily sprinkled throughout all three groups. Although some of those sessions on new features and “inside baseball” capabilities are being delivered by Oracle folks, the majority are developed and presented by experienced Enterprise Manager customers and partners.

    Word is starting to get out. In fact, Kellyn Pot’Vin-Gorman just published an excellent blog, “Everything I Needed to Know about Enterprise Manager I Learned at Collaborate15” which takes you on a highly-descriptive day-by-day journey of all the sessions, hands-on labs, demos and SIG meetings which feature Oracle Enterprise Manager. Oracle has also published a handy guide for Collaborate15 attendees to help build their schedules, called “FocusOn Enterprise Manager at Collaborate15” which is duplicated below for your convenience.

    The Oracle Enterprise Manager product group will also have a solid contingent present through-out the conference so please stop by the Oracle Demogrounds area and check out the OEM demo kiosks. See you there!

    Sunday April 12 - Pre-Conference Day





    Primary Presenter

    Hands-on Lab: Everything I Needed to Know About Enterprise Manager I Learned at COLLABORATE

    9:00 AM start

    Kellyn Pot'Vin-Gorman, Oracle

    Courtney Llamas, Oracle

    Werner de Gruyter, Oracle

    Expanding Use of Your Enterprise Manager System

    3:30 PM – 4:30 PM

    South Seas I


    Brent Sloterbeek, Gentex

    Monday April 13 - Day One





    Primary Presenter

    Zero to Manageability in One Hour: Build a Solid Foundation for Oracle Enterprise Manager 12c

    9:15 AM – 10:15 AM

    Banyan B


    Courtney Llamas, Oracle

    Architecting your own DBaaS in a Private Cloud with EM12c

    9:15 AM – 10:15 AM

    Reef F


    Gustavo Antunez , Pythian

    The Best Oracle Database 12c Tuning Features

    10:30 AM – 11:30 AM

    Palm B


    Rich Niemiec, ROLTA

    Exadata Exachk and Oracle Enterprise Manager 12c: Keeping up with Exadata

    12:00 PM – 12:30 PM

    Banyan B


    Bobby Curtis, Enkitec

    Application Management Suite Deep Dive - Patching and Cloning

    3:15 PM – 4:15 PM

    South Seas I


    Ravi Madabhushanam, Apps Associates

    The Power of the AWR Warehouse

    3:15 PM – 4:15 PM

    Banyan B


    Kellyn Pot'Vin-Gorman, Oracle

    Panel: Wait, Before We Get the Project Underway, What Do You Think Database as a Service Is...

    3:15 PM – 4:15 PM

    Reef F


    Steve Lemme, Oracle

    Erik Benner, Mythics

    Seth Miller, Collier IT

    Gustavo Antunez, Pythian

    The New Tool- Automatic Diagnostic Repository (ADR): How Can It Help You Troubleshoot Your Databases?

    3:15 PM – 4:15 PM

    Palm C


    Michael Nelson, Northrop-Grumman

    Getting Started with Oracle Enterprise Manager Cloud Control 12c

    4:30 PM – 5:30 PM

    Banyan B


    Leighton Nelson, World Wide Technology

    Stabilize Your Plans with SQL Plan Management Including 12c

    4:30 PM – 5:30 PM

    Palm B


    Alfredo Krieg, Sherwin Williams Company

    Top Weblogic Administration Tasks You Can Automate Now

    4:30 PM – 5:30 PM

    Breakers H


    Mrityunjay Kant, AST Corporation

    Welcome Reception

    Enterprise Manager Demos:

    • Total Cloud Control with Oracle Enterprise Manager (Technology Area)
    • Applications Management with Oracle Enterprise Manager (Applications Area)

    5:30 PM – 8:00 PM

    Exhibit Hall - Oracle Demogrounds

    Oracle Enterprise Manager Team

    Tuesday April 14 - Day Two





    Primary Presenter

    Enterprise Manager Demos:

    • Total Cloud Control with Oracle Enterprise Manager (Technology Area)
    • Applications Management with Oracle Enterprise Manager (Applications Area)

    9:30 AM – 3:30 PM

    Exhibit Hall - Oracle Demogrounds

    Oracle Enterprise Manager Team

    Protect Your Identities: Managing User Access Using Oracle Identity and Access Management With Bonus Tuning Tips

    9:45 AM – 10:45 AM

    Banyan C


    Ken Ramey, Centroid Systems

    Upgrading to an OEM 12c High Availability Architecture for Monitoring and Job Execution - Keeping the NOC from Knocking

    9:45 AM – 10:45 AM

    Banyan B


    Bill Petro, American Express

    Enable Oracle GoldenGate Monitoring for the Masses with Oracle Enterprise Manager 12c

    11:00 AM – 12:00 PM

    Banyan B


    Bobby Curtis, Enkitec

    What is My EnterpriseOne Web Users Real Experience?

    11:00 AM – 12:00 PM

    Surf C


    Frank Jordan, ERP Suites

    The Best Oracle Database 12c New Features

    11:00 AM – 12:00 PM

    Palm A


    Rich Niemiec, ROLTA

    Oracle WebLogic Performance Tuning

    11:00 AM – 12:00 PM

    Banyan C


    Jon Gilmore, Zirous, Inc

    Where did my day go?: Oracle Enterprise Manager 12c Administration

    2:00 PM – 3:00 PM

    Banyan B


    Alfredo Krieg, Sherwin Williams Company

    Automated Database Patching with Clould Control 12c: Lessons Learned and Best Practices

    4:30 PM – 5:30 PM

    Banyan B


    Fernando de Souza, General Dynamics IT

    Happy Hour

    Enterprise Manager Demos:

    • Total Cloud Control with Oracle Enterprise Manager (Technology Area)
    • Applications Management with Oracle Enterprise Manager (Applications Area)

    5:30 PM – 7:00 PM

    Exhibit Hall - Oracle Demogrounds

    Oracle Enterprise Manager Team

    Wednesday April 15 - Day Three





    Primary Presenter

    Your Own Private Cloud

    8:00 AM – 9:00 AM

    Reef F


    Gleb Otochkin, Pythian

    Managing and Monitoring Fusion Middleware Using Oracle Enterprise Manager 12c

    8:00 AM – 9:00 AM

    Banyan C


    Shawn Ruff, Mythics

    You've Got It—Flaunt It: Oracle Enterprise Manager Extensibility

    8:00 AM – 9:00 AM

    Banyan B


    Ray Smith, Portland General Electric

    Exadata 101 - What You Need to Know

    8:00 AM – 9:00 AM

    Banyan D


    Rich Niemiec, ROLTA

    How to Comply With Audit and Make Your Life Easier

    8:00 AM – 9:00 AM

    South Pacific J


    Frank Pound, Bank of Canada

    Enterprise Manager Demos:

    • Total Cloud Control with Oracle Enterprise Manager (Technology Area)
    • Applications Management with Oracle Enterprise Manager (Applications Area)

    9:30 AM – 3:30 PM

    Exhibit Hall - Oracle Demogrounds

    Oracle Enterprise Manager Team

    Enterprise Manager 12c Cloud Control for Managing Oracle E-Business Suite 12.2

    9:15 AM – 10:15 AM

    South Seas H


    Angelo Rosado, Oracle

    SIG: OAUG Oracle Enterprise Manager for Applications Special Interest Group

    10:45 AM – 11:45 AM

    South Seas H


    James Lui, Aramark

    Erik Benner, Mythics

    Oracle 12c Multitenant Database Lifecycle Management with Enterprise Manager 12c Cloud Control

    10:45 AM– 11:45 AM

    Banyan B


    Krishna Kapa, UBS

    SIG: IOUG Oracle Enterprise Manager Special Interest Group Meeting

    12:30PM – 1:00 PM

    South Seas Ballroom B


    Enterprise Manager Leadership Committee

    Design and Implement your Own Self-Service Enabled Private Cloud with Oracle EM12c

    2:45 PM – 3:45 PM

    Reef F


    Kai Yu, Dell

    Migrate Your Cron Jobs to Oracle Enterprise Manager Cloud Control 12c

    2:45 PM – 3:45 PM

    Banyan B


    Vladimir Lugo, Loyola Marymount University

    PeopleSoft Application and System Monitoring Basics

    2:45 PM – 3:45 PM

    Mandalay Bay Ballroom C


    Raj Garrepally, Emory University

    Migrate Your Cron Jobs to Oracle Enterprise Manager Cloud Control 12c

    2:45 PM – 3:45 PM

    Banyan B


    Vladimir Lugo, Loyola Marymount University

    Servers and Systems and Storage, Oh my! Infrastructure Management Using OEM 12c

    4:00 PM – 5:00 PM

    Banyan B


    Erik Benner, Mythics

    Recipe for Building a Private Database Cloud with Oracle RAC 12c

    4:00 PM – 5:00 PM

    Reef F


    Leighton Nelson, World Wide Technology

    Panel: Oracle Best Practices for Managing Oracle Applications

    4:00 PM – 5:00 PM

    Mandalay Bay Ballroom B


    Ken Baxter, Oracle

    Thursday April 16 - Day Four (Final Day)





    Primary Presenter

    Pluggable database as a service: Combining Oracle 12c Database multitenant architecture and Oracle Enterprise Manager 12c

    8:30 AM – 9:30 AM

    Reef F


    Krishna Kapa, UBS

    Future Now: Advanced Database Management for Today's DBA

    9:45 AM – 10:45 AM

    Banyan B


    GP Gongloor, Oracle

    12 Things to Consider for Migrating EBS to Exadata

    11:00 AM – 12:00 PM

    Banyan D


    Arun Kumar Anthireyan, BIAS Corporation

    Anomaly Detection for Database Monitoring

    11:00 AM – 12:00 PM

    Palm B


    Alex Gorbachev, Pythian

    Data Clone and Refresh Made Easy with Enterprise Manager 12c Snap Clone

    11:00 AM – 12:00 PM

    Palm D


    Pete Sharman, Oracle

    Under The Hood of Enterprise Manager - A troubleshooting primer

    11:00 AM – 12:00 PM

    Banyan B


    Courtney Llamas, Oracle

    Werner de Gruyter, Oracle

    Best Practices for Planning and Deploying Private Database Clouds with Oracle RAC 12c Technologies

    11:00 AM – 12:00 PM

    Reef F


    Mark Scardina , Oracle

    Smarter Monitoring with Adaptive Thresholds and Time Based Metrics

    12:15 AM – 1:15 PM

    Banyan B


    Courtney Llamas, Oracle

    Case Studies Moving ASM Files

    12:15 AM – 1:15 PM

    Palm D


    Anthony Noriega, ADN

     Updated March 10, 2015

    Wednesday Feb 25, 2015

    Editing EM12c Jobs in Bulk

    I recently received requests for suggestions on how to edit EM12c jobs in bulk. The two examples that were presented to me were:

    1. Change the start time of 70+ jobs
    2. Change the oracle home path in 80+ RMAN script jobs

    So how do we do this?

    Read More

    Tuesday Feb 24, 2015

    Q&A: The Cloud Journey with Enterprise Manager

    On last week's Enterprise Manager webcast, we had a great opportunity to catch up on the latest product news and hear how Enterprise Manager is helping companies transition to the cloud. We specifically focused on new capabilities around Platform as a Service for databases and middleware. You can still view the webcast on demand.

    As a speaker on the webcast, I really enjoyed seeing the high number of questions in the text chat window - that's maybe the most fun part! Here are some of the questions & answers we had. (They've been slightly edited for clarity.) As always, you're welcome to comment via the blog.

    Q: Do you recommend a DBA onsite or do you provide DBA support?
    A: Either way. You can have your own DBA managing your database private cloud, or hire a consultant from Oracle or an Oracle partner. The important thing is that a DBA can support many more databases once users have self-service.

    Q: Please explain provisioning of a schema in the database.
    A: Schema as a Service allows you to deploy a schema and use it as if it were a separate DB - but with the benefits of consolidated management at the DB layer. In Database 12c, this is achieved using multi-tenant, pluggable DBs.

    Q: What is Showback?
    A: Showback is like chargeback, except that no money actually changes hands. IT is just showing the users how many resources they used.

    Q: In Database Replay, does the workload run on an actual production-like environment, or is it just a simulation?
    A: Database Replay allows you to replay the captured workload on the actual proposed environment. This is often useful for upgrade exercises and testing new configurations.

    Q: Yes, but if consolidation is in planning stage, then the actual proposed environment won't be there. Are you talking about proposed environment in the cloud only?
    A: Using Consolidation Planner, you can simulate the workload and arrive at the target environment requirement for a specific set of workloads. Also, using Real Application Testing and SQL Performance Analyzer, you can test using captured workloads and replay them. 

    Q: Can EM provision MS SQL Server, and can EM provision in the Azure or Amazon cloud?
    A: EM has no out of box capabilities for provisioning non-Oracle DBs. Current capabilities are focused on private cloud. Provisioning for public cloud is on the roadmap.

    Q: Can you buy plugins for MS SQL Server?
    A: Yes, plugins are available for non-Oracle DBs, including SQL Server, Sybase, DB2. The Oracle Extensibility Exchange on OTN has a list of available plugins from Oracle and from third party sources.

    Q: I have a customer that wants to use Azure Pack as their provisioning UI. Can EM talk to Azure Pack in order to do this?
    A: Yes, your customer can use Oracle Cloud APIs and build the relevant application for provisioning.

    Q: So would Oracle Cloud APIs be an integration layer to Azure Pack?
    A: You need to write your own code to integrate the Oracle private cloud solution into any third party solution.

    Q: What's difference between full and snap clone?
    A: As the names suggest, a full clone is a copy of the source database - it will occupy the same amount of space as the source. Snap Clone is a sparse copy of the source database, where the copy will occupy very little space on the disk as it uses copy-on-write storage technology.

    Q: So Snap Clone only stores the changes and reads most data from the source?
    A: Snap Clone stores only changes made in the clone copy. 

    Q: In Snap Clone, what is the continuous refresh from production?
    A: When you clone a database (typically from production to either a test or dev environment), there may be a need to refresh the clone on a regular basis.

    Q: What is drift tracking?
    A: Using the new configuration management features, you can define a configuration standard for your databases. If there is a deviation, you can get a report (typically called) drift analysis.

    Q: What are some of the critical security-related configurations that you recommend for DB12c?
    A: EM12c can be used to track and enforce compliance, including industry standards such as PCI or customer policies created and monitored by EM itself. 

    Q; With self-service DBaaS, can the end user can update or upgrade the database or DB home?
    A: The end user (Self Service User) can upgrade the database service that he/she created earlier. Only Cloud Admin can upgrade Oracle Homes.

    Q: Can you explain this with an example?
    A: The Cloud Admin will upgrade all Oracle Homes in a Pool to the next patchset release. Now, SSA users can subscribe to upgrade the database services they created. If SSA users do not do so by a certain time, the Cloud Admin can force-upgrade their databases.

    Q: What is the difference between a hosting environment and a cloud?
    A: Resource abstraction, metering, chargeback, self-service, and a few other things are industry-accepted characteristics of a cloud.

    Q: Is dev/test in the public cloud, and production in the private cloud, the most common architecture?
    A: It's definitely very common. Dev/test environments are often temporary in nature and that lends itself very well to public cloud.

    Q: What's the difference between Exadata and Exalogic?
    A: Both are Oracle hardware systems. Exadata is optimized for databases, whereas Exalogic is meant for Oracle middleware and applications.

    Q: Thank you for answering all my questions. Great webcast!
    A: Thanks so much! Glad we got the opportunity to share the news.

    Monday Feb 23, 2015

    Webcast: Database Provisioning in Minutes: Using Oracle Enterprise Manager 12c DBaaS Snap Clone and EMC Storage

    Live Webcast
    Wednesday February 25, 2015
    8:00 a.m. PST | 11:00 a.m. EST

    Oracle Enterprise Manager 12c Database as a Service Snap Clone allows administrators to create fully functional copies of databases using the capabilities of the underlying storage layer. Users can request databases from the self-service console and have them provisioned within minutes instead of hours while keeping storage needs to a minimum.

    Attend this presentation to learn more about the features and benefits of Oracle Enterprise Manager 12c DBaaS Snap Clone using EMC storage and to view a live demo.

    This webcast is specifically targeted for DBAs, storage administrators and cloud administrators interested in saving time and effort implementing enterprise grade DBaaS.

    Register Now!

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

    Wednesday Feb 18, 2015

    Test Drive Oracle Enterprise Manager at a City Near You

    Are you tired of watching product demos? Prefer to try products for yourself? Then this is for you.

    Oracle is currently running a workshop series called Oracle Database as a Service Test Drives. You bring your laptop, connect to live Oracle Database 12c and Oracle Enterprise Manager 12c instances, and try our latest database cloud management solution for yourself.

    The day begins with an overview of DBaaS benefits and the architectural choices for building your enterprise cloud (OK, the introduction is actually a PowerPoint presentation!) You then use a step-by-step workbook that guides you throughout the day through the steps of creating a database cloud environment. The event is perfect for DBAs, application developers, IT managers and anyone involved in private cloud deployments.

    These are the workbooks we’ll go through:

    • Database as a Service using Snap Clone – self service
    • Database as a Service using pluggable databases (PDB) – self service
    • Database as a Service setup for cloud administrators
    • Cloud management – chargeback and metering
    • Database consolidation testing with Real Application Testing
    • Database lifecycle management with Enterprise Manager 

    Looks interesting? Register for an event near you.

    Wednesday Feb 11, 2015

    Webcast: Accelerate Your Cloud Journey With Enterprise Manager (February 17)

    Webcast: Accelerate Your Cloud Journey

    On February 17, join us for a webcast about the journey to the cloud with Oracle Enterprise Manager 12c. (If you can't make it, you can watch the webcast later on demand.)

    Last month, Oracle announced a new release of Enterprise Manager with many new cloud management capabilities, especially around Database as a Service and Middleware as a Service. This is a good opportunity to learn how the new capabilities fit into the overall cloud story.

    On the agenda:

    • The Cloud Journey
    • Private Cloud Platform as a Service
    • Making the Journey with Enterprise Manager 12c
    • Customer Case Studies
    • Looking Ahead: The Hybrid Cloud

    Register here


    Latest information on Oracle Enterprise Manager and Oracle Management Cloud.

    Related Blogs


    « August 2016