REPOST: Re: Oracle TNS does not start when Notebook is diconnected from Netwo rk

Home -> Community -> Usenet -> c.d.o.misc -> REPOST: Re: Oracle TNS does not start when Notebook is diconnected from Netwo rk

From: Doggy Daddy <spamhole_at_blorch.org>
Date: Fri, 28 Dec 2001 20:34:19 -0800
Message-ID: <5$--$$_--%-%%_$%%$@news.noc.cabal.int>

On Fri, 28 Dec 2001 05:48:52 -0800, Niemann, Thomas wrote:

> I´ve installed a lokal Oracle Database on (8.0.5) on my Win 2k Pro. When
> i´m connected to the Network there is no problem, but when i´m
> disconnected from the Network the TNS Listener does not start?
>
> Any suggestions?

I've seen this happen when the disconnected laptop can't find its own name with DNS. Try changing the server name in your LISTENER.ORA so it refers to 127.0.0.1 instead of your laptop's name. You'll probably have to do this in your TNSNAMES.ORA, too, if you want to make Net8 connections (even to yourself!) while you're disconnected.

WAS CANCELLED BY =======: Message-ID: <cancel.pan.2001.12.28.20.34.19.120929.13858_at_blorch.org> Control: cancel <pan.2001.12.28.20.34.19.120929.13858_at_blorch.org> Subject: cmsg cancel <pan.2001.12.28.20.34.19.120929.13858_at_blorch.org> From: Doggy Daddy <spamhole_at_blorch.org> Newsgroups: comp.databases.oracle.misc X-No-Archive: yes Lines: 2 NNTP-Posting-Host: wonenara.ozemail.com.au X-Trace: ozemail.com.au 1009694848 203.108.164.177 (Sun, 30 Dec 2001 17:47:28 EST) NNTP-Posting-Date: Sun, 30 Dec 2001 17:47:28 EST Organization: OzEmail Ltd, Australia Distribution: world Date: Sun, 30 Dec 2001 04:36:34 GMT Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!newspump.sol.net!news.maxwell.syr.edu!news1.optus.net.au!optus!yorrell.saard.net!duster.adelaide.on.net!newsfeed.ozemail.com.au!ozemail.com.au!not-for-mail

This message was cancelled from within Mozilla. Received on Fri Dec 28 2001 - 22:34:19 CST