I’ve amended my Web Scripting for Oracle article to include ASP.NET (VB and C#).
I don’t claim to be an expert in any of these languages, so I can’t guarantee I’m using the best practices, but I like to keep some simple examples for those, “You’ve got to use bind variables!”, conversations 🙂
I can understand Oracle charging for support and product upgrades, like 9i to 10g. I can even see the point of charging for releases upgrades, like 10gR1 to 10gR2. What I think is a little cheeky is to charge people for regular patchsets.
This line of thought came about because of a post on the Dizwell Forum, where someone mentioned they were running a production system without support. This person is working with 188.8.131.52.0 because they don’t have access to 184.108.40.206.0 as a result of not having a support and updates contract. Personally, I think this is more than a little mean of Oracle. Afterall, these patchsets are only fixing bugs in the product that was bought in good faith. Even Microsoft don’t charge for basic Windows Updates, only for version upgrades.
Personally, I believe patchsets on an existing product should be free to those who have a product license. Access to new releases and new product versions could still be restricted.
I just hope I’m never put in th same position as this guy!
I’m nearing the end of my “I wonder what RAC is like on other platforms?” phase. I ran through a basic setup of a cluster file system using OCFS2, just to prove it worked:
OCFS2 On Linux
As I say in the article, the only reason to use it as far as I can see is to provide a shared location or UTL_FILE and external table operations. I can’t see the point in using it for the OCR location or voting disk as raw devices work fine and it’s not recommended for sharing datafiles…
I guess it’s nice to know it’s there if I ever need it 🙂
I’ve been trying to figure out if it’s better to run ASM on Linux using ASMLib or raw devices. Some of the Oracle documentation claims ASMLib gives better performance that raw devices with 10g Release 2, while other sources claim it only affects candidate disk discovery time…
Whilst setting up a test I wrote this article:
ASM using ASMLib and Raw Devices
I’m sure the configuration information will be useful to others, but my first performance test only convinced me that using VMware on my kit at home is pointless for performance tests. You don’t say!!! 🙂
Over the last few weeks I’ve received lots of comments relating to the Oracle 10gR2 on FC5 issue. Recently, most of these have been people commenting on the success of the installation. As a result, I revisited the article based on all the comments and made the following changes:
- There was a typo on my amendment on the gennttab script. It’s now corrected.
- I originally used the source rather than the binary of the openmotif21 package. I now use the binary.
- I was originally installing from an early download of 10gR2, the one that extracts to give a “./db/Disk1/runInstaller” structure. I downloaded a later release that extracts to “./database/runInstaller”. I now use this later release.
I ran through the installation again this morning and it worked perfectly. I don’t know which of the three changes made the difference and to be totally frank, I don’t care. So as it stands, the installation works fine and I hope this is the last time I’ll have to use FC5.
Thanks to everyone who helped in the production of the final article. All your comments were appreciated. 🙂
PS. The document has been released, so it is now listed as a new article. You gotta laugh 🙂
I spent the Bank Holiday weekend playing with 10g RAC on Linux. I don’t have a FireWire disk, and I didn’t want to destroy my NAS, so I decided to user VMware Server to fake it. That process resulted in this:
Oracle Database 10g Release 2 (10.2.0.1) RAC Installation On CentOS 4 Using VMware Server
It’s got about 100 screen shots, so it’s a bit on the large side 🙂
I’ve been using RAC (9i and 10g) on Tru64 for a few years, but until this weekend I had never installed it on any other operating system. Suffice to say, the process is almost identical.
I suppose I should repeat the exercise on Windows 2003, but I’m not sure I can be bothered. Windows is such a drag 🙂
A lot has been said about Fedora Core 5 (FC5) recently, so I thought I would pull together a few things of interest.
Q. Where can you get it from?
A. Try here: http://fedoraproject.org/wiki/Distribution/Download
Q. What is it like?
A. I like the review by Howard Rogers.
Q. Can I install Oracle Database 10g Release 2 on it?
A. There has been a lot of hot air produced (mostly by me) this week about this question, but the answer seems to be NO! Here is a draft installation guide I wrote against a beta version of FC5, but so far I’ve had no luck getting this installation to work on the final release of FC5. I’ve decided to leave the article on my site as a testament to my failure 🙂 Please add to the comments if you have any workarounds.
Q. Can I install Oracle AS10g Release 3 on it?
A. Strangely enough, this seems to work fine. I wrote this installation guide against a beta version of FC5 and it works fine against the final release also. Miracles never cease 🙂 Of course, installing and being stable are two very different things!
Q. Can I use FC5 as a VMware Server host or client?
A. Yes you can, but it’s not exactly straight forward and reliable. The VMware forums will help you get it sorted, specifically these threads (host, client).
Q. What do you think about, FC5 Tim? (Asking yourself a question is kinda freaky :))
A. I don’t like it. My main interest is in server software and FC5 seems to break just about everything it touches, so CentOS4 (a Red Hat clone) is the obvious choice for me.
I hope this information will make life a bit quicker and easier for anyone reading.
Somebody asked me how to install Oracle9i on Red Hat 4.0, so I wrote quick how-to. Personally, I can’t see the point. Why run an old version of Oracle that requires you to make RHEL 4 think it’s RedHat 9? Each to their own I guess.
A number of bloggers have mentioned the new Oracle blogs site, so I thought I’d check it out. I was more than a little surprised when I found my blog listed there. I’m a very “off-topic” blogger and my opinion of Oracle is not always flattering. I guess I slipped through the quality control net…
Now, who do I need to bribe in order to get one of those little ACE images? 😉
The obligatory installation article:
Oracle Application Server 10g Release 3 (10.1.3) Installation On RedHat Advanced Server and CentOS
The installation required less prerequisites than previous installations.
I wrote a quick how-to article about Renaming or Moving Oracle Files in response to a forum thread. Nothing new and exciting here for those in the know, but it might help some of the newer people.
I had a bit of an weird experience last night. I finished quite a tough Karate class and didn’t feel particularly like socializing so I went to the cinema on my own to watch “The Descent”. I’d been meaning to see it for a couple of weeks, but never got round to it. I was feeling pretty thirsty so I bought one of those stupidly large cups (more like buckets) of diet Coke. I sat down to watch the film and started drinking at a pace. Within about ten minutes of the film starting I had the shakes bigtime! I was shivering uncontrollably and felt really bad. I guess the fact I was so tired and had just downed a bucket of ice-cold diet coke had caused my core temperature to drop quite quickly.
I wasn’t totally sure what to do, my judgment was a little off as you can imagine, but fortunately my natural reaction was to start using Ujjayi breath. This is a special type of loud breathing (like Darth Vader) used in Ashtanga Yoga to help generate heat. Sounds a bit dumb, but within five minutes I was feeling a lot better. So much so I was able to watch the film…
Film review – The Descent
Take a bunch of athletic and overly adventurous young women with an assortment of issues and send them caving. Next, have them make some stupid decisions and for good measure throw in some subterranean predators.
Unknown to me I’ve become claustrophobic in my old age. I can’t remember really having a problem with this before, but there are several scenes where people are in really confined spaces that made me want to freak out. I know these scenes were included to increase the tension, but they were by far the scariest bits of the film for me!
There are the usual gore and “make you jump” scenes that you would expect from a horror film. Several of the latter made everyone in the cinema scream, then bust out laughing.
Despite the unfortunate episode at the start of the film I really enjoyed it. It’s not a high budget film, so don’t expect perfect effects, but it’s a significant step forward compared the director’s previous film “Dog Soldiers”. I liked that too, but it is a seriously low budget film 🙂
Note to self. If you’re ever invited to go caving make a polite excuse and run for your life!