TNS server startup in Windows stand-along mode fails

From: George Hernando <georgehernando_at_hotmail.com>
Date: 4 May 2003 12:13:13 -0700
Message-ID: <f9d20da7.0305041113.6dc411c3@posting.google.com>

Hello,

I'm using Oracle 8.0.5 on Windows 2000.
When running with the laptop attached to the company intranet, everything is fine. When I'm off the net and try to run stand-alone, the TNS server refuses to come up.

Some other people I talked with said they've seen that before. Based on their suggestions I disabled the TCP/NetBios service (and eventually tried disabling any service that sounded like it was doing something with the network). But I still get the error.

In the TNSNames.ora file I've replaced my computer name with 127.0.0.1.
I'm able to ping 127.0.0.1 successfully.

What could be wrong?

The error in the listener.log file is:

TNSLSNR80 for 32-bit Windows: Version 8.0.5.0.0 - Production on 04-MAY-03 11:50:27
(c) Copyright 1997 Oracle Corporation. All rights reserved.

System parameter file is C:\orant\NET80\admin\listener.ora Log messages written to C:\orant\NET80\log\listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))
Listening on: (ADDRESS=(PROTOCOL=nmp)(PIPENAME=\\127.0.0.1\pipe\ORAPIPE))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=204)(HOST=127.0.0.1)(PORT=1521))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=212)(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

Your help would be appreciated!! Received on Sun May 04 2003 - 14:13:13 CDT