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)这是怎么回事啊?愁死人了...
#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)这是怎么回事啊?愁死人了...
解决方案 »
- oracle在给表空间添加数据文件时报错
- 帮新手小弟优化下语句
- 一个扫qlplus调用存储过程(带参数)的问题
- 大家好,我想问一个两个oracle数据库通讯的问题
- oracle 函数问题:java.sql.SQLException:ORA-01000:超出打开游标的最大数
- 有两道 sql 练习题不明白,求大神们指教
- 请教如何在这个表上建索引?
- 如何向表中插入日期数据?
- 谁买过正版的Oracle吗?我请他喝茶。
- 怎么样才能在linux操作系统下新建普通用户并且可以访问oracle
- 在哪里可以下载oracle 11g forms builder,急>>>>>>>>>>>>
- 请教一个sql的写法,关于group by分组后再进一步处理?
ORA-02063: preceding line from <name of a database link>This also happens when a select is issued over a database link, and not a
distributed transaction
Solution Description
--------------------The ORA-2063 indicates that this must be done at the remote database.
Explanation
-----------When the error is generated at the remote database it is accompanied with an
ORA-2063. In this case the parameter distributed_transactions must be increased
at the remote database.If there is no ORA-2063 the parameter distributed_transactions must be
increased at the local database.In a distributed environment, if a select is issued in a session without the
SET TRANSACTION READ ONLY command, the select query is considered a
distributed transaction.If the parameter distributed_transactions is set too low, this too will result in an ORA-2042 and ORA-2063
在SQL Plus里先
SET TRANSACTION READ ONLY
再SELECT
或加大distributed_transactions参数
是在创建dnlink之前加吗?还是在什么地方加?
distributed_transactions的值应该加大为多少啊?
是在init.ora里加吗?
distributed_transactions改为146
出发的错误还是一样的。
我装完oralce9i怎么没有sqlnet.ora文件啊