TNS-12571 error : packet writer failure [message #67266] |
Thu, 18 March 2004 04:19 |
Denis Pervushin
Messages: 1 Registered: March 2004
|
Junior Member |
|
|
Good Day
I have installed Oracle Client 8.0.6 on pc with Win2K Professional OS. Installation finished successfully.
I have then tried TNSPING to the server and received an error message TNS-12571.
"ping" and "pathping" to the server machine were ok.
I have deinstalled (and then even manually cleaned registry entries) and re-installed Oracle Client, but the error remains. Parameter "sqlnet.authentication_services" in
sqlnet.ora is set to "none".
Here is the abstract from tnsping trace:
nscall: connecting...
nsc2addr: entry
nttbnd2addr: entry
nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address: 192.168.0.80
nttbnd2addr: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 400 bytes at 0xc593d8
nsmal: normal exit
nsnainconn: entry
nsmal: entry
nsmal: 1664 bytes at 0xc9c0f0
nsmal: normal exit
nsnainconn: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: No PROTOCOL.ORA file is found
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: creating a socket.
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 796.
nttcni: exit
nttcon: NT layer TCP/IP connection has been established.
nttcon: exit
nsopen: transport is open
...
nscon: entry
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nspsend: entry
nspsend: plen=87, type=1
nttwr: entry
nttwr: socket 796 had bytes written=0
nttwr: exit
nspsend: transport write error
nspsend: error exit
nscon: error sending NSPTCN packet
nserror: entry
nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[[0]]=0, nt[[1]]=0, nt[[2]]=0
nscon: exit (-1)
...
I'll appreciate any suggestions about the cause of that problem. Thank you.
|
|
|
Re: TNS-12571 error : packet writer failure [message #67342 is a reply to message #67266] |
Thu, 20 May 2004 03:35 |
Prashanth
Messages: 41 Registered: September 1999
|
Member |
|
|
Hi All
There is solution for TNS write packet failure error . follow these setps to resolve the issue
1) Uninstall the TCP/IP
2) Export the registry
3) remove all the winsock entry from registry
4) restart the PC
5) install TCP/IP
6) Try to connect to database if you get diffrent error (other than TNS write packet error ) then
7) Uninstall and reinstall the SQL
This steps will resolve the TNS write packet failure error ..
Regards
Prashanth
prashanth.rao@oracle.com
|
|
|
Re: TNS-12571 error : packet writer failure [message #67354 is a reply to message #67342] |
Mon, 31 May 2004 18:53 |
Prashanth
Messages: 41 Registered: September 1999
|
Member |
|
|
Hi All
There is solution for TNS write packet failure error . follow these setps to resolve the issue
1) Uninstall the TCP/IP
2) Export the registry
3) remove all the winsock entry from registry
4) restart the PC
5) install TCP/IP
6) Try to connect to database if you get diffrent error (other than TNS write packet error ) then
7) Uninstall and reinstall the SQL
This steps will resolve the TNS write packet failure error ..
Regards
Prashanth
|
|
|
|
|