Re: Oracle db on os cluster

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Sat, 14 Nov 2009 15:25:24 -0800 (PST)
Message-ID: <ff2dbdeb-2497-4ff3-a337-846a8355a695_at_y28g2000prd.googlegroups.com>

> Virtual ip gets
> switched but not the hostname.

This means that you need to use this virtual IP and not hostname:

- in listener.ora
- in tnsnames.ora on the database server
- in tnsnames.ora on the application server
- in configuration files used by thin JDBC driver if your application

is java-based
- when configuring backup (Legato Networker/Veritas Netbackup) and monitoring (Open View, etc)

If your application is ruconnects to the database using JDBC connection pool (or .Net connection pool) then it should re-connect automatically.

You also need to minimize time it takes to bring the database up on the failover node (parameter fast_start_mttr_target). Received on Sat Nov 14 2009 - 17:25:24 CST