For this blog I have compiled the main information regarding JDBC drivers specifically considering the 11gR2 platform, but the concepts and idea also apply for older platforms as well.
For last few months I was part of the Pythian’s team helping implement Oracle 11gR2 Clusters for different Oracle customers. All the implementations had different requirements and configurations, however, in all cases, the client’s DBAs made the same mistake over and over again. They used sqlplus and lsnrctl utilities to manage (start/stop) databases and listeners. This is totally wrong in the 11gR2 Cluster world. The following commands are just few examples on how you should start/stop Oracle processes
11gR2, lib32 directory no longer exists and 32 bit libraries are no longer provided. Which means that there is no way to use 32 bit Perl to connect to Oracle. BTW. This applies to other 32 bit clients as well. I’ve heard that SAP can’t support 11gR2 for a similar reason. What do we do? Here are the options.
In this post I want to talk about updating ASMLIB after or before updating kernel version. Beginning oracleasm-support version 2.1.0 and higher we can use the embedded function “update-driver” which can help us to save time and simplify the process of updating ASMLIB driver.
The past four days have found me very frustrated and at wits’ end while testing upgrades of standalone Oracle Grid Infrastructure (ASM) 188.8.131.52 to 184.108.40.206 on RHEL/OEL 5 VMs. The upgrade would seem to go fine, but after rebooting, I would see ASM and LISTENER running under the old (220.127.116.11) grid home directories again. This is the second bug with the 18.104.22.168 upgrade process that I’ve encountered.
North California Oracle User Group are planning their 2011 conferences and are looking for good presentations! We are a very friendly local user group, so if you live in NorCal and never presented before – this is a great place to start! We love seeing new presenters and we even have a public speaking expert on our board who loves giving feedback when requested. Of course, we are nice to seasoned gurus too.
My presentations are finished and the feedback positive. I will be presenting one of sessions (Using AWR/ASH data) at RMOUG Training Days and Hotsos Symposium 2011 with minor modifications (I wonder…can I use the 11g analytical function LISTAGG with AWR/ASH data?). Anyway here are some highlights from the last day and a half…
The highlight of Monday night was Doug Burns shaving ceremony and finalizing it at Tap & Spile. I have captured some videos but they need some post-processing before I can publish them. Another highlight was watching photos of previous UKOUG conferences I attended.
Blogging from the Speaker Ready room which is now suited on the balcony overlooking the exhibition. I must say that I like the new location. Not only it is closer to the action, but allows you to oversee who is hanging out over the exhibitors. There’s been a number of interesting sessions, but it’s little things here and there that I learn that provide some real value. Here’s a few examples
After an inauspicious start, my 7th visit to Birmingham for the UKOUG Conference is in full swing. As in the past, the quality of the presentations is outstanding and the biggest challenge to the attendee is to decide which of the 3 concurrent sessions to attend.