ORA-12571: TNS:packet writer failure + LISTENER.ORA file.

From: Pete S. <swiadek_at_hotmail.com>
Date: Fri, 13 Sep 2002 05:33:32 GMT
Message-ID: <MMeg9.6908$Yo3.2870397@twister.socal.rr.com>

This is from the LISTENER.ORA file:

TNSLSNR for NetWare: Version 8.0.3.0.0 - Production on 12-SEP-02 10:30:32

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" <swiadek_at_hotmail.com> wrote in message news:4meg9.6904$Yo3.2839535_at_twister.socal.rr.com...
> Hi there,
>
> 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
>
>
Received on Fri Sep 13 2002 - 00:33:32 CDT