Oracle has introduced new column "REASON" to V$SQL_SHARED_CURSORS. I came across this extremely useful column while debugging multiple child cursor issue ( seems to have too many bugs which…

Read Full Recipe
479 views 3:36 pm 0 Comments

10.2 CRS startup issue

Today I faced a strange issue with CRS  post host reboot. CRS was not coming up and we could see following message in $ORA_CRS_HOME/log/<hostname>/client/clsc*.log cat clsc26.log Oracle Database 10g CRS…

Read Full Recipe
425 views 10:38 am 5 Comments