freetds.conf 配置 41 # A typical oracle server
42 [oracle]
43 host = 192.168.1.6
44 port = 1521
45 tds version = 5.0
46 client charset = UTF-8
47连接出现下面问题
[root@localhost freetds-0.95.0]# tsql -S oracle -U ycx -P 123456
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
There was a problem connecting to the server服务器抓包:192.168.1.6 是服务器
2997.764369 192.168.1.20 -> 192.168.1.6 TCP 45269 > ncube-lm [SYN] Seq=0 Win=14600 Len=0 MSS=1460 TSV=642204486 TSER=0 WS=7
2997.764402 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [SYN, ACK] Seq=0 Ack=1 Win=5792 Len=0 MSS=1460 TSV=160472000 TSER=642204486 WS=7
2997.764545 192.168.1.20 -> 192.168.1.6 TCP 45269 > ncube-lm [ACK] Seq=1 Ack=1 Win=14720 Len=0 TSV=642204487 TSER=160472000
2997.764630 192.168.1.20 -> 192.168.1.6 TDS Login Packet (Not last buffer)
2997.764641 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [ACK] Seq=1 Ack=614 Win=7040 Len=0 TSV=160472000 TSER=642204487
2997.764884 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [FIN, ACK] Seq=1 Ack=614 Win=7040 Len=0 TSV=160472000 TSER=642204487
2997.765021 192.168.1.20 -> 192.168.1.6 TDS TDS5 Query Packet
2997.765037 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [RST] Seq=2 Win=0 Len=0
2997.765045 192.168.1.20 -> 192.168.1.6 TCP 45269 > ncube-lm [FIN, ACK] Seq=624 Ack=2 Win=14720 Len=0 TSV=642204487 TSER=160472000
2997.765052 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [RST] Seq=2 Win=0 Len=0监听日志:则出现listener.log
Thu Jun 11 21:38:42 2015
11-JUN-2015 21:38:42 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from clientlistener.ora配置
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /home/oracle/app
42 [oracle]
43 host = 192.168.1.6
44 port = 1521
45 tds version = 5.0
46 client charset = UTF-8
47连接出现下面问题
[root@localhost freetds-0.95.0]# tsql -S oracle -U ycx -P 123456
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
There was a problem connecting to the server服务器抓包:192.168.1.6 是服务器
2997.764369 192.168.1.20 -> 192.168.1.6 TCP 45269 > ncube-lm [SYN] Seq=0 Win=14600 Len=0 MSS=1460 TSV=642204486 TSER=0 WS=7
2997.764402 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [SYN, ACK] Seq=0 Ack=1 Win=5792 Len=0 MSS=1460 TSV=160472000 TSER=642204486 WS=7
2997.764545 192.168.1.20 -> 192.168.1.6 TCP 45269 > ncube-lm [ACK] Seq=1 Ack=1 Win=14720 Len=0 TSV=642204487 TSER=160472000
2997.764630 192.168.1.20 -> 192.168.1.6 TDS Login Packet (Not last buffer)
2997.764641 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [ACK] Seq=1 Ack=614 Win=7040 Len=0 TSV=160472000 TSER=642204487
2997.764884 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [FIN, ACK] Seq=1 Ack=614 Win=7040 Len=0 TSV=160472000 TSER=642204487
2997.765021 192.168.1.20 -> 192.168.1.6 TDS TDS5 Query Packet
2997.765037 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [RST] Seq=2 Win=0 Len=0
2997.765045 192.168.1.20 -> 192.168.1.6 TCP 45269 > ncube-lm [FIN, ACK] Seq=624 Ack=2 Win=14720 Len=0 TSV=642204487 TSER=160472000
2997.765052 192.168.1.6 -> 192.168.1.20 TCP ncube-lm > 45269 [RST] Seq=2 Win=0 Len=0监听日志:则出现listener.log
Thu Jun 11 21:38:42 2015
11-JUN-2015 21:38:42 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from clientlistener.ora配置
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /home/oracle/app
解决方案 »
- 求树形结构数据自定义的递归查询?
- 帮忙看看下面这个工作要求,对于新手多久可以达到?
- 该表空间中已存在一个或多个数据文件,是否重复使用已存在的数据文件?
- 为什么刚用手动生成的服务用命令行连接不上,而从DBA STUDIO引入后才可连接?
- 一个简单的问题
- like 'a_bcd' _只能是 b或者c或者f 能够使用类似SYBASE [b,c,f]去选择吗?
- 绝对高手进>++++>不利用oracle管理平台 也不能在cmd下输入命令 在应用程序里 如何实现数据库的备份与恢复
- linux下安装oracle出错, 请教如何解决!
- 如何批量把某个用户的表的所有索引转到另外一个表空间?
- 帮我看看这个Sql server语句如何转成Oracle语句!
- 求意见
- 100分求SQL,自己整半天了
Compile-time settings (established with the "configure" script)
Version: freetds v0.95.0
freetds.conf directory: /usr/local/etc
MS db-lib source compatibility: no
Sybase binary compatibility: no
Thread safety: yes
iconv library: yes
TDS version: 5.0
iODBC: no
unixodbc: yes
SSPI "trusted" logins: no
Kerberos: no
OpenSSL: no
GnuTLS: no