Re: Why modifying tnsnames.ora

From: <ovoelker_at_gmx.de>
Date: Fri, 26 Feb 1999 11:58:31 GMT
Message-ID: <7b6294$vdh$1@nnrp1.dejanews.com>

In article <36D602E4.AA42F0EE_at_ms1.hinet.net>, Dino Hsu <dino1_at_ms1.hinet.net> wrote:

> I re-installed Oracle client in Windows 95, the tnsnames.ora needs to be
> modified by adding the following lines, but I don't know why. Can
> anybody tell me the reason?
> Thanks in advance, replace reply to my mail box.
>
> PMDP_TW.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 134.65.71.22)(PORT = 1521))
> (CONNECT_DATA = (SID = PMDP))
> )
>
> TCP-LOOPBACK.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
> (CONNECT_DATA = (SID = ORCL))
If you reinstall an oracle client, your tnsnames.ora will be deleted. The first part tells the client where your database (PMDP) is located. If this part does not exist, the client will tell you the following message: ERROR: ORA-12154: TNS:could not resolve service name

Bye,

Oliver

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 26 1999 - 05:58:31 CST