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: [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).
RE: Microsoft Transaction Server Standby database problem
Thanks, We tried this syntax in our test environment and it worked very well but of course had no way of knowing if it solved our problem since that didn't show up in the test environment even in normal circumstances. Have you actually had experience using this when Microsoft Transaction Server wasn't switching the way it should and this resolved the issue? Thanks! Jay -Original Message- Sent: Friday, May 17, 2002 8:43 PM To: Multiple recipients of list ORACLE-L prod = (description= (address_list= (failover=ON) (load_balance=OFF) (address=...) = points to primary db (address=...) = points to standby db ) (connect_data=(service_name=prod) ) ) The ADDRESS_LIST= stuff has worked since the 7.2 time-frame, though I think the FAILOVER= and LOAD_BALANCE= syntax was added with 8.0; it was just for failover functionality originally. Of course, the SERVICE_NAME= stuff didn't happen until Oracle8i; before that it was SID= only... The key to the FAILOVER=ON functionality working correctly is the death of the SQL*Net listener at the specified port, not the death of the database. Make sure that when the database dies, the SQL*Net listener dies too. Create a sniper process that monitors the database instance and automatically stops the listener if necessary. Or, calls the UNIX halt command... :-) Whatever works... Otherwise, if the database instance is dead but the SQL*Net listener is still running, then this TNS syntax will timeout waiting for a connection rather than just failing over to the next ADDRESS= entry... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 10:33 AM When we switch between production and standby databases our procedure is to change the DNS Name to point to the new ip address. This works perfectly for all our old Powerbuilder client/server apps. However, our connections that go through Microsoft Transaction Server as a middle tier apparently continue to try and connect to the old database until all the services are recycled or the NT boxes are rebooted. This unfortunately adds about a half hour to our downtime as well as requiring several more people to be present when we're doing the switch. Microsoft and Oracle are unanimous in saying it's the other one's fault. Our developers say there's no way of monitoring what's going on in MTS. To make matters more difficult we've been unable to replicate the problem in our test environment. We have someone developing a loadrunner script now in the hopes that a much higher load will cause the problem to show up. There are several things (such as TAF) that we'd like to test to see if it helps but we can't do that until we can replicate the problem. So has anyone else seen this behaviour or (even better!) have a proven solution for it? Thanks, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman 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). -- 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
Re: Microsoft Transaction Server Standby database problem
Sorry, I've never used MS-MTS... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 3:48 PM Thanks, We tried this syntax in our test environment and it worked very well but of course had no way of knowing if it solved our problem since that didn't show up in the test environment even in normal circumstances. Have you actually had experience using this when Microsoft Transaction Server wasn't switching the way it should and this resolved the issue? Thanks! Jay -Original Message- Sent: Friday, May 17, 2002 8:43 PM To: Multiple recipients of list ORACLE-L prod = (description= (address_list= (failover=ON) (load_balance=OFF) (address=...) = points to primary db (address=...) = points to standby db ) (connect_data=(service_name=prod) ) ) The ADDRESS_LIST= stuff has worked since the 7.2 time-frame, though I think the FAILOVER= and LOAD_BALANCE= syntax was added with 8.0; it was just for failover functionality originally. Of course, the SERVICE_NAME= stuff didn't happen until Oracle8i; before that it was SID= only... The key to the FAILOVER=ON functionality working correctly is the death of the SQL*Net listener at the specified port, not the death of the database. Make sure that when the database dies, the SQL*Net listener dies too. Create a sniper process that monitors the database instance and automatically stops the listener if necessary. Or, calls the UNIX halt command... :-) Whatever works... Otherwise, if the database instance is dead but the SQL*Net listener is still running, then this TNS syntax will timeout waiting for a connection rather than just failing over to the next ADDRESS= entry... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 10:33 AM When we switch between production and standby databases our procedure is to change the DNS Name to point to the new ip address. This works perfectly for all our old Powerbuilder client/server apps. However, our connections that go through Microsoft Transaction Server as a middle tier apparently continue to try and connect to the old database until all the services are recycled or the NT boxes are rebooted. This unfortunately adds about a half hour to our downtime as well as requiring several more people to be present when we're doing the switch. Microsoft and Oracle are unanimous in saying it's the other one's fault. Our developers say there's no way of monitoring what's going on in MTS. To make matters more difficult we've been unable to replicate the problem in our test environment. We have someone developing a loadrunner script now in the hopes that a much higher load will cause the problem to show up. There are several things (such as TAF) that we'd like to test to see if it helps but we can't do that until we can replicate the problem. So has anyone else seen this behaviour or (even better!) have a proven solution for it? Thanks, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman 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). -- 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
Microsoft Transaction Server Standby database problem
When we switch between production and standby databases our procedure is to change the DNS Name to point to the new ip address. This works perfectly for all our old Powerbuilder client/server apps. However, our connections that go through Microsoft Transaction Server as a middle tier apparently continue to try and connect to the old database until all the services are recycled or the NT boxes are rebooted. This unfortunately adds about a half hour to our downtime as well as requiring several more people to be present when we're doing the switch. Microsoft and Oracle are unanimous in saying it's the other one's fault. Our developers say there's no way of monitoring what's going on in MTS. To make matters more difficult we've been unable to replicate the problem in our test environment. We have someone developing a loadrunner script now in the hopes that a much higher load will cause the problem to show up. There are several things (such as TAF) that we'd like to test to see if it helps but we can't do that until we can replicate the problem. So has anyone else seen this behaviour or (even better!) have a proven solution for it? Thanks, 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).
Re: Microsoft Transaction Server Standby database problem
prod = (description= (address_list= (failover=ON) (load_balance=OFF) (address=...) = points to primary db (address=...) = points to standby db ) (connect_data=(service_name=prod) ) ) The ADDRESS_LIST= stuff has worked since the 7.2 time-frame, though I think the FAILOVER= and LOAD_BALANCE= syntax was added with 8.0; it was just for failover functionality originally. Of course, the SERVICE_NAME= stuff didn't happen until Oracle8i; before that it was SID= only... The key to the FAILOVER=ON functionality working correctly is the death of the SQL*Net listener at the specified port, not the death of the database. Make sure that when the database dies, the SQL*Net listener dies too. Create a sniper process that monitors the database instance and automatically stops the listener if necessary. Or, calls the UNIX halt command... :-) Whatever works... Otherwise, if the database instance is dead but the SQL*Net listener is still running, then this TNS syntax will timeout waiting for a connection rather than just failing over to the next ADDRESS= entry... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 10:33 AM When we switch between production and standby databases our procedure is to change the DNS Name to point to the new ip address. This works perfectly for all our old Powerbuilder client/server apps. However, our connections that go through Microsoft Transaction Server as a middle tier apparently continue to try and connect to the old database until all the services are recycled or the NT boxes are rebooted. This unfortunately adds about a half hour to our downtime as well as requiring several more people to be present when we're doing the switch. Microsoft and Oracle are unanimous in saying it's the other one's fault. Our developers say there's no way of monitoring what's going on in MTS. To make matters more difficult we've been unable to replicate the problem in our test environment. We have someone developing a loadrunner script now in the hopes that a much higher load will cause the problem to show up. There are several things (such as TAF) that we'd like to test to see if it helps but we can't do that until we can replicate the problem. So has anyone else seen this behaviour or (even better!) have a proven solution for it? Thanks, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman 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).