Re: Local Database connection

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 16 Apr 2001 19:27:35 +0200
Message-ID: <tdmao8pfju0n39_at_beta-news.demon.nl>


<u518615722_at_spawnkill.ip-mobilphone.net> wrote in message news:l.987437315.1698394775_at_[198.138.198.252]...
> I have a local database on my laptop,
> Oracle 8.1.6 on NT 2000. Every time
> when I log into our network, I do not
> have problem coneect to my local database.
> But when I do not log into our network,
> say, at home or travel, I can not connect
> to my local database anymore.
>
> My listener can not get started, because
> the IP address is not correct. I add the
> following entry to my tnsnames.ora
>
>
> beq.WORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)
> (ARGV0 = oracle80shao816)(ARGS =
> '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))
> )
> (CONNECT_DATA =
> (SID = MYSID)
> )
> )
>
> which I copied from metalink, but it will not
> work. I always got error message saying that
> service name not found, could somebody tell me
> what is wrong with the beq entry?
>
> Thanks for your help.
>
>
>
>
> --
> Sent by dbadba62 from hotmail within area com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new

Apparently you need to change MYSID in the SID you really use. I know for a fact (I am doing this myself) that including the following line in your hosts file (don't know where that ended up in winsux 2000, but on WinNT it is in winnt\system32\drivers\etc) 127.0.0.1 localhost

and use host=localhost instead of host=<real ip address>

will also do the tric.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Apr 16 2001 - 19:27:35 CEST

Original text of this message