Category Archives: Oracle RDBMS

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.

Two OCP exam mini-reviews: 1Z0-040 (10g DBA New Features) and 1Z0-238 (R12 Install, Patch and Maintain)

Here are my impressions of two Oracle certification exams I’ve had the opportunity to take in the past few months: 1Z0-040 (Oracle Database 10g: New Features for Administrators), and the beta version of 1Z0-238 (Oracle EBS R12: Install, Patch and Maintain Applications)

Unravelling TNS-03505 with database lookups in Oracle Internet Directory

I was playing around with using Oracle Internet Directory to resolve database service names recently, and it turned into an adventure. Not exactly a memoir-inspiring adventure, but at least one worth blogging about. Maybe my little voyage of discovery here will help someone else who gets a TNS-03505 when using LDAP to look [...]