由于业务需要oracle要连sqlserver
我按照资料提示做了如下修改
listener.ora
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = tg4msql)
(ORACLE_HOME = D:\oracle\ora92) )
inittg4msql.ora
HS_FDS_CONNECT_INFO="SERVER=127.0.0.1;DATABASE=smgp"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVERtnsnames.ora
tg4msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =***.***.***.***)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
(SERVER = DEDICATED)
)
)
重启后
建dblink后测试
提示
ora-28546 连接初始化失败,可能势NET8管理错误
ora-02068 以下严重错误源于link_sql
ora-03113 通信通道的文件结束
我按照资料提示做了如下修改
listener.ora
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = tg4msql)
(ORACLE_HOME = D:\oracle\ora92) )
inittg4msql.ora
HS_FDS_CONNECT_INFO="SERVER=127.0.0.1;DATABASE=smgp"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVERtnsnames.ora
tg4msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =***.***.***.***)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
(SERVER = DEDICATED)
)
)
重启后
建dblink后测试
提示
ora-28546 连接初始化失败,可能势NET8管理错误
ora-02068 以下严重错误源于link_sql
ora-03113 通信通道的文件结束
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货