Re: Oracle db on os cluster
From: Palooka <nobody_at_nowhere.invalid>
Date: Sun, 15 Nov 2009 00:49:03 +0000
Message-ID: <4eILm.54113$kH2.40209_at_newsfe04.ams2>
On 14/11/09 23:25, vsevolod afanassiev wrote:
>> 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).
Disagree, Get your Unix admins/network people to set up a name which points to the virtual IP address. If they are half competent, they should have done that already anyway.
Date: Sun, 15 Nov 2009 00:49:03 +0000
Message-ID: <4eILm.54113$kH2.40209_at_newsfe04.ams2>
On 14/11/09 23:25, vsevolod afanassiev wrote:
>> 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).
Disagree, Get your Unix admins/network people to set up a name which points to the virtual IP address. If they are half competent, they should have done that already anyway.
Hard coding IP addresses (virtual or otherwise) in listener.ora and tnsnames.ora is a *bad* idea.
Palooka Received on Sat Nov 14 2009 - 18:49:03 CST