Re: Listener Won't Start

I took a look at netstat -a -n. I expected, maybe incorrectly, to find some activity on Port 1521, which is supposed to be used by the Listener (?)

Here's what I got:

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    0.0.0.0:80             0.0.0.0:0              LISTENING
  TCP    0.0.0.0:135            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:443            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:445            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1027           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1033           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1034           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1036           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1038           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1039           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1598           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1600           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1605           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:5800           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:5900           0.0.0.0:0              LISTENING
  TCP    192.168.42.18:139      0.0.0.0:0              LISTENING
  TCP    192.168.42.18:427      0.0.0.0:0              LISTENING
  TCP    192.168.42.18:1033     192.168.42.223:524     ESTABLISHED
  TCP    192.168.42.18:1034     192.168.42.223:524     ESTABLISHED
  TCP    192.168.42.18:1039     192.168.42.223:524     ESTABLISHED
  TCP    192.168.42.18:1748     0.0.0.0:0              LISTENING
  TCP    192.168.42.18:1754     0.0.0.0:0              LISTENING
  TCP    192.168.42.18:1808     0.0.0.0:0              LISTENING
  TCP    192.168.42.18:1809     0.0.0.0:0              LISTENING
  TCP    192.168.42.18:3017     0.0.0.0:0              LISTENING
  UDP    0.0.0.0:445            *:*                   
  UDP    127.0.0.1:1202         *:*                   
  UDP    192.168.42.18:137      *:*                   
  UDP    192.168.42.18:138      *:*                   
  UDP    192.168.42.18:427      *:*                   
  UDP    192.168.42.18:500      *:*                   
  UDP    192.168.42.18:1029     *:*                   
  UDP    192.168.42.18:4500     *:*                   

Any suggestions?

Frank van Bortel wrote:

> Bill Van Dyk wrote:
>
>> I'm having trouble getting the listener to start on this system:
>>
>> Windows 2000 Server
>> Oracle 8.1.7
>>
>> I had previously installed and uninstalled Oracle on this machine and
>> I'm wondering if that is the source of the problem. Anyway, here's
>> the error message, when I try: lsnrctl start
>>
>> Starting tnslsnr: please wait...
>>
>> Failed to start service, error 3.
>> TNS-12536: TNS:operation would block
>> TNS-12560: TNS:protocol adapter error
>> TNS-00506: Operation would block
>> 32-bit Windows Error: 997: Unknown error
>>
>> I do love those Windows "unknown error" messages. It's like when you
>> call someone on the phone and ask, "are you there?"
>>
>
> There might be anotherone running? The 9 version is clear
> about the cause:
>
> C:\Documents and Settings\frankbo>lsnrctl start
>
> LSNRCTL for 32-bit Windows: Version 9.2.0.4.0 - Production
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Starting tnslsnr: please wait...
>
> Service OracleOraHome92TNSListener already running.
> TNS-12536: TNS:operation would block
> TNS-12560: TNS:protocol adapter error
> TNS-00506: Operation would block
> 32-bit Windows Error: 997: Unknown error
>
> The error stack is exactly the same...
>
> Another cause could be the port the listener uses is
> used by another process than the listener; netstat -a -n
> should reveal something like:
> TCP 0.0.0.0:1521 0.0.0.0:0 Listening
>
> Note the :1521 - it's the default listener port.
>
> As you had 8i before, check your services for double
> listener entries.
Received on Fri Jun 11 2004 - 08:07:21 CDT