Re: TNS server startup in Windows stand-along mode fails

Ana,

Great! I didn't know about BEQ. That fixes it.

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<Koeta.15469$MJ5.2958_at_fed1read03>...
> 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 Mon May 05 2003 - 00:15:10 CDT