New Cookbook for Database as a Service

Cloud Management in Enterprise Manager 12c is generating a huge amount of interest!! Have a look at the latest Cookbook by Oracle Product Management, this shows how to set up DbaaS (Database as a Service) step by step.

Database as a Service using Oracle Enterprise Manager 12c Cookbook
http://www.oracle.com/technetwork/oem/cloud-mgmt/em12c-dbaas-cookbook-1432364.pdf

Regards,

Porus.

Now Available: OVERVIEW presentation of Enterprise Manager 12c Cloud Control

Dear Readers,

Now Available: a brand-new OVERVIEW presentation of Enterprise Manager 12c Cloud Control. This is an excellent introduction to Enterprise Manager in general. Updated to latest EM 12c version.

This presentation also includes a number of slides on the Database Lifecycle Management pack, a very handy pack including database/server/OS configuration management, database provisioning and patch automation, and database change management (schema level changes and comparisons). Have a look at the presentation to get an idea of Cloud Control as well as this newly-combined powerful pack.

Download from Mediafire:

OVERVIEW presentation of Enterprise Manager 12c Cloud Control including DB Lifecycle Management Pack

http://www.mediafire.com/file/l25h2chvyv3ocvc/Enterprise_Manager12c_CloudControl_Overview_plus_DBLifeCycleMgmtPack.pdf

Alternatively, download from Ge.tt:

http://ge.tt/8j4CkDB?c

Includes a General introduction to Enterprise Manager 12c Cloud Control, recommended architecture, list of the most popular packs and a short introduction to the Application Management Suites, many slides on the Database Lifecycle Management Pack including the configuration management, provisioning, patch management and database change management aspects. Also includes slides on the new Test Data Management Pack (data subsetting) and a number of slides on Oracle and the cloud, showing cloud setup tasks for Iaas, DbaaS, and PaaS using Enterprise Manager, and on chargeback.

In all a very well-rounded presentation on Enterprise Manager that I have personally delivered to many customers/partners across ASEAN to give a solid idea of what is Enterprise Manager.

Enjoy!!

If you are based in the ASEAN region and feel your company could use any of the Enterprise Manager packs, please feel free to contact me for further details.

Regards,

Porus.

Latest Presentation: Managing Exadata with Enterprise Manager 12c

Friends,

Please see the latest presentation I have uploaded on:

Managing Exadata with Enterprise Manager 12c

http://www.mediafire.com/file/4ykp0mmu75xzceq/Managing_Exadata_with_Enterprise_Manager_12c.pdf

Alternative site for download: http://ge.tt/8ZJ9oQ9?c

I have updated this with the latest pack name changes and more slides as well so this is the most upto date presentation on this topic. Original presentation was by Deba Chatterjee and Mark Ramacher in Oracle Open World, October 2011.

Exadata DBAs will understand from this. that their machines can be managed very well with the latest Enterprise Manager 12c Cloud Control released recently by Oracle on October 3^rd 2011.

Packs and Options included in this presentation:

• Diagnostics/Tuning Packs

• Lifecycle Management Pack (3 EM11g packs combined in EM12c)

• Cloud Management Pack (Brand-new in EM12c)

• Data Masking Pack

• Test Data Management Pack (Brand-new in EM12c)

• Real Application Testing (RAT) DB EE Option

Using Cloud Control 12c, the client will be able to see an integrated view of all the hardware and software in the Exadata machine, with a schematic of storage cells, compute nodes and switches, and a software/system view of database systems/clusters. The client can inspect performance/availability /usage by databases /services/clusters and get software alerts on the database, cluster and ASM, as well as alerts on all hardware components. The Infiniband network and switches, so important for Exadata can be fully monitored with alerts, performance metrics and configuration standards. Storage cells can be monitored and also administered via Cloud Control. All storage cells in a database are automatically placed in a group, and you can administer the cells at the group level.

The performance of the RAC databases on Exadata can be fine tuned using the Diagnostics and Tuning pack capabilities of Enterprise Manager, these include the AWR repository, the ADDM diagnostics engine, and the SQL Tuning and SQL Access advisors. The database performance page is now Exadata aware with the performance graphs showing cell offload efficiency and cell smart scan, which are extremely powerful Exadata specific features. IO activity of other databases sharing the same storage can be examined. Exadata “smart scan” relevant info is also displayed on Real-time SQL monitoring and other SQL pages. There is also a Exadata System health page for a quick overview of availability across different time periods.

The newly-combined Lifecycle Management pack has the very useful capabilities of Configuration Management, Provisioning and Patch Automation, and Change Management. The Configuration management inventory has the version summary of all Exadata components, with the ability to compare configurations – useful in trouble shooting and to enforce configuration standards. The Patch Automation capabilities can be used to patch the multiple RAC database nodes and also the OS – a real need for automation when there are so many nodes, and the Change Management capabilities of the Lifecycle Management pack can be used to seamlessly propagate database schema changes across development, test and production databases. And, optionally, the Cloud Management pack for database lets you set up an internal DbaaS (Database as a service) cloud, with full self-service, metering and chargeback capabilities. The Cloud capabilities also include IaaS (Infrastructure as a Service) if using Oracle VM server pools, or, if using Exalogic servers, the Cloud Management pack for Fusion Middleware lets you set up PaaS (Platform as a service).

In this presentation we also discuss the Test Data Management pack, brand new in Enterprise Manager 12c, that lets you create test or development databases with a relationally intact fraction of the production data. This reduces the storage overhead for multiple test and development copies of large databases, and is very useful in real life situations.

Enjoy the world of Managing Exadata with Oracle Enterprise Manager 12c Cloud Control!!

As of January 2012, this presentation has 1100+ downloads on mediafire and ge.tt on the internet.

Regards,

Porus.

How Can You Capitalize on Oracle's New Database Solutions?

How Can You Capitalize on Oracle's New Database Solutions?

You’re invited to join senior Oracle Database leaders for a live chat explaining what the latest product innovations coming out of Oracle OpenWorld mean for you and your business.

Get real-time advice and answers to your top questions:

• In-Memory Databases or Big Data?
• Engineered or DIY Systems?
• Appliances or machines?
• Private or public clouds?
• SQL or NoSQL?

Bring your database questions and learn how you’ll benefit from new product advances. Join the conversation -- register now for one of the two live sessions.

Session 1: From Oracle OpenWorld to Your Enterprise—Capitalizing on the Vision
Tues, October 18, 10am US Pacific

Session 2: From Oracle OpenWorld to Your Enterprise—Capitalizing on the Vision
Wed, October 19, 7:30am in India, 10am in China, 1pm in Sydney
(NOTE: SESSION 2 is better for APAC time zone)

Space is limited so register today using the link below:

http://event.on24.com/r.htm?e=350793&s=1&k=51928AE8D947EABC86C7B629DEC6A1EC&partnerref=APACAce

Regards,

Porus.

Oracle Unveils Oracle Enterprise Manager 12c Cloud Control

Friends, Oracle has unveiled Oracle Enterprise Manager 12c "Cloud Control", notice the title change of this blog as well to include "Cloud Control" instead of "Grid Control"!!

Cloud Control, on which I did Beta testing as well, is a complete cloud management solution for your enterprise cloud - http://bit.ly/nAIhoJ #em12c #OOW11

The Oracle Enterprise Manager launch highlights can be viewed from http://www.oracle.com/openworld/live/on-demand/index.html

The link from the enterprise manager web page has the complete video that plays from (http://event.on24.com/view/presentation/flash/EventConsoleNG.html?uimode=nextgeneration&eventid=363130&sessionid=1&key=F84702A281E8EC9D97576E9604126690&format=fhvideo1&contenttype=A&playerwidth=1000&playerheight=650&mediametricid=772173&mode=launch&eventserver=http://event.on24.com&eventuserid=55468526&usercd=55468526&mediametricsessionid=45690682&mode=launch#

The New EM12c page is at http://www.oracle.com/enterprisemanager12c

Pricing for Enterprise Manager 12c "Cloud Control" will be announced soon on the Technology Price List, the link is http://www.oracle.com/corporate/pricing/technology-price-list.pdf Wait for the updates, some big suprises coming!!

You can also watch this new, interesting video -- The Enterprise Manager - Episode 7 : Cloud Management with Oracle Enterprise Manager 12c:

http://www.youtube.com/watch?v=M32RgzvUzco&feature=youtu.be

The EM 12c docs are available here: http://download.oracle.com/docs/cd/E24628_01/index.htm

(they’re not listed on the central documentation page. This link originates from the Readme)

You can also download the zip from: http://download.oracle.com/docs/cds/E24628_01.zip

Jenny Tsai-Smith (Oracle) has mentioned "We have also created over 60+ technical videos on how to put Oracle Enterprise Manager Cloud Control 12c to work, please encourage your subscribers to visit http://apex.oracle.com/pls/apex/f?p=44785:2:0:FORCE_QUERY::2,RIR,CIR:P2_SEARCH:EM12c%20Solution ". Thanks Jenny.

We have full DbaaS capability for databases on Exadata in this release of Oracle Enterprise Manager 12c Cloud Control. This will involve self-service provisioning, metering and chargeback. This will require licences of the Lifecycle Management Pack for database and the Cloud Management pack for database.

Regarding the public cloud, this is a great video on Oracle's Cloud Offering - http://www.youtube.com/watch?feature=player_embedded&v=cAra36lgLxc

Enterprise Manager is also used heavily in Oracle's public cloud.

Enjoy the new world of Enterprise Manager 12c Cloud Control.

Oracle Enterprise Manager NEW VERSION Launch Event on Monday

Join Oracle Enterprise Manager launch event on Monday 3rd October at 5 PM pacific time.

Live : http://bit.ly/qC1C6y Online : http://bit.ly/rdwW9O #OOW11

Applying database and CRS patches on Exadata

A friend asked: "Could you share what is the best practise for appling rolling patches

on database, grid infrastructure and Storage cells on EXADATA environment, we

are using half rack node in our environment?"

My reply:

You can have a look at Enterprise Manager's Provisioning and Patch Automation pack,

which can automate the application of rolling patchs on database and Grid Infrastructure.

It is worthwhile to spend a few extra dollars on Enterprise Manager packs to aid

with managment of complicated Exadata machines - and EM managment of Exadata is

going to get better and better! Get the customer to agree on the management

software cost (EM). It will definitely help them in the long run. EM will be

able to centrally manage Exadata machines in the organization, find performance

issues, patch and upgrade the database, etc.

In reality, CRS/RAC patching is used extensively by Enterprise Manager Grid Control customers for RAC databases. We have had good success stories in the real world. In Exadata, there are mostly 8 nodes in the RAC database so It makes sense to use the automated patch deployment procedures in the Provisioning and Patch automation pack of Grid Control when we can have rolling patch upgrades automatically handled by the deployment procedure. It is not rocket science.

Remember to apply the OMS cumulative patches first, of course. Core DBAs should remember that this is a way to ease their manual work and their late nights, especially if CPU/PSU patches are to be applied every three months (as per Oracle recommendations) to the RAC databases. Fundamentally, give it a whirl. If the pre-reqs pass, the patching will work. If not, you can either fix the issues or do the patching manually if you prefer.