Home » RDBMS Server » Networking and Gateways » SQLNET loadbalancing and failover
SQLNET loadbalancing and failover [message #367698] Thu, 18 November 1999 17:32
Will Luttrell
Messages: 1
Registered: November 1999
Junior Member
Problem Description:
we have the following stanza in our tnsnames
file on aclient application machine. Our
goal is to have our application firsttry
the instance 'ci05' on machine 'alphadb5', and
then, in the event offailure, try 'ci01' on
alphadb1. What we are seeing instead israndom
placement of the client application to either
machine (instead of theparticular order.)
We are running on single-threaded machines.
Can youhelp?

Contact me via :EMAIL -> will@commerceinc.com

18-NOV-99 20:37:18 GMT

New info : This is the stanza that is not
behaving as desired:

search_dbs=
(DESCRIPTION_LIST =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE=OFF)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=TCP)(Host= somehost1.commerceinc.com)(Port= 1521
))

)
(CONNECT_DATA= (SID = somehost1))
)
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE=OFF)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=TCP)(Host= somehost2.commerceinc.com)(Port= 1521
))

)
(CONNECT_DATA= (SID =somehost2))
)
)

18-NOV-99 21:27:14 GMT

New info : Furthermore, this stanza isn't provid-
ing true failover protection. If I
break the tnsnames stanza with dummy
values, it fails over fine, butif
I unplug one of the machines, any
connection attempt to the machine in
thestanza simply hangs indefinitely.
All the literature I've read implies
thatyou can't have true failover/load-
balancing unless all instances havethe
same SID. However, if global_names is
set to true, which oracle
recommends in
a multi-server environment, that means
that all sid's must bedifferent, right?

Confused. . .

-will
Previous Topic: Obtaining SQL *Net 2.x
Next Topic: Oracle & Netscape... HELP!!!!
Goto Forum:
  


Current Time: Fri Mar 29 10:46:15 CDT 2024