Posts by Gwen Shapira
Hotsos is a blast. Easily the best technical Oracle conference. The speakers are terrific, the topics are cutting edge and the audience is experienced, intelligent and engaged. I’m documenting the best lessons I’ve learned, so you can learn too and so I won’t forget them.
Yesterday was actually my second day at Hotsos, 2011.Have a look at my post to see what kind of interesting tidbits I have to share.
It started out innocently enough: Two node RAC cluster on two Linux RHEL5 with Netapp NFS used as shared filesystem for all shared files. My favorite OS and storage, so I felt confident that clusterware installation will be as smooth as it usually is. I told the customer that this can be done in 3 hours. What I didn’t take into account is that this was my first 11gR2 installation, and that much have changed since 11gR1. As things turned out, it took over 20 hours of my time and a lot of help from colleagues and even former colleagues before we had a successful installation. The time it takes you to read this blog post (and any other on this subject) is likely to be time well spent.
The days are cold and wet. The nights are long and dark and full of beeping pagers. It is time to look back and reflect on the past year and plan for next year.
Welcome to Log Buffer, the weekly news update of happenings in the database world.
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.
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
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.
I give a lot of thought of what makes a DBA awesome as remote DBA, or a consultant. Based on my experience as a in-house DBA working with consultants we hired, on my experience as remote DBA for Pythian and on my observation of the amazing guys working for Pythian Consulting. Here’s the secret: You need to give the customer a warm fuzzy feeling. Here’s what I consider key parts of being effective at giving customers warm fuzzy feelings. Obviously all this applies in addition to being a very proficient technical problem solver.
One of my favorite customers had a problem. They had to load around 20G of data into a table on MySQL database. The data loaded fine, but when he tried to build few indexes on the database, he got a mysterious error: ERROR 1114 (HY000): The table ‘really_big_table’ is full. The error was mysterious because we had around 1.5T of free space on the disk. Also, if the customer created the indexes before loading the data there was no error. This gave them a work around, but one that slow and annoying. Later, I found out that we are not the first to run into this mystery.