Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNSNAMES.ORA placment ??
Hi, Paul
Paul Mattes wrote in article <01bc9610$59056460$bc7167cf_at_mattesp.voicenet.c
om>...
>*,
>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.
In general that is the place.
First, listener is looking for $HOME/.tnsnames.ora file. Then, in /var/opt/oracle ( under Solaris and BSD-like systems) After, in $ORACLE_HOME/network/admin
May be it'll help
ping your_hostname
disable all dispatchers in init<sid_name>.ora
unset TNS_ADMIN
Be sure there is no $HOME/.tnsnames.ora
tnsping your_service_name
cd $ORACLE_HOME/bin
./adapters oracle
./adapters tnslsnr
>
>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
>
>
Received on Tue Jul 22 1997 - 00:00:00 CDT