Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

11.2.0.2

Home » 11.2.0.2

11.2 AQ – Messages stuck in PROCESESED,WAIT State

  • Post author:Amit Bansal
  • Post published:11 January, 2013
  • Post category:11g
  • Post comments:0 Comments

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…

Continue Reading11.2 AQ – Messages stuck in PROCESESED,WAIT State

11gR2:Oracle Online Patching

  • Post author:Amit Bansal
  • Post published:22 June, 2012
  • Post category:11g
  • Post comments:1 Comment

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…

Continue Reading11gR2:Oracle Online Patching

V$SQL_SHARED_CURSOR in 11.2.0.2

  • Post author:Amit Bansal
  • Post published:16 December, 2011
  • Post category:Performance
  • Post comments:0 Comments

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…

Continue ReadingV$SQL_SHARED_CURSOR in 11.2.0.2

Changing CRS/Database timezone in 11.2.0.2 post install

  • Post author:Amit Bansal
  • Post published:26 September, 2011
  • Post category:11g
  • Post comments:1 Comment

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…

Continue ReadingChanging CRS/Database timezone in 11.2.0.2 post install
Read more about the article In-Place Upgrade 11gR2 RAC : 11.2.0.1 To 11.2.0.2

In-Place Upgrade 11gR2 RAC : 11.2.0.1 To 11.2.0.2

  • Post author:Saurabh Sood
  • Post published:8 September, 2011
  • Post category:11g/Featured
  • Post comments:12 Comments

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…

Continue ReadingIn-Place Upgrade 11gR2 RAC : 11.2.0.1 To 11.2.0.2
Read more about the article Steps to Upgrade 11.2.0.1 RAC to 11.2.0.2

Steps to Upgrade 11.2.0.1 RAC to 11.2.0.2

  • Post author:Amit Bansal
  • Post published:3 October, 2010
  • Post category:11g/Featured
  • Post comments:7 Comments

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…

Continue ReadingSteps to Upgrade 11.2.0.1 RAC to 11.2.0.2
  • 1
  • 2
  • Go to the next page
Copyright - OceanWP Theme by OceanWP