Category Archives: Oracle misc

Workflow got you down? Changing the default Grid Control monitoring of EBS

This post describes how to remove the Workflow Notification Mailer from the list of targets that impact the reported status of an E-Business Suite instance monitored by Oracle Grid Control. This can be useful in test or dev systems, where users may not want a disabled notification mailer to be indicative of problems with the instance.

Reference list for deploying Grid Control 10gR4 on Linux

Here’s a quick list of reference links for deploying Oracle Grid Control 10.2.0.4 on Linux. If you’re starting out on a Grid Control deployment project, perhaps this will help to jump-start your own research. This is a non-exhaustive list, but it covers the basics reasonably well.

Clearing the Oracle environment in a Unix session

Correctly defining Oracle-related environment variables in a Linux or Unix session is pretty important, especially on a system that hosts multiple ORACLE_HOMEs. Equally important is making sure that old settings are removed from the environment when switching contexts from one ORACLE_HOME to another. Here’s an example of how I do it.

Running oidadmin on Mac OS X

Being a Mac user and an Oracle DBA need not be an “oil and water” situation. This post describes a way to leverage virtualization (in this case, VMware Fusion) to access tools that are not currently available on OS X. My example is how to launch oidadmin on Mac OS X, but it can easily be adapted to other favorite applications.

A huge thank-you to all the OOW 08 attendees

I risk being accused of egregious sycophancy with a post title like that, but I’ll stand by it, because I am genuinely grateful: if you went to Oracle Openworld 2008 and blogged, liveblogged, youtubed, podcast (podcasted?), or tweeted about your experiences at the event, thank you. You made my professional life so much [...]

Using Ubiquity to access Metalink

Here’s a second Oracle-related Ubiquity command, metalink-open. The command searches a selected (or copied) chunk of text for patch numbers, SR numbers, and Metalink DocIDs, and opens a browswer tab for each item found.

I biq, Ubiq, we all biq: Accessing Metalink through Ubiquity

After playing with the new Firefox extension Ubiquity, I tried my hand at writing a Ubiquity command to retrieve information from Oracle Metalink documents. As a result, I can now use far fewer keystrokes to format links to Metalink notes in blogs, forums, emails, etc.

Launching SQL*Plus from SQL Developer on Mac OS X

I recently upgraded my Macbook Pro to Leopard, and along with all of the other goodies that come with that upgrade, I’ve been able to install and use the long-awaited (and Intel Leopard-only) Oracle Instant Client for OS X. I’ve been using SQL Developer on my Mac for a long time, but I’ve missed the [...]