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@cde mailto:lanier/lanier@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
