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…

Direct NFS (DNFS) Clonedb…

A bit before Christmas I got an email from Kevin Closson asking me to take a look at a new undocumented Direct NFS (DNFS) feature in the 11.2.0.2 patch set. I think he wanted to see what a regular DBA would think of it. What with Christmas and some family issues, I didn’t get too much done. As soon as I hit the first hurdle I kinda caved in and left if for the new year.

Well, January came and went, then I finally got round to looking at it again. I like to think my constant questions and dumb mistakes has helped to prepare Oracle for the sort of thing that will happen when other idiots like me are let loose on it. Anyway, the result of that little journey is documented here.

As I’ve said in the article, things are still in a state of flux and I will no doubt have to do some alterations once the My Oracle Support (MOS) Note 1210656.1 is released that will properly document it.

So as a regular DBA what do I think? I think it is awesome!

Old-style cloning of databases isn’t hard, but it’s boring and can take ages depending on the size of the database and storage being used. It’s one of those tasks that always makes me sigh, before I get off my ass and start it. Clonedb turns that on its head because it is really quick and simple. There is a bit of setup, but that is really going to be a one-time thing on most servers. You are doing your backups anyway, so there is no big deal there. Now you can just run a script and bang, you have a running clone.

I think this is going to please a lot of DBAs out there!

Cheers

Tim…

The Myth of Oracle Fusion…

I read a post this morning by Grant Ronald talking about fusion apps. In Grant’s post he mentioned things that people have been saying about Fusion over the years. Middleware and Apps are not my specialist field, but I get to hear a lot about them from the conferences and ACE Director meetings, so I have been witness to the Oracle Fusion myth from the beginning.

Cast your mind back several years and the whole concept of Fusion was launched at OOW. We were told that the middleware stack was going to become a single coherent product, rather than the buggy rag-tag bunch of technologies we had in 9iAS and AS10g. Sounds good so far, but then all the existing stuff got rebranded as Fusion Middleware when the products it was made up of hadn’t significantly changed. That’s confusing.

Fast forward a bit and we were expecting something like real Fusion Middleware to appear, then the BEA buyout was announced and WebLogic became the core of Fusion Middleware. Oh. So this wonderful coherent product that Oracle had been developing and we were expecting soon was swapped for a best-of-breed app server from an acquisition. Strange and a little disconcerting, but at least we have a better app server now, except that some of the existing features still required you to install the old AS10g stuff. Still the name Fusion is plastered everywhere.

Fast forward a bit more and we have got to a point where applying the term “Fusion” to the middleware stack is less insulting, but if anyone experienced Fusion along the way they would probably have been left with a bad feeling about what Fusion actually means. It’s very hard to overcome a bad first impression. Are Oracle really surprised that the term “Fusion” is associated with myth and confusion?

OK. That’s the Middleware. What about Fusion Apps? Well, the name includes the word “Fusion”, so it takes on all the bad connotations associated with the infancy of Fusion Middleware. Added to that, since the original announcement of Fusion Apps there have been numerous acquisitions, all of which have no doubt added to the confusion about what Fusion Apps actually is. Then we are told there is no natural upgrade from eBusiness Suite to Fusion Apps. It’s a new product and we have to migrate data to it as we would any new ERP. Next we are told that the initial release will only be a subset of the modules we require, so we will have to run it alongside eBusiness Suite. Wow. This is really confusing. That sounds like a half-finished ERP built on a half-finished middleware stack. Once again, are Oracle really surprised people react like this?

Now I’m not saying the Fusion Middleware is bad. It’s come a long way. I’m also not saying Fusion Apps are bad. I’ve seen the demos and they look amazing. I’ve also talked to people in that field who are genuinely impressed and exited by it. I believe it will be a big eye opener and possibly a game-changer for a lot of people. What I’m saying is I can totally understand when people on the outside of our little goldfish bowl have a really bad and confused impression of anything containing the term “Fusion”, because it does have a very long and sordid history.

In my opinion the term Fusion needs to be scrapped and replaced, then perhaps we can forget the history and focus on the now. Kinda like they did with Beehive. 🙂

Cheers

Tim…

Where’s my money gone?

Over the holiday period I got a credit card bill from Oracle Norway for £3230.12. I have no idea what this is for, and as far as I know I’ve never dealt with Oracle Norway before, so my bank are treating it as a credit card fraud case. 🙁

What’s more I have no idea how they got my card details because this isn’t a card I use for anything Oracle related, like travel etc.

I contacted Oracle Norway, who put me on to Oracle Romania, who have passed me on to a finance department, who have now passed me on to another finance department. As yet no indication of what I supposedly bought or did to warrant this charge. The initial issue was worrying, but what’s more worrying is the amount of time it’s taken to get any response. I guess the holidays have had an impact though.

In the short term I’m not that bothered because my bank have already refunded the cash, as is their way when investigating potential fraud cases, but I would certainly like to know how this happened in the first place so I can prevent it from happening again…

Cheers

Tim…

VirtualBox 4.0.0. Changes to VBoxManage Syntax…

I just got home to find a question about my RAC on VirtualBox article. The poster was having problems creating the virtual disks using the commands in the article. A quick scan through the docs reveals a number of changes to the way VirtualBox 4.0.0 handles disks and also changes to the VBoxManage syntax. I’ve amended the article to include a version of the commands for version 4.0.0 which seem to create and attach the shared disks in the same state, but it will be a few days before I get to test this properly.

So what’s happened that affects shared disk setup?

First, you can’t create a shareable disk. You have to create the disk (createhd), then modify it to shareable (modifyhd). That sounds fine, but there is an issue. The manual says,

“Before VirtualBox 4.0, it was necessary to call VBoxManage openmedium before a medium could be attached to a virtual machine; that call “registered” the medium with the global VirtualBox media registry. With VirtualBox 4.0 this is no longer necessary; media are added to media registries automatically. The “closemedium” call has been retained, however, to allow for explicitly removing a medium from a registry”

Well that is not entirely true. When you create a new disk it is not visible in the media manager until it is attached to a VM. That means you have to create the disk, attach it to a VM and then convert it to shareable. If you try to modify it before attaching it to a VM you get told the disk doesn’t exist. This just feels wrong.

As a minor annoyance, the VM detail pane doesn’t notice the “–type” change so the disks still display as normal unless you restart VirtualBox, or click the “Storage” link for the VM and come straight out, which seems to get the screen to update.

This is not a big deal, it’s just a little annoying as the old syntax was more straight forward. I’m sure it was done for a good reason… 🙂

Cheers

Tim…

Belgrade, Serbia: PL/SQL Masterclass -Day 2

Day 2 of the PL/SQL Masterclass went well. The feedback was very positive, which is always nice. As always I over ran on both days. I was about 25 minutes over on the first day and something like 40 minutes over on the second. I’ve got some more stuff I would like to include in the course, but that will mean taking something out or locking the doors and strapping people to their seats. 🙂

I’ve  had a really good time in Serbia. It would be good to go back again some time so I can see all it in daylight. 🙂

Cheers

Tin…

Belgrade, Serbia: PL/SQL Masterclass – Day 1

I’ve just completed day 1 of the PL/SQL Masterclass for Oracle University in Belgrade. So far so good…

Last night Ljiljana took me on an evening tour of the city. I got to see a little of New Belgrade, which is very modern with wide streets, big buildings and some shopping malls, as well as some of Old Belgrade, which has narrower streets, regular shops and mostly smaller buildings . There are few big blocks there with a “communist feel” to them (her words not mine). What was quite freaky is some of the military/government builds that were bombed during the NATO bombings in the late 90’s are still not repaired. The amount of building that has happened in the last few years leads me to believe these may be left that way for a reason… I’m not big on commenting about politics, but it is very interesting hearing stories about that time from regular folks who were living here at the time. Always two sides to every story etc.

Unfortunately the timing of my visit is such that I can only really see the city by night, so I’ve not taken any photos yet. I think I’m going to Google some and pretend I saw it all by daylight. 🙂

After the tour and some shopping we went out to a small traditional Serbian restaurant near Ljiljana’s parents house. Serbians are very big meat eaters, but they also have some really cool veggie dishes. I had lots of stuff I can’t spell or pronounce. Lots of cheese and a dish made out of butter beans, peppers and onions that was awesome. I’m hoping to get the recipe from Ljiljana’s mom so I can try and make it at home. It’s quite similar to the food I’ve had in Bulgaria, which suits me just fine. 🙂

I didn’t sleep too well last night. I think I was still a little stressed out about the luggage situation. I did manage to buy some clothes and stuff yesterday so today wasn’t too bad, but you still feel a little off center. I got back to the hotel tonight and my luggage has arrived. Now I’ve got no excuse for looking scruffy tomorrow… Doh!

Let’s see what tomorrow brings. 🙂

Cheers

Tim…