ITPub博客

Oracle Transparent GateWay connect to MYSQL fix BUG

原创 作者:赵宇 时间:2010-02-03 17:02:21 0 删除 编辑
  今天一个朋友用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.




请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-25

  • 博文量
    73
  • 访问量
    891178