oracle 11g 透明网关连接mssql 2005报错？？？
通过oracle 11g 连接mssql 2005 报下面的错误
select * from maintanance@mssql
*
第 1 行出现错误:
ORA-28545: 连接代理时 Net8 诊断到错误
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: 紧接着 2 lines (起自 MSSQL)
oracle 11g listener.ora配置如下：
# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=UniteAlarm)
(ORACLE_HOME=D:\app\Administrator\product\11.1.0\db_1)
(ENVS=LD_LIBRARY_PATH=D:\app\Administrator\OraGtw11g_home1\dg4msql\driver\lib;D:\app\Administrator\product\11.1.0\db_1\LIB)
(PROGRAM=dg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = aRong)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
oracle 11g tnsnames.ora配置如下：
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
UniteAlarm =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST= aRong)(PORT=1521))
)
(CONNECT_DATA =
(SID = UniteAlarm)
)
(HS=OK)
)
其中，UniteAlarm是要连接的mssql的数据库，透明网关D:\app\Administrator\OraGtw11g_home1\dg4msql\admin下面的配置文件initUniteAlarm.ora如下：
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO="SERVER=10.147.51.156;DATABASE=UniteAlarm"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
请高手帮忙解决下，多谢！！！
相关文档：
oracle的分析函数over 及开窗函数
一：分析函数over
Oracle从8.1.6开始提供分析函数，分析函数用于计算基于组的某种聚合值，它和聚合函数的不同之处是
对于每个组返回多行，而聚合函数对于每个组只返回一行。
下面通过几个例子来说明其应用。 &nb ......
收集的几条在oracle中通过connect by prior来实现递归查询
Start with...Connect By子句递归查询一般用于一个表维护树形结构的应用。
创建示例表：
CREATE TABLE TBL_TEST
(
ID NUMBER,
NAME VARCHAR2(100 BYTE),
PID NUMBER ......
一,INSERT
1.为了不打乱原来的表的数据,所以备份原来的数据.
create table emp2 as select * from emp
create table emp3 as select * from emp
create table dept2 as select * from dept
create table salgrade2 as select * from salgrade
2.查看表的设计情况:desc dept2;表示查看表dept2的设计情况.
3.插入数据� ......
表1：temp1
AA BB CC
1 1 1
1 1 2
1 1 3
表2：temp2
AA BB ......
