--
On Sun, 26 Aug 2001 23:10:20
Paul Drake wrote:
>Andrey Bronfin wrote:
>>
>> Hi Paul !
>> Thanks a lot for your reply .
>> This is a production DB and can not be upgraded right now.
>>
>> DBAndrey
>>
>> * 03-9254520
>> * 053-464562
>> * mailto:andreyb_at_elrontelesoft.com
>>
>
>You could probably run ONames on a different box, different version - if
>that helps.
>
>
>> -----Original Message-----
>> Sent: Thursday, August 23, 2001 8:06 PM
>> To: Multiple recipients of list ORACLE-L
>>
>> Hi.
>>
>> I would highly recommend the book (its my current train reading)
>>
>> "Oracle Net8 Configuration and Troubleshooting"
>> By Jonathan Gennick and Hugo Toledo - O'Reilly
>> January 2001
>>
>> Chapter 8 - Load Balancing and Failover covers this subject in detail for
>> Oracle 8.1.6.0.0.
>> You can specify that the client only connects to OPS1, fails over to OPS2.
>> I do not know anything about how well this works back on 8.0.5.
>> Are you using Oracle Names?
>>
>> What you want to do is only specify one connect descriptor for the initial
>> connect,
>> and specify a failover descriptor - using TAF. Again, I have only read the
>> docs for 8.1.6 - and not the 8.0 series.
>>
>> Again - 8.0.6 is de-supported next month.
>> Why not get this working on 8.1.7?
>> You'll have much better features and fewer bugs on 8.1.7.
>>
>> hth,
>>
>> Paul
>>
>> Paul Drake
>> DBA/SysAdmin
>> Encoda Systems, Inc.
>>
>> -------- Original Message --------
>> Date: Thu, 23 Aug 2001 09:06:06 -0800
>> Reply-To: ORACLE-L_at_fatcity.com
>> Organization: Fat City Network Services, San Diego, California
>> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>
>> Dear list !
>> I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
>> I want the clients to connect to the instance OPS1 and , if OPS1 becomes
>> unavailable , to connect to OPS2 .
>> The Oracle version is 8.0.5
>> I put the following lines in clients' tnsnames.ora file :
>>
>> OPS.world = (DESCRIPTION_LIST =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
>> (CONNECT_DATA = (SID = OPS1))
>> )
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
>> (CONNECT_DATA = (SID = OPS2))
>> )
>> )
>>
>> The problem is that when both the instances are up and running , it
>> looks
>> like clients connect to one of the instances randomly .
>> How can i ensure that they will try to connect to OPS1 first , and only
>> if
>> it is unavailable , they'll connect to OPS2.
>>
>> Thanks a lot in advance .
>>
>> DBAndrey
>> mailto:andreyb_at_elrontelesoft.com
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Andrey Bronfin
>> INET: andreyb_at_elrontelesoft.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> 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).
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Paul Drake
>> INET: drake_at_psscorp.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> 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).
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Andrey Bronfin
>> INET: andreyb_at_elrontelesoft.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> 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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Drake
> INET: paled_at_home.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
>
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: viraj999_at_lycos.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Mon Aug 27 2001 - 01:31:25 CDT
