19 November 2010

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 want (e.g. Amazon associate links) and now Blogger does what I wanted before (e.g. Pages).

The big task now is to find a way to import from Wordpress to Blogger. I can import everything from my previous Blogger blog, but might have to manually copy posts since then (3 years ago). I don't know that there are that many since then, so it might not be too bad. Plus I'm on vacation this week.

12 November 2010

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 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: not all alterations performed 
ORA-29702: error occurred in Cluster Group Service operation
ORA-29702: error occurred in Cluster Group Service operation 
ERROR: error ORA-15032 caught in ASM I/O path 

Uh-oh, that doesn't look good. So I log into the ASM instance and try to see if the disks are OK:

SQL> select path, mount_status from v$asm_disk; 
select path, mount_status from v$asm_disk 
                               * 
ERROR at line 1: 
ORA-15032: not all alterations performed 
ORA-29702: error occurred in Cluster Group Service operation 
ORA-29702: error occurred in Cluster Group Service operation

I can't even query that. As Ted would say, "strange things are afoot at the Circle K."