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:

Highlights:

  • 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 12.1.0.2 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

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

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

Policies

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

Examples

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"

Summary

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.

Regards,

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

    Demonstration

    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 

    Resources:  

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

    "THE PREVIOUS IS INTENDED TO OUTLINE OUR GENERAL PRODUCT DIRECTION. IT IS INTENDED FOR INFORMATION PURPOSES ONLY, AND MAY NOT BE INCORPORATED INTO ANY CONTRACT. IT IS NOT A COMMITMENT TO DELIVER ANY MATERIAL, CODE, OR FUNCTIONALITY, AND SHOULD NOT BE RELIED UPON IN MAKING PURCHASING DECISIONS. THE DEVELOPMENT, RELEASE, AND TIMING OF ANY FEATURES OR FUNCTIONALITY DESCRIBED FOR ORACLE’S PRODUCTS REMAINS AT THE SOLE DISCRETION OF ORACLE.”  

    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/OCDoctor.sh --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/OCDoctor.sh --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/OCDoctor.sh --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/OCDoctor.sh --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/OCDoctor.sh --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/OCDoctor.sh --collectlogs on the system being patched and collect the output file
    • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --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/OCDoctor.sh --collectlogs on your Enterprise Controller and collect the output file
    • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --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/OCDoctor.sh --collectlogs on the system you are installing the agent on and collect the output file
    • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on the relevant Proxy Controller and collect the output file

    Domain Model issues

    • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --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.

    Regards,

    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 11.2.0.4 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 11.2.0.4 Production database to an 11.2.0.4.2 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 11.2.0.3.   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

    Overview

    Starting in release 12.1.0.3 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 12.1.0.3 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 12.1.0.3.0 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

    Reporting

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

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


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

    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

    Title

    Time

    Room

    ID

    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

    10188

    Brent Sloterbeek, Gentex

    Monday April 13 - Day One

    Title

    Time

    Room

    ID

    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

    0

    Courtney Llamas, Oracle

    Architecting your own DBaaS in a Private Cloud with EM12c

    9:15 AM – 10:15 AM

    Reef F

    556

    Gustavo Antunez , Pythian

    The Best Oracle Database 12c Tuning Features

    10:30 AM – 11:30 AM

    Palm B

    567

    Rich Niemiec, ROLTA

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

    12:00 PM – 12:30 PM

    Banyan B

    746

    Bobby Curtis, Enkitec

    Application Management Suite Deep Dive - Patching and Cloning

    3:15 PM – 4:15 PM

    South Seas I

    10479

    Ravi Madabhushanam, Apps Associates

    The Power of the AWR Warehouse

    3:15 PM – 4:15 PM

    Banyan B

    112

    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

    598

    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

    241

    Michael Nelson, Northrop-Grumman

    Getting Started with Oracle Enterprise Manager Cloud Control 12c

    4:30 PM – 5:30 PM

    Banyan B

    856

    Leighton Nelson, World Wide Technology

    Stabilize Your Plans with SQL Plan Management Including 12c

    4:30 PM – 5:30 PM

    Palm B

    231

    Alfredo Krieg, Sherwin Williams Company

    Top Weblogic Administration Tasks You Can Automate Now

    4:30 PM – 5:30 PM

    Breakers H

    10506

    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

    Title

    Time

    Room

    ID

    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

    100

    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

    741

    Bill Petro, American Express

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

    11:00 AM – 12:00 PM

    Banyan B

    219

    Bobby Curtis, Enkitec

    What is My EnterpriseOne Web Users Real Experience?

    11:00 AM – 12:00 PM

    Surf C

    101760

    Frank Jordan, ERP Suites

    The Best Oracle Database 12c New Features

    11:00 AM – 12:00 PM

    Palm A

    565

    Rich Niemiec, ROLTA

    Oracle WebLogic Performance Tuning

    11:00 AM – 12:00 PM

    Banyan C

    239

    Jon Gilmore, Zirous, Inc

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

    2:00 PM – 3:00 PM

    Banyan B

    230

    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

    182

    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

    Title

    Time

    Room

    ID

    Primary Presenter

    Your Own Private Cloud

    8:00 AM – 9:00 AM

    Reef F

    460

    Gleb Otochkin, Pythian

    Managing and Monitoring Fusion Middleware Using Oracle Enterprise Manager 12c

    8:00 AM – 9:00 AM

    Banyan C

    336

    Shawn Ruff, Mythics

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

    8:00 AM – 9:00 AM

    Banyan B

    281

    Ray Smith, Portland General Electric

    Exadata 101 - What You Need to Know

    8:00 AM – 9:00 AM

    Banyan D

    569

    Rich Niemiec, ROLTA

    How to Comply With Audit and Make Your Life Easier

    8:00 AM – 9:00 AM

    South Pacific J

    389

    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

    10550

    Angelo Rosado, Oracle

    SIG: OAUG Oracle Enterprise Manager for Applications Special Interest Group

    10:45 AM – 11:45 AM

    South Seas H

    10083

    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

    108

    Krishna Kapa, UBS

    SIG: IOUG Oracle Enterprise Manager Special Interest Group Meeting

    12:30PM – 1:00 PM

    South Seas Ballroom B

    949

    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

    464

    Kai Yu, Dell

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

    2:45 PM – 3:45 PM

    Banyan B

    335

    Vladimir Lugo, Loyola Marymount University

    PeopleSoft Application and System Monitoring Basics

    2:45 PM – 3:45 PM

    Mandalay Bay Ballroom C

    100270

    Raj Garrepally, Emory University

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

    2:45 PM – 3:45 PM

    Banyan B

    335

    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

    453

    Erik Benner, Mythics

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

    4:00 PM – 5:00 PM

    Reef F

    656

    Leighton Nelson, World Wide Technology

    Panel: Oracle Best Practices for Managing Oracle Applications

    4:00 PM – 5:00 PM

    Mandalay Bay Ballroom B

    104800

    Ken Baxter, Oracle

    Thursday April 16 - Day Four (Final Day)

    Title

    Time

    Room

    ID

    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

    107

    Krishna Kapa, UBS

    Future Now: Advanced Database Management for Today's DBA

    9:45 AM – 10:45 AM

    Banyan B

    866

    GP Gongloor, Oracle

    12 Things to Consider for Migrating EBS to Exadata

    11:00 AM – 12:00 PM

    Banyan D

    660

    Arun Kumar Anthireyan, BIAS Corporation

    Anomaly Detection for Database Monitoring

    11:00 AM – 12:00 PM

    Palm B

    701

    Alex Gorbachev, Pythian

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

    11:00 AM – 12:00 PM

    Palm D

    921

    Pete Sharman, Oracle

    Under The Hood of Enterprise Manager - A troubleshooting primer

    11:00 AM – 12:00 PM

    Banyan B

    157

    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

    729

    Mark Scardina , Oracle

    Smarter Monitoring with Adaptive Thresholds and Time Based Metrics

    12:15 AM – 1:15 PM

    Banyan B

    144

    Courtney Llamas, Oracle

    Case Studies Moving ASM Files

    12:15 AM – 1:15 PM

    Palm D

    211

    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

    Monday Feb 09, 2015

    Take the IOUG Database Manageability Survey

    The Independent Oracle Users Group (IOUG), is conducting its annual database manageability survey. If you are a database professional responsible for managing and operating your organization's database applications and systems, then the IOUG wants to hear from you.

    Take the next few minutes to answer simply questions around your common manageability practices and challenges. Share your experience and insight with the IOUG and Oracle communities and you'll be entered into a draw for a chance to win an Apple iPad from the IOUG. You will also receive a free copy of the final report.

    Take the 2015 IOUG Database Manageability Survey


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

    Monday Feb 02, 2015

    Snap Clone using EMC SAN and ASM

    Recently we announced the latest update to Enterprise Manager Cloud Control 12c Release 4.  One of the enhancements in that release is support for Snap Clone on Automatic Storage Management (ASM) and EMC Storage.  Before we examine the details of this specific enhancement, let's look at a quick refresher on what Snap Clone provides for you.

    What is Snap Clone?

    Snap Clone is a storage agnostic and self service approach to creating rapid and space efficient clones of large databases (and by large, we’re talking terabytes or more). Now that’s probably more buzz words in one sentence than anyone’s brain can deal with without exploding, so let’s explain some of those terms more:
    • Storage agnostic – by that I mean Snap Clone supports all storage vendors, both NAS and SAN. It can leverage storage layer APIs or layer a ZFS filesystem on top to provide copy on write.
    • Self service – in the XaaS world – where X can be any of I, MW, P and DB :) – one of the key features is empowering the end user to do the work, rather than waiting on some techie to find time in their otherwise busy schedules. So it’s the end user who makes the adhoc clones here, not the storage admin
    • Rapid – People simply don’t have the time to wait weeks for provisioning to happen any more, so you have to support the functionality to clone databases in minutes rather than the days or weeks things used to take.
    • Space efficient – When you’re working with terabyte or larger databases, you simply may not have the storage to create full-sized clones, so you have to significantly reduce the storage footprint to start with.
    Over the various EM releases,  more and more functionality has been added to Snap Clone:
    • EM12cR2 provided Snap Clone for NAS storage (NetApp and Sun ZFSSA).  It provided RMAN backup based clones, and included the Snap Clone Analyzer to show you the storage savings you could make using Snap Clone
    • EM12cR3 added in support for Snap Clone using the Solaris File System (ZFS) and admin flows for Snap Clone for PDB’s (pluggable databases)
    • EM12cR4 added a lot more:
      • Snap Clone using CloneDB – this is the biggie, as it means Snap Clone can now be used with ANY Oracle database release that supports CloneDB, regardless of what storage it’s on
      • Data Guard standby as a test master – allows offloading the impact of creating the test master from your Production environment
      • NetApp Ontap 8.x cluster mode support
      • Certification for engineered systems, with I/O over Infiniband
      • Support for NFSv4
    • And in the latest plugin update that's just been shipped, we added:
      • Integrated data lifecycle management
      • Snap Clone using EMC SAN and ASM
      • Admin flows for test master creation
      • Integration with masking, patching, upgrades etc.

    Snap Clone using EMC SAN and ASM

    Most NAS technologies offer storage efficient clones in the form of Snapshots. The snapshots make use of underlying volumes, knows as flexvols (Netapp) or shares (ZFS). Unfortunately, SAN storage does not provide native snapshotting capability unless a file is created on it by leveraging TCP/IP over iSCSI over Ethernet. However this defeats the purpose of having high speed fiber channel fabric, not to mention that it makes little sense to overlay SAN with a filesystem. Another complaint we heard from our customers is that cloning is a data intensive operation that could flood the corporate IT backbone if Ethernet is used. Consequently, lot of our customers want native support for SAN for cloning purposes, especially, the ones who run ASM on SAN. And they are quite a lot in number.

    Using Snap Clone on ASM and EMC storage provides the ability to create ‘live’ thin clones of databases that are on ASM. A live clone is NOT snapshot based but rather a live copy of the database, residing on copy-on-write storage technology, that can be within the same cluster or indeed another one. Both single instance and RAC are supported – supported versions are 10.2.0.5 or higher of the database, 11.2 and higher of the Grid Infrastructure code. This functionality works on both EMC VMAX (with Time Finder VPSnap) and VNX storage appliances.

    Diagrammatically, the configuration looks like this:



    Why Use Snap Clone with EMC SAN and ASM

    There are a number of major challenges that Snap Clone can be used to address:
    1. Lack of automation - Manual tasks such as provisioning and cloning of new databases (for example, for test or development systems) is one area that many DBA’s complain is too time consuming. It can take days to weeks, often because of the need to coordinate the involvement of different groups, as shown in the image below:

    2. When an end user, be it a developer or a QA engineer, needs a database he or she typically has to go through an approval process like this, which then translates into a series of tasks for the DBA, the sysadmin and storage admin. The sysadmin has to provide the compute capacity while the storage admin has to provide the space on a filer. Finally, the DBA would install the bits, create the database (optionally on Real Application Clusters), and deliver that to the user. Clearly, this is a cumbersome and time-consuming process that needs to be improved on.

    3. Database unfriendly solutions – Obviously, when there is a need looking for a solution, different people take different approaches to solving that need. There are a variety of point solutions and storage solutions out there, but the vast bulk of them are not database aware. They tend to clone storage volumes rather than databases and have no visibility into the database stack, which of course makes it hard to triage performance issues as a DBA. They also lack the ability to track configuration, compliance and data security issues, as well as having limited or no lifecycle capabilities. As mentioned before, DBAs would like to leverage the native FDDI protocol of SAN for cloning.  This will make cloning fast and efficient without disrupting regular network traffic.

    4. Storage issues and archaic processes – Of course, one of the main issues is storage. Data volumes are ever increasing, particularly in these Big Data days, and the growth can often outpace your storage capacity. You can throw more disks at the problem, but it never seems to be enough, and you can end up with degraded performance if you take the route of sharing clones between users. There can also be different processes and different priorities between the storage team and the DBA team, and you may still have fixed refresh cycles, making it difficult to clone on an adhoc basis.
    So the end result of all of this is that far too often, there are competing priorities at odds. Users want flexibility – simplified self service access, rapid cloning, and the ability to revert data changes. IT, on the other hand, want standardization and control, which allows a reduction in storage use, reduction in administrative overhead, visibility into the complete database stack and lineage tracking.  

    Snap Clone on EMC storage helps you to address all these competing priorities, using hardware you may already own.  Indeed, EMC is well established as an Oracle database storage vendor over many years, and that integration has become tighter and tighter over the past few years.  In addition to that, the actual setup and configuration can be simpler than is the case when using other hardware, as you do not need to create Database Profiles in this configuration.  Service Templates are created directly on either a single instance or RAC database that resides on ASM.  Because you're using this combination of ASM and EMC SAN storage, the database is already Snap Clone enabled as it resides on copy-on-write storage technology.

    In my next post, I'll discuss more details of what else is new in the Snap Clone product in this latest release, so stay tuned for more details on that soon!

    For More Information

    You can see more details on how you actually set Snap Clone up on EMC storage by viewing the following screenwatches:

    For more details on using Enterprise Manager Cloud Control 12c to provide Database as a Service functionality, visit the OTN page located here.

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

    Tuesday Jan 27, 2015

    Top Oracle Enterprise Manager 12c Questions

    Guest contributors: Courtney Llamas and David Wolf

    What are the steps involved for upgrading from Oracle Enterprise Manager 12c Release 3 to Release 4? Is it an upgrade in place or a new install/migration
    Answer: Yes, Oracle Enterprise Manager 12c R3 to R4 is an out-of-place upgrade, which means the installer will install in a new Oracle Home and migrate the application over. You will need the additional space for a new Oracle Home. You can reduce downtime of the upgrade by performing a “Software Only Install”, and then upgrade later. See the upgrade documentation here.

    Do the patch and upgrade functionality work on Oracle Database 11g targets or only on Oracle Database 12c targets?
    A: Yes, patching and upgrading can be performed on any certified target version. For more details on database patching and lifecycle management visit this page.

    Where can I find a full list of new enhancements compared to Release 3?
    A: The new features are listed in Oracle Enterprise Manager Cloud Control Introduction Guide.

    Is there a list available of new features by management pack?
    A: The new features are listed in Oracle Enterprise Manager Cloud Control Introduction Guide. They are listed by plug-in, not management pack. For the license information read this page.

    What are the best hardware configuration and setup in order to provide high availability capabilities for database as a service (i.e. Oracle RAC, Oracle Exadata)?
    A: The more you rely on Oracle Enterprise Manager, the more you need to think about high availability. The best recommendation is to have a multi-OMS system with a standby for disaster recovery. You can scale up to this as the environment grows, but starting with a multi-OMS system will give you the availability and scalability you need. A standby database with Oracle Data Guard and a software replicated standby OMS would be the next step. Please read this whitepaper Deploying a Highly Available Oracle Enterprise Manager 12c Cloud Control for more information.

    Can Snap Clone be used with EMC storage or is Oracle ZFS storage required?
    A: Yes. Snap Clone can be used with either EMC VMAX and/or VNX Block Storage, both are supported. More details can be found on this page under the section: Database Cloning and Dynamic Data Refresh.

    Does Oracle Enterprise Manager support monitoring of hypervisors?
    A: Oracle Enterprise Manager supports monitoring of Oracle VM natively and VMWare via a Blue Medora third party plug in. More details on managing physical and virtual host can be found here.

    Is the metering and chargeback functionality part of the base product or does it requires an additional management pack?
    A: Metering and Chargeback for Oracle Database is part of the Oracle Cloud Management Pack for Oracle Database. Metering and Charge back for guest virtual machines (VMs) and hosts are included with the base product and does not require a separate license. Read this whitepaper for more on Metering and Chargeback with Oracle Enterprise Manager.

    Does Enterprise Data Governance require additional licensing?
    A: Use of the Enterprise Data Governance capabilities within Oracle Enterprise Manager requires an Oracle Database Lifecycle Management Pack license.

    How is the new AWR Warehouse feature different from the existing AWR report in Oracle Enterprise Manager 12c Release 3?
    A: The existing AWR report in Oracle Enterprise Manager pulls AWR data from the source database and relies on the AWR retention setting of that database. This is typically only saved for 8 days. There’s been a big demand for saving this data for 30-60 days and even longer. AWR Warehouse, automates the extract of the source AWR data and loading to a warehouse database so that data can be retained without affecting the performance and storage of the source database. The reports are the same, it just allows you to dig back further in time. Read this article for more details.

    Does this new release require more disk space for the AWR Warehouse? More CPU and memory?
    A: Not for the OMS. The recommendation is to setup the AWR Repository in a separate database, outside of the Oracle Enterprise Manager repository database. Hosting on the same server would be fine, so long as there is sufficient memory and CPU for both instances. Read this article on AWR Warehouse for more details.

    Does AWR Warehouse also support Oracle Database 10g and/or 11g AWR?
    A: AWR Warehouse must be installed on Oracle Database 12.1.0.2 or higher or version 11.2.0.4 with the appropriate patch. It also must be an equal or higher database version of the source databases it accommodates. Check out this demo to understand AWR Warehouse. Read the AWR Warehouse documentation.

    Is there a list of 3rd party technologies that can be managed by Oracle Enterprise Manager 12c?
    A: Check out the Oracle Enterprise Manager Extensibility Exchange for a list of the available 3rd party plug-ins and connectors.

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

    Monday Jan 26, 2015

    Register Now for the Cloud Platform Online Forum

    January 28th, 2015 10:00 a.m. PST/1:00 p.m. EST
    Register Today

    Modern Business. Modern Cloud.
    Is Your PaaS Delivering the Agility Your Users Demand?

    Don't miss the opportunity to join Oracle and IDC in a series of deep discussions on Cloud Platform as a Service. This online event kicks off on Wednesday January 28th at 10:00 a.m. PST. Take advantage of 20+ sessions, 10+ demos and 100+ tips and techniques to plan your PaaS adoption effectively. Topics encompass private, public and hybrid cloud. You will also learn how to plan your transition from traditional IT delivery to cloud delivery using Oracle technologies you use every day. Register at bit.ly/PaaSForum

    Oracle Enterprise Manager discussions during this event include tips and techniques on workload consolidation using database as a service and application platform as a service; transforming traditional IT delivery using self-service; effectively collaborating with business users with showback/chargeback, and more. Our speaker Sudip Datta, Vice President of Product Management will also provide a glimpse into the future of PaaS management.

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

    Sunday Jan 18, 2015

    Enterprise Manager Ops Center - Ops Center EC/PC sizing

    Counting Access Points Vs Assets

    When designing a customer's Ops Center environment, one of the first questions I get asked is how many servers can an Enterprise Controller (EC) or a Proxy Controller (PC) support.  Customers think of sizing, as being the number of servers,  LDOMs, etc. and these are lumped together into a total number of assets. In the real world, the answer to the "How many assets can my Enterprise Controller /Proxy Controller support?" question is, "It Depends".  How you place your Proxy Controllers in your network and what you manage from each Proxy Controller can impact the total number of assets that can be supported from an Enterprise Controller.

    The amount of load placed on an Enterprise Controller or Proxy Controller is not directly determined by the number of assets it manages, but by the number of Access Points (AP) it is supporting. A simple view of Access Points is that they are a connection. But it is a little more complex in that they are also a reflection of the way Ops Center internally models its data structures. The actual load on any given Enterprise Controller or Proxy Controller closely links to the number of Access Points it is managing. The number of Access Points seen by the Enterprise Controller can differ depending on whether an asset is connected via a single or multiple Proxy Controllers. Therefore, the Access Point count on the Enterprise Controller will be higher than the actual number of managed assets, if assets are managed by multiple Proxy Controllers. When the documentation is referring to Enterprise Controller /Proxy Controller capacity and uses the term "Asset", it is actually counting "Access Points".

    Let's look at a couple examples of this to make it clearer:

    Physical Server ILOM

    In this example, a single physical server has multiple data collection methods. A Proxy Controller can gather LOM data by accessing the service processor and by using the agent running inside the operating system.


    If the same Proxy Controller is used to access a single asset, the two data feeds are consolidated into a single Access Point. The Enterprise Controllers total load will be a single Access Point.


    If different Proxy Controllers are used to access a single asset,  each Proxy Controller will record it as a separate Access Point. The Enterprise Controllers total load will be the sum of both Proxy Controllers and will be a total of 2 Access Points.

    LDOMs

    Another example would be an LDOM guest where we obtain data from the Control Domain agent and the agent running inside the LDOM guest OS.

    Once again, if  both data feeds are via a single Proxy Controller they only count as 1 Access Point on both the Proxy Controller and the Enterprise Controller.

    Where as, if each data feed is via a separate Proxy Controller they each count as 1 Access Point on each Proxy Controller and the total Access Point count on the Enterprise Controller will be 2.

    With the release of Enterprise Manager Ops Center - 12.2.2, we have updated and renamed the Enterprise Manager Ops Center Sizing and Performance Guide (https://docs.oracle.com/cd/E40871_01/doc.122/e57052/toc.htm). This revised document is easier to understand and has been updated to reflect current releases of Ops Center. Note: Since the term "Access Point" was not considered to be commonly understood, the term "Asset" has been used in the documentation. 

    To make the counting of Access Points easier, we have added a program to the OCDoctor toolbox. This program "AssetCount.sh" is new in OCDoctor version 4.45 and can be found on any EC/PC or system that has an agent deployed. The path to the OCDoctor toolbox is /var/opt/sun/xvm/OCDoctor/toolbox.

    # /var/opt/sun/xvm/OCDoctor/toolbox/AssetCount.sh
    
            AssetCount.sh [-v] { standard | machine | agent | all }
    
            standard - show Asset count
            machine - show machine output with Assets names
            agent - show information about agents, agentless Assets, Service Processors
            all - show all the information together
    
            -v : verbose output, present additional notes around the counting algorithm
    
            (Version 1.0 2015/01/08) 
      #

    Let's just look at the standard output (we are running this on the Enterprise Controller). The output shows:

    • The total Access Point count for the EC (72)
    • The number of Access Points for each type of asset, for each Proxy Controller ( Note: the total Access Point count for each Proxy Controller is labeled as Assets )
    root@ec1:~# /var/opt/sun/xvm/OCDoctor/toolbox/AssetCount.sh standard
    
    EC 72
    
    Proxy Assets Zones Ldoms OVMGuests Servers Storages Switches ExadataCells MSeriesChassis MSeriesDomain
    ------------------------------------------------------------------------------------------------------
    pc4   32     5     25    0         2       0        0        0            0              0
    pc1   28     0     26    0         2       0        0        0            0              0
    pc0   12     2     4     0         6       0        0        0            0              0
    
    Use option '-v' to see additional notes on the counting algorithm.
    

    #

    You can also use the "machine" option to list out which asset is attached to which proxy.

    # /var/opt/sun/xvm/OCDoctor/toolbox/AssetCount.sh machine
    
    EC 72
    
    Proxy 32 pc4
    Zones 5 S11zone101 S11zone102 S11zone100 S11zone103 S11zone104
    Ldoms 25 stdldom21 stdldom34 stdldom36 stdldom22 stdldom45 stdldom47 stdldom25 stdldom43 stdldom49 stdldom30 stdldom23 stdldom29 stdldom42 stdldom20 stdldom32 stdldom46 stdldom44 stdldom26 stdldom31 stdldom27 stdldom48 stdldom40 stdldom35 stdldom41 stdldom28
    OVMGuests 0
    Servers 2 10.187.70.169 pc4
    ...
    Proxy 28 pc1
    Zones 0
    Ldoms 26 stdldom21 stdldom34 stdldom36 stdldom22 stdldom45 stdldom47 stdldom25 stdldom43 stdldom49 stdldom30 stdldom23 stdldom29 stdldom42 stdldom33 stdldom20 stdldom32 stdldom46 stdldom44 stdldom26 stdldom31 stdldom27 stdldom48 stdldom40 stdldom35 stdldom41 stdldom28
    OVMGuests 0
    Servers 2 10.187.70.171 pc1
    ...
    # 
    

    You can see this would be incredibly verbose on a large environment ( I have truncated it here). You can clearly see that the LDOMs (stdldomXX) are being reported by both "pc1" (via Control Domain) and "pc4" (via OS agent). Note: the differing LDOM count on "pc1" and "pc4"  as "stdldom33" has no OS or agent on it, so it only reports against "pc1".

    You can also use the "agent" option to display agent/agentless/LOM totals for each Proxy Controller.

    # /var/opt/sun/xvm/OCDoctor/toolbox/AssetCount.sh agent
    
    EC 72
    
    Proxy Agents Agentless SPs
    --------------------------
    pc4   25     2         0
    pc1   1      1         0
    pc0   5      5         5
    
    Use option '-v' to see additional notes on the counting algorithm.
    
    #
    
    

    In addition, OCDoctor.sh --troubleshoot will also be checking for the number of configured Access Points and comparing this number against the recommend Access Point count. It will print a warning at approximately 90% of the recommended capacity and a warning if you exceed the recommended capacity.

    Armed with the information above, you should be able to better design your Ops Center deployments and to monitor the growing load on the Enterprise Controller/Proxy Controllers as you add more assets.

    Regards,

    Rodney

    Friday Jan 16, 2015

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

    Wednesday, January 21, 2015
    1:00 p.m. EST | 10:00 a.m. PST

    The goal in every Oracle Enterprise Manager 12c rollout is to take it from zero to manageability in the shortest possible time. This presentation will show you how to accomplish this feat. Oracle experts will demonstrate how to properly architect and deploy Oracle Enterprise Manager 12c, including designing a highly available and scalable environment. Through this demonstration a list of essential techniques and tips compiled from Oracle Enterprise Manager Development’s Strategic Customer Programs team will also be shared. Topics such as; users, roles, groups, templates, and incidents will be discussed, plus key architectural decisions.

    By attending this webinar, you will learn how to:

    • Organize targets, notifications and users properly
    • Configure for best practices after the install is complete
    • Properly plan and architect an Oracle Enterprise Manager 12c environment

    Featured Speaker: Courtney Llamas, Principal Member of Technical Staff, Oracle

    Registered Now

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

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

    Related Blogs




    Search

    Archives
    « February 2016
    SunMonTueWedThuFriSat
     
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
         
           
    Today