Monday, June 12, 2017

Wednesday, May 24, 2017

New Blog "Clouds and Databases"

Dear Friends,

I have started to write on a brand new blog "Clouds and Databases" that I created recently.

On the new blog, I will be writing about different cloud technologies and databases. Please also join me there if interested in the cloud.

The blog address is and this is how it looks:



Saturday, May 6, 2017

Enterprise Manager Functionality without the Packs

A friend asked:
“I know we can use Oracle Enterprise Manager without the packs. However, is there any document that shows in detail what database monitoring and alerting functionality is provided by Enterprise Manager (12c version) without using any packs.”
The answer was:
This information is in the “Enterprise Manager Licensing Information” guide.   Chapter 10, “Base Enterprise Manager Functionality” outlines the list of features that are included with the base functionality of Oracle Enterprise Manager. 
For the database side of things, See the “Base Database Management  Features” section in this chapter. This includes things like the following (that you can do without any pack licenses in Enterprise Manager):
  • Set up and Schedule RMAN backups
  • Set up and manage Data Guard Standby databases
  • Use Data Pump to move data
  • Manage Oracle Automatic Storage Management (ASM) and Clusterware
  • Use some Advisors such as Segment Advisor and Memory Advisor
  • Manage critical errors via Support Workbench
  • Manage database objects such as tables, indexes, views, materialized views etc.
  • Manage optimizer statistics and SQL plans
  • Set up Resource Manager for the database
  • Manage database users, roles, profiles etc. 
  • Manage control files, datafiles, tablespaces, log files etc.
  • View SQL execution history, execute SQL statements
  • Use Scheduler Central to manage jobs maintained by the database as well as Enterprise Manager
  • Get My Oracle Support (MOS) Critical Patch Recommendations
  • Perform PDB operations in Database 12c with some caveats for the free stuff, as described in an earlier blog entry here.
The link for the full set of base database features is here. Thanks for your question, and hope you have gained an understanding of what can be done as part of the base functionality.

Saturday, January 7, 2017

Article series "Consolidation Planning for the Cloud"

This is the 6th installment of my article series "Consolidation Planning for the Cloud":

  This series is an extract from the first chapter of my Oracle Press book on the Oracle Database Cloud. The Book link is at the end of the article.

Thursday, December 15, 2016

Oracle's Database as a Service in action


Have a look at Oracle's Database as a Service in action:

This is a preview lecture of the Udemy Course: Oracle Private Database Cloud. 

The full Udemy course is available on 


Porus Homi Havewala.

Friday, October 21, 2016

Reasons to upgrade to Enterprise Manager 13.2

By Sudip Datta-Oracle
Before, during and after the Open World, I have received numerous queries on the release of Enterprise Manager 13.2. This is an important release for Enterprise Manager 12c customers whose Premier Support expires this month and who traditionally wait for the release 2 of any product before upgrading, and for customers who have already upgraded to 13c, but want their critical issues addressed. And there are specific capabilities that are sought for by a specific set of customers, for example, security-sensitive customers have been asking for TLS 1.2 support. 
Se here we are, announcing the release of Enterprise Manager 13.2. The primary focus of this release was around security, scalability and availability of the platform. Some long pending requirements have been addressed in the release. First, comes the support for TLS1.2. The communication between the agent and OMS, the agent and the targets, and in case of target types such as database, between the OMS and the targets are now secure with TLS1.2 protocol. Second, Enterprise Manager 13.2 supports IPv6 addresses, allowing targets to be managed on IPv6-enabled hosts. Lastly, for ensuring higher availability of the Enterprise Manager platform, the "Always On" Monitoring feature has now been certified to run on a different host than the OMS.
Enterprise Manager 13.2 continues to improve upon the 13c theme of having a unified hardware and software management. The highlights in this area include better engineered systems and infrastructure management with the support for Exadata X6-2, X6-8 and Oracle VM 3.4 (and therefore the latest PCA models). Couple of other improvements in infrastructure management worth mentioning, are seamless ASR integration for hardware telemetry and Solaris Compliance checks.
Management of database and middleware platforms continues to evolve in this release. The fleet-maintenance feature, first introduced in 12cR5, can now support a wider range of database configurations, making patching really simple for cloud-scale environments. For Fusion Middleware, Enterprise Manager now supports Weblogic 12.2.x, enabling customers to enjoy the benefits of multitenancy for their Weblogic platform. Some of the benefits can also be enjoyed in a hybrid environment, as on-prem targets as well as DBCS, JCS and SOACS targets can be managed by a single Enterprise Manager instance.
Visit the OTN page to get more information on Enterprise Manager 13c.

By Sudip Datta, Oracle.

Wednesday, September 21, 2016

Oracle Open World

My latest Oracle Press "Oracle Database Cloud Cookbook" being sold at Oracle Open World this week. Grab a copy.


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