Tag Archives: database

Oracle Database on Oracle Linux 6.1…

I mentioned the day before Open World I put a Virtual RAC on Oracle Linux 6.1 article live. Although the procedure was complete, some of the screen shots were from an old article as I didn’t have time to redo them before my flight. I’ve just run through the procedure again and taken new screen [...]




Oracle Database 11gR2 on OL6 / RHEL6: Certified or Not?

There seems to be a little confusion out there about the certification status of Oracle Database 11gR2, especially with the release of the 11.2.0.3 patchset which fixes all the issues associated with RAC installs on OL/RHEL 6.1. Currently, 11gR2 is *NOT* certified on OL6 or RHEL6. How do I know? My Oracle Support says so! [...]




Two New Articles: UDEV and Database Triggers…

I’ve recently put a couple of new articles about old subjects on the website. In both cases, the articles were initiated by forum questions, but the explanations became too painful in the format of a forum post so they graduated into articles… UDEV SCSI Rules Configuration In Oracle Linux 5 : For those of you [...]




Oracle Database SQL Expert (1Z0-047)…

I can see this post degenerating into a rant, so I would like to preemptively appologize to anyone involved in the production of this exam. I’m guessing it’s a real pain to develop these exams, especially when some ass like me starts moaning about them. Added to that, I’m guessing the word “Expert” means slightly [...]




Oracle Database File System (DBFS) PL/SQL APIs…

My previous article discussed the DBFS. This article gives an overview of the PL/SQL APIs for managing and interacting with the DBFS. Oracle Database File System (DBFS) PL/SQL APIs There’s a lot in there, so this is just skimming the surface. Cheers Tim…




Oracle Database File System (DBFS) in 11gR2…

I’ve been having a play with the DBFS functionality in 11gR2. Oracle Database File System (DBFS) in Oracle Database 11g Release 2 For the most part it is extremely simple. If you are working on Linux then it’s a really neat solution. On any other platform you are limited to using the dbfs_client tool, which [...]




Oracle 11gR2 RAC On Linux Using NFS

I finally got round to trying an NFS installation of 11gR2 RAC. Oracle Database 11g Release 2 RAC On Linux Using NFS No real surprises here. It all seems a little simpler when using NFS, but it was cronically slow on my crappy kit. Cheers Tim…




Dipping my toe in 11gR2…

I’ve had my first play with 11gR2 today: Oracle Database 11g Release 2 (11.2) Installation On Enterprise Linux 5.0 Nothing too unpredictable really. I guess the most noticeable change is the new installer. I didn’t have an issue with the old installer, but a few friends from the Microsoft world had pointed out how dated [...]




Resource Manager Enhancements in 11g…

I’ve just put another Oracle 11g new features article live: Resource Manager Enhancements in Oracle Database 11g Release 1 Cheers Tim…




Database Change Notification…

I’ve recently been playing around with Database Change Notification, which is basically an asynchronous triggering mechanism. I’m not really sure why I would use it in an application, but it’s always nice to know about this stuff, just in case. I suppose it’s not drastically dissimilar to the the use of a handler module in [...]