NOTE: This post originally appeared on the Pythian blog.The past four days have found me very frustrated and at wits' end while testing upgrades of standalone Oracle Grid Infrastructure (ASM) 184.108.40.206 to 220.127.116.11 on RHEL/OEL 5 VMs. The upgrade would seem to go fine, but after rebooting, I would see... [Read More]
I Do Not Think It Means What You Think It Means
Arup Nanda posted a great blog article about one of the most fundamental, yet misunderstood, behaviors of the Oracle database: the relationship of the COMMIT statement and buffer caches being flushed to disk. I plan to re-read this every day for month. This clip seems apropos:The article is titled "100... [Read More]
Back to Blogger!
With the recent announcement of Google Apps for Domains integration with the rest of the Google tools suite, I've decided to further simplify my life and run this blog on Google's blogger utility. I've been considering coming back for a while, given that Wordpress doesn't let me do everything I... [Read More]
Beware the /var/tmp/.oracle Hidden Directory!
NOTE: This post originally appeared on the Pythian blog.A few months ago, we had a test instance complaining that it couldn't write to ASM. This was an 18.104.22.168 single (non-RAC) instance on Oracle Enterprise Linux 5, using ASM for the storage. We first saw these errors in the alert log:ORA-15032:... [Read More]
Installing Oracle 11gR2 Enterprise Edition on Ubuntu 10.04 (Lucid Lynx)
Note: This post originally appeared on The Pythian Group blog.I recently reformatted my laptop with the latest Ubuntu LTS release, 10.04, aka Lucid Lynx. Since I like to have a native client installation as well as a portable sandbox server, I decided to install the latest version of Oracle EE,... [Read More]