Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to figure out how to use RHEL cluster to have automatic failover of an oracle 9 database from one physical machine to another. Ideally this solution would be fully hardware redundant in that there would be no single piece of hardware that could fail that would take down the database.

I'm happy to get answers that simply point to documentation or even descriptions themselves.


edit: I wanted to note that I would like to not have to use oracle RAC or a SAN to keep costs down.

share|improve this question
Which edition are you using? Standart, Enterprise? – Benoit Sep 16 '09 at 7:52
9.2 Enterprise Edition – Nathan Feger Sep 16 '09 at 14:00

I don't know about RHEL cluster or Oracle 9 in particular, but one of my colleagues has just done a Heartbeat/Oracle 10 XE HA installation, and had the good sense to blog about it:

Hopefully they'll give you some pointers in the right direction, even if the recipes aren't directly applicable.

share|improve this answer

Oracle 9i introduced RAC (Real Application Cluster) an option that provides software for clustering and high availability.

You should find all the documentation you may need on metalink, the Oracle web site or the Interweb.


If you don't want to use RAC, you could always use Data Guard.

Dataguard allows you to synchronize your primary database with up to nine db, called "standby" database.

If your primary server crashes, you just have to open one of the standby databases.

share|improve this answer
Oracle RAC costs way too much money to be an option. I should have specified that in the question. – Nathan Feger Sep 14 '09 at 22:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.