11.2 AQ – Messages stuck in PROCESESED,WAIT State
I had been working today on AQ issue where messages were not moving from WAIT to READY State.This was on 11.2.0.3 database running on RHEL5u6(64 bit). I thought of quickly…
Read Full RecipeTag: 11.2.0.2
11gR2:Oracle Online Patching
Online patching is new feature introduced in 11.1.0.6 and oracle started delivering patches with 11.2.0.2. This patch allows you to apply patch to live database i.e we do not need…
Read Full Recipe
V$SQL_SHARED_CURSOR in 11.2.0.2
Oracle 11.2.0.2 has introduced new column "REASON" to V$SQL_SHARED_CURSORS. I came across this extremely useful column while debugging multiple child cursor issue (11.2.0.2 seems to have too many bugs which…
Read Full Recipe
Changing CRS/Database timezone in 11.2.0.2 post install
I had installed a 11.2.0.2 RAC setup few days back with incorrect timezone. It had to be PDT but I installed with UTC. Starting/stopping clusteware with correct timezone didn't solve…
Read Full Recipe
In-Place Upgrade 11gR2 RAC : 11.2.0.1 To 11.2.0.2
Sharing a post from my friend "Carthik" on 11gR2 RAC in-place upgrade. Overview ======== Starting oracle 11gR2 the Oracle database and Clusterware upgrades are done via the "Out of place…
Read Full Recipe
Steps to Upgrade 11.2.0.1 RAC to 11.2.0.2
This post is in continuation to Grid Infrastructure upgrade post written earlier. Ensure that you have downloaded the software and have upgraded the infrastructure database. Following files contain database software…
Read Full Recipe