ORA-12571: TNS:packet writer failure
Road Runner News
I have Oracle v8.0.3.0.6 running on a NetWare v4.11 SP9 server. As far as I
can tell Oracle is working. I can load up SVRMGR30.NLM, login as internal or
scott, do select, issue some commands such as
'archive log list' and I don't get any errors. This is a home setup and I am
still fairly new to Oracle, even though I have been going to the Oracle
classes for a year. Seems like one can spend a lifetime learning Oracle...
Here are some NLMs that are loaded that I thought might be of importance in
troubleshooting this:
ORACLE80.NLM
Oracle8 Server for NetWare v8.0.3.0.6
Version 8.00f June 26, 1998
Copyright (c) Oracle Corporation 1990, 1998. All rights reserved.
TNSLIB80.NLM
Oracle TNS Library v8.0.3.0.6 - Production
Version 8.00c June 26, 1998
Copyright (c) Oracle Corporation 1990-1997. All rights reserved.
TNSLSN80.NLM
Oracle TNS Listener v8.0.3.0.6 - Production
Version 8.00c June 26, 1998
Copyright (c) Oracle Corporation 1990-1997. All rights reserved.
Workstation is a WinXP Pro SP1 with Novell Client 32 v4.83 SP1. Yesterday I
have installed the Client portion of Oracle, but when I attempt to connect
via "Oracle Net8 Easy Config" I get "ORA-12571: TNS:packet writer failure"
error -- please see below:
The test did not succeed.
ORA-12571: TNS:packet writer failure
There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
NetWare v4.11 has IPX (Ethernet_II -- 055FF004) and IP bounded
(172.16.0.10 - subnet 255.255.0.0) and I can connect to it over IPX from
WinXP as well as ping it via IP. WinXP has 2 NICs in it, one is connected to
the cable modem and gets its IP address via DHCP and the other one is
connected via 10BaseT hub to the NetWare server and its static IP address is
17.16.0.30 - subnet 255.255.0.0. I can RCONSOLE to the NetWare server as
well as PING WinXP workstation (172.16.0.30) from the NetWare server.
I have done some basic searches on the Internet, and the best thing I found
was to turn on traces and report this to Oracle. I don't really know which
things to put in trace and where, and where the logs go, etc. OK, I was just
poking around and see NET80 directory with LOG and TRACE subdirectories as
well as LISTENER.ORA file, where there is a line TRACE_LEVEL_LISTENER=OFF.
Perhaps I should try setting that to ON... and see what I get in either LOG
or TRACE subdirectories. Perhaps I will be able to interpret the output of
these traces, but somehow I doubt I will know what to do next... Should
this configuration even work to begin with ? Meaning Oracle 8 Client on
WinXP ? Can I use Oracle 9 Client to "talk" to Oracle 8 ? Oracle v9.x is not
available for NetWare anymore, so I am trying to use v8.x. I guess I can go
with Oracle for Windows but I rather learn on NetWare because I support
stuff on NetWare and want to learn more about it, etc. I just tried
connecting via SPX using the service name I found in TNSNAMES.ORA file --
USSDNW411FS1-SPX, but received a failure as well -- please see below:
The test did not succeed.
ORA-12224: TNS:no listener
There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
Any help would be greatly appreciated.
Thanks in advance.
Pete
Pete S.
TNSLSNR for NetWare: Version 8.0.3.0.0 - Production on 12-SEP-02 10:30:32
(c) Copyright 1997 Oracle Corporation. All rights reserved.
System parameter file is APPS:ORANW803\NET80\admin\listener.ora
Log messages written to APPS:ORANW803\NET80\log\listener.log
Trace information written to APPS:ORANW803\NET80\trace\listener.trc
Trace level is currently 0
Listening on:
(ADDRESS=(PROTOCOL=ipc)(DEV=9)(NET=00000000)(NODE=000000000000)(SOCKET=0000)
)
Listening on:
(ADDRESS=(PROTOCOL=spx)(DEV=13)(NET=000411f1)(NODE=000000000001)(SOCKET=40dd
))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=16)(HOST=172.16.0.10)(PORT=1521))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
12-SEP-02 10:30:53 *
(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=Console)(USER=OPERATOR))) *
(ADDRESS=(PROTOCOL=ipc)(NET=00000002)(NODE=000000000000)(SOCKET=0000)) *
establish * ORCL * 0
12-SEP-02 10:31:45 *
(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\ORANT\jre11\bin\java.exe)(HOST=SWIA
DEKXP)(USER=swiadek))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.30)(PORT=1785)) * establish * ORCL *
12560
TNS-12560: TNS:protocol adapter error
TNS-00533: Connection dissolved or not yet made
NetWare Error: 14: Result too large
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12571: TNS:packet writer failure
TNS-12560: TNS:protocol adapter error
TNS-00533: Connection dissolved or not yet made
NetWare Error: 14: Result too large
12-SEP-02 10:32:48 *
(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\ORANT\jre11\bin\java.exe)(HOST=SWIA
DEKXP)(USER=swiadek))) * nsevwait_error * 12560
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
12-SEP-02 10:32:48 *
(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\ORANT\jre11\bin\java.exe)(HOST=SWIA
DEKXP)(USER=swiadek))) * listen_address_removed * 1170
TNS-01170: Event detection broke for address:
'(ADDRESS=(PROTOCOL=IPC)(KEY=USSDNW411FS1_LSNR))'
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
"Road Runner News" <swi...@hotmail.com> wrote in message
news:4meg9.6904$Yo3.2...@twister.socal.rr.com...
Marcin P
> This is from the LISTENER.ORA file:
>
Did you start Oracle instance ?
type orastart on console
Pozdrawiam
--
*************************
Marcin 'PIORO' Przepiórowski * BORN TO BE WILD *
http://oraforum.altkom.com.pl *************************
roobaron
Has the netware protocol IPX? been installed on the server?
The first error was a protocol adapter error, make sure the right
protocol drivers are loaded on both the client and the server.
Hope this helps
p.s. i am working on a similar error, however i have the joy of 3rd
party ODBC drivers connecting via WAN :)
--
Posted via http://dbforums.com
Pete S.
"Marcin P" <pio...@poczta.fm> wrote in message
news:slrn.pl.ao37...@pioro2.localdomain...
Pete S.
XP.
"roobaron" <mem...@dbforums.com> wrote in message
news:1810088.1...@dbforums.com...
roobaron
If you have the tnsping command on the client, trying connecting to the
server that way.
tnsping
eg tnsping my_db
where my_db appears in the tnsnames.ora file with the correct
connection info.
Enabling tracing might or might not help you diagnose the problem
as can produce mountains of info, with the errors hidden amongst
the mountain.
Have a read of the doco for network administrator, especially the
sections of listener.ora and sqlnet.ora for the setting for TRACING.
eg TRACE_LEVEL_ =
Have Fun