Fedora 16 came out yesterday and since it’s my main server OS it’s been upgrade crazy round here. All new installs and upgrades were straight forward. No real dramas at all (touch wood). As usual, I’ve done the OS installation and Oracle installation articles. Fedora 16 (F16) Installation Oracle Database 11g Release 2 (11.2) Installation [...]
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 [...]
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! [...]
It’s all a bit last minute, but today I decided to do an Oracle 11gR2 (11.2.0.3) RAC installation on Oracle Linux 6.1 using VirtualBox. The 11.2.0.3 patch has fixed all of the installation issues related to RAC on OL6.1, so it was pretty smooth. The procedure can be seen here. Oracle Database 11g Release 2 [...]
As I’ve mentioned before, I’ve kinda ignored the fact that any operating system other than Linux (specifically Oracle Linux) exists. It’s quite easy to do when you are working with Oracle products and you get to choose your own environment. As a vague nod to the fact that Windows does actually exist, I’ve finally got [...]
There’s a neat new feature for editioning in 11.2.0.2 that allows you to associate an edition with a service. I’ve added it to the end of my Edition-Based Redefinition article here. Cheers Tim…
It looks like 11.2.0.2 has improved most of the original shortfalls of segment creation on demand that were present in 11.2.0.1. Segment Creation on Demand (Deferred Segment Creation) in Oracle Database 11g Release 2 Cheers Tim…
With the arrival of Oracle Linux 6 comes the inevitable installation articles. Oracle Linux 6 Installation Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6 The Oracle installation on Oracle Linux 6 is certainly smoother than the recent Fedora installations have been. Even Enterprise Manager works fine with no meddling. The official 11gR2 [...]
Fedora 14 is here and so are the obligatory articles: Fedora 14 (F14) Installation Oracle Database 11g Release 2 (11.2) Installation On Fedora 14 (F14) My attitude to Fedora and Ubuntu as changed today, with most of that shift due to VirtualBox. Before I switched to VirtualBox I was always reliant on my OS being [...]
The APPEND_VALUES hint is new to 11gR2 and allows you to use direct-path inserts from “INSERT INTO … VALUES” type statements. Pretty neat if you are doing inserts in a FORALL statement and need the extra punch. Cheers Tim…