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
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
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
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
prod = (description=
(address_list=
(failover=ON)
(load_balance=OFF)
(address=...) = points to primary db
(address=...) = points to standby db
)