Win A Free Copy of Packt’s Oracle Database XE 11gR2 Jump Start Guide eBook


I am pleased to announce that Packt Publishing is organizing a giveaway especially for you. All you need to do is just comment below the post and win a free copy of Oracle Database XE 11gR2 Jump Start Guide. Two lucky winners stand a chance to win an e-copy of the book. Keep reading to find out how you can be one of the Lucky One.


Overview of Oracle Database XE 11gR2 Jump Start Guide eBook

Build and manage the Oracle Database 11gR2 XE environment with this fast paced, practical guide. The book helps beginners to install, administer, maintain, tune, (more...)

Book Released: “Oracle Database XE 11gR2 Jump Start Guide”


I am pleased to announce my first book "Oracle Database XE 11gR2 Jump Start Guide" published by Packt Publishers. The book is available in two formats "Print Book" and "ebook".  


Please let your friends and colleagues know about the book. Have a look at the contents by following the below link:



The book is available for purchase from the publishers website (www.packtpub.com) and other leading consumer websites like Amazon, Barnes and Nobles, Waterstones etc. 

Thanks to all my readers who have encouraged me to write this book. 

Oracle Database 12c – New Feature: Identity Columns


Well, Oracle Database 12c is not yet available but new features seems to be popping out in MOS. While troubleshooting Oracle Enterprise Manager Cloud Control 12c startup issues I came across Oracle Database 12c new feature called “Identity Columns”.

An Identity Columns is auto-incremented at the time of insertion just like in SQL Server. Going forward, I think you will not use Oracle Sequence anymore to generate unique values instead use Identity Columns.

For more information on this read:



Happy reading!!!

Oracle Certified Master (OCM)





Today I received a congratulations email from “Oracle Certification Program” for successfully completing Oracle 10g OCM. Being an OCM is really an accomplishment in a DBA’s career. OCM is the most advanced database credential for an Oracle professional.


I still have to wait for another 2-3 weeks to receive OCM-Kit and to get my profile updated under “Oracle Certified Master Profiles”. 

DBUA Fails with ORA-17502 Error

While upgrade four-node Oracle RAC environment from 11.2.0.1 to 11.2.0.3, DBUA started to throw ORA-17502 error while creating a new SPFILE for the upgraded database. Not only did DBUA err out but it also deleted the existing SPFILE.

Below is the screenshot of the error:




In order to complete the upgrade process, we have to manually perform the following:
  1. Re-create the SPFILE,
  2. Complete Post-installation steps (like executing “utlrp.sql”), and
  3. Re-create the Cluster Services


I later found out on MOS that this situation can be avoided by pinning the nodes as shown below:

$GRID_HOME/bin/crsctl (more...)

Modifying SCAN Listener Port

It’s been awhile since I’ve published a post on my blog. I have so many things to share but not able to find time to share. Hopefully, very soon I will get back to blogging. Here’s a quick post on modifying SCAN listener port.

We have been having archive log corruption issues since we setup Data Guard (sometime last week) on Oracle 11gR2 (11.2.0.2). The physical standby database is receiving the archive log files but unfortunately not able to perform media recovery as the archive logs are in malformed state.

The customer is using CISCO switches between (more...)