In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple sessions hitting database with wrong password. As per Bug 7715339 - Logon failures…
Read Full Recipe
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
A short write-up on a problem faced in few newly upgraded databases to 11.2.0.1 : I faced this issue in couple of databases which were recently upgraded to 11gR2, the…
Read Full Recipe
I was setting up 11gR2 RAC grid infra on my new Toshiba L745 series laptop on OEL5.4, the installation was going very smoothly but suddenly the VMWare machines crashed while…
Read Full Recipe
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
Short post on a error which can take lot of time to debug. You have upgraded a database and after restoring all files (init,tnsnames) try to startup 11g database and…
Read Full Recipe