topic Re: Cluster and databases in Operating System - OpenVMS

Cluster and databases

Vladimir Fabecic — Tue, 05 Sep 2006 02:09:31 GMT

Hello
I am about to install few two node clusters and one four node VMS cluster. Those clusters have to run several single instance Oracle databases (failover mode).
My idea was to create ip alias on node before starting database and configure listener to use ip alias address. So each database can be started on any member with no difference to users. Every database instance would have its own ip alias address.
The question is how would you do it.
Is my idea OK? Does anybody have better idea?
Thanks

Re: Cluster and databases

Wim Van den Wyngaert — Tue, 05 Sep 2006 02:23:04 GMT

I have something simular.
See enclosure.

XFBSALP is the alias.

Wim

Re: Cluster and databases

Jan van den Ende — Tue, 05 Sep 2006 03:29:13 GMT

Vladimir,

that would work.

I do not know your site(s) so the next may or may not apply, but if it does, or may in the future:

As the alias, just use the APPLICATION name. If the desire arises (maybe even only temporarily, eg during upgrades) than just add another app name, and you will be able to vary those independently.
We have about a dozen apps on our cluster, and it is VERY convenient to be able to change the DNS translations if, when, and as desired. And it is fully transparant to the users!

hth

Proost.

Have one on me.

jpe

Re: Cluster and databases

labadie_1 — Tue, 05 Sep 2006 04:17:58 GMT

Win I can't open your attachment.

Re: Cluster and databases

Wim Van den Wyngaert — Tue, 05 Sep 2006 04:21:15 GMT

Gerard,

It's simply a txt file. Tried it and it works.

Wim

Re: Cluster and databases

Jan van den Ende — Tue, 05 Sep 2006 04:30:15 GMT

Gerard,

I can simply open Wim's attachment.

fwiw

Proost.

Have one on me.

jpe

Re: Cluster and databases

Hein van den Heuvel — Tue, 05 Sep 2006 06:05:06 GMT

[The attachment works for me]

>> Does anybody have better idea?

rtfm:
"Oracle9i Net Services
Administratorâ s Guide
Release 2 (9.2) March 2002 Part No. A96580-01

15 Enabling Advanced Features for Oracle Net
Services
:
TAF instructs Oracle Net to fail over a failed connection to a different listener.
This enables the user to continue to work using the new connection as if the original
connection had never failed.
:
FAILOVER_MODE..."

While this is mostly for RAC, the basic STANDBY mode should work for cold started single instances... after a failing connection attempt to the preferred node

fwiw,
Hein.

Re: Cluster and databases

Vladimir Fabecic — Tue, 05 Sep 2006 07:51:59 GMT

Thanks
Forgot to say: it is Oracle 8.1.7 envirement and few minutes of database downtime is acceptable. Problem are some old applications that can not use advanced stuff of later versions.
Can you post some DCL procedure for automatic failover of instance.
Do you use cluster generic batch que for starting procedure or some other way?