Category Archives: Oracle RDBMS

Build an 11gR2 RAC cluster in VirtualBox in 1 Hour using OVM templates

[I originally posted this over at the Pythian blog. If you're not following it, you should! Way more content, by far smarter people than lil ol' me.] After reviewing my blog post about running EBS OVM templates in VirtualBox, two of my teammates suggested that I work on something with potentially broader appeal. Their basic […]

NOW they’re fixed…

A short demonstration of how incorrect fixed object stats can really bog down an E-Business Suite instance startup.

Finding debug and trace profiles in EBS

Two recent requests in rapid succession (“why is the instance running so slowly when I do X?” and “why is this mount point filling up with .dbg files?”) prompted me to dust off an old script.

Logging for non-existent listeners

Trying to start a database listener that doesn’t exist generates log files. In older versions of the database, it’s just one file, but what about in 11g, with its fancy Automatic DIagnostic Repository?

Resolving ORA-4023 during a 10gR2->11gR1 upgrade

Sometimes, even on the 3rd or 4th run-through of a database upgrade test, it’s possible to miss something. Practice makes perfect.

Friday mumblings: VanOUG, 11gR2, and EBS

Random notes about the March 2010 VanOUG meeting presentations

32-bit to 64-bit database migration tips: OLAP upgrade

Notes on upgrading OLAP workspaces when migrating a database from 32-bit to 64-bit Linux.

Keeping OPatch up-to-date: an object lesson

Is opatch failing with the message “ApplySession failed: Patch ID is null.”? Might want to verify your opatch version…

Oracle 10gR2 RDBMS for Mac OS X (Intel) has arrived!

Oracle has, at long last, released a version of the RDBMS for Mac OS X Intel. Not all features are supported, but on the other hand, it will run natively even on a non-Server version of Leopard. Woohoo!

Fixing file permission problems on Grid Control targets

When installing Grid Control on a Linux or Unix platform, a recommended practice is to install the monitoring agent software as a user that doesn’t own the ORACLE_HOMEs to be monitored. This poses a challenge when configuring monitoring for some targets, particularly those based on Oracle Application Server 10g. This post lists some changes you can make to work around a variety of target discovery and metric collection errors.