Beware the /var/tmp/.oracle Hidden Directory!
A few months ago, we had a test instance complaining that it couldn’t write to ASM. This was an...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Don Seiler
Installing Oracle 11gR2 Enterprise Edition on Ubuntu 10.04 (Lucid Lynx)
I recently reformatted my laptop with the latest Ubuntu LTS release, 10.04, aka Lucid Lynx. Since I...
Applying Oracle 11.2 April 2010 PSU for Single-Instance ASM and DBMS
When news of the April 2010 PSU for Oracle 11.2 came out, I was excited to see it, since it marked...
HOWTO: Oracle Cross-Platform Migration with Minimal Downtime
I recently performed a migration from Oracle 10gR2 on Solaris to the same version on Linux,...
Moving Oracle Datafiles to a ZFS Filesystem with the Correct Recordsize
Full credit for this tale should go to my colleague Christo Kutrovsky for the inspiration and basic...
Setting up Network ACLs in Oracle 11g… For Dummies
Having recently performed a test upgrade for a client from Oracle RDBMS 10g to 11g, I can tell you...
Turn Off db_cache_advice To Avoid Latch Contention Bugs
A couple of weeks ago, we noticed some timeouts in some of our standard Oracle RDBMS health check...
Sending Timezone-Aware Email with UTL_SMTP
I’m back again with another in what I hope will be a long line of “Quick Tips for Newbies” series....
ORA-16069? You May Need A New Standby Controlfile
On a recent Monday, I had to perform an emergency Oracle standby switchover for a client whose...
RMAN Redundancy is not a Viable Retention Policy
The story you are about to read is based on actual events. Names and paths have been changed to...
