Oracle RAC on VirtualBox…

 

With the recent news that the latest version of VirtualBox now supports shared disks, I thought I better give it a go and see if I could do a RAC installation on it. The good news is it worked as expected. You can see a quick run through here:

This is pretty good news as that was the last feature that tied me to VMware Server. I’ve now moved pretty much everything I do at home on to VirtualBox and it’s working fine.

It’s worth taking a little time looking at the VBoxManage command line. Some of the operations, like creating the shared disks, have to be done from the command line at the moment. It’s also handy for running VMs in headless mode if you don’t want the GUI screen visible all the time.

Cheers

Tim…

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.

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.

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 is currently lacking a lot of functionality. Even so, it’s a good first step.

I am having a bit of trouble with the “/etc/fstab” mounting. I’ve included it in the article, with a warning that it isn’t working for me. If anyone has got it to work I would really appreciate some input on what I’ve got wrong. The documentation is a little sparse on this subject even with some digging around it’s proving difficult.

I’ll probably be witing another article on a different aspect of DBFS soon.

Cheers

Tim…

Oracle 11gR2 RAC On Linux Using NFS

 

I finally got round to trying an NFS installation of 11gR2 RAC.

No real surprises here. It all seems a little simpler when using NFS, but it was cronically slow on my crappy kit. :)

Cheers

Tim…

Something old and something new…

 

A couple of articles crept out of the last couple of days.

First a revamp of an old article about XML over HTTP to bring it in line with some of the stuff I’ve been presenting recently.

Next, something new that caught my eye to do with auditing in 11gR2.

I know it’s hard to get excited about auditing, but this stuff is pretty neat.

Cheers

Tim…

New scheduler stuff in 11gR2…

 

There are some nice new features in the scheduler in 11gR2. I’ve written about them here:

Remember, there was already a bunch of new stuff added in llgR1, so there’s a lot of whiz-bang stuff if you are moving from 10g.

I do think there are some real security issues with some of this stuff if it is used unwisely though. The remote jobs (external and database) just strike me as a disaster waiting to happen in the wrong hands. :)

Cheers

Tim…

Oracle 11gR2 RAC On Linux Using VMware Server 2

 

I’ve taken my first tentative steps into 11gR2 RAC and it was a big surprise.

11gR2 RAC feels very different to 11gR1 RAC. I can imagine quite a few people wanting to upgrade from 11gR1 thinking it will be trivial and getting a rude awakening…

The Grid Infrastructure (Clusterware + ASM) seems more complicated. There are more installation options, more prerequisites, more background processes and a bigger memory requirement…

I typically install 11gR1 RAC on VMware using 1G of RAM per VM. If you try that with 11gR2 you will get to the end of the Grid Infrastructure installation and have nothing left. The minimum recommendation for Grid Infrastructure alone is 1.5G, but if you want the RAC DB as well you are talking 2.5G. It actually worked fine with 2G of RAM allocated to each VM, but this is a whopping increase compared to 11gR1.

At this point I feel like I know nothing about 11gR2 RAC, but it certainly doesn’t feel like a patched version of 11gR1. If this had been released as 12g I would have still have been surprised by the level of change.

So over the next few days I’m expecting the dust to settle, my residual fear of all things new to subside and I’ll probably change my opinion completely and think it’s all the same as it was before… :)

Cheers

Tim…

PS. Please don’t try this installation on your 32-bit Windows laptop with 2G of RAM then write to me complaining it doesn’t work and telling me the article is rubbish… :)

RELIES ON clause no more…

 

I’ve been running through my demos before my PL/SQL workshop in Utrecht and I noticed a change in the behaviour of the PL/SQL Function Result Cache. In 11gR1 it was necessary to specify dependencies using the RELIES ON clause, but now Oracle 11gR2 takes care of Detection of Sources for you. Neat. :)

Cheers

Tim…

Dipping my toe in 11gR2…

 

I’ve had my first play with 11gR2 today:

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 it looked. The new is much cleaner, and although it will take some getting used to, I think it is a step in the right direction.

I’ve decided that I’m only going to do 64-bit installations from now on. I see little point doing the 32-bit installations, as I hope I will never work on one again. :)

Cheers

Tim…