TNS listener won't start (TNS: no listener)

From: <jerwynn_at_my-dejanews.com>
Date: Wed, 25 Nov 1998 14:24:16 GMT
Message-ID: <73h3to$qd4$1@nnrp1.dejanews.com>

I have a problem starting TNSListener.
Whenever I use TNSping to ping the server remotely, or locally (through tcp-loopback), I get the error: TNS: no listener
I tried starting the TNSlistener in Control Panel, but still the same. (I displays started in Control Panel, but when I get back after a while, it isn't anymore)

do you have any suggesions?
I have put the listener.trc and listener.log file contents below.

Thanks.

this is the contents of the listener.trc file:

TNSLSNR for 32-bit Windows: Version 2.3.2.1.4 - Production on 25-NOV-98 18:34:10

TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "D:\ORANT\network\trace\listener.trc" New trace level is 6
TRACE CONFIGURATION INFORMATION ENDS ---
PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source D:\ORANT\network\admin\listener.ora Parameter source loaded successfully

Attempted load of command line source
Parameter source was not loaded

-> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <- STARTUP_WAIT_TIME_LISTENER = 0 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ORCL))) CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = ADMIN

PASSWORDS_LISTENER = (oracle)  LISTENER = (ADDRESS_LIST = (ADDRESS=

(PROTOCOL= IPC) (KEY= oracle.world)) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL))
(ADDRESS= (COMMUNITY= NMP.world) (PROTOCOL= NMP) (SERVER= SOL) (PIPE=
ORAPIPE)) (ADDRESS= (COMMUNITY= TCP.world) (PROTOCOL= TCP) (Host= orcl)
(Port= 1521)) (ADDRESS= (COMMUNITY= TCP.world) (PROTOCOL= TCP) (Host= orcl)
(Port= 1526))) --- PARAMETER SOURCE INFORMATION ENDS ---

LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "D:\ORANT\network\log\listener.log" Log stream validation requested Log stream is valid
LOG CONFIGURATION INFORMATION ENDS ---

Resolved "CONNECT_TIMEOUT_LISTENER" to: 10 Resolved "STARTUP_WAIT_TIME_LISTENER" to: 0
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world)))
opening transport...
listening on pipe 76
transport is open
global context check-in (to slot 0) complete completing partial addr: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=
(PROTOCOL=IPC)(KEY=oracle.world)))Listening on: (ADDRESS=(PROTOCOL=ipc)
(PIPENAME=\\.\pipe\oracle.worldipc))
(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
opening transport...
listening on pipe 120
transport is open
global context check-in (to slot 1) complete
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=ORCL)))
opening transport...
listening on pipe 124
transport is open
global context check-in (to slot 2) complete completing partial addr: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=
(PROTOCOL=IPC)(KEY=ORCL)))Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.
\pipe\ORCLipc))
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(COMMUNITY=NMP.world)(PROTOCOL=NMP)
(SERVER=SOL)(PIPE=ORAPIPE)))

opening transport...
listening on pipe 136
transport is open
global context check-in (to slot 3) complete completing partial addr: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=
(COMMUNITY=NMP.world)(PROTOCOL=NMP)(SERVER=SOL)(PIPE=ORAPIPE)))Listening on:
(ADDRESS=(PROTOCOL=nmp)(PIPENAME=\\SOL\pipe\ORAPIPE))
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)
(Host=orcl)(Port=1521)))

port resolved to 1521
looking up IP addr for host: orcl

-<FATAL?>- *** hostname lookup failure! ***

-<ERROR>- nsres: id=0, op=78, ns=12545, ns2=12560; nt[0]=515, nt[1]=1001, nt[2] =0 Deallocating cxd 0xbd4a00. -<ERROR>- Reporting the following error stack: TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist 32-bit Windows Error: 1001: Unknown system error no timer allocated closing transport Closed pipe 120 global context check-out (from slot 1) complete no timer allocated closing transport Closed pipe 76 global context check-out (from slot 0) complete Deallocating cxd 0xbd3380. no timer allocated closing transport Closed pipe 124 global context check-out (from slot 2) complete Deallocating cxd 0xbd3ab0. no timer allocated closing transport Closed pipe 136 global context check-out (from slot 3) complete Deallocating cxd 0xbd3680.

this is the listener.log file:

TNSLSNR for 32-bit Windows: Version 2.3.2.1.4 - Production on 25-NOV-98 18:34:10

System parameter file is D:\ORANT\network\admin\listener.ora Log messages written to D:\ORANT\network\log\listener.log Trace information written to D:\ORANT\network\trace\listener.trc Trace level is currently 6

Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc))
Listening on: (ADDRESS=(PROTOCOL=nmp)(PIPENAME=\\SOL\pipe\ORAPIPE))

Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=
(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=orcl)(Port=1521)))
TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist 32-bit Windows Error: 1001: Unknown system error

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 25 1998 - 08:24:16 CST