Xref: alice comp.databases.oracle.server:30963
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!hub1.ispnews.com!news14.ispnews.com.POSTED!not-for-mail
From: dondealy@teleport.com (Don)
Newsgroups: comp.databases.oracle.server
Subject: How to: Find value for SQL*PLUS host string
Reply-To: dondealy@teleport.com
Message-ID: <361fa78d.528575890@news.involved.com>
X-Newsreader: Forte Agent 1.5/32.451
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
X-Trace: news14.ispnews.com 908043932 206.136.47.40 (Sat, 10 Oct 1998 14:25:32 EDT)
NNTP-Posting-Date: Sat, 10 Oct 1998 14:25:32 EDT
Organization: ISPNews http://ispnews.com
Date: Sat, 10 Oct 1998 18:33:01 GMT

I'm trying to connect to Oracle 8.0.4 on a SUN server.  I've tried all
the values listed in the TNSNAMES.ORA file, but none of them work.

On a wild hunch, I used the alias of the SUN server, as found in the
/etc/hosts table on the UNIX server.

It worked!!

Why?  What is going on?  I'd prefer to have the "host connect string"
be the value found in the TNSNAMES.ORA file.  How do I make this
change?

Thx

email:  dondealy@teleport.com