Tag Archives: database

How can we make Oracle Database 12cR2 the best release ever?

Oracle will be releasing Oracle Database 12cR1 at some point this year. Many companies will avoid this release, opting to wait for 12cR2, their reasoning being it will be more stable and, as a terminal release, will have a longer supportĀ life-cycle. Since 12cR2 is what most businesses care about, what can we do to make [...]




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…