TNS Listener Error

From: Leonardo <nospam_at_junkbusters.com>
Date: 11 Oct 2000 22:13:27 GMT
Message-ID: <8s2om7$pca_at_dispatch.concentric.net>

Hi,

[Quoted] I have installed Oracle8i server 8.1.5 and Oracle Designer on Windows NT Server 4.0.
I am unable to start the OracleOraHome81TNSListener service.

I checked listener.log and found:
- - - - - - - - - - - -

Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(PROTOCOL_ST ACK=(PRESENTATION=TTC)(SESSION=NS)))
Listening on:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=2481))(PROTOCOL_ST
[Quoted] ACK=(PRESENTATION=GIOP)(SESSION=RAW)))
Listening on: (ADDRESS=(PARTIAL=yes)(PROTOCOL=spx))

Attempted to listen on: (ADDRESS=(PARTIAL=yes)(PROTOCOL=spx)) TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter
- - - - - - - - - - - -

The first two entries look fine for Net8 & IIOP. The third seems to be attempting to load up SPX, which I don't have a driver installed for.

[Quoted] I set the listener's trace level to 16, and saw in the trace file:
- - - - - - - - - - - -

tnslsnr: Protocol stack = spx
tnslsnr: Protocol stack = tcp
- - - - - - - - - - - -

and
- - - - - - - - - - - -

nsgllsn: LSNDSC==>(ADDRESS=(PARTIAL=yes)(PROTOCOL=spx)) nsgllsn: Listening on: (ADDRESS=(PARTIAL=yes)(PROTOCOL=spx))
- - - - - - - - - - - -

I've removed / disabled all references to SPX in: listener.ora
tnsnames.ora
NETPROPERTIES
SQLNETV2.CFG
SQLNETV2.INI The problem persists.

Thanks for your help,

Leonardo Received on Thu Oct 12 2000 - 00:13:27 CEST