Sorry, I've never used MS-MTS...
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
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" <ORACLE-L_at_fatcity.com>
> 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: 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Gorman
> INET: Tim_at_SageLogix.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).
> --
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: Tim_at_SageLogix.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 May 20 2002 - 17:18:23 CDT
