Wednesday, August 24, 2016

Monday, August 8, 2016

Oracle Database Cloud Cookbook published


If you want to know more about the Oracle Private/Hybrid Database Cloud using
the latest Enterprise Manager Cloud Control 13c, then this is the book.

Just published on August 5th 2016, and achieved Amazon Best Sellers Rank: #11 in all Oracle Books.  Read more about the book in my LinkediIn Pulse post:

This book will also be available in Oracle Open World.


Porus Homi Havewala
(Oracle Certified Master)
(Oracle ACE Director Alumni)

Wednesday, June 8, 2016

My New Udemy course "Oracle Private Database Cloud"


Happy to announce that I have created and published my very first Udemy course on the "Oracle Private Database cloud" as an Udemy Premium Instructor. In this course, I am explaining the set up of the private database cloud and actually demo'ing the different "database/snapclone/schema/pdb-as-a-service" capabilties in action. I hope you find this course beneficial.

About This Course:

Published 6/2016 English

Course Description:

This course will introduce you to the concepts of the Oracle Private Database cloud. You will be taught techniques for building, configuring, and managing a private database cloud with Oracle Enterprise Manager 13c Cloud Control. Learn best practices for a wide variety of different approaches--Database as a Service, Snap Clone as a Service, Schema as a Service, and Pluggable Database as a Service. The course also explains how to use the Oracle Cloud REST API for performing Database as a Service.

You will gain a reasonable understanding of how to architect, configure, and manage every component in a private database cloud lifecycle. Learn from an Oracle Certified Master, previous Oracle ACE Director, and experienced computing writer (three books published on Oracle Enterprise Manager).

What are the requirements? 
  • Oracle Enterprise Manager Cloud Control 13c installed on a sandbox server - Enterprise Manager Cloud Control is the main driving engine for the Oracle private database cloud
  • Oracle Database Enteprise Edition Homes installed for 11g and 12c
  • Oracle Databases created - 11g for SChaaS and 12c container database for PDBaaS
  • Alternatively, you can follow the lectures without an actual install of the software

What are you going to get from this course?
  • Understand the concepts and requirements of the Oracle Private Database Cloud
  • Learn techniques and best practices for building, configuring, and managing a private database cloud with Oracle Enterprise Manager 13c Cloud Control
  • Set up the foundation of the Oracle Private Database Cloud - including the Enterprise Manager Software Library, Enterprise Manager Self update, User Privileges and Roles for self-service, and the PaaS Infrastructure Zones
  • Set up and Configure Database as a Service and Snap Clone as a Service - Database Pools, Quotas, Database Profiles, Database sizes, Service Templates, Request Settings
  • See Database as a Service in action using the Enterprise Manager Self-Service console
  • See Snap Clone as a Service in action using the Enterprise Manager Self-Service console
  • Set up and Configure Schema as a Service - Schema Pools, Quotas, Schema Profiles, Service Templates, Request Settings
  • See Schema as a Service in action using the Enterprise Manager Self-Service console
  • Set up and Configure PDB as a Service - PDB Pools, Quotas, PDB Profiles, Service Templates, Request Settings
  • See PDB as a Service in action using the Enterprise Manager Self-Service console
  • Understand how to use the Cloud REST API for performing Database as a Service, using the REST client in Google Chrome, and why you would use the Cloud REST API instead of the Enterprise Manager Self Service Console
  • Understand the next course of action and further reading material

What is the target audience?
  • Students who want to get a basic understanding of the setup, configuration and actual use of the capabilities of the Oracle Private Database Cloud
  • Students who want to understand the use of Oracle Enterprise Manager for Database as a Service, Snap clone as a Service, Schema as a Service and PDB as a Service
  • Students who want to use the Cloud REST API for self-service in their own customized orchestration engine
  • Students should have a basic understanding of Oracle Database install/administration concepts, and Oracle Enterprise Manager adminstrator concepts

I hope this course is beneficial to you and your careers. Please do recommend to your friends and colleagues as well. All the Best.


Porus Homi Havewala (OCM).

Friday, March 25, 2016

Announcing my new Oracle Database Cloud Cookbook from Oracle Press

Dear Friends,

I am pleased to announce my new book "Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control" to be published by Oracle Press, and is now available as a pre-order from Amazon. The Amazon link is:

This practical Oracle Press guide Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control teaches cutting-edge techniques for building, configuring, and managing a secure private database cloud with Oracle Enterprise Manager 13c. This hands-on volume lays out ready-to-deploy roadmaps for the design and maintenance of high-performance private database clouds using Oracle Enterprise Manager 13c. Learn best practices for a wide variety of different approaches--Database as a Service, Snap Clone as a Service, Schema as a Service, and Pluggable Database as a Service along with setting up chargeback for all of these. The book also explains how to use the RESTful API for performing DBaaS, SCHaaS and PDBaaS, and gives step by step instructions to set up the Oracle Database Hybrid Cloud using the Enterprise Manager Hybrid Gateway to connect to the Oracle Public Database Cloud.

Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control thoroughly explains how to architect, configure, and manage every component in a private/hybrid database cloud lifecycle. You will get an insider's solutions for securing your cloud-based infrastructure, generating reliable RMAN backups, and protecting your mission-critical enterprise information using Oracle Data Guard. This comprehensive volume from Oracle Press features detailed, step-by-step instructions with multiple screen shots and diagrams that illustrate each technique along the way.

  • Real-world examples and case studies illustrate applications in various industries
  • Offers essential skills for cloud administrators and DBAs
  • Author is an Oracle Certified Master, previous Oracle ACE director, and experienced computing writer
Table of Contents:
Ch. 1: Consolidation Planning for the Cloud
Ch. 2: Database as a Service
Ch. 3: Schema as a Service
Ch. 4: Pluggable Database as a Service
Ch. 5: Hybrid Database Cloud
Ch. 6: Using the RESTful API
Ch. 7: Managing Database Backups
Ch. 8: Managing Standby Databases

(Mockup of my new book's cover. This is a draft version of the cover.)

The publisher has confirmed the publication date to be August 2016.

Hope all my readers will enjoy this book which I have written in easy to understand English. Please recommend to your friends as well.


Porus Homi Havewala.

Sunday, December 20, 2015

Oracle Enterprise Manager 13c: New and Exciting Features

Oracle Enterprise Manager 13c: New and Exciting Features

Oracle Enterprise Manager 13c: What’s New
We just announced the release of Oracle Enterprise Manager 13c. Well, if the number 13 makes you jittery, rest assured that this new release is an improvement on Oracle Enterprise Manager 12c which has witnessed unprecedented adoption among customers worldwide. Oracle Enterprise Manager 12c rests on the key themes of enterprise grade management, stack management and cloud lifecycle management. The 13c version simply bolsters those pillars.

Our first goal in this release has been to make monitoring cloud scale and resilient. Oracle Enterprise Manager today is the nerve center of IT operations among thousands of enterprises, our very own public cloud operations being one among them. Millions of assets in Oracle’s SaaS and PaaS public cloud operations are managed by Enterprise Manager round the clock, which requires that Oracle Cloud’s own Oracle Enterprise Manager instance stays up and running during unplanned and planned downtime windows. Oracle Enterprise Manager 13c therefore introduces “always on” monitoring, where a small companion monitoring application continues to receive critical alerts from the agents out-of-band while the management server is down. One can start the application, take Oracle Enterprise Manager down for patching and continue to be alerted on critical events. Speaking of planned downtime windows, another exciting feature being introduced is “notification blackouts”, which lets administrators monitor their targets during their maintenance windows, while notifications from critical alerts are still turned off.
When it comes to stack management, the BIG news for our customers is the unification of hardware and software management. Ever since Oracle acquired Sun, we have promised a converged systems management, but current customers have been managing hardware through a separate tool called Ops Center. In Oracle Enterprise Manager 13c, some of the important hardware management features have been assimilated into the Cloud Control product. This not only benefits platform administrators in that they can now drill down into the infrastructure problems easily, this also benefits system and storage administrators because they can enjoy the scalability, availability and security framework features of Cloud Control. As an example, critical incidents in the hardware layer can now be published to a 3rd party ticketing system using the connector framework, something that Oracle hardware customers have asked for a long time. As part 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, including the ability to patch a complete Exadata and Exalytics stack. 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). Another enhancement that should thrill Engineered Systems customers is the integration of Exacheck into the Compliance framework of Enterprise Manager; this would let them generate automated notifications and reports for any violation in their Exadata configurations.

One request we always received from our database customers was to enable fine grain access control. Most organizations have multiple personas (Central DBAs, application DBAs, Developers, etc) and would like segregation of duties among these personas. For example, a Developer may be allowed to tune the application but not patch the underlying database. Oracle Enterprise Manager 13c enables fine grained privileges for controlling access to specific features.
In terms of cloud management, the release focuses on three key aspects: the ability to perform database consolidation planning for various scenarios, the ability to manage configuration drifts at scale and improved data lifecycle management across production and test instances.
The new Consolidation Workbench provides an end-to-end workflow that provides three distinct steps:
· What-if analysis on various consolidation scenarios: commodity to engineered systems, non-multitenant to multitenant databases and on-prem to Oracle Cloud.
· The actual enactment of the consolidation by integrating with the provisioning features
· Post-consolidation testing using the SQL Performance Analyzer
The new configuration drift management feature enables administrators to proactively spot the “needle in the haystack” among the hundreds and thousands of members that can constitute a cloud or even across multiple clouds. And last but not the least, Snap Clone customers would be benefited by the ability to keep the test databases in sync with their production.
It would be an incomplete disclosure to limit Oracle Enterprise Manager 13c’s capabilities to the above features. There are many more new features (see the full list) as well as hundreds of enhancements introduced into the existing features. I am certain that IT administrators and consultants would be looking for a top-12 feature list. For them, here’s the summary:
1. Gold image based agent lifecycle management (view screenwatch)
2. “Always on” monitoring (view screenwatch)
3. Notification blackouts for managing target downtime windows (view screenwatch)
4. Cloud-scale configuration drift management
5. Hardware and infrastructure management  (view screenwatch)
6. Engineered Systems patching
7. Exadata and Exalogic-Nimbula VM provisioning
8. Exacheck integration into the compliance framework
9. Flexible access control for database management (view screenwatch)
10. Database Consolidation workbench (view screenwatch)
11. Continuous data refresh between production and test databases
12. Unification of Middleware Consoles into Enterprise Manager 13(view screenwatch)
To summarize, Enterprise Manager 13c reinforces its ability to manage along two dimensions: vertically across the stack, and horizontally, within and across clouds. So, number 13 indeed sounds lucky for Enterprise Manager customers, right?

Tuesday, December 1, 2015

How to check for Database Option and Management Pack usage

How do you check for Database Option and Management Pack usage? There are two scripts available from Oracle for this purpose. They are :
1. option_usage.sql
This script outputs database option usage and management pack usage by a database target
2.  used_options_details.sql
This script will output the features used by each database option and management pack.
You can get these two scripts from Document ID 1317265.1 in My Oracle Support. The direct link for the document is here.
These scripts can be executed manually on database targets, or optionally they can be run on all targets via Enterprise Manager – which will be more convenient.
Note that the output of these scripts is for information purposes only. You need to talk to the Oracle Sales representative in your location to find out which options and packs your company is licensed for.
This is an example of running the script in Oracle SQL Developer on a particular database. In this database, only the Tuning pack is in use. Although this may be technically valid (the Diagnostics pack may never have been used), you still require the pre-requisite license of the Diagnostics pack to use the Tuning pack.
In the above case, running the second script tells you that the feature being used as part of the Tuning Pack is the “Automatic SQL Tuning Advisor”, and tells you the number of detected uses and the last usage date.     
This blog post was originally published at this link.

Thursday, October 15, 2015

Managing Oracle Database 12c with Enterprise Manager – Part XXI

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at the tablespace level Heat Map in Database 12c, showing which objects were accessed with a full table scan. We now move to the Policy tab.
Information about the Compression and Storage policies is displayed. There are 2 storage policies present. Only one object has a policy enabled.  Drill down to the enabled policy.
The object displayed is the table HR.EMPLOYEES. This object has the policy enabled. Click ok to go back to the policy tab. On the policy tab, select the policy and click on “Execute Policy”.
In the window that appears, confirm by clicking on Execute. The policy will be executed. You can also see the PL/SQL that you would have to write to perform this simple action, if it were not for Enterprise Manager.
The evaluation job is submitted. You can go back to the evaluations tab, select the policy, and click on execution history.
This history shows that the job has been created.
On the main Policy tab, there is another button called “Policy Details”. This shows further details of the policy.
Finally, there is the button “Default Execution Settings” on the main Policy tab. This displays information about when and how the policy will be executed.
This has been a quick introduction to what is available in Enterprise Manager 12c for Information Lifecycle Management (ILM) in Database 12c. For more information on Managing the ILM Heat Map and ADO with Enterprise Manager, please see the documentation here.
This blog post was originally published at this link.


Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive