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…
BUG:10082277: Database Connections failing with ORA-4031
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…
BUG: Creating 11gR2 RAC Using VMware On Toshiba Laptop
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…
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…
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…
Effect Of Multiple SHMMAX Settings
Last week I saw a warning message at database startup time saying: WARNING: EINVAL creating segment of size 0x000000000f0020xx fix shm parameters in /etc/system or equivalent It is an Oracle…