Has anyone else seen a huge slowdown Oracle Gateway connections to SQL Server when moving from Gateway 11g to 12c?
Date: Fri, 1 Nov 2019 15:42:17 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F762ED4181_at_PRDTXWPEMLMB32.prod-am.ameritrade.com>
We have an Oracle Gateway connection from a 12.1 Oracle database to a SQL Server 2012 database. It has connected through a separate Windows 2008 Oracle 11.2.0.1 Gateway server for many years with no issues.
We set up a new 12.2.0.1 Oracle Gateway server on Windows 2012 to test but all queries run very slowly and then start hanging. We’re opening a SR but thought I’d ask if anyone here has seen something similar.
On the database side the session shows it’s waiting on HS message to agent.
Could it be an issue with the Gateway being 12.2 and the database being 12.1? I tried to find the certification matrix but metalink said:
Oracle Gateway Release's
The certification matrix for the 11.1, 11.2 and 12c Gateways is now available on OTN from the following URL -
http://www.oracle.com/technetwork/database/gateways/index.html
and that gives an error “We can’t find the page you were looking for”
Any advice appreciated.
Thanks,
Jay Miller
Sr. Oracle DBA
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 01 2019 - 16:42:17 CET