George Hernando wrote:
> 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!!
If/when in stand alone mode, why bother with SQL*Net at all?
You can connect "locally" using BEQ protocol without the listener running.
Received on Sun May 04 2003 - 15:06:00 CDT
