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

It appears your entry for TCP/IP in the LISTENER.ORA (and probably the TNSNAMES.ORA) file is wrong. There is a portion of your file in the definition that read "HOST=ORCL". The host it is looking for is the server name, not the instance name. You need to put either the server name or the actual IP address in there.

Dave

jerwynn_at_my-dejanews.com wrote:

> 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=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
>
> 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 - 09:21:39 CST