| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Solution to Microsoft Transaction Server/Standby database problem
Some of you may recall a question I posted on a problem with MTS connection
pooling. MTS continued to try to connect to our old IP address after
switching between production and standby. This happened even though we
switched the IP address the DNS Name was pointing to.
Well, we finally managed to replicate the problem in our test environment through using a loadrunner script so it is a load related issue. Even better, using a TAF entry in the tnsnames.ora resolves most of the problem, although it takes several (i.e., app. 2-3) minutes for the switchover to take effect for all connections. Still not certain what's happening in that time period, but it works!
If we ever manage to figure out why the problem is happening I'll post again, but wanted to post this now in case anyone else has similar issues.
Jay Miller
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
INET: JayMiller_at_TDWaterhouse.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 Jun 03 2002 - 11:43:35 CDT
 |
 |