Re: Listener Won't Start

Hold that thought--

I just went in and reconfigured the Listener with Net 8 Configuration Assistant. Much to my surprise, the listener kick into action and I can now connect. On to the next adventure...

Thanks for the help.

Bill Van Dyk wrote:

> 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:13:00 CDT