Re: tnsnames stupid question

The tnsnames.ora file must be located in your $ORACLE_HOME/net8/admin directory for tnsping to use it...

( or if SqlNet v2 $ORACLE_HOME/network.admin)

and must have the correct connection info....use the configuration tools form Oracle to set the aliases up....Remember, its not the host name but the tnsnames.ora alias that is used...

Hope it helps,
John G

pauldb <luapdb_at_yahoo.com> wrote:

>I am trying to set up tnsnames.ora to connect to
>a remote database.
>
>I have tried tnsping <host> and if the host is in the
>/etc/hosts file- it comes back saying that TNS-12541 -No
>listener.
>
>It does not appear to use the tnsnames.ora file. Is there
>some parameter i have failed to set up- to specify this?
>
>Please help- i am a bit stumped and the oracle
>documentation is of no use to man or beast.
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Jul 23 1999 - 11:01:39 CDT