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 to, 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 ( 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...)

Sangam 2011: Less than a month now

Sangam11, AIOUG's annual conference is starting in the first week of December-2011. To be precise it's on 9th and 10th of December.

The IT capital of India will be hosting 3rd annual meetup of AIOUG. World renowned experts like Murali Vallath, Arup Nanda, Hemant Chitale are leading the show.

If you are in India then grab this opportunity to learn and network. For agenda and registrations click here.

Results of the Second International NoCOUG SQL Challenge are Out

The Second International NoCOUG SQL Challenge was published on 2/13/11 in the February 2011 issue of the NoCOUG Journal. The challenge was to find the secret message hidden in a seemingly random collection of words.

Andre Araujo, Rob van Wijk, and Ilya Chuhnakov are the winners of this competition. Pythian was the sponsor of the competition and each winner will receive an Amazon Kindle.

The full announcement can be read in the 100th issue of the NoCOUG Journal.