Oracle Transparent GateWay connect to MYSQL fix BUG

  今天一个朋友用Oracle透明网关连接mysql时碰到这样的错误，之前他的环境是：

网站：PHP+MYSQL5.0  HA LinuxAS3 32bit   

订单系统：LinuxAS3 32bit Oracle10g

透明网关连接完全没有问题，但是OS升级到Red Hat Enterprise Linux AS5后，原来的透明网关不可以。 主要原因是需要升级mysql-connector-odbc-3.51.27-0

[oracle@localhost ~]$ rpm -qa|grep ODBC

unixODBC-2.2.11-7.1

unixODBC-2.2.11-7.1

[oracle@localhost ~]$ rpm -qa|grep mysql

mysql-connector-odbc-3.51.27-0

mysql-connector-odbc-3.51.27-0

[oracle@localhost ~]$

朋友升级以后，报了个新问题：

SQL> select * from ysj@yaofang;     

select * from ysj@yaofang

                  *

ERROR at line 1:

ORA-28545: error diagnosed by Net8 when connecting to an agent

Unable to retrieve text of NETWORK/NCR message 65535

ORA-02063: preceding 2 lines from YAOFANG

查了一下原因，是Oracle 10.2.0.1的一个bug

Oracle came up with a solution, from a related bug (metalink bug 5550614) - it
is to do with bigints afflicting the results of selects.

Support recommended applying patch 4547817 (to get to oracle 10.2.0.2) and 5550614 (to
fix the problem). Apparently the fix has made it into the 10.2.0.4 patchset so will be
fixed when that is released.

I've applied the patches 4547817/5550614 and can confirm that it's fixed.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/175005/viewspace-626759/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/175005/viewspace-626759/