Oracle

11G R2 Cluster: AVOID using sqlplus & lsnrctl for Oracle

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

DBD::Oracle and Oracle 11gR2 – Battle of Bits

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.

DBD Release 1.27 Release Candidate 1

Sorry, no funny nick name for version 1.27 but here is the scoop on it anyway. This version removes ‘PERL_POLLUTE’ and adds in PL_ so it will be fully compatible with Perl 5.13. So in a nutshell 1.27 is a single issue maintenance release.

Updating ASMLIB Driver Using “update-driver”

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.

Failure Scenarios for your Restore Practice

I always tell DBAs to practice their restore skills because this is one area that you are not allowed to get wrong. Having experience with different types of restores give you the confidence to do the right thing in an emergency. However, I noticed that when it comes to practicing, not all DBAs are equally imaginative on what to practice. Practicing the same failure over and over is not the best possible practice. Here are few scenarios you should be able to recover from

Upgrading Standalone ASM to Oracle Grid Infrastructure?

The past four days have found me very frustrated and at wits’ end while testing upgrades of standalone Oracle Grid Infrastructure (ASM) 11.2.0.1 to 11.2.0.2 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 (11.2.0.1) grid home directories again. This is the second bug with the 11.2.0.2 upgrade process that I’ve encountered.

Call for Papers – NoCOUG 2011

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.

Page 57 of 139« First...102030...5556575859...708090...Last »