Cluster and databases

[Vladimir Fabecic]

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

[Wim Van den Wyngaert · Accepted solution]

I have something simular.
See enclosure.

XFBSALP is the alias.

Wim

[Jan van den Ende]

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

[labadie_1]

Win I can't open your attachment.

[Wim Van den Wyngaert]

Gerard,

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

Wim

[Jan van den Ende]

Gerard,

I can simply open Wim's attachment.

fwiw

Proost.

Have one on me.

jpe

[Hein van den Heuvel]

[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.

[Vladimir Fabecic]

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?