Managing & Troubleshooting Cluster

Syed Jaffer Hussain on 15 April 2013 with 10 comments

In this webinar, Syed Jaffar Hussain (Oracle ACE Director and Oracle Magazine Editor’s choice award (2011) for ‘Technologist of the year, DBA’) explains how to manage and troubleshoot various clusterware issues. View the presentation slides Watch video You will learn: Grid Infrastructure (Clusterware) startup sequence, like how things getting started after a node reboot or cluster start-up How to understand… Continue Reading →

Migrating Oracle Single Instance to RAC

Syed Jaffer Hussain on 17 April 2012 with 0 comments

This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have to cope with numerous challenges when migrating an existing non-cluster environment to a cluster environment. One of the most significant challenges a DBA faces is to migrate/convert an existing single instance to RAC. Oracle provides several easy methods to carry… Continue Reading →

Upgrading to Oracle 11gR2

Syed Jaffer Hussain on 05 March 2012 with 0 comments

It has been a common practice and relatively a tough task for almost every individual Oracle DBA to decide whether to proceed or not with the upgrade whenever Oracle releases new version. The core objective of this presentation is to share my experience of upgrading 4 Cluster environments with nearly 200 databases to Oracle 11gR2. The presentation is best suited… Continue Reading →

An Easy Way to Obtain 10053 Trace

Syed Jaffer Hussain on 23 January 2012 with 0 comments

I have just learnt a couple of new methods to obtain an Optimizer (10053) trace for any sql statement that is already in the cache, without actually executing it and also enabling ‘events infrastructure’. With 11gR2 onwards, you can either use the DBMS_SQLDIAG.DUMP_TRACE package procedure or use new diagnostic events infrastructure to obtain the 10053 trace for a given sql_id…. Continue Reading →