Re: RAC and hostnames

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 13 Aug 2008 13:20:40 -0700
Message-ID: <1218658832.77806@bubbleator.drizzle.com>


Loial wrote:
> We have a customer running our application in a RAC cluster. The
> application runs on the database server and accesses an oracle
> database.
>
> Our application has the server hostname configured when installed.
> Customer says that in a failover scenrio that hostname will change.
> Is
> this the case?
>
>
> What can I do to ensure that our application runs Ok in failover
> without having to amend the hostname that it references?
>
>
> My knowledge of RAC is zer0.

Here is what we need to know to understand what you are doing:

  1. Oracle version (3 decimal places)
  2. Is failover being done with TAF or FCF
  3. Is connection using VIPs (Virtual IP Addresses)

There is a sample TNSNAMES.ORA file for a RAC cluster in Morgan's Library at www.psoug.org under "REAL APPLICATION CLUSTERS." Look at how the host has been configured ... the host name does not even enter into the picture.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Aug 13 2008 - 15:20:40 CDT

Original text of this message