Wednesday Sep 18, 2013

Learn from Korea Telecom and HDFC about their private cloud journey at Oracle Open World

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.

Stay Connected:

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

Tuesday Aug 27, 2013

Enterprise Manager sessions by Usergroup members at Oracle Openworld 2013 SIG Sunday

Oracle Enterprise Manager 12c

User Group Forum Sessions

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.

Session Name
Time Room ID
Extending Oracle Enterprise Manager 12c Features/Functionality: Oracle Application Express
Todd Bellaver, Secure 24 LLC

8-9 AM

3005 UGF9793
Oracle RAC Performance with Oracle Enterprise Manager 12c and AWR—Interconnect Troubleshooting
Tim Quinlan, Scotiabank

8-9 AM

3016
UGF9804
I Have to Patch Again? Patch Management with Oracle Enterprise Manager 12c
Bobby Curtis, BIAS Corporation.

9:15-10:15 AM

3005 UGF9772
 Managing Oracle Enterprise Manager Cloud Control 12c with Oracle Clusterware
Leighton Nelson, Mercy Health

10:30-11:30 AM

3005 UGF9794
Oracle Enterprise Manager 12c, Oracle Database 12c, and You
Bobby Curtis, BIAS Corporation.

1-2 PM

3004 UGF9764
Simplify Database Performance Analysis with Oracle Enterprise Manager 12c for Monitoring
Sam Lucido, EMC CORPORATION

1-2 PM

3005 UGF9807
Clustering/High Availability with Oracle VM and Oracle Enterprise Manager 12c: 360 Degrees
Tariq Farooq, BrainSurface & Kai Yu, Dell, Inc.

1-2 PM

3016
UGF9803
Oracle Enterprise Manager Command-Line Interface Illustrated
Ray Smith, Portland General Electric

2:15-3:15 PM

3005 UGF9773
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
UGF9756
Oracle Enterprise Manager Panel Discussion
Kris Cook, SITA; Bobby Curtis, BIAS Corporation; Seth Miller, St. Jude Medical; Ray Smith, Portland General Electric

3:30-4:30 PM

3005 UGF9808


Stay Connected:

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

Tuesday Aug 20, 2013

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

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

Stay Connected:

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

Tuesday Aug 06, 2013

Secure, Subset and Self-Service Database provisioning in Cloud


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

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




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


1) Prepare source database

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

2) Perform Inline data subsetting and masking workflow

Here are the steps :

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

b) Create Masking and Subsetting definition

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

c) Generate subset using export option

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

3) Prepare secure test/reference database

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

4) Self-Service Portal Setup

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

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

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

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




5) Self-Service database provisioning in Cloud

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




Solution References

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

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


Additional information

Stay Connected:

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

Monday Jun 10, 2013

Schema-as-a-Service implementation using Oracle Enterprise Manager 12c

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.

  • Project Planning - Define scope of implementation, engage end users/cloud consumers in the planning process and get the project plan approved from all stakeholders.
  • Setup Cloud Management infrastructure
    • Review the EM 12c Sizing paper before you get started with EM 12c Release 2 install
    • Refer to EM 12c Administrator’s guide for High Availability, Security, Network/Firewall best practices and options
    • Deploy EM 12c site using EM 12c Release 2 Installation guide
    • Oracle Cloud Application, Database, Chargeback and Capacity planning, Storage Management Framework (SMF) and Virtualization (VT) plug-ins are required for enabling overall Database-as-a-Service capabilities
    • Install latest EM PSU [MOS note 822485.1] and also recommended patches for Database-as-a-Service [MOS Note 1549855.1]
    • Setup Roles and Users - Cloud Administrator (EM_CLOUD_ADMINISTRATOR), Self Service Administrator (EM_SSA_ADMINISTRATOR), Self Service User (EM_SSA_USER) are the important roles required for cloud lifecycle management and different users can be created and mapped to their respective roles as per their functional responsibility. Roles and users are managed by Super Administrator via Setup –> Security option. For Self Service/SSA users custom role(s) based on EM_SSA_USER should be created and EM_USER, PUBLIC roles should be revoked during SSA user account creation.
    • Setup Software Library - Cloud Administrator configures Software library via Enterprise –> Provisioning and Patching option and the storage location provided is OMS shared filesystem. Software Library is the centralized repository that stores all software entities
    • Setup Self Update – Self update can be configured via Setup -> Extensibility option by Super Administrator and is the unified delivery mechanism to get all new and updated entities (Agent software, plug ins, connectors, gold images, provisioning bundles etc) in EM 12c.
  • Setup Schema Cloud
    • Identify candidate servers to be pooled together into database cloud and deploy agents on those servers
    • Next step is to pool these server resources into a 'PaaS Infrastructure Zone'. As Cloud Administrator user, Create PaaS Infrastructure Zone via Enterprise -> Cloud -> Middleware and Database Cloud option
    • Deploy Oracle Database and Configure listener - As SSA Administrator user, setup target database(s) for Schema pool using Provision Oracle Database deployment procedure Refer to EM 12c database provisioning section in EM 12c Lifecycle Management Administrator's guide. Ensure listener is configured and discovered in EM for all the servers part of the Schema Cloud.
    • Setup Database Pool for Schema Cloud - As SSA Administrator user, create database pool via Setup -> Cloud -> Database option. you can specify max workload allocated to each database and also can enable Resource manager at this stage
  • Setup Service Catalog
    There are two distinct use cases here. you can either have SSA user get a) reference schema(s) imported or b) empty schema(s) provisioned . In case of empty schema(s) use case you can directly create service template and skip first step of configuring profile
    • Configure Profile - Profile captures required information from reference database including metadata and actual schema(s) content. As SSA Administrator, create profile via Setup -> Cloud -> Database and select 'Profiles and Service Templates' under Database cloud SSA portal and use 'Export Schema Objects' option.
    • Create Service template - Service template defines the standardization and actual flow that will be run when SSA user requests for Schema(s) from service catalog. As SSA Administrator, create a new service template via 'Profiles and Service Templates' option. you can select the related profile using which schema should be auto-imported when SSA user requests for schema. Important Tip - As part of Service template creation flow, there is this option of including standard custom scripts that can run part of service request flow before or after self-service schema(s) are provisioned.
  • Setup governance rules and policies
    • Configure Request Settings - As SSA Administrator, configure request settings via Setup -> Cloud -> Database and select Request settings tab under Database cloud SSA portal. you can define maximum duration of requests, how far in advance requests can be made etc and other request associated settings
    • Configure Quotas - As SSA Administrator, configure quotas via Quotas tab in Database cloud SSA portal and define total amount of memory, storage, no of Schemas that can be granted to each user. Quotas are assigned at role level and only the roles that has EM_SSA_USER privilege assigned can be selected.
    • Configure Chargeback/Showback - Chargeback is all about accountability and here you can track and meter resource usage and related costs in shared resource model and provide IT and business some powerful reports related to resource utilization and consumption costs. As SSA Administrator, Refer to Setting up Chargeback flow for defining charge plans and cost centers, chargeback settings. Important tip - Cost Center name is set by default as SSA user name for any new schema service provisioned by SSA users. Cost center can be changed via the Setup -> Cloud -> Database ->  Chargeback tab,  select 'Configure targets' and here the schema service target can be assigning to a different cost center.
  • Rollout Self-Service Portal to SSA Users
    •  Requesting Schema service - SSA Users at this stage can login to the Database cloud SSA portal and select the service template to request for schema service. During schema service request you can provide schema prefix to be added, workload size of service, schema passwords etc
    • Access Schema service - SSA users can access provisioned schema service from SSA portal and they can use the connection details from summary. There are performance and usage graphs provided for schema service monitoring by SSA users. There is also option to export/import data for all Schemas part of this Schema service.
  • Monitor and Manage Schema Cloud
    • SSA Administrator can monitor the schema service requests via request dashboard via Enterprise -> Cloud -> Middleware and Database request dashboard.
    • Refer to Private Cloud Administrator's guide for additional details to monitor the infrastructure at service, pool and zone levels. Important tip - Services Instances UI provides lot of useful detail in a single screen as you get to see all types of services along with their pool, zone association and also with related service template details.

More information -

Stay Connected:

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

Thursday Jun 06, 2013

The Enterprise Manager: Episode 9 - Java Platform as a Service

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.

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

Wednesday May 29, 2013

The Enterprise Manager: Episode 8 - Database as a Service

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.


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

Tuesday Oct 09, 2012

Private Cloud: Putting some method behind the madness

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.

http://www.oracle.com/technetwork/oem/cloud-mgmt/index.html

Sudip Datta

The views expressed here are my own and do not necessarily reflect the views of Oracle.

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

Tuesday Feb 07, 2012

Delivering Database-as-a-Service (DBaaS) with Oracle Enterprise Manager 12c

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 : 

Twitter | Facebook | YouTube | Linkedin | Newsletter

About

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs




Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
3
5
6
7
9
10
11
12
13
14
15
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today