Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RAC - setting up failover and load_balance

Re: RAC - setting up failover and load_balance

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 26 Aug 2003 17:54:27 -0800
Message-ID: <F001.005CD58C.20030826175427@fatcity.com>


...it would also help to spell ≥secondary≤ correctly in the ≥BACKUP=≤ clause...

on 8/26/03 3:24 PM, Mladen Gogala at mladen_at_wangtrading.com wrote:

> Well, that is because of your understanding of the word "failover". Don't be
> confused, there are other words
> in desperate need of redefinition, too. One of them is "unbreakable".
> To make the long story short, "FAILOVER=ON"  makes possible for Oracle*Net to
> skip the non-functioning
> TNS descriptor, not that the application should simply fail over and continue
> from another node. The application
> will simply fail, without the desired "over", unless it's written using OCI,
> which is the only means for an
> application to resume on one of the surviving nodes. In other words, it is the
> TNS descriptor that "fails over",
> not your application. I hope that things are clearer now.
>  
>  
> --
> Mladen Gogala
> Oracle DBA 

>> -----Original Message-----
>> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On Behalf Of laura
>> pena
>> Sent: Tuesday, August 26, 2003 5:49 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: RAC - setting up failover and load_balance
>>
>> So I have RAC setup ( Solaris 2.8 , Veritas DBE/AC 3.5 MP1 and HDS disks if
>> you are interested) and I am attempting to setup my failover and
>> loadbalancing from a client.
>>
>>
>> I brought down VLDBN1
>> and Thought I should fail over to VLDB2 ... but I did not.
>>
>>
>> Here is what I have in my tnsnames.ora:
>>
>> VLDB =
>> (DESCRIPTION =
>> (FAILOVER=ON)
>> (LOAD_BALANCE = yes)
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.25)(PORT = 1521))
>> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))
>> )
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = VLDBN2)
>> (FAILOVER_MODE=
>> (BACKUP=SECONDAY)
>> (TYPE=select)
>> (METHOD=basic)
>> (RETRIES=5)
>> (DELAY=5)
>> )
>> )
>> )
>> SECONDARY =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))
>> (CONNECT_DATA =
>> (SERVICE_NAME = VLDBN2)
>> )
>> )
>>
>> Any ideas?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Aug 26 2003 - 20:54:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US