Posts Categorized: Technical Blog

Installing TOra with Oracle Support on Ubuntu 10.10

I installed this on Kubuntu 10.10 x86_64 systems with the newest Oracle 11.2 client. The version of TOra this time around is 2.1.2 which works fine except for one really really frustrating thing, that I will mention at the end to keep you in suspense. I ran through this 3 times on 3 separate systems (VM, work and home) and in all cases I got through it mostly unharmed with only a few humps. So here we go, it’s time to…

Pythian Q1 2011 Speaking: Find us at RMOUG, Hotsos

Pythian will be at RMOUG in full force. Look for Alex Gorbachev, Kellyn Pedersen & Don Seiler. Be sure to stop by our table (#10), say hi to us & our friends from the OakTable Network, and enter our draw to win an Amazon Kindle, and software provided by Cary Millsap (MR-Trace, MR-Tools & Method-R Profiler) among a few other surprises. Pythian is agressively hiring top DBA talent. If this is you, register on our Career Center, or request a time for a short intro chat with Pythian. Alex, Kellyn or Don will be more than happy to give you the inside scoop on the company & share why they love working for Pythian.

The DBA and the Trigger

Anyone can fall into this scenario. Everyone is carefully taking time to test before applying a couple patches to address an async I/O issue in Oracle to ensure all testing environments are exact, all patching is approved by everyone that would like to review it. No one is willing to pull this trigger and apply the patches until they are absolutely sure they have every SQL statement, every network tweak, every application scenario looked over and over again. Suddenly, the database reaches what every DBA dreads…

Is ADR Really Automatic?

Oracle has consolidated the diagnostic information of database under one umbrella called as Automatic Diagnostic Repository (ADR). This repository is XML-based and that opens up new vistas for future Oracle diagnostic tools to manipulate the hierarchical data.

Oracle DBA: Huge Pages and Oracle Cluster 11GR2

In looking at this subject, most of you will say: Hey Yury! What’s new that you can tell us about? The following note describes it all:
11gR2 Grid Infrastructure Does not Use ULIMIT Setting Appropriately [ID 983715.1] These were exactly my thoughts when I was called to troubleshoot a case where a DB instance, starting with the “srvctl start instance” command failed to use Huge Pages in Linux. Huge pages are configured in Linux already as shown in the following example.

Guerilla Perl Installations

App::perlbrew is a tool that simplifies down to triviality the process of making local perl installations. With it, any user can, in the span of a few minutes, have a working perl that is totally independant of whatever the system has. This is a win for you — you’re now in control of your perl, and of your destiny — as well as for the sysadmin, who is now free of the prickly choice between system integrity and users’ happiness. The path to self-sufficient brewing is incredibly easy. First, you have to download and install perlbrew

Congrats to Fahd Mirza on Becoming an Oracle ACE

Last week brought great news to Pythian – one of our DBAs in Pakistan, Fahd Mirza, has become an Oracle ACE. Fahd joined Pythian in September 2010 as the very first Pythian employee in Pakistan and thanks to his skills and ambitions ended up on the team supporting Exadata environments. I should also mention that another Oracle ACE DBA joined us recently – Jared Still. Jared is a well respected member of Oracle community, member of the OakTable Network and a veteran of the Oracle-L mailing list

Page 36 of 60« First...102030...3435363738...5060...Last »