| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
