Oracle Transparent GateWay connect to MYSQL fix BUG

趙宇發表於2010-02-03
OracleGatewayMySql
  今天一個朋友用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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章