Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TNSNAMES.ORA placment ??

Re: TNSNAMES.ORA placment ??

From: Vitaly Sikolenko <vsikolen_at_ru.oracle.com>
Date: 1997/07/25
Message-ID: <33D86995.932ECC4B@ru.oracle.com>#1/1

Paul Mattes wrote:

> *,
> I'm installing SQL*net v2 under solaris 5.5 and am having a bit of
> trouble.
> I have the listener.ora file created (i'm not using the network
> manager)
> and it lives in /var/opt/oracle as does the tnsnames.ora file.
>
> I am able to get the listener process started, it tells me there is
> one
> service supported, but when i try to connect to sqlplus
>
> sqlplus user/password_at_service_name
>
> i get the dreaded
>
> ERROR: ORA-12154: TNS:could not resolve service name
>
> I think maybe tnsnames.ora is in the wrong place????????
>
> help!?
>
> Thanks!
>
> Paul

  To ensure everything to work fine define the TNS_ADMIN environment variable
pointing to the directory containing your configuration files.

--
Vitaly Sikolenko                  Senior Sales Consultant
                                  Server & Gateways
ORACLE C.I.S.
Moscow Russia                      E-mail: vsikolen_at_ru.oracle.com

The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.
Received on Fri Jul 25 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US