我使用tg4sybs作为需要连接到的SYBASE库的SID,修改ORACLE透明网关的inittg4sybs.ora文件,
增加如下语句:HS_FDS_CONNECT_INFO=test_sybase.testdb,修改ORACLE SERVER的listener.ora
文件,增加如下语句:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = tg4sybs)
(SID_NAME = tg4sybs)
(ORACLE_HOME = f:\oracle\ora9i)
)
)
修改ORACLE SERVER的ltnsnames.ora文件,增加如下语句:
SYBASE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4sybs)
(HS = OK)
)
)
以上配置完成并重启ORACLE后在ORACLE中创建到SYBASE库的DATABASE LINK,在使用该DB LINK
连接SYBASE库时出现以下错误(使用SYBASE的DSEDIT测试SYBASE库能够正常连接):
ORA-28500:连接ORACLE到非ORACLE系统时返回此信息:
[Transparent gateway for SYBASE]ct_connect():network packet layer:
internal net library error:Net-Library operation terminated due to disconnect希望各位大虾帮我分析一下原因以及怎么解决,急!!!
增加如下语句:HS_FDS_CONNECT_INFO=test_sybase.testdb,修改ORACLE SERVER的listener.ora
文件,增加如下语句:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = tg4sybs)
(SID_NAME = tg4sybs)
(ORACLE_HOME = f:\oracle\ora9i)
)
)
修改ORACLE SERVER的ltnsnames.ora文件,增加如下语句:
SYBASE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4sybs)
(HS = OK)
)
)
以上配置完成并重启ORACLE后在ORACLE中创建到SYBASE库的DATABASE LINK,在使用该DB LINK
连接SYBASE库时出现以下错误(使用SYBASE的DSEDIT测试SYBASE库能够正常连接):
ORA-28500:连接ORACLE到非ORACLE系统时返回此信息:
[Transparent gateway for SYBASE]ct_connect():network packet layer:
internal net library error:Net-Library operation terminated due to disconnect希望各位大虾帮我分析一下原因以及怎么解决,急!!!
最后要改成下面这种显示,
set SYBASE="c:\\sybase" (用双引号,和双斜杠)