客户端连接oracle经常失败,并生成sqlnet.log,内容如下。 服务器端listerner.log好像没发现异常,请大家帮忙分析下是什么问题
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=168.168.10.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=test)(CID=(PROGRAM=D:\test.exe)(HOST=JZGL)(USER=Administrator)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 29-9月 -2010 14:41:35
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS: 协议适配器错误
ns secondary err code: 0
nt main err code: 538
TNS-00538: Message 538 not found; product=NETWORK; facility=TNS nt secondary err code: 65
nt OS err code: 0
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=168.168.10.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=test)(CID=(PROGRAM=D:\test.exe)(HOST=JZGL)(USER=Administrator)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 29-9月 -2010 14:41:35
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS: 协议适配器错误
ns secondary err code: 0
nt main err code: 538
TNS-00538: Message 538 not found; product=NETWORK; facility=TNS nt secondary err code: 65
nt OS err code: 0
Action: Start your listener with an unused address.
Generally this problem may ocurr for a incorrect setting in the listener.ora. Some causes of this problems may be:
a.- Some defined address in the listeners.ora is been used. Make sure other listeners are not running. Either listener.log and screen output appear the address with problem Explanation: The listener will try to acquire the address in exclusive mode, if this is been used then the process to get it will fail.
用net configuration assistant再增加配置一个连接串,
host改为用ip地址,试试。
1,没有启动监听器:lstrctl start //启动,配置文件有没问题,看它所产生的信息就知道。
2.在windows下的Oracle,所用的IP要用静止的,要不你的IP一变,你的配置文件就不能用了。
文件中的HOST尽可能的用机名代替。
3.如果实在不行的话,就用netca、netmgr这两个家伙重新创建下服务器,客户端的配置文件。
PORT=1521
SERVICE_NAME=test
都正确?
客户端所在操作系统多少位的?客户端与服务器版本是否匹配?