Posts Tagged ‘11.2.0.2’
V$SQL_SHARED_CURSOR in 11.2.0.2
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 can cause multiple child cursors). As per documentation [Read More]
Changing CRS/Database timezone in 11.2.0.2 post install
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 the issue. In 11.2.0.2 Oracle stores timezone information in file [Read More]
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 upgrade”. And is the easier way to perform your upgrade. [Read More]
Steps to Upgrade 11.2.0.1 RAC to 11.2.0.2
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 for 11.2.0.2. p10098816_112020_Linux-x86-64_1of7.zip [Read More]
Upgrading Grid Infrastructure 11.2.0.1 to 11.2.0.2 on RHEL4
11.2.0.2 Patchset was released few days back. I decided to upgrade a test RAC database to 11.2.0.2 yesterday and was able to do it successfully. I will be documenting the steps here for easy reference Environment Details 2 node RAC on Red Hat Enterprise Linux AS release 4 [Read More]
