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

Your problem is with the host. It is looking for a host named "orcl". If you are using standalone windows machine, try renaming it to "localhost" or "127.0.0.1". That should fix the problem

Uday

jerwynn_at_my-dejanews.com wrote in message <73h3to$qd4$1_at_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
>
>Copyright , 1996(c) Oracle Corporation 1994. All rights reserved.
>
>
>--- 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=NM
P)
>(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=TC
P)
>(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
>
>Copyright , 1996(c) Oracle Corporation 1994. All rights reserved.
>
>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 - 17:19:30 CST