Prerequisites

Oracle 9i is the result of merging almost their entire product line into two products. To say that 9i is the database is a little misleading, but this is what you need if you want to keep current with your Oracle database.

There are a few things that you need to be aware of before embarking on the installation of Oracle 9i. First are it’s hardware requirements. They’re huge, much more than 8i which itself was large.

I assure you: it’s not deliberate. I’d like to go on record and say that I do not plan to only go to obscure — some have even said dangerous — places. I just go where my interests lie.

I’ve been to a couple of Buddhist countries recently (Thailand and Sri Lanka), but they both practise the same kind of Buddhism — called Theravada. I originally thought that they were the less pure form, the Church of England to Tibet’s Catholicism. I went to Tibet to see the “real” Buddhism, however it turns out that, in some ways, the opposite is true (it’s a long story; leave comments!). Tibetan Buddhism (Mahayana) is actually a merger of the traditional Tibetan religion, B?n, with more normal Buddhism.

In all honesty, I’ve not managed to get Oracle working properly yet. When I upgraded my RedHat 7 machine to 8 it still worked, when I installed it from scratch it didn’t. This clearly shows that it’s possible to get Oracle 8i working, but I can’t say how!

For those that are interested, I found that it was easy to get the installer to complete, but I get the infamous “end of communication channel” error when trying to start an instance.

Introduction

“Practical C Programming” not only plans to teach you C, but also about style, debugging and the software life-cycle.

Introduction

Those two point, on their own, were enough to clinch the purchase just over eighteen months ago.

Content

The book is, to say the least, comprehensive. When I first started to use PL/SQL I would never have guessed that there was enough there to write a thousand page book, but there is.

You tend to find two things relating to programming languages on the Internet. The first is a long list of all the languages, often with links to a representative web site. The second category are the “representative” web sites, detailed descriptions of a particular language.

I hope to make this part of ZX81.org.uk to be the middle-ground. I won’t cover every language ever designed and nor will I cover them in vast amounts of detail. Instead I’ll look at each languages main features, advantages and flaws.

Credit where it’s due

I am unable to criticise a suite of products the size and complexity of Oracle on my own. There are a number of people that need to me mentioned. Remind me if I missed you out!

People

Thanks to Anna Brabants who nearly created the term ‘Oracle Comedy Errors’ and certainly did an almost continuous stream of abuse (not all of it at Oracle).

And thanks to the rest of the project team, who invariable love Oracle products as much as I do.

I have recently installed Oracle 8i R3 (8.1.7) on my Celeron 466 machine. I found the installation to be very straight-forward compared with both 8.1.5 and the experiences of many people.

My machine is well below the specification that would be required to do real work on, especially if you have a number of developers. It does work, albeit rather slowly. Creating my initial database, for example, took around eight hours.

Introduction

The subject at hand is really much wider than just Redhat 7.x, especially as more recent distributions are following Redhats lead and are now including glibc 2.2 also. I have no reason to believe that this process will not work with newer versions of SuSE, Debian, etc.

The other point to note is that I have not tried the procedure outlined here. I have migrated my box from Debian 2.2 to RedHat 7.2 and can testify that Oracle still works, but I have not actually performed an installation. I have, however, recieved a good number of emails confirming that it works, so don’t worry!

Working eight hours a day with a product, you notice not only bugs, but other strange bits and pieces too. This is the page for them.

• One mis-spelling of ‘Oracle’ looks remarkably like ‘Roach.’ Surely not just a coincidence.
• Mis-typing ‘ORACLE_SID’ often looks like ‘ORACLE_SOD’ which is only one word short of what you usually think when you’ve done this.