小弟原来配置了一个透明网关,但是在台式机配置的,后来出问题了,现在改到服务器上了,但是配置完成 查询语句一直处于执行状态,没有数据返回,而且对应的SQLSERVER数据库也没死锁。
initdg4msql.ora 内容如下
HS_FDS_CONNECT_INFO=[203.203.203.14]/MSSQLSERVER/hrp_run
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
listener.ora内容如下
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=E:\product\11.2.0\tg_1)
(PROGRAM=dg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.99)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = E:\product\11.2.0\tg_1
tnsnames.ora
SQLSERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.99 )(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = dg4msql)
)
(HS = OK)
)
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)
SELECT * FROM GY_TEST@SQLSERVER
create public database link HISSQL
connect to sa identified by "xt-xy"
using '(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.1.99)(PORT=1521))
(CONNECT_DATA=(SID=dg4msql))
(HS=OK)
)';
SELECT * FROM GY_TEST@HISSQL 这种方式执行一直处于执行状态不返回结果
create database link HISSQLZS
connect to sa identified by "xt-xy"
using 'SQLSERVER';
SELECT * FROM GY_TEST@HISSQLZS 这种方式提示TNS无法解析指定的连接标识符
在网上找了好多方法,都没能解决这个问题,希望哪位大神给知道一下