oracle90透明网关设置问题。在线等。急啊...
inittg4msql.ora文件
#HS_FDS_CONNECT_INFO="SERVER=10.61.136.196;DATABASE=dsn"
HS_FDS_CONNECT_INFO=10.61.136.196.dsn
HS_FDS_TRACE_LEVEL=DEBUG
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER两个HS_FDS_CONNECT_INFO都试过了,都不行。listener.ora文件
# LISTENER.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.61.136.156)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oradb)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = oradb)
)
(SID_DESC=
(SID_NAME=tg4msql)
(ORACLE_HOME=C:\oracle\ora90)
(PROGRAM=tg4msql)
)
)tnsnames.ora文件
####################################
# TNSNAMES.ORA Configuration File:C:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Tue Mar 24 15:38:44 CST 2009
####################################TG4MSQL =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.61.136.156)(PORT=1521))
)
(CONNECT_DATA=(SID=tg4msql))(HS=OK)
)
ORADB_10.61.136.158 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.61.136.158)(PORT = 1521))
)
(CONNECT_DATA = (SID = oradb)(SERVER = DEDICATED))
)ORADB_10.61.136.156 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.61.136.156)(PORT = 1521))
)
(CONNECT_DATA = (SID = oradb)(SERVER = DEDICATED))
)create database link TG4MSQL connect to ZJGC identified by ZJGC using 'TG4MSQL';
select "dptcode" from dsndy_dpt@TG4MSQL;
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL]DRV_InitTdp: Could not open MS-SQL Connection
ORA-02063: 紧接着2 lines(源于TG4MSQL)这是怎么回事啊?愁死人了...
inittg4msql.ora文件
#HS_FDS_CONNECT_INFO="SERVER=10.61.136.196;DATABASE=dsn"
HS_FDS_CONNECT_INFO=10.61.136.196.dsn
HS_FDS_TRACE_LEVEL=DEBUG
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER两个HS_FDS_CONNECT_INFO都试过了,都不行。listener.ora文件
# LISTENER.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.61.136.156)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oradb)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = oradb)
)
(SID_DESC=
(SID_NAME=tg4msql)
(ORACLE_HOME=C:\oracle\ora90)
(PROGRAM=tg4msql)
)
)tnsnames.ora文件
####################################
# TNSNAMES.ORA Configuration File:C:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Tue Mar 24 15:38:44 CST 2009
####################################TG4MSQL =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.61.136.156)(PORT=1521))
)
(CONNECT_DATA=(SID=tg4msql))(HS=OK)
)
ORADB_10.61.136.158 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.61.136.158)(PORT = 1521))
)
(CONNECT_DATA = (SID = oradb)(SERVER = DEDICATED))
)ORADB_10.61.136.156 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.61.136.156)(PORT = 1521))
)
(CONNECT_DATA = (SID = oradb)(SERVER = DEDICATED))
)create database link TG4MSQL connect to ZJGC identified by ZJGC using 'TG4MSQL';
select "dptcode" from dsndy_dpt@TG4MSQL;
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL]DRV_InitTdp: Could not open MS-SQL Connection
ORA-02063: 紧接着2 lines(源于TG4MSQL)这是怎么回事啊?愁死人了...
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货