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
ORA-00132 while starting 11gR2 database
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
Adding a reinstalled/reimaged node back to 11gR2 Cluster
There could be a scenario of node crash due to OS/hardware issues and a reinstall/reimage of the same. In such cases, just a normal node addition would not help since…
Read Full Recipe
Performance Management Guide on AIX
While trying to find the amount of physical memory used by oracle process on AIX, I got reference of a document from Metalink: Performance Management Guide It tell us about…
Read Full Recipe
Retrieving Database SID,Port information from Grid Control repository
This is short posting on sql which can be used to get Hotsname,SID,Port information for databases registered in Grid Control repository. This information can be used to create a tns…
Read Full Recipe
ORA-01722 with Full Table Scan
My application developers approached me with an issue which is very unique to me. They were complaining about a query which was failing with ORA-01722 "invalid number" after an upgrade…
Read Full Recipe