Tuesday, February 27, 2018

From Gavin Soorma: Implementation Online Workshop Oracle GoldenGate 12c Release 3 (with Oracle 12c Release 2 RAC/ASM)

Based on popular demand, my friend Gavin Soorma and fellow Oracle Certified Master, is offering this brand new online training course combining Oracle GoldenGate with Oracle Clusterware and RAC/ASM. This course is the first of its kind and spaces are limited!

Learn how to install and configure your own two node Oracle 12c Release 2 RAC cluster environment and deploy a cluster-based highly available Oracle GoldenGate 12c Release 3 environment. Book your seat for the course by sending an email with your particulars to Gavin at his email address prosolutions@gavinsoorma.com , and registration details will follow shortly.

Course Duration: 24 hours (6 weeks)
Commencing: Sunday 11th March 10.00 AM US EST
Course Fee: 699.00 USD

Hands-on Lab Exercises with recordings provided of every session

Course Topics and Objectives:
Install and Configure Oracle 12c Release 2 Grid Infrastructure, ASM and Clusterware
Create an Oracle 12c Release 2 RAC database
Configure High Availability for Oracle GoldenGate using Grid Infrastructure Agent (XAG)
Simulate GoldenGate processing recovery from cluster node failure
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

Tuesday, January 23, 2018

Oracle Licensing bootcamp training in your city

Dear Friends, 

In the year 2018, our friend Sibaji Dey Choudhury is conducting 2-day "comprehensive" bootcamp trainings on Oracle Licensing in several major cities across the world. At the end of the intensive bootcamp training, you have the option of an assessment at no extra cost to get an "Oracle Licensing Maestro" certificate. 

Sibaji has 13 years of experience on "Oracle Licensing" training and consulting services, across 300+ customers worldwide.

If you are are interested in an "Oracle Licensing" bootcamp training in your city, please register your interest through the Contact page of www.LicensingCircle.com . Kindly mention your full name, email id and your city. 

Best regards, 
Porus Homi Havewala
Oracle Certified Master.

Tuesday, January 9, 2018


Dear Friends,

In 2018, we are very pleased to announce the upcoming new Oracle 12c Release 2 Performance Tuning 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.

Oracle 12c Release 2 Performance Tuning Workshop:
Course Duration: 20+ hours. This webinar meets 5 times.

Mon, Jan 22, 2018 12:00 AM - 4:00 AM AEST
Mon, Jan 29, 2018 12:00 AM - 4:00 AM AEST
Mon, Feb 5, 2018 12:00 AM - 4:00 AM AEST
Mon, Feb 12, 2018 12:00 AM - 4:00 AM AEST
Mon, Feb 19, 2018 12:00 AM - 4:00 AM AEST

Course Fee: 599.00 USD including a lifetime subscription to Oracle DBA Tips & Techniques website

Hands-on Lab Exercises with recordings provided of every session

Course Topics and Objectives:

Tuning Methodology
Using Automatic Workload Repository and AWR Baselines
Using Active Session History (ASH) Analytics
Using and interpreting ADDM including Compare Periods ADDM
Real-time ADDM and Emergency Monitoring
Tuning the Buffer Cache
Tuning the Shared Pool
Tuning sort operations and PGA
Managing optimizer plan stability
Adaptive Plans, Re-optimization and SQL Directives
SQL Outlines and SQL Plan Baselines
SQL Profiles
 Gathering and managing optimizer statistics
Gathering and managing histograms
Bind Variables, Cursor Sharing, and Optimizer Hints
Using SQL Performance Analyzer
Tuning using wait events
Optimizing performance by partitioning data
Indexes, Access Paths, and Join Operations
Tracing SQL statements
Automatic SQL Tuning
Generating and Displaying Execution Plans
SQL Monitoring
Creating and managing the Result Cache
….. and more!

Registration URL:


 Hope you enjoy the workshop.


Porus Homi Havewala
Oracle Certified Master,
Oracle ACE Director Alumnus.

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 www.LicensingCircle.com (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: sibaji@konnagar.com or by phone: +44 776 017 1216 (UK) and his company website is https://www.konnagar.com/

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 phhbooks@gmail.com 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.


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