Author Archive
11gR2:Listener Startup Issues
In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this post based on my experiences or any comments on this blog post. Let’s get started.You will experience following errors while starting listener using [Read More]
Cluster SSH tool Utility
Many times you come across scenario’s when you wish to open multiple ssh windows and execute same commands.e.g You wish to see alert log for multi-node RAC simultaneously or edit sysctl.conf files for multiple machines. Cluster SSH utility helps solve this problem as [Read More]
11g: Multiple failed login attempt can block New Application connections
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 causes “row cache lock” waits – Allow disable of logon [Read More]
Oracle Critical Patch Update January 2012
I guess most of us having My Oracle Support have got email from Oracle mentioning that Critical Patch Update January 2012 has been released. Main reason behind this is Security bug found by Infoworld which can make database run out of SCN. You can read the article here [Read More]
User Sessions stuck on resmgr:cpu quantum wait event
We were experiencing lot of session getting stuck on resmgr:cpu quantum in our database. In fact at a time we had 70 sessions which were stuck on this wait event and our cpu load average was touching 60 Checking active resource plan, we found that DEFAULT_MAINTENANCE_PLAN [Read More]
Plan Stability using Sql Profiles and SQL Plan Management
PLAN STABILITY How many times you have noticed a query using Index X when you wanted it to use index Y or query performing Nested Loop join when Hash Join would have completed the query much faster.Or take a scenario when the application suddenly starts using wrong plan [Read More]
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]
11gR1 CRS start failing with ORA-29702
This post was actually a comment from Sasi which came on previous article 10.2 CRS startup issue . I am converting it to a post so that we can get some feedback on this issue from other users. I suspect this to be caused by RHEL5 bug (fixed in RHEL5u6) related to NIC going [Read More]
AIOUG 2011 – I am Attending :)
All India Oracle User Group(AIOUG) is organizing the annual Oracle Conference in Bangalore on Friday, December 9th and Saturday December 10th, 2011.Arup Nanda is key speaker this year. I will be attending this conference for first time and I am looking forward to meeting [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]
11.2.0.3 Patchset is available
11.2.0.3 patchset is now available for download. 10404530 is available on Linux x86,x86-64 bit only. Tanel Poder first tweeted this Soon after this Surachart and Martin have started upgrading to 11.2.0.3. I expect a blog post soon from one of them [Read More]
CRS-4640 Error on Starting 11gR2 clusterware
I was working on a issue where in Clusterware was not coming up as private interface was down. Following errors were recorded in ocssd.log which informed that issue was with private interface 2011-08-31 15:03:38.051: clssnmvDHBValidateNCopy: node 2, testrac2, has a disk HB, [Read More]
11gR2:Enable and Disable Oracle Feature with Chopt
Oracle has introduced a utility called Chopt in 11gR2 to enable/disable few database features after database installation. To perform this, you need to shut down database and run the utilty present under $ORACLE_HOME/bin. Find below list of options allowed Value Description [Read More]
10gR2 Silent Install with 11gr2 CRS fails
I was trying to perform a 10.2 silent install with 11gR2 CRS. While doing pre-checks installer failed with following error Check complete: Failed <<<< Problem: The 'active' version of Oracle Clusterware is not 10g Release 2 (10.2). Recommendation: You [Read More]
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 Release 10.2.0.4.0 Production Copyright 1996, 2008 Oracle. All [Read More]
