Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> TNS Listener Error

TNS Listener Error

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

Hi,

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
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.

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 Wed Oct 11 2000 - 17:13:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US