How-To: "Listener" High Availability?

[Rookie]

I'm trying to configure databases high availability within HP9000 Cluster (Two nodes).
When node A fails, its database file systems are mounted in node B but I cannot access the node B database. I added both hosts names and oracle_sid's in each listener.ora file, but I cannot see the instance when I do "ps - eaf|grep pmon"; however when I try to startup the database manually It says database is already running and when trying to stop it I get "database not mounted".

Here is how I configured my hosts in listener.ora:

SQLNET.AUTENTICATION_SERVICES = (BEQ,NONE)
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(HOST = HostA)(PORT = 1521))


(ADDRESS= (PROTOCOL= TCP)(HOST = HostB)(PORT = 1526))

...But I saw an example somewhere like this:

LISTENER =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL=tcp)
(HOST=)
(PORT=1521)
(COMMUNITY=UK_SUP_TCPIP)
)
(ADDRESS =
(PROTOCOL=ipc)
(KEY=700)
(COMMUNITY=UK_SUP_TCPIP)
)
)

I didn't try this way cause I didn't know what is that Key=700.

Any suggestions please ???

[John Palmer]

Hi,

You need to configure your Serviceguard Package to have its own 'floating' IP address and configure the listener to listen on that address only.

Let me know if you need full details on how to configure this.

Regards,
John

[Pramod_4]

Hi,

There is an IP associated with each package configured in MC/SG to make the package failover transparent to the end user and this IP is know as floating IP address.

This IP would be boud to the system on which the concerned package is running ( done by MC/SG control script) and all the user/application package must use this IP address for transparency.

From your input it seems that you haven't configured any floating IP with the package ( oracle) and you are using the IP address of the primary system in your package ( oracle ) configuration file.

You need to configure the Floating IP address in your control script and use that IP in your oracle config file instead of Host A IP address.

Refer the docs at http://www.docs.hp.com/hpux/onlinedocs/B3936-90026/B3936-90026.html for more informations.

Regards,

Pramod