Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: georgehernando@hotmail.com (George Hernando)
Newsgroups: comp.databases.oracle.server
Subject: Re: TNS server startup in Windows stand-along mode fails
Date: 4 May 2003 22:15:10 -0700
Organization: http://groups.google.com/
Lines: 53
Message-ID: <f9d20da7.0305042115.17e90024@posting.google.com>
References: <f9d20da7.0305041113.6dc411c3@posting.google.com> <Koeta.15469$MJ5.2958@fed1read03>
NNTP-Posting-Host: 64.161.25.19
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1052111710 12720 127.0.0.1 (5 May 2003 05:15:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 5 May 2003 05:15:10 GMT
Xref: core-easynews comp.databases.oracle.server:185288
X-Received-Date: Sun, 04 May 2003 22:14:40 MST (news.easynews.com)

Ana,

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



"Ana C. Dent" <anacedent@hotmail.com> wrote in message news:<Koeta.15469$MJ5.2958@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.