Oracle 10g RAC using NFS…

I’ve mentioned it before, but I really like Kevin Closson‘s blog. For some time he’s been evangelizing about Oracle RAC over NFS, so I thought I would give it a go to see what it’s all about and here is the result.

Oracle 10g RAC On Linux Using NFS

I was only using two machines, and I didn’t have access to a NAS that supported NFS, so I was forced to use one of the RAC nodes as my NFS server. I know it’s a dumb idea, but it proves the technology.

If you are just playing about, the nice thing about this solution is you don’t need to worry about “real” shared storage. I prefer it to the VMware approach because you don’t need a single server with loads of memory to fake two virtual machines and the shared storage. Finding two poor machines is always easier than 1 good one. 🙂

Cheers

Tim…

When is Oracle 11g released?

So all the pomp and ceremony is over and Oracle 11g is launched, but as yet I’ve not heard anything about a release date. Does anyone know when it is likely to hit the shelves. I kind-of though that was the big news, but as yet I’ve not seen any press releases or blog entries that specify a date. It’s not available for download on OTN yet, so I’m assuming the “Launch” and the “Release” are not the same thing.

Have I missed something?

Cheers

Tim…

Noons is channeling me, or vice versa…

I read the latest post by Nuno Souto (Noons) and it felt like he was channeling me, or maybe I’ve been channeling him. I guess everyone knows my thoughts on the fiasco that is J2EE, so I won’t go there. After over 12 years in the business, I’ve still never found a development technology as simple or productive as Oracle Forms. Maybe I’m looking at things with rose coloured spectacles, but it’s been 10 years since I’ve used Oracle forms regularly and I can still open it up and knock out an application in a couple of minutes. I don’t think many people could say the same of other technologies.

Those were the days… 🙂

Cheers

Tim…

Coming down off my 11g high…

I guess if I was honest with myself, I didn’t really expect to be downloading 11g database software on 11th of July, but to see my doubts confirmed is a little deflating:

Get Ready for Oracle Database 11g – July 11th 2007

It takes me back to a discussion with Tom Kyte at last years UKOUG where his estimate for the release date was, “Between 1st July 2007 and 31st December 2007”. 🙂

I know Oracle need months of hype before a release, but I’ve still got my fingers and toes crossed for something earlier than Christmas.

Cheers

Tim…

Oracle Licensing…

We’re trying to figure out what Oracle licenses we have to buy to add another node into an application server cluster. Sounds easy doesn’t it!

Trouble is, we need to load an old version of the application server, and the whole product set has been renamed and re-jigged since this version of the application server was released. The components we’re using sound like a match for the cheaper Java Edition, but that didn’t exist when we bought the product originally, so we are really not sure if we can get away with this.

We contacted sales yesterday, and the lady we spoke to was very pleasant, but was unable to confirm what we need to do. We’re now waiting for an account manager to investigate it and make a decision.

This just confirms to me that Oracle’s licensing is a total mess, and repeatedly renaming their product ranges along with the components they include only serve to exacerbate the problem.

Cheers

Tim…

Oracle Database 11g…

Eddie Awads has posted that the 11g launch is on July the 11th. I have a feeling his hit rate is probably going mad at the moment.

Previous announcements said the release was planned for second half of this year, so I was expecting it to be December 31st. Coming so early in second half of the year is a rather pleasant surprise.

I like to think that in some way I am responsible for the early release. My constant moaning about being bored and wanting 11g to be released soon has obviously done its job. It’s truly wonderful to be the center of my universe. 🙂

Cheers

Tim…

Oracle 10gR2 on Fedora 7…

I had a quick go at this installation and it worked OK. I had to load a bunch of FC6 packages to get Oracle to install, link and run properly. It looks like lots of the “compat_*” packages have been removed from Fedora 7, which is a problem as Oracle 10g needs them. The “libaio” package is no longer present. I’m sure the functionality is there somewhere, but I couldn’t get the listener to work without loading the old package. Also, the “libXP” package is necessary to get the installer to run. It has also been removed, along with some deprecated X11 packages that were present in FC6.

I’m sure the cleanup makes sense going forward, and 10g is getting a little old in Fedora timescales, but I wonder how many other applications will be broken by this.

Of course, I’m no Linux expert, so maybe I’ve missed something and these extra packages are not really needed.

Cheers

Tim…

Schema Owners and Application Users…

I was trying to explain to a colleague the concept of using application users, rather than logging directly into the schema owner. Although it’s a very basic point, it seemed worthy of a write-up, especially because it’s been a long time since I’ve written anything about Oracle. So here is it:

Schema Owners and Application Users

Cheers

Tim…

It’s not simple, so don’t claim it is!

Rant Alert. The following is an unreasoned attack on the IT community in order to vent my frustration. I’m not claiming it makes any sense or it’s factually correct. It’s just how I feel today. Maybe I’ll feel different tomorrow…

I can’t help feeling that companies like Oracle are doing the IT world a major disservice by trying to make out that their products are easy to use. I have a quick newsflash… They are not!

This post is really a response to two things:

  1. My current work situation.
  2. Some of the questions I field on my forum.

From a work perspective, the mass exodus of people from my current company has left me having to deal with bits of technology that aren’t really my bag. It gets doubly annoying when I’m having to use bad support services to help me do really basic tasks. If software and hardware vendors were honest and made customers aware that they would need trained professionals to deal with this crap, perhaps people like me wouldn’t be left fumbling in the dark, trying to pick up the pieces.

From the Oracle forum side of things, I’ve really noticed a shift over the last few years and I’ve written about it before. The same type of questions are being asked as they always were. The difference is that in the past these questions were being asked by people trying to learn the technology. Now they seem to come from people who are employed as DBAs and developers by companies. I don’t believe the intellectual capacities of people have dropped over the years. I just think companies are employing under-skilled people to save money, or expecting people to cover roles they are not qualified to do. You wouldn’t let an electrician fix your plumbing, so why would you let this happen?

I don’t claim to know the answers, but I can see that the constant barrage of “point-and-click”, “intuitive” and “self-tuning” marketing messages are leading people to believe they don’t need qualified staff, and the result is a whole bunch of people asking how to recover their production databases from incomplete backups.

IT is getting more complicated and the range of skills needed in a company is getting bigger by the year. Companies need to be made to understand this or they will constantly be finding themselves in the shit!

Cheers

Tim…