topic Re: Oracle failover in Operating System - HP-UX

Oracle failover

CH.KrishnaMohan — Mon, 24 Nov 2003 15:45:26 GMT

Hi
We have Two HP Unix Servers (Unix Vesrion 11 i)
we configured cluster managemnt also using mc service Guard. We are installing Oracle 9i release 2. How the cluster failover mechansim will take care oracle

Re: Oracle failover

Steven E. Protter — Mon, 24 Nov 2003 15:52:50 GMT

Service Guard has a special module for oracle databases. It has to be configured and then failover will work.

SEP

Re: Oracle failover

Karthik S S — Mon, 24 Nov 2003 16:07:59 GMT

If you are a HP Employee the following site gives you step by step procedures on Oracle RAC installation on HP-UX,

www.hporaclectc.com.

Else start here,

http://download.oracle.com/docs/html/A96687_01/toc.htm

http://h71028.www7.hp.com/enterprise/cache/7319-0-0-0-121.aspx

Basically you have to configure the Service guard first. Then start installing Oracle RAC which detects the cluster automatically.

There is a separate edition of Serviceguard which supports RAC.

-Karthik S S

Re: Oracle failover

Sunil Sharma_1 — Tue, 25 Nov 2003 02:33:53 GMT

Hi,

This is the best manual for configuring ORACLE RAC with HP Cluster soultion.

http://docs.hp.com/hpux/pdf/B5158-90001.pdf

Sunil

Re: Oracle failover

Christian Gebhardt — Tue, 25 Nov 2003 03:04:13 GMT

Hi

Cluster failover is very different from Oracle RAC.

Cluster failover: One Oracle instance switch to the other node, with the loss of all active connections. As mentioned there are scripts from HP to manage the failover.

RAC: You have two (or more) instances working on one database, no package failover to the other node, oracle manage the failover between the nodes without loss of connection.

RAC is a (high price)feature from Oracle. OPS is the old version of RAC.

Sunil: Your document gives an overview, but Oracle7 with shared raw devices is not comparably with Oracle RAC. RAC is an immense progress, and you'll need the software (expensive) and the hardware (shared disks, node interconnect) to build an Oracle RAC.

Chris