Thursday, December 14, 2017

FREE, Trial access to Oracle Licensing training portal​

Here's your final chance for 2017 to get access to the FREE, TRIAL training module on ORACLE LICENSING. My friend Sibaji Dey Choudhury has created this unique, comprehensive training portal on Oracle License Management, with an objective towards understanding Oracle's complex licensing rules, optimizing costs and avoiding non-compliance.

So, how do you get the Free, Trial access?

Step 1: Sign up on (takes 1 minute)
Step 2: Request Free, trial access on the Contact Us page

I sincerely hope this will benefit all our readers and their contacts.

Best regards,

Porus Homi Havewala,
Oracle Certified Master.

Wednesday, November 22, 2017

FREE customised workshops on "Oracle License Management"


My friend Sibaji Dey Choudhury is offering customised workshops on "Oracle License Management" for members of this group. The workshops are FREE, and are designed to highlight potential Oracle licensing issues that your organisation may be facing. Each workshop will be on a 1-on-1 basis, and will last around 3 to 4 hours depending on the size of the Oracle license estate.

A bit of introduction: Sibaji Dey Choudhury is an experienced Oracle Licensing Specialist with 13 years of dedicated experience on "Oracle License Management" across 330 customers worldwide. His services are fully independent, as he does not have any partnership with Oracle, does not re-sell Oracle licenses and also does not recommend any Oracle re-sellers.

You can reach Sibaji by email: or by phone: +44 776 017 1216 (UK) and his company website is

This is your opportunity to get all your Oracle licensing issues sorted and queries answered!

Best regards,

Porus Homi Havewala,
Oracle Certified Master.

Wednesday, November 15, 2017

Author Signed Copy of my Oracle Private Database Cloud cookbook


My Oracle Press book "Oracle Private Database Cloud cookbook" looks at all the private database/ schema/ PDB services in detail, and shows you how to set up Chargeback, and 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.

A few Author signed printed copies are now available.  If interested in one of these special copies, contact me directly on and I will inform you of the postage charges to anywhere in the world. The book cost is 60 USD and postage will differ as per the country.

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

The book has been reviewed by popular Oracle ACE Director Gokhan Atil, he said "I can say that I really liked the book. It’s really easy to read and all topics are explained by detailed samples. Porus Havewala has a deep knowledge and experience about the subject so his instructions are very clear. It’s like following a workshop about building Database as a Services architecture on Cloud."

The book has also been reviewed by Rob Zoeteweij who is an Oracle ACE, Enterprise Manager expert, specialist and trainer. He also has his own Linkedin group on Enterprise Manager. His review says "When you are looking for a book on a thorough guidance through the setup of DB as a Service and Schema as a Service and working with the Self Service portal of Oracle Enterprise Manager release 13c Cloud Control, stop looking you found it. "


Porus Homi Havewala
Oracle Certified Master.

Wednesday, November 1, 2017

Gavin Soorma to conduct new Oracle 12c Data Guard/Backup and Recovery Workshop

Dear Friends,

We are very pleased to announce the  upcoming new Oracle 12c Data Guard/Backup and Recovery Workshop. This will be conducted by my friend Gavin Soorma who is an Oracle ACE Director, Oracle Certified Master, and a highly experienced Oracle technology instructor.

DBAs, protect your company data and also more importantly protect your job!

Learn how to configure an Oracle 12c Data Guard environment and perform switchovers and failovers in an Active Data Guard environment with confidence.

Learn advanced RMAN Backup and Recovery techniques and best practices and also practice recovery from a number of real-life simulated failure scenarios.

The cost of the 20+ hour online course is only $549.00 and also includes a lifetime membership to Oracle DBA Tips and Techniques website repository.

The course will include main  topics which would require attending two Oracle University courses which would cost over $7000!

The course is being offered both on weekends (Saturday US AM) as well on weekdays (Mon -Fri US PM).

Kindly use the registration links provided below to register for the required batch.


Registration URL:

(The weekday sessions start Mon, Nov 13, 2017 US PM (or Tues in other time zones) and meet 10 times)


Registration URL:

(The weekend sessions start Sat, Nov 11, 2017 US AM (or Sun in other time zones) and meet 5 times, with longer duration sessions)


Porus Homi Havewala
Oracle Certified Master.

Wednesday, October 25, 2017

Free trial access of the Oracle Licensing training course


This is a message from my friend and Oracle licensing expert Sibaji Dey Choudhury.

Oracle Licensing has been a global challenge for a number of years now, and a lack of deep understanding on Oracle Licensing has derived $$ Millions during audits from unaware Oracle customers. To help tackle this issue 'Licensing Circle' was built to train and certify Oracle professionals on a comprehensive, portal-based knowledge on Oracle License Management.

The Oracle Senior DBA group on Linkedin has negotiated with 'Licensing Circle' to provide for the members of the Oracle Senior DBA Group a Free, trial access of the Oracle Licensing training course. This offer is also open to your own Linkedin contacts who may not be a member of the group.

So, how do you get the Free, trial access of 'Licensing Circle'?

Step 1: Sign up on (takes 1 minute)
Step 2: Request Free, trial access on the Contact Us page. Mention the Oracle Senior DBA group.

We sincerely hope this will benefit all our group members and their contacts.

Best regards,

Porus Homi Havewala,
Oracle Certified Master.

Wednesday, October 18, 2017

Gavin Soorma Implementation Workshop: GoldenGate 12c

From fellow Oracle Certified Master Gavin Soorma:

Register for the new Oracle GoldenGate 12c Release 3 online training course from Gavin and learn all about the exciting new features in Oracle 12.3 OGG like the Microservices Architecture, Parallel Replicats, Automatic Conflict Resolution and more as well as fast track yourself towards acquiring the skills to implement and maintain an Oracle 12c GoldenGate replication environment. Great for cloud database migrations as well.

Course Duration: 20+ hours
Course Fee: 549.00 USD including a lifetime subscription to Gavin's "Oracle DBA Tips & Techniques" website
Hands-on Lab Exercises with recordings provided of every session

Course Topics and Objectives:

• Learn about the new Oracle GoldenGate 12c Release 3 microservices architecture, topologies and components
• Installation of Oracle GoldenGate 12.3 Classic as well as Microservices Architecture
• Configuring the Manager process
• Prepare the Oracle database for GoldenGate replication
• Create Classic/Integrated extracts and replicat process groups
• Create Co-Ordinated /Parallel replicats
• Configure and manage DDL replication
• Configuring security and encryption of trail files and credentials in GoldenGate
• Column mapping, Data filtering and transformation
• Using the Logdump utility to examine trail files
• Using OBEY files, macros and tokens
• Handling errors and exceptions in GoldenGate
• Configuring Automatic Heartbeat Tables
• Monitoring Lag
• Configuring Bi-Directional replication, Conflict Detection and Resolution, and new 12c Release 3 automatic conflict resolution

Both weekdays as well as weekend batches are available for this training course.

Use the links below to register for the training.

From Mon, Oct 23, 2017 and meets 10 times

From Sun, Oct 29, 2017 and meets 5 times

Wednesday, October 11, 2017

New Oracle Training from OCM Gavin Soorma

Dear Friends,

Fellow Oracle Certified Master Gavin Soorma has now created some exciting new Oracle training courses.  On his behalf, we are pleased to announce the following forthcoming online training courses:

<> Oracle Database 12c Release 1 and Release 2 New Features
<> Oracle 12c Data Guard and Backup and Recovery
<> Oracle Performance Tuning Workshop
<> Exadata essentials for Oracle DBA’s
<> Oracle GoldenGate 12c Release 3 Implementation Workshop
<> Oracle GoldenGate 12c Release 3 Advanced Workshop
<> Oracle 12c Clusterware, RAC and ASM
<> SQL Server 2016 for Oracle DBA’s

All the above courses are between 16 to 20 hours in duration (4 hours a week) and are each priced at only 499.00 USD including a free lifetime membership to his Oracle DBA Tips and Techniques website.

Recordings will be made available for each session and every course will carry several hands-on lab exercise modules for which remote support will be provided as well.

Kindly register your interest for any of the training courses listed via the link below:


Porus Homi Havewala
Oracle Certified Master.

Wednesday, October 4, 2017

Aussie Database Performance Tuning software "Ellarose" from Riyosu

My friend and fellow Oracle OCP Nathan McAteer is providing all readers with an opportunity to purchase the latest version of Riyosu’s Aussie database performance tuning software "Ellarose" at a discounted rate. Ellarose, named after his daughter by the proud father, is used by some of Australia’s largest financial institutions on a daily basis. In fact the majority of articles posted by Nathan on the Riyosu website are real world scenarios from one of the top 4 Australian banks.

The product is extremely versatile and covers a range of Oracle version and editions. Both Standard and Enterprise edition are supported from 10g. Backward compatibility from 9i downwards is cleverly done by allowing the user to tailor the underlying scripts which query the database performance metrics. Access to the underlying scripts is a huge bonus and rarely do vendors share the intelligence of their product like this. It means you also get access to hundreds of great performance scripts. Not licensed to use AWR? Not a problem because it also works on STATSPACK. There are a whole series of articles from Nathan on the Riyosu web site about the database performance tuning that can be achieved by Ellarose.

The Ellarose product itself can be downloaded through the Riyosu online store at for an annual subscription of $349 USD (further discount code provided below). Once you have your subscription you can use it on *any* number of databases within your organisation. Note that similar products on the market would cost ten times as much.

For a further 10% discount, enter the special coupon code of "SDBA1".

Note: You can apply your discount code after clicking on the “BUY NOW” button.


Porus Homi Havewala,

Oracle Certified Master.

Wednesday, September 27, 2017

Optimize Oracle response times with Cary Millsap using Method R

Came across this interesting logical method of Oracle Database Tuning called as Method R, created by Cary Millsap (pictured), a performance tuning expert and an Oracle veteran. If you want to learn more about Method R, you can attend the webinar below. The following information is from Cintra where Cary is currently a Vice President.


  • Date:            Thursday 26th October 2017
  • Time:            11:00 (EDT) and 16:00 (BST)
  • Duration:     30 minutes + 15 minutes Q&A
  • Location:     Online webinar

Your customers’ experience with the speed of your applications is an important differentiator. As you move to the cloud, delivering excellent performance experiences becomes even more challenging.

Traditional Oracle performance management isn’t enough; our revolutionary approach enables you to understand exactly how your users experience your systems.

In this webinar, Cintra practice leader Kyle Smith will discuss Method R with Cary Millsap. Join us to learn more about this extraordinary advance in Oracle performance optimization:

  • What does “faster systems” really mean?
  • Why is it so hard to get there?
  • What is Method R? How is it different? Why did we create it?
  • How does the process work?
  • How does moving to the cloud affect performance management?

If you’re unable to make the time below, please register and we’ll send you the recording afterwards.

Please register on 

Recordings of Previous Webinars:

17th August Method R webinar:

27th September Method R webinar:

Product demonstration recording:


Wednesday, September 20, 2017

EXADATA Essentials For Oracle DBAs: Hands-on 4-Week Saturday Workshop by Gavin Soorma (OCM)

My friend and fellow Oracle Certified Master Gavin Soorma, after his recent popular Oracle RAC workshop (over 100 registrants) is now offering a new hands-on 4-week Saturday workshop on "Exadata Essentials For Oracle DBA’s", so you can fast track your path towards becoming an Oracle Database Machine (DMA) administrator.

In this new workshop, instructions will be provided by Gavin on how to install and configure an Exadata Storage Server on your own individual VirtualBox platform.

You will learn about the architecture, key features and capabilities of Exadata Database Machine as well as how to administer, monitor and manage the Exadata Storage Server using the CELLCLI command line interface. Attendees will learn how to use CELLCLI to create and manage celldisks, grid disks and flash disks as well as how to configure alerts and monitoring of storage cells on their own individual Exadata Storage Server environments.

The 4-week online workshop commencing on Saturday, 30th September will include hands-on lab exercises for each module (for which remote support will be provided) and cover a wide variety of topics (the full list can be seen in the registration URL given below). Recordings of sessions  will be made available for future reference.

The course curriculum is based on topics in the Exadata Database Machine: 12c Administration Workshop course offered by Oracle University, the latter  costs over US$5000 whereas Gavin's workshop is only $499.00 USD which is about 1/10th of the cost.

Kindly use the link below to register and pay for the Exadata Essentials for Oracle DBA’s training course.

Registration URL:

For any related queries or clarifications kindly drop an email to


Porus Homi Havewala.

Sunday, September 17, 2017

Oracle preps autonomous database at OpenWorld

Oracle preps autonomous database at OpenWorld

IMHO The new database version will probably use the Oracle Management Cloud (OMC) to monitor and tune, the OMC has machine learning using big data analytics to aid performance tuning. Since version 10g, the Oracle DB has had self-tuning capabilities, i.e. auto application of SQL profiles using the Tuning pack license. Everything else was done by the DBA, perhaps with advice gained from the Tuning Advisor, but the DBA had to make the final call. Probably the self-tuning has been carried further in the coming version with expertise from machine learning. Regarding AWS databases, I would agree that the AWS capability of performance insights is only at its starting stage so databases on AWS Aurora cant really be compared to what Oracle will offer in this regard.

Wednesday, September 13, 2017

No-Win, No-Fee Oracle Licensing Review Offer for your Oracle usage

Dear Friends,

As we all know, Oracle Licensing is a complex subject and a lack of its complete understanding can attract millions of dollars in contractual non-compliance during an official audit. Non-compliance on Oracle Licensing can be due to several reasons, including vague rules and inaccurate analysis. If your Oracle licensing is not fully managed or optimised, then you also risk over-paying for support costs that could have been avoided. Over-Licensing or Under-Licensing can both bring large financial exposure for an Oracle end-user organisation. 

Exclusively for the members/friends of our 'Oracle Senior DBA' group on Linkedin, we have negotiated with 'Konnagar Limited' >> << to help you reach a safe harbor with compliance on Oracle licensing. Konnagar Limited won the Gold Award from UK-OUG for 'Independent Services', and is run by Sibaji Dey Choudhury - an ex-Oracle License Auditor with 12+ years of Oracle licensing experience across 300+ customers. 

How is this a good proposition for you? Sibaji will run a complimentary Oracle License Review, exclusively for the members/friends of the group (you need not be a member, just mention the group). If any contractual non-compliance (and therefore, commercial exposure) is identified, only then you pay the fee for the engagement. If no non-compliance is identified, then you DO NOT pay anything. Simple! 

Please note that Konnagar Limited is independent of any Oracle partnership and also does not resell Oracle licenses (or recommend resellers), and therefore has no conflict of interest. The only objective is to help you uncover non-compliance arising out of mismanagement of Oracle Licensing. 

Please reach out to to register your interest. This offer is on a 'No-Win, No-Fee' basis exclusively for the members and/or friends of the 'Oracle Senior DBA' group, so please mention the group name in your email to them even if you are not a member.

Best regards, 

Porus Homi Havewala, 
Oracle Certified Master.

Sunday, August 27, 2017

Hands-on 5 week Sunday workshop for Oracle 12c RAC, ASM and Clusterware

My friend and fellow Oracle Certified Master Gavin Soorma is offering this five week online workshop on Sundays, which looks very interesting for people seeking to learn about these advanced Oracle technologies. 

This online training workshop will help you build your own personal two-node Oracle 12c Release 2 Real Application Cluster environment and learn in-depth about Oracle 12c RAC, ASM and Clusterware Administration.

The five week, 20 hour online workshop commencing on Sunday, September 10th will include hands-on lab exercises for each module (for which remote support will be provided) and cover a wide variety of topics including :

<> How to install and upgrade Oracle 12c (R1 and R2) Grid Infrastructure 
<> How to administer and manage Oracle Clusterware including Flex Clusters 
<> How to create and manage policy and admin-managed RAC databases 
<> ASM architecture, Diskgroups, ACFS, Flex ASM 
<> Applying a patch to Grid Infrastructure and Database Home
..... and more!

This course will cover the main topics from three separate Oracle University Courses (12c RAC Administration, 12c ASM Administration and 12c Clusterware Administration).

The cost of the training is 599.00 USD which would otherwise have costed close to 10,000 dollars for attending all three official Oracle University trainings! There is a further ten percent discount if you use the discount code mentioned below.

Kindly register for the training course via the URL mentioned below.

Registration URL:

On this form, type the discount code "OracleSeniorDBAGroup" in the Discount Code field for a further special TEN PERCENT DISCOUNT on the 599 USD cost of the course.

Porus Homi Havewala.

Tuesday, July 25, 2017

Licensing|Circle - Oracle Licensing Comprehensive training course (12 modules)

We finally can release the pre-launch discount code for Licensing|Circle - the comprehensive training course on Oracle Licensing. The discount code for the full course is "OracleSeniorDBA10" and this code is valid until 15-Aug-2017. The full course with 12 modules is here:

As mentioned earlier, Oracle Licensing can be a complex subject, and a lack of its understanding for Oracle professionals (including DBAs) could almost certainly lead to substantial financial risk exposure due to contractual non-compliance. To help avoid such scenarios, training on licensing is essential. Licensing|Circle is globally the first and only comprehensive & online training, reference, assessment and certification platform on Oracle License Management.

I hope you have enjoyed the free module of Licensing|Circle. If not, you can still request FREE ACCESS to the first module ('Oracle Licensing Overview') of the training by following the instructions in the link below.

If you need any support, you can write to

Best Regards,

Porus Homi Havewala

Friday, July 14, 2017

Thursday, July 13, 2017

Comprehensive Training on Oracle License Management

With the current "Journey to Cloud" scenarios, one of the main reasons cited is Oracle licensing.

Oracle Licensing can be a complex subject, and a lack of its understanding for Oracle professionals (including DBAs) could almost certainly lead to substantial financial risk exposure due to contractual non-compliance. Depending on the size and complexity of the Oracle license estate, the commercial value of the non-compliance could run into $$ Millions during an official audit.

To combat this, we now have Licensing|Circle, which is globally the first and only comprehensive & online training, reference, assessment and certification platform on Oracle License Management.

You can now request free access to the first module ('Oracle Licensing Overview') of the training by following the instructions in the link below.

After a few days, we will announce a discount code for the full course.

I am sure this will be a huge value add for all members. I suggest you request access to the free module initially for a head start into the course. If you need any support, you can write to

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.


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