| Failover mechanism delay [message #64154] |
Wed, 22 December 2004 19:11 |
Pushparaj
Messages: 4
Registered: May 2002
|
Junior Member |
|
|
We have an issue with the failover mechanism in our application.
Tnsnames.ora looks similar to
APPL.WORLD =
(DESCRIPTION_LIST =
(DESCRIPTION = (LOAD_BALANCE = ON)(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(Host =xxx.xxx.xxx.xxx)(Port = 1521))
(CONNECT_DATA = (SID = DB1)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(BACKUP= APPL.world))))
(DESCRIPTION = (LOAD_BALANCE = ON)(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(Host =xxx.xxx.xxx.xxx)(Port = 1521))
(CONNECT_DATA = (SID = DB1)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(BACKUP= APPL.world))))
(DESCRIPTION = (LOAD_BALANCE = ON)(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(Host =xxx.xxx.xxx.xxx)(Port = 1521))
(CONNECT_DATA = (SID = DB2)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(BACKUP= APPL.world))))
(DESCRIPTION = (LOAD_BALANCE = ON)(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(Host =xxx.xxx.xxx.xxx)(Port = 1521))
(CONNECT_DATA = (SID = DB3)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(BACKUP= APPL.world))))
(DESCRIPTION = (LOAD_BALANCE = ON)(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(Host =xxx.xxx.xxx.xxx)(Port = 1521))
(CONNECT_DATA = (SID = DB3)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(BACKUP= APPL.world))))
)
The hosts here are unix machine running database instances.
It has been found if a particular unix machine running a instance of database goes down or crashes, it takes significant time to return a error message.
This causes the failover mechanism not to trigger till an actual error code is returned back by a call.
Has any one ever encountered any such error? If yes, what is the way ahead to investigate and resolve.
This problem is not encountered when the actual database goes down. It only happens when the machine goes down.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
