Auditing in Oracle 10g Database Release 2…

I wrote/revamped an article yesterday called Auditing in Oracle 10g Database Release 2. Most of the information was already present on the site, but it was spread across several articles including an 8i article and several new features articles for 9i and 10g. Rather than write a small article on the XML audit trail in Oracle 10g Release 2, I thought I would bring the whole lot up to date.

One point I spotted was an unusual change in the AUDIT_TRAIL parameter. In 10g Release 1 there was an allowed value of DB_EXTENDED, which indicates that the audit records should go to the DB audit trail and the SQL_TEXT and SQL_BIND columns should be populated. In Release 2 this has been changed to DB,EXTENDED. Can’t see the point in this change myself. Personally, I would not have been offended by XML_EXTENDED, rather than XML,EXTENDED… 🙂

Whatever…

Cheers

Tim…

The life of a DBA…

Person: Is there a problem this morning?
DBA: A problem with what?
Person: Application “X” is throwing out errors. Do you know what’s going on?
DBA: That’s wierd, as far as I know nothing has changed on that project recently.
Person: They put some new software live yesterday, but they are sure that’s not the problem!
DBA: Which server are they seeing the problem on?
Person: Server “Y”.
DBA: The applications on that server don’t connect directly to the database. It doesn’t even have an Oracle client loaded.

So let me see:

  • The specific application does not, and has never, connected to the production database.
  • Some new software went live yesterday.
  • The problems they are seeing must be related to the production database. It can’t possibly be due to the new software put live yesterday!

I’m sure there is logic somewhere there, but I’m just too stupid to see it 🙂

Cheers

Tim…

New article and a little surprise for me…

Somebody asked me how to install Oracle9i on Red Hat 4.0, so I wrote quick how-to. Personally, I can’t see the point. Why run an old version of Oracle that requires you to make RHEL 4 think it’s RedHat 9? Each to their own I guess.

A number of bloggers have mentioned the new Oracle blogs site, so I thought I’d check it out. I was more than a little surprised when I found my blog listed there. I’m a very “off-topic” blogger and my opinion of Oracle is not always flattering. I guess I slipped through the quality control net…

Now, who do I need to bribe in order to get one of those little ACE images? 😉

Cheers

Tim…

Installation frenzy…

I’ve modified my “Linux Articles” page to show a matrix of all my installation articles. It makes finding stuff a little easier than reading the text long-hand. For the most part, these are installations I’ve practiced for work, or needed for home, so I doubt I’ll try too hard to fill in the gaps.

There are a couple of draft articles for Fedora Core 5 (FC5). It’s still in beta, so these will need some amendments by the time the final version is released.

Fun, fun, fun 🙂

Cheers

Tim…

10.1.0.5.0 Limited Release…

The 10.1.0.5.0 patch is now available for:

  • Linux Intel (64-bit)
  • Linux x86
  • Windows 64-bit

Why 64-bit Windows and not 32-bit Windows? I would have thought the latter would be the priority as the uptake of 64-bit Windows has been poor so far. Perhaps it’s just a fluke 🙂

Cheers

Tim…