Re: OracleTNSListener80 and W2000

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<asm8ju4jt7h3kl6cgsp4ajs0qlq7lfmei4_at_4ax.com>...
> On Tue, 16 Jul 2002 10:25:11 -0400, ImPrecise <f_puhan_at_precise.com>
> wrote:
>
> >I'm no network guru, but this tells me that your TCP/IP protocol stack
> >isn't loaded, or loaded properly.
>
> He is using the default localhost entry (127.0.0.1) and so the local
> loopback interface. He definitely shouldn't do anything to his
> IP-address, and -just BTW- you shouldn't run a server from a DHCP
> address.
> It is probably not going to work at all as Oracle 8 was never
> certified for Win2k.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Oracle does not support 8.0.6 on Win2K. First version supported on Win2K is 8.1.6.0.0, which is also desupported. You should upgrade to atleast 8.1.7.4.

Having said that you should look at the first and third errors in the stack i.e. TNS-12542 and 00512. I can't read spanish but in English it means "Address already in use". This to me looks like you are using a same port number more then once in your listener address list for TCP protocol. Check lines,

> (ADDRESS=(PROTOCOL=tcp)(DEV=260)(HOST=127.0.0.1)(PORT=1521))
> (ADDRESS=(PROTOCOL=tcp)(DEV=268)(HOST=127.0.0.1)(PORT=1526))
> (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))

Change one of the 1521's to 1527 then try again.

The other thing is,

> The problem only occurs when the system is not connected to the net. If I
> connect it, the service starts ok,

Why do you want to start the listener when you are disconnected? If you want to connect locally then use server manager or (Not so well documented) BEQ protocol

HTH
//Rauf Sarwar Received on Tue Jul 16 2002 - 18:24:35 CDT