The overwhelming majority of the replies stated that OPS (Oracle Parallel
Server) is required in configurations where there are one or more nodes
running an instance that accesses the same database. Also, there were
several warnings against using OPS on TC 5.0 until TC 5.0A is available.
....................
FROM: Rick Greene" <GREENER_at_labs.wyeth.com>
I've not moved to 5.0 yet, but I can speak about Oracle and Tru64 failover
from the 1.4-1.5 versions.
Depending on the failover scenario you want to use, you don't neccessarily
have to use OPS. OPS is only needed if you want to be able to access the
database from two servers at the same time. The way we have things
implemented, is we are using the TruCluster 1.5 "Disk Service" to put up the
filesystems on one server, and run the database on that server only. If
something happens that should cause the primary server to fail, we move the
disk service over the other server and start a new instance.
The drawback to this method is that end users will have a period when they
cannot access the database at all...depending on the nature of the
filesystem and disk structures you build, it can be a fairly quick
turnaround...less than 5 minutes. OPS would enable users to reconnect to
the database immediately, however any activity that was in-process (queries,
updates) on the failed server would still be lost (I'm not a DBA, so I can't
tell you exactly how OPS handles interrupted transactions in this
situation).
Now, one final caveat...as far as I know OPS requires RAW
PARTITIONS....meaning DRD services. It has its own lock manager which it
applies against the DRD partitions.
....................
FROM: Dr. Tom Blinn, 603-884-0646" <tpb_at_doctor.zk3.dec.com>
I passed your question along to one of our TruCluster product managers
who is technical enough to understand it, and he wrote:
------- Forwarded Message
If you want multiple Oracle instances, you need OPS. If you want vanilla
Oracle and HA, then you do failover scripting with V5.0x TCR just like
you did with ASE 1.6.
------- End of Forwarded Message
....................
FROM: Vipin Gokhale <vgokhale_at_us.oracle.com>
No. You need Oracle Parallel Server if there's ever a case where a given
database on disk is manipulated by two or more Oracle servers running on
different nodes in the cluster. The only thing Cluster Filesystem gives you
is
the ability to place the database on a file system rather than on raw disks
(as
you'd need to without a cluster filesystem). If good performance is a
requirement, I'd recommend holding off on puting database files on CFS until
V5.0-A release of Tru64.
For failover purposes, you can, however run an Oracle instance on one node
(and
ONLY ONE node at any given point in time) in the cluster; but when that node
crashes (or even gracefully shutdown) restart the Oracle instance on another
surviving cluster member.
....................
Thanks to the following:
Rick Greene" <GREENER_at_labs.wyeth.com>
Dr. Tom Blinn, 603-884-0646" <tpb_at_doctor.zk3.dec.com>
Thomas Strandenaes" <thomas.strandenaes_at_adm.uit.no>
Vipin Gokhale <vgokhale_at_us.oracle.com>
Haesaerts, Corinne" <Corinne.Haesaerts_at_compaq.com>
Davis, Alan" <Davis_at_Tessco.Com>
Joe Ledesma <6787187_at_usa.net>
Lars Bro" <lbr_at_nettest.dk>
Edgardo S. Safranchik" <esafran_at_aluar.com.ar>
...and many others.
Allen Belk
| Allen Belk, Systems Manager
| Office of Technology Resources
| University of Southern Mississippi
| allen.belk_at_usm.edu 601.266.6013
----- Original Message -----
From: "Allen Belk" <allen.belk_at_usm.edu>
To: "tru64" <tru64-unix-managers_at_ornl.gov>
Sent: Thursday, January 20, 2000 2:01 PM
Subject: TruCluster 5.0 and Oracle
> Managers,
> Our organization is considering clustering our Oracle database servers
> for high availability purposes. We have foregone this option in the past
> due to the need for the highly complex Oracle Parallel Server. With TC
5.0
> and its inherent shared filesystem, is it possible to cluster Oracle DB
> servers without using Oracle Parallel Server?
>
> Thanks,
>
> Allen Belk
>
> | Allen Belk, Systems Manager
> | Office of Technology Resources
> | University of Southern Mississippi
> | allen.belk_at_usm.edu 601.266.6013
>
>
>
Received on Fri Jan 21 2000 - 14:27:35 NZDT