Re: TNSNAMES.ORA placment ??

In article <01bc9610$59056460$bc7167cf_at_mattesp.voicenet.com>,   "Paul Mattes" <mattesp_at_voicenet.com> 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

Try putting the following in your .profile

TNS_ADMIN=/var/opt/oracle; export TNS_ADMIN

We typically put tnsnames.ora,listener.ora and sqlnet.ora into /etc. I'm not sure if it really matters where it is as long as TNS_ADMIN is set.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet