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 11.1.0.7 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]
Applying Oracle 11.2 April 2010 PSU for Single-Instance ASM and DBMS
Note: This post originally appeared at The Pythian Group blog.NOTE NOTE: Grid Infrastructure PSU 9343627 has since been revoked by Oracle, and replaced with a newer PSU. Do not apply PSU 9343627. I'm leaving this post up for educational purposes only.When news of the April 2010 PSU for Oracle 11.2...
[Read More]
A Drupal Backup Script
I maintain a drupal codebase that hosts multiple sites. I’ve been shamefully lax in getting regular backups of those files and databases, until today. Here is a pretty basic bash script that will create a bzip2 archive of the drupal codebase (including site-specific dirs), and then create mysqldump exports of...
[Read More]
Moving Oracle Datafiles to a ZFS Filesystem with the Correct Recordsize
Originally posted on The Pythian Group blog.Full credit for this tale should go to my colleague Christo Kutrovsky for the inspiration and basic plan involved.We recently migrated a large database from Solaris SPARC to Solaris x86-64. All seemed to go well with the migration, but in the next few weeks,...
[Read More]