Part 2: RAC/Linux/Firewire – Basic Costs + Hardware Platform Outline

Basic Costs + Hardware Platform Outline In my test environment, I bought the following equipment. Note that although RedHat Advanced Server seems to be required, I worked with the development team to get it working without that distribution, and included RPMs. If you want to get a copy, get the developer release. I listed that …

Oracle 9iRAC – Clustering on Linux/Firewire

Introduction Ever since the announcement of Oracle 9i, Oracle’s Real Application Clustering feature has created quite a stir. For those not familiar, 9iRAC is a complete overhaul of Oracle Parallel Server (OPS) from previous versions of the database into a workable product. For many DBA’s, however, this technology is completely out of reach. Without an …

Tracking the Wily Proxy Hackers

Recently the server that hosts our business was hacked. This interrupted the service of twelve different websites we host, as well as our corporate mail. Needless to say it caused us plenty of headaches, sleepless nights, and frustrating hours. In retrospect, however it has instilled a greater appreciation for computer security, a greater awareness, and …

Open Insights 27: Fragile Foundations

OPEN INSIGHTS NewsletterIssue 27 – Fragile FoundationsJanuary 5, 2007 by Sean HullFounder and Senior ConsultantHeavyweight Internet Group Happy New Year and welcome back to our Open Insights newsletter. Our readership isnow north of 3000 subscribers and growing everyday. Thanks to everyone for your support and for forwarding us on to friends and colleagues! Reading from …

Your Database – A Long-Haul Truck Or A Sports Car?

Introduction Databases, even those running high-powered software like Oracle, can be incredibly touchy, demanding, and even fragile in their own way. For that reason we must take care to optimize and tune them based on characteristic usage. Data Warehouse vs OLTP In broad terms, database applications are divided into two large classes, Data Warehouse, and …

Oracle 10g Laptop/nodeless RAC Howto

INTRODUCTION ———— Let me start by saying that this whole article is rather unorthodox. That’s why I thought the analogy of hitchhiking was so apt. Also if you are a hitchhiker, and you happen to be carrying your laptop, well you can bring along an Oracle 10g Real Application Cluster to show all your friends. …

Part 10: RAC/Linux/Firewire – Summary

Summary We covered a lot of ground in this article and it should serve as an introduction to 9iRAC on cheap Linux hardware. There are plenty of other topics to dig into including tuning, backup, SQL*Net setup and Load Balancing, I/O Fencing, NIC Failover and so on. 9iRAC is *NOT* a silver bullet as any …

Part 9: RAC/Linux/Firewire – A Quick 9iRAC Example

A quick 9iRAC example The names of the two instances I’m using are EAST and WEST, so I’ll use them here to refer to commands you’ll execute at the sqlplus prompt. This test assumes you’re logged into the same schema on both instances. I used ‘sys’ but you can create your own schema if you …

Part 8: RAC/Linux/Firewire – Review of Clustered Features + Architecture

Review of Clustered Features + Architecture Oracle 9iRAC has some important hardware and software components which are distinct from a standard single-instance setup. On the hardware side, you have the IPC interconnect. On high-end specialized hardware such as sun clusters, you have a proprietary interconnect. On our low-cost working-mans clustering solution, you simply use a …

Part 7: RAC/Linux/Firewire – Cluster Database Setup

Cluster Database Setup Setting up a clustered database is a lot like setting up an normal Oracle database. You have datafiles, controlfiles, redologs, rollback segments, and so on. With a clustered database you have a few new settings in your init.ora, and an second undo tablespace. init.ora + config.ora setup In a RAC environement, we …