Posts by Marc Fielding

Testing Out Oracle’s Unbreakable Enterprise Kernel 2

I’m going to test Oracle’s Unbreakable Enterprise Kernel out, and an obvious way to do this would be using Amazon EC2, providing high-capacity instances on demand. After some blind allies getting the Oracle Linux UEK2 kernel working with Amazon EC2 and Oracle VM, I found that I could make it work without Oracle VM, with Amazon’s default Xen hypervisor. Here are the steps I used.

Disabling Oracle triggers on a per-session basis

The method of disabling triggers requires Oracle 11.2.0.2+ or 10.2.0.5+, plus execute permissions on sys.dbms_xstream_gg. Since it’s a call to an XStream package, it may also require a XStream license. So if I haven’t scared you away yet, here’s a quick testcase:

Getting GoldenGate Heartbeats Working with SUPPRESSTRIGGERS

Those of you who have seen me present about GoldenGate will know that I recommend using a heartbeat table to monitor GoldenGate lag. The heartbeat table is a great way to monitor GoldenGate replication because it can follow a single SQL insert through each major GoldenGate replication process, and report the replication lag attributable to each.

Oracle Database Appliance Now Supports All Monitoring Agents

I was browsing My Oracle Support today, and came across note Note 1415713.1 which talks about updates to third-party monitoring agent support. According to the note and associated FAQ, as of February 15, 2012, all third-party monitoring agents are supported on the Oracle Database Appliance (ODA). This means that the previously-published list of supported third-party agents on OTN no longer applies. The biggest benefit to the policy change will be for people who use in-house or open-source monitoring tools like Nagios or newer replacements.

RIP Flash-based My Oracle Support

The end is nigh for Adobe Flash at My Oracle Support. The first step will happen during this weekend’s planned maintenance of My Oracle support, when all of MOS will be down for 5 hours starting at midnight eastern, Saturday January 28. Once it comes back up, the unadvertised non-Flash supporthtml.oracle.com will come up as a quasi-user acceptance test of the new application, while the flash-based support.oracle.com stays as-is.

Gearing up for RMOUG Training Days 2012

The 2012 edition of RMOUG Training Days in Denver less than a month away, running February 15 and 16 at the Colorado Convention Center in Denver. . It’s not too late to register, and it’s a pretty nice excuse to get to the Rockies in ski season. I’ll be doing two presentations, and am polishing up whitepapers and presentations for the submission deadline tomorrow

Page 3 of 712345...Last »