Re: listener error under window NT

From: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Sun, 21 Mar 1999 17:14:13 GMT
Message-ID: <36f51170.23135707@news.demon.co.uk>

On Wed, 03 Mar 1999 03:29:50 GMT, tedchyn_at_yahoo.com wrote:

>Sir,I installed oracle 8.0.5 on my pc (standalone pc). when I try to start
>listener using listener file created during installation. I ran into
>following error message -can not reach <abcd> . do you want to dial to
>remote.

This is the important bit of your output:

Listening on:(ADDRESS=(PROTOCOL=tcp)(DEV=164)(HOST=127.0.0.1)(PORT=1521)) Listening on:(ADDRESS=(PROTOCOL=tcp)(DEV=184)(HOST=127.0.0.1)(PORT=1526)) Attempted to listen on:
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port =1521)))

TNS-12542: TNS:address already in use 
TNS-12560: TNS:protocol adapter error	
TNS-00512: Address already in use  

32-bit Windows Error: 48:Unknown system error

Having already started to listen on 127.0.0.1 port 1521, the listener then tries to do it again, and fails because you can't use the same port number twice.

The reason for trying again is that the two lines:

        (ADDRESS=(PROTOCOL= TCP)(Host= abcd)(Port= 1521) ) and

        (ADDRESS=(PROTOCOL= TCP)(Host= 127.0.0.1)(Port= 1521) )

in your listener file are really the same, so you should remove one of them. The bit about dialling out is a standard NT message which is misleading in this case.

Regards,

Eric Received on Sun Mar 21 1999 - 11:14:13 CST