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 shots. As a result, I’ve allowed the article to display on the front page of the website, which is why you will see it listed as a new article there.

This kinda rounds out the whole Oracle on 6.1 stuff as there has been a single instance installation guide out for ages and more recently the Cloud Control installation, which references it.

Remember, it’s still not certified yet, but it’s coming.

Cheers

Tim…

Update: It’s finally certified. See here.

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! Check for yourself like this:

  • Log on the My Oracle Support (support.oracle.com).
  • Click the “Certifications” link.
  • Type in the product name, like “Oracle Database”
  • Select the product version number, like “11.2.0.3.0”.
  • Select the platform, like “Linux x86_64” or a specific distro beneath this.
  • Click the “Search” button.

From the results you will see that Oracle Database 11.2.0.3 is certified on OL and RHEL 5.x. Oracle do not differentiate between different respins of the major version. You will also notice that it is not currently supported on OL6 or RHEL6.

Having said that, we can expect this certification really soon. Why? Because Red Hat has submitted all the certification information to Oracle and (based on previous certifications) expects it to happen some time in Q4 this year, which is any time between now and the end of the year.

With a bit of luck, by the time I submit this post MOS certification will get updated and I will happily be out of date… :)

Cheers

Tim…

Update: It’s finally certified. See here.

Oracle 11gR2 RAC on Oracle Linux 6.1 using VirtualBox…

 

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.

As noted in the article, the screen shots of the GI and DB installers are from an 11.2.0.1 article. I’ll update these screen shots when I get back from OpenWorld. Like I said, it was all a bit last minute. :) Normally I wouldn’t put an article like this live (and you can see it’s not on the homepage yet), but I get lots of questions about this subject, so I thought I would make it available to make my life easier.

Cheers

Tim..

PS. There is no suitable oracle-validated package available for this at the moment, so the prerequisites have to be done manually.

11gR2 RAC on Windows 2008 using VirtualBox…

 

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 round to updating my Windows virtual RAC article.

Windows 2008 is an unusual operating system in some respects. The RAC installation is pretty simple really, but finding some of the config dialogs is a complete nightmare. Chains of menus, dialogs, buttons and hyperlinks to get you to the dialog you need. What’s worse, some of the menus are hidden unless you remember to “Alt” or “Alt+N”. Crazy! If I was using Windows on a regular basis I think I would just memorize all the dialog program names and start them directly from the Run menu. It’s got to be easier than traversing that nightmare. I remember when Windows was considered the easy option. It doesn’t feel like the case anymore. :)

In related news, yesterday I got an invite from Jeremy Schneider to help out at RAC Attack at OOW 2011. That should be fun. See you there! :)

Cheers

Tim…

Segment Creation on Demand (Deferred Segment Creation) in Oracle 11.2.0.2…

 

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.

Cheers

Tim…

Oracle 11gR2 on Oracle Linux 6…

 

With the arrival of Oracle Linux 6 comes the inevitable installation articles.

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 installation guide has not been updated to include Oracle Linux 6 and I can’t see any notes on MOS about it, so I’ve essentially followed the installation for Oracle Linux 5 and adjusted where necessary. I’m guessing when the official notes are released they are going to be pretty close to this. I can’t see any certifications against Oracle Linux 6, so I guess I would avoid it for production Oracle installations at the moment.

Cheers

Tim…

Fedora 14…

 

Fedora 14 is here and so are the obligatory articles:

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 able to run VMware Server. Over the years I had repeatedly encountered problems running VMware Server on Ubuntu and Fedora. Not all of them show stoppers, but enough to put me off them as my main desktop OS. Why did I stick with VMware Server? Just because it supported shared virtual disks, which allowed me to easily create virtual RAC installations. Version 3.2.8 of VirtualBox included support for shared disks for the first time, so I ditched VMware Server and launched full scale into using VirtualBox.

While I was playing around with Fedora 14 I was thinking how cool it would be to have a newer OS on my desktop that could run Google Chrome, then it dawned on me that now I can. I’ve been free of VMware Server for a while now and I hadn’t realized the knock-on effect of that.

My years of using RHEL mean I feel a little more comfortable with Fedora than Ubuntu, but to be honest all I do on a desktop is fire up VirtualBox, use a browser (preferably Chrome) and use a terminal for SSH. Virtually everything else is done in VMs.

Now, do I waste a few days assessing the various options for my desktop, or do I just stick with CentOS and deal with the fact I can’t use Chrome on it? :)

Cheers

Tim…

APPEND_VALUES Hint…

 

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…

Fedora 13 and Oracle…

 

Until a couple of days ago I hadn’t even realized that Fedora 13 was out. I guess that shows how interested I am in Fedora these days. :)

Anyway, I had a play around with it.

Cheers

Tim…