Zhao Yu of Oracle Life

暂无签名

  • 博客访问: 870066
  • 博文数量: 86
  • 用 户 组: 普通用户
  • 注册时间: 2007-12-25 11:07
个人简介

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类

全部博文(86)

文章存档

2010年(4)

2009年(22)

2008年(60)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

分类: Linux

  今天一个朋友用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.




阅读(8402) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~

赵宇2010-02-03 17:18:34

To implement the solution, please execute the following steps: SOLUTION A: 1. Make sure to use a newer gateway distribution CD available online on OTN.oracle.com or edelivery.oracle.com 2. If the g4drsrv and g4drsrvd executable is still not extracted from the source, manually open the filegroup1.jar file located on the CD in \stage\Components\oracle.tg4drda.tcp\10.2.0.1.0\1\DataFiles Open the filegroup1.jar file using WinZIP and manually extract both files into the ORACLE_HOME/bin directory SOLUTION B: 1. Apply the 10.2.0.2 patchset (or newer) right after in

评论热议
请登录后评论。

登录 注册