ORA-12541: TNS:no listener

From: Kelton, John <JKelton_at_lanierhealthcare.com>
Date: Mon, 29 Apr 2002 10:53:28 -0800
Message-ID: <F001.0045222D.20020429105328@fatcity.com>

Do you know where I can get an answer to the following question:  

Why do I get the following error: "ORA-12541: TNS:no listener" on my win 2000 professional client when trying to connect using "SQLPLUS lanier/lanier_at_cde <mailto:lanier/lanier_at_cde> ?"  

1. The client is a separate box from the server running oracle v8.1.6.
2. The listener service on the server is running.
3. Am able to connect using the same string on the server.
4. The SQLNET trace file reveals the following:

niotns: Calling address:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.18.118.51)(PORT= 1521)))(CONNECT_DATA=(SERVICE_NAME=cde)(CID=(PROGRAM=C:\Oracle\Ora81\bin\SQL PLUS.EXE)(HOST=CMT01)(USER=jkelton))(SERVER=dedicated)))
.
.
.

nttbnd2addr: entry
nttbnd2addr: port resolved to 1151
nttbnd2addr: using host IP address: 127.0.0.1
nttbnd2addr: exit

.
.
.

nttcnp: Validnode Table IN use; err 0x0
nttcnp: creating a socket.
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 204.

ntt2err: entry
ntt2err: soc 204 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
.
.
.

nioqper:  error from nscall
nioqper:    nr err code: 0
nioqper:    ns main err code: 12541
nioqper:    ns (2)  err code: 12560
nioqper:    nt main err code: 511
nioqper:    nt (2)  err code: 61
nioqper:    nt OS   err code: 0

niomapnserror: entry

niqme: entry
niqme: reporting NS-12541 error as ORA-12541
niqme: exit

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kelton, John
  INET: JKelton_at_lanierhealthcare.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Apr 29 2002 - 13:53:28 CDT