![3535daa66d687d64c749aaeaf0e59ae4.png](https://i-blog.csdnimg.cn/blog_migrate/f0509df1ca3aebde39fbedb77388f9e4.jpeg)
报错如下:
SQL> select * from t@mstest;
select * from t@test
*
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 MSSQL
解决办法:
说明:sqlserver版本为2008
gateway版本为11.2.0.4。
sqlserver端的listener中将program的值写成了tg4msql。11g版本应该为dg4msql,10g版本中为tg4msql
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:product11.2.0tg_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = C:product11.2.0tg_1)
(PROGRAM = dg4msql)
)
)
再次执行成功
![7f7067b520412b19dd31e43bd94b9bc1.png](https://i-blog.csdnimg.cn/blog_migrate/270def1271d4fee6f2d1229d946a0d27.jpeg)
oracle gateway透明网关详细安装步骤可联系重庆思庄