By Scott Mcneil-Oracle on Apr 11, 2016
Thursday April 14th
Do you have
barriers between development and operations and your end-users?
During the webcast Oracle experts will talk about how to:
Thursday April 14th
Do you have
barriers between development and operations and your end-users?
During the webcast Oracle experts will talk about how to:
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
28th, 2015 10:00 a.m. PST/1:00 p.m. EST
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.
Join us and listen to Korea Telecom and HDFC in the
Zero to Cloud: Real Customers, Real-World Success Stories [CON9585]
at Oracle Open World on Tuesday, Sep 24, at 10:30 AM - 11:30 AM in #305 , Moscone South.
In this session, real customers will discuss their real successes as early adopters, revealing how they were able to organize IT resources into a cloud, enable self service provisioning, publish self service applications and meter and manage the cloud. We'll walk you through their best practices and customer experiences in implementing clouds in the real world for greater agility, IT efficiency and reduced costs.
You will learn how the Data Centers of Korea Telecom transformed to offer
Private and Public Infrastructure Services. HDFC will share how they continued
their private cloud through Database Schema as a Service.
Don't forget to join us at the Oracle Enterprise Manager General Session that features many real-world IT heroes who will share their personal journeys with Oracle Enterprise Manager. A full listing of Oracle Enterprise Manager activities at Oracle Enterprise Manager is available at the Focus-on document.
Oracle Enterprise Manager 12c
Sunday, September 22, 2013 - Moscone West
The IOUG's Enterprise Manager Special Interest Group (EM SIG) wants to let you know of an awesome line-up of Enterprise Manager sessions awaits those who can be there on "SIG Sunday" of Oracle OpenWorld! It promises to be an interesting mix of real-world use cases and panel discussions from implementers and users. Click the titles on the listing below for session abstracts.
Make sure you come early. Last year many of these sessions were full and folks had to be turned away, so don't let that happen to you. All sessions will be in the user pavilion area in Moscone West. While you are there you can stop by the User Group booths in the pavilion to learn more about IOUG in between the sessions.
At the final session of the day, Oracle Enterprise Manager Panel Discussion will
also serve as the EM special interest group (SIG) meeting. It will
be a great opportunity to meet with colleagues,
peers, and subject matter experts to share best practices, tips, and
techniques around Oracle technologies. In addition to the Oracle
usergroup experts, Oracle executives and experts will be available to
answer questions and listen to the user feedback.
If you cannot make it to the session, the IOUG and Oracle Enterprise Manager teams invite you to join a Twitter Chat during this session on Sunday, Sep. 30th from 3:30 PM to 4:30 PM PST. IOUG leaders, Enterprise Manager SIG contributors and many Oracle Users Forum speakers will answer questions related to their experience with Oracle Enterprise Manager and the activities and resources available for Enterprise Manager SIG members.You can participate in the chat using hash tag #em12c on Twitter.com or by going to tweetchat.com/room/em12c (Needs Twitter credential for participating).
A full listing of Enterprise Manager activities at OOW is available at the Focus-on EM 12c document.
| Extending Oracle Enterprise Manager 12c Features/Functionality: Oracle Application Express
Todd Bellaver, Secure 24 LLC
| Oracle RAC Performance with Oracle Enterprise Manager 12c and AWR—Interconnect Troubleshooting
Tim Quinlan, Scotiabank
| I Have to Patch Again? Patch Management with Oracle Enterprise Manager 12c
Bobby Curtis, BIAS Corporation.
| Managing Oracle Enterprise Manager Cloud Control 12c with Oracle Clusterware
Leighton Nelson, Mercy Health
| Oracle Enterprise Manager 12c, Oracle Database 12c, and You
Bobby Curtis, BIAS Corporation.
| Simplify Database Performance Analysis with Oracle Enterprise Manager 12c for Monitoring
Sam Lucido, EMC CORPORATION
| Clustering/High Availability with Oracle VM and Oracle Enterprise Manager 12c: 360 Degrees
Tariq Farooq, BrainSurface & Kai Yu, Dell, Inc.
| Oracle Enterprise Manager Command-Line Interface Illustrated
Ray Smith, Portland General Electric
| Cloud Computing, Oracle VM, and Oracle Enterprise Manager 12c Best Practices: Expert Panel
Michael Ault, IBM; Tariq Farooq, BrainSurface; Syed Jaffar Hussain, Alinma Bank; Charles Kim, Viscosity North America
|2:15-3:15 PM|| 3018
| Oracle Enterprise Manager Panel Discussion
Kris Cook, SITA; Bobby Curtis, BIAS Corporation; Seth Miller, St. Jude Medical; Ray Smith, Portland General Electric
One-step inline data masking and data subsetting is a very innovative solution in Oracle Enterprise Manager 12c that enables enterprises to provision secure and reduced size test systems directly from the production or standby database without the need for a full production database copy. So you are able to create reduced size copies of production database keeping the referential integrity of data set intact saving on storage costs and more importantly also ensure your sensitive database never creeps into any of your development or test systems in compliance with data privacy policies.
With Oracle Enterprise Manager 12c Release 3 customers have now started adopting this one-step on-the-fly masking and subsetting solution along with Database-as-a-Service(DBaaS) self-service provisioning capabilities and the outcome is one of the most comprehensive and unique solution to realize self-service provisioning of secured, subset copies of production like databases for all of testing and development needs in a private cloud model.
In this blog post I will walk through the steps required to achieve this comprehensive solution for test and development systems provisioning in enterprise private cloud.
1) Prepare source database
One of the ideal option in case customer has physical standby is to convert physical standby into a snapshot standby for one-step data subsetting and masking operation. A snapshot standby receives and archives but does not apply redo from primary until converted back to physical standby. So once you have created subsetted and secure dump from snapshot standby you can convert snapshot standby back to physical standby using Oracle Enterprise Manager. Refer to Oracle Data Guard guide for considerations in using snapshot standby. In-line data subsetting and masking can also be performed on production database in case there is no physical standby.
2) Perform Inline data subsetting and masking workflow
Here are the steps :
a) Create Application Data Model(ADM)
ADM is a knowledge base entity in Oracle Enterprise Manager that captures application metadata, referential relationships, sensitive columns and is used by both test data management and data masking. There are pre-defined drivers to capture data relationships from application metadata tables for Oracle Applications such as Fusion Apps and eBusiness Suite. Security Administrator requires EM_ALL_OPERATOR privilege to create ADM and Data Masking and Subsetting definition.
b) Create Masking and Subsetting definition
As a best practice, Security Administrator can create masking formats for all regulated information in the enterprise. There are out-of-box Oracle supplied default masking formats also that can be used from format library. Next step is to create masking definition that includes information regarding table columns and the format for each column. You can choose which columns to mask. Data Masking workflow can be referred here.
Next step is to create Data subset definition and use the same ADM and database used in creating the masking definition. In this step you can define the table rules,rule parameters, include 'Ancestor and Descendant tables' or 'Ancestor tables only' option this ensuring referential integrity is maintained. At this step Space estimates can also be reviewed and depending on the result, you can modify or add new rules and review back on space estimates value. Pre/Post subset scripts can also be included in definition.
c) Generate subset using export option
Using the definition subset can be created by writing the subset data to export file. Specify directory where to save the export dump and schedule the subset job. Once the job is complete, the subset Data pump file of production data with sensitive data masked is ready. The overall flow is described here
Some key tips -
- Parallel degree can be used for faster export. Start with twice the number of CPUs and tune from there
- %U and max file size parameter can be used to ensure optimum use of parallelism
- Rule parameter in where clause can be used for actual subset generation with different values
- Column rules can be used to set large-sized columns to null or fix value to reduce database size further
3) Prepare secure test/reference database
Once the Data pump export file is generated it can be imported in a test/staging database . For details refer here.This test database can be used as a reference for all development and testing copies and hosted in Self-Service portal for end users to request from service catalog.
4) Self-Service Portal Setup
Following two options are available to cloud-enable this secure reference database for self-service provisioning of future copies of this database via Oracle Enterprise Manager 12c Database-as-a-Service (DBaaS) solution :
a) Snap Clone option that leverages storage level copy-on-write technologies for cloning and is suited best for functional testing requirements and for short lived databases.With this option you can clone terabytes of data in few minutes and storage saving is enormous with this option. you need to review the supported storage options for this method. As of time of writing the post Netapp and ZFS is supported though there are plans to support more storage options in near future.
b) RMAN based cloning from backup is one of the favorite option for DBAs. The restore process is completely automated with EM 12c DBaaS and this option is best suited for performance and load testing, development requirements and for databases used for significant updates.
Once you decide on the option, steps to follow are documented in one of my recent blog post around Planning Database as a Service Implementation Project
Refer to Private Cloud Setup and Administration guide here for details on DBaaS Setup and Snap Clone, RMAN Profile options. The secure database prepared in previous step will be used as reference target by SSA Administrator while creating database provisioning profile using RMAN backup or Snapshot option. Please also ensure you have reviewed this MOS Note for DBaaS related patches -
"Enterprise Manager Cloud Control 12c Recommended Plug-Ins and Patches for Database as a Service (DBaaS) (Doc ID 1549855.1)"
5) Self-Service database provisioning in Cloud
End users can now request for secure subset copies of production database via Self-service portal for all kind of functional QA, load and performance testing, development requirements. All the databases provisioned from this approach are also enabled by default with EM 12c powered monitoring and diagnostics, lifecycle and cloud management capabilities.
1) Oracle Enterprise Manager 12c Packs
Oracle Test Data Management Pack
Oracle Data Masking Pack
Oracle Database Lifecycle Management Pack
Oracle Database Cloud Management Pack
2) Oracle Enterprise Manager 12c Platform and Plug-ins
Enterprise Manager Cloud Control 12c Release 3 Base Platform (188.8.131.52)
Enterprise Manager for Oracle Database (DB) plug-in 184.108.40.206
Enterprise Manager for Oracle Virtualization (VT) plug-in 220.127.116.11
Enterprise Manager Storage Management Framework (SMF) plug-in 18.104.22.168
Enterprise Manager for Oracle Cloud (SSA) plug-in 22.214.171.124
Schema-as-a-Service capability was released few months back as part of Oracle Enterprise Manager 12c Release 2 Plug-in Update 1 and is one of the widely talked about deployment models in a database cloud environment enabling deepest level of consolidation density possible and in turn driving maximum ROI. Schema consolidation also requires careful planning in terms of identifying the right mix of applications and business case and also meeting up with isolation requirements at operational, security and workload management levels. The following video presents Schema as a Service and other features supported by EM 12c Database as a Service.
In this post, I will go through the steps required to setup a Schema cloud service using Oracle Enterprise Manager 12c Release 2.This note is chalked down based on a recent customer experience and can be referred to by Administrators who are planning to or in process of setting up Schema-as-a-Service using Oracle Enterprise Manager 12c.
More information -
Empty VM containers are not good enough for java developers since they will need to install and manage software and Java before they can use it. Our intrepid hero Ed Muntz explains how Oracle Enterprise Manager enables complete Java Platform as a Service via self-service cloud portal.
Our intrepid hero Ed Muntz is back after a short stint in marketing to rescue the CIO Felix from IT challanges created by virtualization sprawl and management challanges for his enterprise databases.
Spinning VMs for database deployment is creating VM sprawl. Ed Muntz explains how Oracle Enterprise Manager enables rapid deployment of private database as a service and provides total control over the Database as a Service cloud.
Finally, I decided to join the blogging community. And what could be a better time to start than the week after OpenWorld 2012. 50K+ attendees, demonstrations, speaker sessions and a whole lot of buzz on Oracle Cloud..It was raining clouds in this year's Openworld. I am not here to write about Oracle's cloud strategy in general, but on Enterprise Manager's cloud management capabilities. This year's Openworld was the first after we announced the 12c Cloud Control and we were happy to share the stage with quite a few early adopters. Stay tuned for videos from our customers and partners, I will post them as they get published.
I met a number of platform administrators in Oracle-DBAs, Middleware Admins, SOA Admins...The cloud has affected them all, at least to the point where it beckoned more than just curiosity..Most IT infrastructure are already heavily virtualized (on VMWare and on others including Oracle VM), and some would claim they are already on “cloud” (at least their Sysadmins told them so). But none of them were confident of the benefits because their pain points continued to grow.. Isn't cloud supposed to ease those? Instead, they were chasing hundreds of databases running on hundreds of VMs, often with as much certainty propounded by Heisenberg. What happened to the age-old IT discipline around administration, compliance, configuration management?
VMs are great for what they are. I personally think they have opened the doors to new approaches in which an application stack gets provisioned and updated. In fact, Enterprise Manager 12c is possibly the only tool out there that can provision full-fledged application as VM Assemblies. In this year's Openworld, customers talked on how they provisioned RAC and Siebel assemblies, which as the techies out there know, are not trivial (hearing provisioning time for Siebel down from weeks to hours was gratifying indeed). However, I do have an issue with a "one-size fits all" approach to cloud. In a week's span, I met several personas:
Project owners requiring an EC2 like VM instance for their projects
Admins needing the same for Sparc-Solaris.
DBAs requiring dedicated databases for new projects
APEX Developers needing just a ready-to-consume schema as a service
Java Developers looking for a runtime platform
QA engineers needing a fast clone of their production environment
If you drill down further, you will end up peeling more layers of the details. For example, the requirements for Load testing and Functional testing are very different. For Load testing the test environment should ideally be the same as the production. You shouldn't run production on Exadata and load test on a VM; they will just not be good representations of one another. For Functional testing it does not possibly matter.
DBAs seem to be at the worst affected of the lot. It seems they have been asked to choose between agile provisioning and faster runtime performance. And in some cases, it is really a Hobson's choice, because their infrastructure provider made no distinction between the OLTP application and the Virtual desktop! Sad indeed.
When one looks at the portfolio of services that we already offer (vanilla IaaS, VM Assembly based PaaS, DBaaS) or have announced (Java PaaS, Instant Cloning, Schema-aaS), one can possibly think that we are trying to be the "renaissance man" ! Well I would have possibly digested that had it not been for the various personas that I described above.
Getting the use cases right is very important for an application such as cloud management. We iterate and iterate over these over and over again and re-validate them in CABs (Customer Advisory Boards). We consider over the major aspects of tenancy: service placement, resource isolation (can a tenant execute an expensive SQL and run away with all the resources), quota and security. We, in Engineering, keep reminding ourselves that we are dealing with enterprise clouds. We owe it to our customer base !
In the coming posts, I will drill down more into each of the services. In the meanwhile, here are some collateral and demos for starters with EM 12c.
The views expressed here are my own and do not necessarily reflect the views of Oracle.
In the 2011 IOUG Survey on Cloud Computing , 37% of respondents said they have a private cloud computing effort underway within their enterprises, up 29% from a similar survey conducted in August 2010. As you can see from this growing trend in the chart below, a significant number of companies are now considering deploying either private or public clouds, with many leaning towards the Platform-as-a-Service (PaaS) model.
The Oracle PaaS includes Database-as-a-Service (DBaaS) as one of its foundations. Based on Oracle Database 11g and Oracle Exadata Database Machine, the Oracle DBaaS model is a highly elastic and scalable platform that can deliver database applications and services in a public or private cloud environment.
One of the reasons why DBaaS works so well and why so many IT organizations are finding it very cost effective is manageability. With the recent release of Oracle Enterprise Manager 12c, Oracle now delivers deep management and automation capabilities that span the entire Database cloud lifecycle—from configuration and change management to performance diagnostics and tuning. It lets administrators identify and consolidate pooled resources, setup role-based access, define the service catalog, and related chargeback plans for compliance and reporting purposes.
For example, when the demand for services peak, say during a quarter end closing, Oracle Enterprise Manager 12c allows administrators to scale-up their databases, in some case, in as little as 20 minutes, and subsequently scale-down when workloads change. Finally, the solution lets IT management establish accountability for DBaaS consumers to help them understand the costs of services.
In a recent podcast, “Database-as-a-Service using Oracle Enterprise Manager 12c”, I talked with Sudip Datta, Senior Director, Oracle Enterprise Manager Product Management, about the paradigm shift for deploying database applications and services to the cloud through DBaaS. Listen to the podcast by clicking the image below.
To learn more about Database-as-a-Service, I recommend you read the technical whitepaper Database-as-a-Service using Oracle Enterprise Manager 12c Cookbook, which outlines how to setup DBaaS for your organization.
For more advanced documentation, be sure to read Part III of the Oracle Enterprise Manager Cloud Administration Guide that focuses on the Database-as-a-Service.
For more information, please go to Oracle Enterprise Manager web page or follow us at :