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…

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… :)

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…

RTFM… If you can find them…

A certain something has been released today, so like any self respecting DBA/Developer I went straight for the manuals…

At the time of writing there are none listed on OTN or Tahiti. I tried cunningly altering existing URLs to match the new version, but to no avail.

I’m sure they will appear soon. :)

Cheers

Tim…

Update: Thank you to Mathew Buttler for pointing out the documentation is available here:

http://www.oracle.com/pls/db112/portal.all_books