odbc 连接oracle 数据库 ,求大神指点!
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 client
listener.ora配置
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /home/oracle/app