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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).